Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
I have a field includes number values,
I want to copy this values into input box but instead of entering many commas manually (850 values) in input box,
Can I add commas automatically in order to seperate values in input box.
Thanks .
Hi,
Unfortunately this is not possible in input box. We can enter only single value in input box.
Thanks
Advait
Yes, you can do this.
Add a variable to input box and go to the constraints tab of input box. Select the variable and check the radio button of Predefined Values in Drop-down of Value List and also check Listed Values box of Predefined Values. Now you can see expression box bottom of this check box. Paste the below code there.
=Concat(DISTINCT FIELDNAME,',')
Hope it helps you
Cheers!!
Jagan
hi
INPUTBOX-->PROPERTIES--> CONSTRAINTS-->LISTED VALUES
Tthen write
= concat(distinct(fieldname),',')
and then check on predefined selected listed values,
in constraints tab of input box write
=concat(distinct(fieldname),',')
check on list and write above code
tick on the radio button of predefined value in drop down
thanks for all replies,
er.mohit your reply is working for my case but for 850 values is problem for apllication