autogenerate code based on form entries
im building a grid in an app wich will be populated by end users through a form.
i've created an action with a form but the problem is:
my form has 5 entries which correspond to selected line items in my module. 3 of those are drop down lists and the others are manual entry type. im trying to generate a code based on the information entered into the form. the code should be a concatenation of some entries.
i tried to add a formula like this since its not possible to concatenate on list.
account (drop down list)
currency(drop down list)
type(drop down list)
i tried this formula but it didnt work
is it even possible to generate a code based on the values selected and entered in a form?
Thanks in advance 🙂
code line item is in text format so it doesnt work when i try to concatenate the others line item(list format) by doing CODE(NAME(line item )) & CODE(NAME(line item 2))0