I just created an automation to check for a due date coming up in the next month and send an email reminder.
How often will an automation run? It’s triggered to look for a due date in the next month, but how often will that be checked?If a notificat...
Could someone please help troubleshoot this?
I’m trying to calculate an expiration date based on the service provided. I believe I shouldn’t really be using “or” here, but included this just to help illustrate what I’m trying to do. Each IF statement...
I’m trying to use an automation to look for a record in one table to update a record on another table.
I’ve created a form that I’d like my team to use to update students testing status (Yes/No)I tried to set up the automation with a Trigger on a new...
I have a database of clients who need to pass an annual certification exam.
I have a Client table, that is linked to a Certification table, with multiple Certification rows for each attempt at the exam, with a unique date & result for each row. For e...
Thank you again for all the great advice! You are correct that I was confusing the Record ID and the Primary Field. Thanks for explaining! after reading through this, I think I can simplify what I want to do in another keeping the test results & tes...
Thank you for the reply!
I’ve probably tried this a million different ways lol. I set the Record ID to Record ID and now it says “record does not exist”
Here’s the data in the table that the form will populate
I’m trying to set the automation to us...
Thank you again! I was trying to think this through and was on a similar path as your first suggestion, but thought there must be an easier way. Lol
I’ve built many apps in other database tools. Airtable is awesome for its simplicity, mobile app and ...
Thanks! @ScottWorld ! I had tried this, but didn’t know where to go from there.
So now, on my Client table, I have my Client info, and I am linked to the Certification table, and I have the max date calculated. I currently see that each of my test C...
