Hi
I’ve tried to search for the answer to this but couldn’t see anything that matches.
I’m building an app for users to view older documentation for works completed within Appsheet.
I want them to be able to search the data to only show specific records that meet certain requirements.
We have one master table with 3 main fields that they would be able to search (using any of the filters not all)
-
JobId - Table Key
-
SpanID
-
Tower1
I have set up a user settings field for each of the above with a referenced list of entries that meet criteria
select(table[JobId],and=false,[Ispassed]=true)
this works ok for the JobId as the key
How do I get the other usersettings to show a list of the other non-key fields using the same criteria
select(table[JobId],and([Ispassed]=true;USERSETTINGS(“spanId”)=[spanid]))
Hi
apologies, I’m not sure if I explained quite correctly, is this formula not for filtering the data within a slice once the user settings are chosen?
the issue I’m trying to resolve is within the User settings formulas.
I need to show 3 different lists from the same table, the user will be able to choose any one of these fields to filter:
JobID is a Ref type that uses a Select formula to list the rows that meet the restrictions.
How do I get the SpanID and Tower 1 fields to list the correct rows from the same table?Everything I have tried so far has only shown the JobID again as it is the key column (so all 3 lists show the same)
The above expression sounds syntactically incorrect. Could you mention what and=false means?
1 Like
