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 |
---|---|
43 | |
29 | |
24 | |
21 | |
13 |