I am trying to use a from for data entryโฆ
I have a column that name is โActionโ and it belongs to Ref Type. โActionโ Column has a dropdown by the name โAdvance ACโ โExpanseโ & โSalesโ
Just Below of Action column has another column โAction Typeโ & and it also belongs to Ref Type. That has also a dropdown by the name โOfficeโ โStaffโ โStationaryโ โconveyanceโ โParcelโ โDine Inโ โReceiveโ โAdjustโ etc.
I want when I will select โExpanseโ from the โActionโ field, the โAction Typeโ Column will show โOfficeโ โStaffโ โStationaryโ & โConveyanceโ
When I will select โAdvance ACโ From the โActionโ field, the โAction Typeโ Column will show โReceiveโ & โAdjustโ
When I will select โSalesโ From the โActionโ field, the โAction Typeโ Column will show โParcelโ & โDine Inโ
Sorry In advance, Because, My English & Codding knowledge is so weak.
So, Please give me a suggestion in an easy way.
Solved! Go to Solution.
Your going to want to put something like this in the suggested values of [Action Type]
IFS(
[Action]="Expanse",
LIST("Office","Staff","Stationary","Finished","Conveyance"),
[Action]="Advance AC",
LIST("Receive","Adjust")
)
Your going to want to put something like this in the suggested values of [Action Type]
IFS(
[Action]="Expanse",
LIST("Office","Staff","Stationary","Finished","Conveyance"),
[Action]="Advance AC",
LIST("Receive","Adjust")
)
Thank you very much,
Itโs working as I want.
User | Count |
---|---|
40 | |
36 | |
34 | |
23 | |
17 |