Help

Automation "Create Record" when Date cell "is not empty" firing the automation before time entered

Solved
Jump to Solution
1331 6
cancel
Showing results for 
Search instead for 
Did you mean: 
DevinA
6 - Interface Innovator
6 - Interface Innovator

I have an automation that moves information from one table to another when a date field is entered. The problem is that the date field also has a time associated to it which is an important part of the dataset. The automation fires right as you click a day without allowing time to be entered accurately. Is there a way to only have the automation fire when a time is inputed as well?

1 Solution

Accepted Solutions
jacedh
5 - Automation Enthusiast
5 - Automation Enthusiast

Could you separate the date and time field in two separate fields ("Date" + "Time"), then use a formula to combine them into a Date field with both?

The automation could then have conditions that both fields need to be filled out before running.

Hope this helps!

See Solution in Thread

6 Replies 6
jacedh
5 - Automation Enthusiast
5 - Automation Enthusiast

Could you separate the date and time field in two separate fields ("Date" + "Time"), then use a formula to combine them into a Date field with both?

The automation could then have conditions that both fields need to be filled out before running.

Hope this helps!

I'm afraid not.  jacedh's solution would work great, and another possibility would be using a checkbox field to trigger the automation as well, so you'd fill out the date and time, mark the checkbox, and the automation would fire

When doing this I usually get the automation to clear out the checkbox field too

Hi,

possible solutions:

- add checkbox 'move to another table' and re-trigger automation on it

- change trigger to ' when record matches condition' and set some condition with date field

example:

Alexey_Gusev_0-1676025775995.png


- add formula field (may be hidden) that check whether entered date is valid, trigger automation on formula field

DevinA
6 - Interface Innovator
6 - Interface Innovator

I like this idea. I am not sure of a way to create a field for just a "time". Seems like other solutions have been to use a duration slot in military time which would not be ideal.

DevinA
6 - Interface Innovator
6 - Interface Innovator

This is about as close as I got. I have attached the formula as well. Trying to figure out a way to get the AM/PM to translate.

Screen Shot 2023-02-10 at 10.43.09 AM.png

  

Screen Shot 2023-02-10 at 10.43.21 AM.png

DevinA
6 - Interface Innovator
6 - Interface Innovator

I got it! I am not sure why adding "aaa" to the end of it worked but it allows me to enter 3:00a 3a or 3am and all makes it 3:00am and vis versa with p and pm.

Screen Shot 2023-02-10 at 10.43.21 AM.png