Show If not working

[HansieT]

Hi All

I am sure this is a simple issue and just needs another set of eyes.

I have read many posts and tried the solutions, however they do not work.

I have a table with a column for Category which contains a drop down of values from reference table CATEGORY

I have another column in the same table and based on the selection the user makes for column CATEGORY, I would like to show another column.

I have tried CONTAINS([CATEGORY],"UNIT") and this does not give the desired results. It simply does not show up. I tried these for the Required setting as well with the same result.

I have tried with the universal on and off.

What am I missing ?

Thank you

[Marc_Dillon · Accepted solution]

Row key vs label?

A Ref column stores the key value of the referenced record, but displays the label. You'd have to use the key value in the show_if expression.

https://help.appsheet.com/en/articles/961466-row-labels

https://help.appsheet.com/en/articles/1023086-what-is-a-key

https://help.appsheet.com/en/articles/961426-references-between-tables