Condition using different table

How do i pull out the information from another table for the condition? for example, i want to display a column โ€œcomplaintโ€ in table details only if the column โ€œstatus of callโ€ in another table is set to โ€œTroubleshootโ€

0 3 291
3 REPLIES 3

Do you want to hide value or values in a table view and differently row by row?

yes sir

Iโ€™m afraid you are not able to do that with a table view. If you need that functionality, you should create a virtual column and then show that column in your table view instead of your original column. You can achieve this with the app formula, not with the Show? option. App formula would be likeโ€ฆ
IFS(LOOKUP(โ€œSearchValueโ€,โ€œAnotherTableNameโ€,โ€œSearchColumnโ€,โ€œStatus of callโ€)=โ€œTroubleshootโ€,[OriginalColumnname])

Top Labels in this Space