I am trying to hide a row value so it doesn’t appear in a table lookup. I will explain
I have A app called Live orders and a newly created app call job sheets.
In job sheets app i create a new job by selecting certain details from the live orders app. Like Job Number Customer Name ETC
When I mark that job as complete it still appears in the list of orders i can select. I would like the list only to be orders that are not complete.
I tried using filter or select but I could only get them to work if the column is the key. which it isn’t