We are working on a basic user table for an experience to achieve a “logged in state” to an experience.
I’ve done some testing using excel which works fine for example
- User enters their email address
- Once the email address field loses focus a filter is applied to the excel sheet in the email_address column
- If the email address is found in row 1 then a popup comes up saying the user is registered
- If the value of Number of Rows = 0 once the filter is applied then a new row is added to the excel sheet and the new user is added
This works perfectly with excel. Now I’m trying to port the entire thing into airtable so we can have multiple locations sharing it. Airtable doesn’t have number of rows as a field that is returned in order to create a binding.
I tried just linking it to a field and then creating an IF statement for an empty value but this didn;t work (and didn;t work for excel either). So I’m guessing if a filter in excel or airtable returns no value intuiface doesn’t register anything at all?
The knowledge base around null value for a filter says to use number of rows as the binding. Is there anything similar or a known workaround for air table?
Thanks in advance