Question: Sugar Logic Formula for Random Character?

Hello, is there any Sugar Logic Formula to automatically generate random alphanumeric code on a specific length?

For example:

Record #1: 

Code Generator Field: A123BX3

Record #2

Code Generator Field: X12B1A2

Kindly advise, thank you everyone.

Parents
  • Hello ,

    Instead of developing CRM with new functionality and ensure true randomizing, I would suggest receiving a random value from the specific services that may provide them for free or a small fee.

    E.g. I used Logic Builder configuring tool to configure getting a random string with given parameters (e.g. endlish letters + digits) from a well-known RANDOM.ORG service for free and put the random string into the Name field for the newly created CustomA module record.

    Here is how it works:
    3146.getrandom2.mp4

    Here is the flowchart design that implements a logic hook with an external call to RANDOM.ORG.
    You may read it by following the white line:


    If you like this Sugar-configuring-instead-of-developing approach, you may register for RANDOM.ORG and let me know the module and field name to populate with a random value, so that I could configure it in the Logic Builder cloud environment (https://logicbuilder.integroscrm.com) and get a zip generated for you with a click


    Best Regards,
    Dmytro Chupylka

    integroscrm.com
    We make work in Sugar CRM system faster, more convenient and efficient

Reply
  • Hello ,

    Instead of developing CRM with new functionality and ensure true randomizing, I would suggest receiving a random value from the specific services that may provide them for free or a small fee.

    E.g. I used Logic Builder configuring tool to configure getting a random string with given parameters (e.g. endlish letters + digits) from a well-known RANDOM.ORG service for free and put the random string into the Name field for the newly created CustomA module record.

    Here is how it works:
    3146.getrandom2.mp4

    Here is the flowchart design that implements a logic hook with an external call to RANDOM.ORG.
    You may read it by following the white line:


    If you like this Sugar-configuring-instead-of-developing approach, you may register for RANDOM.ORG and let me know the module and field name to populate with a random value, so that I could configure it in the Logic Builder cloud environment (https://logicbuilder.integroscrm.com) and get a zip generated for you with a click


    Best Regards,
    Dmytro Chupylka

    integroscrm.com
    We make work in Sugar CRM system faster, more convenient and efficient

Children