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 290
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