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 🙂

Best Answer

  • Misbah
    Answer ✓

    @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

Answers

  • @pdekas 

     

    1. CODE(Account)

    2. CODE(Type)

    3. CODE(Currency)

     

    And then concatenate these

     

    Misbah

  • 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))