I want to show the list that I want

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.

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

Simon@1minManager.com

3 Likes

Thank you very much,

It’s working as I want.

2 Likes