Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
May 20, 2021 10:14 AM
I’m trying to ingest a new user registration (password’s being handled separately).
I want to make sure that the new registration does not use an email address already in the DB (prevent duplicate accounts–ideally even if they’re using “+variable” in something like a gmail address).
I’m currently using automations, but I can’t seem to get around the “Find Records Action 0 results stops the automation” flow. I actually want to update the record AFTER a Find Records determines there aren’t any duplicates.
I’m not using scripting – “Plus” account level and coming in from the #nocode crowd.
Here’s the where I am thus far:
Automation 1:
WHEN: a record is created in Ingest Users Table
ACTIONS:
Find Records in Active Users Table where email = [new record email]
Update Record (that was created) → set Duplicate = true[I would IDEALLY be able to handle Find Records = 0 results with an Update Records → set Unique = true, then have a When Record Enters View that copies the Ingest User record to the Active Users Table.
Automation 2:
WHEN: a record enters a view (Ingest Users.Unique = true)
ACTIONS:
Create Record in Active Users Table
Update Record (that entered view) in Ingest Users Table → set Processed = true
Find Records in Active Users Table where Created From = [record that entered view]
Gmail send welcome email[again, IDEALLY handle Find Records in Active Users Table = 0 results with error logging/graceful failure involving logging and emails]
Notes:
I was really excited to build my #nocode app out of Airtable. But this has really hit my morale (and momentum)!
Thank you for any help, suggestions, or insights you might be able to provide.