I just need to create a event after a form saving. To do that, I created a action that add a new row to the calendar table.
In Set these columns , I need to define the Start and End columns to contain values taken from another form, I can do that without problems. The value taken from the other form is a date, I need to set a datetime for Start/End columns using that date. To achieve this I tried to create an expression that uses the date column from the first form and manually inserts the time, but the AppSheet doesnโt recognize it as a datetime.
I tried to format:
CONCATENATE([date_form_1], โ 08:00:00โ)
DATETIME(CONCATENATE([date_form_1], โ 08:00:00โ))
DATETIME ([date_form_1] & โ 08:00:00โ)
Only DATETIME([date_form_1]) worked, but I canโt use the default time of noon.
Solved! Go to Solution.
Please try
DATETIME(CONCATENATE([date_form_1]," ", โ8:00:00โ))
Please note the space, " " between date and time value concatenation. I believe the Datetime column format needs a space between Date and Time values. Hope this helps.
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |