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.

• Related Articles

• Calendar By User

  In this example we'll show a connection between an application of Control and the Calendar. This feature can be used for a particular user to view your timetable where their activities are scheduled. Step 1: We will create a calendar, link: (See here ...

• Upgrading the Security Module: how to migrate from the old to the new

  Web application attacks are constantly evolving. With data being such a valuable asset, it is crucial to keep system security updated to avoid losses. The new security module, besides being extremely flexible and intuitive, implements several ...

• How to change the log module table

  After creating the Scriptcase log module, it is possible to change the table. When making this change, a new table will be created from scratch with no records. The records in the previous table must be migrated to your database. How to edit log ...

• Adding Google Fonts to a Theme

  Watch our  Google Fonts video presentation 1 - Visit the link to access Google Fonts: https://fonts.google.com/ 2 -Select the desired font. 3 - Copy the link that is inside the tag. 4 - Go to Layout> Application Css (Themes). 5 - After that, click ...

• Request a new license

  Some situations require the reinstallation of Scriptcase, in these cases, the user must generate a new serial on our website to register the tool. Follow the steps below to generate a new serial:  1. Log in to the website The entire process to ...