Show_if when a column is a ref column

I have a column that is a ref column (Equipment) but I only want it to show if a certain choice is made from another column (Incident)

So I want the Equipment column to show if a certain choice is made from the Incident Column. Is this possible?

I’ve attached a screenshot.

I want the Equipment column to be shown if the “Equipment-lost” selection is chosen from the Incident list

In the showif constrain for [Equipment] field, you simply add expression of

[Incident] = “Equipment-lost”

1 Like

Thank you! I just figured out that there is a formula option for the Show Constraint. I’d been wondering where to put the expression.

1 Like

Great!

Im not Appsheet guy, but on behalf of them, I would say Appsheet can almost do anything what you want. Just need to “learn” all the tricks.

If my friend comes to me, I want to learn Programming. Then I may say, mate, you should learn Appsheet first while you learn other prog language at the same time, which will give you super powerful skills.

Good night. (from tokyo)

1 Like