Hello everyone!
Context:
The app I am working on calculates dates for particular events based on input from the user then automatically creates corresponding events in a google calendar.
Problem:
I am trying to get to the bottom of an issue Iโm experiencing with the Action that generates a new row to my gCal table.
The expression I use in the โStartโ column is: DATETIME({Date})+ โ007:00:00โ
The expression I am trying to use in the โEndโ column is: DATETIME({Date})+ โ008:00:00โ
However, a new event is not generated whenever I use this expression in the โEndโ column!
When I switch the โEndโ column expression to simply: NOW(), the calendar event is generated correctly.
As a workaround I tried to set the โEndโ column formula as [START] + โ001:00:00โ
โฆ which didnโt work either.
Any help getting to the bottom of this is greatly appreciated!
Thanks, Kyle C.
My testing showed that in a similar set up it works as expected.
Could you confirm the [Prep] column is date type.
Hi, thanks for the response.
Yes, I confirmed that column type of [Prep] is a date.
When I use the expression with [Prep] in the โStartโ column it works perfectly fine. Its only when that expression is used in the โEndโ column that the action fails and the row on my calendar table is never added. As soon as I remove the expression from the โEndโ column, leaving it only in the โStartโ column, the action executes and a new row is added.
Thanks for your time,
Kyle C.
Hi,
Thank you for confirming.
I believe it is some peculiar setting that could be causing a challenge. As I mentioned, principally it is working with the following setting when I tested. [Customer Since] is a date type colum.
So principally, it does not appear to be a bug with settings at least.
Can you please confirm that the action you re-created executes successfully and adds a new event to the calendar?
The expression assistant is also showing me that my expression is formatted correctly, and when testing it produces the correct outcomes.
I do not understand what, if any, setting could be causing the action to fail however.
Yes, I confirmed that the action works and adds rows to the calendar.
Your test expression appears to be [Prep]+โ008:00:00โ. You also confirmed that [Prep] is a date type column.
If so, could you try with the expression DATETIME([Prep])+โ008:00:00โ as suggested earlier instead of [Prep]+โ008:00:00โ
Hmmm, well I am running out of ideas. I have confirmed that the [Prep] column is a date column, and even wrapped the expression with DATETIME() like you suggested but nothing is working.
I have even tried creating a Datetime virtual column [Prep end] that calculates the expression [prep]+โ008:00:00โ, and then simply using the [prep end] column to populate the row in the action, but it STILL isnโt working.
As soon as I take out the expression, or any of my date columns, the action executes and a calendar event is created.
Thank you for the response, I appreciate your time helping me.
-Kyle
Oh okay thank you for the update. I am afraid, I may not have any more suggestions as it works for me with or without datetime format. You may wish to request help from AppSheet support team. (support@appsheet.com) or someone else.
Will request you to post solution after you get it, for the benefit of other community members.
I just reached out to the support team for assistance, I will post back here with the details.
Thank you again for your time Suvrutt_Gurjar,
-Kyle C
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |