Create a record one hour before another existing record

[username1]

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 

[TheTimeSavingCo]

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:

 

Link to base

[username1]

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 😉

[TheTimeSavingCo]

Yeah, you can duplicate the base I linked above to view the formula used

[username1]

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 :))

[username1]

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 :))

[TheTimeSavingCo]

Yeap sure

DATEADD(
  Date,
  -1,
  'hours'
)