I’m making a project where I need to save and retrieve data from an Airtable, and I have a problem getting a list of rows (possibly due to the fact that I have no experience with lists).
How it should work:
When a new row is added to Table1, we need to search for all the rows that match it in Table2.
The search for matching rows is performed on 3 columns (Column1, Column2, Column3), which specify the value True or False.
If in Table1 in one of the columns there is a True value, then in Table2 in the corresponding column we also look for the True value.
But, if in Table1 in one of the columns there is a value False, then in Table2 in the corresponding column we are looking for the value False or True.
I would be grateful for any help with this!