Nov 07, 2022 01:17 AM
Hello,
I currently have airtable tracking shipments that are scheduled to come back at a later time.
I have to manually track all this. I have tried my hardest to find the method to make airtable do this automatically but i cannot figure it out.
i have a status field and I would like the delivered date and due date to be automatically adjusted when i mark the status as “with client” I am trying to figure out how to make airtable select the delivered date on the day that I mark the order “with client” and add 10 days to the due date.
could someone please help me . thanks
Nov 07, 2022 02:30 AM
For this, I think you can:
TODAY()
Status
is “With Client”, and its action will be to update the triggering record’s Delivered
value with the value from the Today
field from the previous pointI assume this means that the due date is ten days after the Delivered
date? If so, a formula field should do fine here with the formula being something like the following:
DATEADD({Delivered}, 10, 'days')
Nov 07, 2022 08:24 PM
thank you! I will try this