Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 18, 2022 09:45 PM
Hi,
I’ve just started using Airtable.
Here’s a list of what I have done and trying to do
How to fix?
Solved! Go to Solution.
Jun 18, 2022 11:53 PM
Automations don’t go back in time to affect previous records in your base. Automations only work from this point forward (i.e. after you create the automation).
To catch up on old records, you could create a formula field that results in the letters “KFC” for the records that you want. Then, afterwards, you can convert the formula field to a normal text field (or a single select field or a multi select field).
Jun 18, 2022 10:27 PM
Hi Silhorn, I don’t think it runs for records that meet the condition before the automation was turned on
If we modify one of your existing records or create a new record with a transaction description that contains the word KFC now, after you’ve turned on the automation, you should see it run
Jun 18, 2022 11:53 PM
Automations don’t go back in time to affect previous records in your base. Automations only work from this point forward (i.e. after you create the automation).
To catch up on old records, you could create a formula field that results in the letters “KFC” for the records that you want. Then, afterwards, you can convert the formula field to a normal text field (or a single select field or a multi select field).
Jun 19, 2022 04:16 AM
Thanks for the help everyone.
A quicker way for old records I found is to delete all records and reload them.