LinkedIn
Twitter
Hey everyone!
There is a problem that I can't quite put my finger on. I have a table called Bookings, where I store every entry made in a booking app. But when a change happens in the Booking table (users change the date of their booking) I want to modify the Google Calendar table (Data set directly imported from google calendar). Now I created a bot for that with the following parameter:
1. Bot triggers when a change happens to the starting time or the end time in the Booking table.
2. And branch decides which Calendar table to update.
3. After it is chosen, I select the corresponding booking using an ID field, and I execute an action on the Calendar table, putting the start time and end time from the Booking table to the Calendar table. I use an expression like this:
LOOKUP([Row ID], "Bookings", "ID", "Start Time")
LOOKUP([Row ID], "Bookings", "ID", "End Time")
So the problem is, that this does not work and crashes with an error like this:
I checked everything I could, I tried to convert it to ISO format in the action, I checked in both tables that the Start and the End is a DateTime value, both ignores seconds. I tried to convert it in the action to very different formats but alas no change, it crashed with this error all the time. What is quite strange that with the base settings (not converting the Start Time from the Booking just using the plain lookup) it actually ran once with a success... And not anymore.
I am so confused why this does not work. Any help or ideas would be highly appreciated. I am a rookie when it comes to appsheet, but if you want further information to investigate, I would try my best to provide it.
Thank you!
