Auto populate a date from one table to another

Unfortunately, automatic linking between tables based on a formula field (or any other type of field) is not supported nor possible in Airtable.

You are always required to manually link records to one another in Airtable. (You could also write a custom JavaScript to link the records, but you would still need to manually run the JavaScript whenever you wanted to link.)

This is the gigantic difference between Airtable and more advanced relational database systems like FileMaker.

The only 2 exceptions to this rule are when you convert a field to a linked record field, or when you import records into a linked record field. Under those 2 circumstances, Airtable will do a “one-time-only” automatic linking of the values in the linked field to the PRIMARY FIELD ONLY of the linked table.

Got it! Thanks -

Do you know how to change it so that my work day calendar is set to EST not GMT? Right now the work day is Sunday - Thursday

Thanks again

@SIairtable If you found my answer above helpful, please mark it as the solution! Thank you! :blush:

Regarding your new inquiry, turn off the GMT option in your date fields. If you need more time zone help, check out my time zone solution in the Airtable Universe: