I also suggest checking out how to prefill forms. You can use a formula field to automatically create these links.
Obviously, this automation will fail if the email they entered on the form doesn’t exactly match the email you have on file for them in...
You can accomplish this with an automation. When a new form submission is populated in the Forms table, the automation will find the matching record in the People table and then link the two records. The finished automation will look like this:
You ...
Thanks @Justin_Barrett! TIL that a zero will also be treated as false when using the field-name-only test. I will keep your workaround in mind next time!
There are many different ways to achieve this, so I’m sure you’ll get different answers. Here is how I would accomplish this using Airtable’s automations.
First, we need to get the person’s birthday in the current year from their DOB. For example, if...
You can check if a cell is blank by simply referencing the cell you want to check in the logic part of the IF statement. Here is the formula I would use:
IF({Number},DATETIME_FORMAT(DATEADD({Clinic Date},3,'week'),'MM-DD-YYYY'),BLANK())
