Hello everyone,
As a event planner, I would like to set some automations to create another record when one specific is created. I would like to create a 1 hour long record "Set Up" when I create a record "Meeting" to have the set up already writen in the planning without having to write it myself.
Do you know how I can do that?
Thanks in advance
+18Sure, you'd need to create a formula field that calculated what time it is one hour before your meeting's start time, and you would create an automation that would trigger when a record's name was "Meeting", and its action would be to create a new record with the formula field's time:
 
Sure, you'd need to create a formula field that calculated what time it is one hour before your meeting's start time, and you would create an automation that would trigger when a record's name was "Meeting", and its action would be to create a new record with the formula field's time:
 
Thank you a lot for your reply :).
Unfortunately, I don't know how to create a formula field that calculated what time it is one hour before the meeting's start time. I tried but each time it asked a precised hour, I am surely doing it wrong. Is there a formula for me ?
Thank you 😉
+18Thank you a lot for your reply :).
Unfortunately, I don't know how to create a formula field that calculated what time it is one hour before the meeting's start time. I tried but each time it asked a precised hour, I am surely doing it wrong. Is there a formula for me ?
Thank you 😉
Yeah, you can duplicate the base I linked above to view the formula used
Yeah, you can duplicate the base I linked above to view the formula used
Is it possible for you to write your formula down here ? For me to understand and replicate it for other events such as cocktails etc.
Thank you :))
Yeah, you can duplicate the base I linked above to view the formula used
Hello @TheTimeSavingCo,
Is it possible for you to write your formula down here ? For me to understand and replicate it for other events such as cocktails etc. thank you !
Have a good day :))
+18Hello @TheTimeSavingCo,
Is it possible for you to write your formula down here ? For me to understand and replicate it for other events such as cocktails etc. thank you !
Have a good day :))
Yeap sure
DATEADD(
Date,
-1,
'hours'
)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
