Issue using variables

dandaanilreddy — Thu, 23 Jan 2020 20:32:22 GMT

Hello All,

I have created 2 variables based on a field . Variable 2 must show always A3 and variable 1 should show A0 or A3 based on user selection. If the user come and select A3 and A0 or A0 and A3 from the field the variables are populating as expected but when the user paste the cycles into the field the variables are showing in reverse order like variable 2 is showing A0 and variable 1 is showing A3. Please can someone help me on how to achieve this? Below is my variables.

vField =concat(distinct field,',')

Variable 1 : =subfield(vField,',',1)

Variable 2 : =subfield(vField,',',2)

Thanks

Re: Issue using variables

Anil_Babu_Samineni — Fri, 24 Jan 2020 10:47:53 GMT

To work as field, You must include Aggr() over Variables, Since Aggregate can't be achieve in the script, If u are using script side variables.

I would rather thing this way

vField =concat(distinct field,',')

Variable 1 : =subfield(Aggr(vField, field),',',1)

Variable 2 : =subfield(Aggr(vField, field),',',2)

topic Issue using variables in App Development

Issue using variables

Re: Issue using variables