Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: calendar view change default time

1844 0
cancel
Showing results for 
Search instead for 
Did you mean: 
hareese
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello!

Adding an entry to calendar view automatically set the time to midnight. Is there a way to change the default time to anything other than midnight?! Thanks!

8 Replies 8
Sara
8 - Airtable Astronomer
8 - Airtable Astronomer

Hi, do you mean like this? that you can select the time

Sara_0-1700680398344.png

 

hareese
5 - Automation Enthusiast
5 - Automation Enthusiast

Yes, correct you change the time - wondering if there is a way to change the default time to something other than midnight - because midnight messes up the automations, thank you.

Sara
8 - Airtable Astronomer
8 - Airtable Astronomer

One thing that you can do, is creating an automation that fill out the column "time" with a fixed value.. 

for example: 

Sara_0-1700680786484.png

Sara_1-1700680818095.png

so every time that you create a record it will go into that day and after you need to change the day and month

Sara_2-1700680889353.png but I don't know how much this could be useful

 

Sara
8 - Airtable Astronomer
8 - Airtable Astronomer

Otherwise.. another thing that you can do to "Trick" your automation is create a column "Clock".. This is what I'm using in my job.

Sara_0-1700681520689.png

So all the automations start only when the column "Clock" arrives at 9 am. In this way I'm able to choose the exact time for the automation (Think that the formula will update every 20/30 minutes, so sometimes the automation will start at 9:05 other times at 9:30 am)

 

hareese
5 - Automation Enthusiast
5 - Automation Enthusiast

That's a good idea too - so does your automation only run if that time if 9:00am or after? 

Sara
8 - Airtable Astronomer
8 - Airtable Astronomer

Yes, I choose at 9, so between 9:03 and 9:30 I will have the email (In my case), but you can also use the option "bigger than" 9 so you will have from 9 am 

Sara_1-1700682183764.png

 

I set up the automation in this way: 

Sara_2-1700682274445.png

 

 

hareese
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks for sending this - very helpful!

Sho
11 - Venus
11 - Venus

If you are using Interface forms or free layout pages, you can set default values for date fields.
However, both the date and time are set, not just the time.