Im in the process of linking my table “Sessions” to my google calendar table. The aim is to have the google calendar entries update on individual booking changes and to also delete entries from the google calendar when events are cancelled.
My aim is to create an action for an add a new row to another table using values in this row. This will be from the “sessions” table to the google calendar table. The idea is then to create a workflow to watch for changes on the start DateTime column to trigger changes. I also have a cancellation column in my “sessions” which has a TimeStamp action when the status of a session is changed to cancelled. The idea is that this will then be triggered by the google cal table to delete the event.
So I’ve started to implement this by using the Title field in the google calendar table as a reference to the sessions table, but, when I use anything that contains numbers and letters it says "Value in field cannot be converted to type Ref. - Does anyone know why this would be?
The main reason I have written quite a lengthy message to describe what I’m doing is to find out whether I’m doing this totally wrong or whether I should be approaching it a different way?