Hi,
When my customer account becomes “cancelled”, we want to set the “cancellation date” automatically, how can I acheive this?
Is there a way to set a date in one field when another field is updated?
+31Hi Steve, you could use an automation to do this, and I’ve set it up here for you to check out
The Today's date formula field is included as it’s the only way (as far as I know) to use today’s date in an automation
The automation triggers when a record’s status is set to “Canceled”, and pastes the value from Today's Date into Canceled Date
Hi Steve, you could use an automation to do this, and I’ve set it up here for you to check out
The Today's date formula field is included as it’s the only way (as far as I know) to use today’s date in an automation
The automation triggers when a record’s status is set to “Canceled”, and pastes the value from Today's Date into Canceled Date
The issue with this approach is that it will output a “date” based on the previous value in the “status” field.
The current status is “active” so it will set the date for when “active” was set, then it will update the date when changed to “cancel”.
I am trying to set a date only when status is cancelled
+31The issue with this approach is that it will output a “date” based on the previous value in the “status” field.
The current status is “active” so it will set the date for when “active” was set, then it will update the date when changed to “cancel”.
I am trying to set a date only when status is cancelled
Nah, the automation only runs when the record’s Status field is “Cancelled”, so what you’re describing won’t happen
Nah, the automation only runs when the record’s Status field is “Cancelled”, so what you’re describing won’t happen
THANK YOU SO MUCH :slightly_smiling_face:
This was PERFECT!
The way you provided a sample was just so super nice of you, you made my day…
THANK YOU SO MUCH :slightly_smiling_face:
This was PERFECT!
The way you provided a sample was just so super nice of you, you made my day…
can you help with this?
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.