Automate

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?

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

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?

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

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?