I have a database with a number field that external automation will set to a value at certain times. I then require that value to be reduced by one every day until it reaches zero again.
I tried to set this up using Find Record and Update Record in automation but it doesn’t appear that it can do this with multiple records in one table at a time. :grimacing:
Is there a way to set this up? Possibly with some scripting?
Hi there! Yes, Airtable automations can’t perform calculations at this point. So this needs to be handled with a script (within automations). Trigger would be at a scheduled time daily and then the script runs and deducts 1 from a given number field. Is this always one specific field or various fields? If it’s one specific field, it would work like this:
If you are on the free plan and do not have access to Automation Scripting, you can add this formula to count the number down every day. Then an automation that triggers on the update of the formula, to copy the formula result and update the number record