The SELECT statement goes through each row of the โquestionsโ table and checks if it meets the conditions you specify. The problem appears to be in the conditions.
Part 1:
The syntax: table_name[column_name] will return the entire column as a list. So when you write questions[Unique ID], AppSheet will return the entire โUnique IDโ column for every check on every row.
You probably want to check the value of โUnique IDโ for that specific row. You can do that by writing
[_THISROW].[Unique ID]
Part 2:
The conditions in your SELECT statement are getting into more advanced use of formulas. Typically, the conditions of a SELECT statement will check each row against some static value. For example [_THISROW].[Color] = โRedโ. However, in your example, the conditions are checking each row against a value in another table.
It can be done, but it is a challenging place to start if youโre still getting familiar with SELECT statements. If youโd like to give it a shot, then youโll need to apply the same concepts to the masterDatabase[ID] part of your conditions. This is currently returning the entire โIDโ column. Try taking the same concepts and using them to select a specific value from the โIDโ column of the โmasterDatabaseโ table.
LinkedIn
Twitter
