I’m using airtable as a project management tool amongst other things in my business. It’d be really great to have the time in a date field default to 5:00PM (EOD) for every date entered instead of the current default which is the current time. Is there a way to do this other than using a formula as I’d really like to use the new timeline feature which doesn’t seem to support formulas.
Thanks for the help!
+20I just ran a quick test, and formulas work fine with the new timeline view. One critical point to remember about this new view is that the start and end fields need to have the same options in their settings (e.g. time vs no time, GMT vs not GMT). As long as they’re both configured the same way, it should work.
Re: the 5 pm default, are you saying that you’d like the ability to override that time in certain cases, or do you always want it 5 pm no matter what?
+1I just ran a quick test, and formulas work fine with the new timeline view. One critical point to remember about this new view is that the start and end fields need to have the same options in their settings (e.g. time vs no time, GMT vs not GMT). As long as they’re both configured the same way, it should work.
Re: the 5 pm default, are you saying that you’d like the ability to override that time in certain cases, or do you always want it 5 pm no matter what?
Sorry I know this is an old thread, but I am having this same issue and have not found a solution. I would like to be able to set it so that when someone enters date, the time in that field defaults to 5pm, but then someone can manually change it to something else if they want to. Currently, if you enter a date, the time defaults to midnight unless it's manually changed. Do you know how to do this?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
