Start a conversation

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:


category
int
id_api
varchar(255)
id_event_google
varchar(255)
recur_info
varchar(255)
event_color
varchar(255)
creator varchar(255)
reminder varchar(255)



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.


Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. Ronyan Alves

  2. Posted
  3. Updated

Comments