Automate

 View Only
  • 1.  Promote a number field in a table where there will be more than one value promoted

    Posted 04-23-2024 14:33

    I'm trying to promote fields in a table. With a text field I can use the merge setting to capture more than one value separated by a comma, but I can't seem to do the same with a number field, it only allows me to use the First setting. Is there a way to promote a number field with more than one value in Evolve?



    ------------------------------
    RTX Polley
    Raytheon Co
    ------------------------------


  • 2.  RE: Promote a number field in a table where there will be more than one value promoted

    Employee
    Posted 04-24-2024 03:27

    Hi Polley,

    We do not allow merging on number element , for example if you merge numbers 564 987 and 546 in a comma separated list it will evaluate to 

    564,987,546 which looks like a large number and not a list, which can be miss leading.

    As a solution you can add a text-box on the form and promote this textbox as solution field, in your repeating table number field you can apply a rule to concat all the numbers separated by a unique separator.

    I have attached a test solution here : https://nowtransfer.de/b2b72d75e5ee

    The result will look like :

    You can further remove textbox_5 from the form and make it as hidden as per requirement.

    Hope this helps.

    Regards



    ------------------------------
    Hammad Naeem
    Precisely Software Inc.
    ------------------------------



  • 3.  RE: Promote a number field in a table where there will be more than one value promoted

    Posted 04-24-2024 08:41

    Hammad, thank you so much, You are always a big help!



    ------------------------------
    RTX Polley
    Raytheon Co
    ------------------------------



  • 4.  RE: Promote a number field in a table where there will be more than one value promoted

    Employee
    Posted 04-25-2024 08:26

    RTX,

    Hammad is correct on merge.  There is a SUM operator for numeric columns, so if you want a total, you can check it out.

    Best Regards,

    Sigrid



    ------------------------------
    Sigrid Kok
    Precisely Software Inc.
    ------------------------------