Adding new columns in the table for Calendar

If your calendar application is already created, we must add the fields below in the table so that the new functionalities work correctly:

You can change the table structure with the ALTER TABLE function.

Example in MySQL:

ALTER TABLE table_calendar
ADD COLUMN category int,
ADD COLUMN id_api varchar(255),
ADD COLUMN id_event_google varchar(255),
ADD COLUMN recur_info varchar(255),
ADD COLUMN event_color varchar(255),
ADD COLUMN creator varchar(255),
ADD COLUMN reminder varchar(255)
AFTER period;

Next, we must access the Calendar application and update the application fields through the item Application > Synchronize Table.

Now we should only configure the fields added according to the configuration below:

Field event_color

Field category:

Field id_api:

Id_event_google field:

Field recur_info:

Now we should relate the fields of the table to the fields of the application:

After that, the application will be ready to work properly with Google Calendar integration.