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.