autogenerate code based on form entries

pdekas
Contributor

autogenerate code based on form entries

Hi guys, 

 

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.

Example: 

account (drop down list)

year(manual entry)

amount(manual entry)

currency(drop down list)

type(drop down list)

i tried this formula but it didnt work   

code: CODE(account)&CODE(type)&CODE(currency)

is it even possible to generate a code based on the values selected and entered in a form?

 

Thanks in advance 🙂

1 ACCEPTED SOLUTION

Accepted Solutions
Misbah
Moderator

Re: autogenerate code based on form entries

@pdekas 

 

Try this

Code of Account: CODE( Account)

Code of Type : CODE(Type)

Code of Currency: CODE(Currency)

Concatenation: Code of Account & Code of Type & Code of Currency

Misbah_0-1621612016596.png

Misbah_1-1621612028396.png

Misbah

View solution in original post

3 REPLIES 3
Misbah
Moderator

Re: autogenerate code based on form entries

@pdekas 

 

1. CODE(Account)

2. CODE(Type)

3. CODE(Currency)

 

And then concatenate these

 

Misbah

pdekas
Contributor

Re: autogenerate code based on form entries

Thanks,
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))
Misbah
Moderator

Re: autogenerate code based on form entries

@pdekas 

 

Try this

Code of Account: CODE( Account)

Code of Type : CODE(Type)

Code of Currency: CODE(Currency)

Concatenation: Code of Account & Code of Type & Code of Currency

Misbah_0-1621612016596.png

Misbah_1-1621612028396.png

Misbah

View solution in original post