Hi all,
I am attempting to put in an authentication field into my app so that only users who are active members can access it.
I have created a google sheet which will be automatically updated once a week with a list of active members from our database. It has 3 columns, name, Membership number and Year of Birth.
In the user’s spreadsheet of my app, I have the following relevant columns:
- ID Number (User Specific Number)
- Year of Birth (User Specific Number)
- ID Number Relation (Relation looking at Google Sheet - ID Number)
- Current Member (If-Then-Else Boolean that checks if the relation field is empty or not)
This method marks the boolean true if the ID number entered by the user matches any ID number in the Google Sheet and gives them access to the rest of the app.
What I am attempting to add is a second check for the member’s birth year. The user will be asked to enter both, their ID number and Birth Year. I would like the Current Member Boolean to be true only if the ID and Year entered match the same Row in the google sheet, but if I add a second relation column in the user data, it will pick up multiple relations as many people share the same birth year.
How can I get this boolean to only =TRUE if both the ID and Year of Birth match the same entry in the Google Sheet?