Calendar By User

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 how to create a calendar application)




Step 2:  We can go on the option "Database -> SQL Builder" so that we can run a specific script that will add a new field in a table on our database database as a parameter to pass a particular user.

On the tab "Tables" select the table used on the Calendar application on the left side, then click on the arrow as show on the image  to move it to the right side



After this we go to the end page and and click on 


 Selecting the tab "Run"  We add the script of the image bellow and click Run. This way a field will be added to the table in our database



After this we go back to the Calendar application and go on the option "Application -> Synchronize Tables" in order to add the new field



After this we add this new field to appear in the application in "Form Settings -> Fileds positioning":


Step 3: Let's use our field to receive the value of a global variable. In the WHERE CLAUSE of the SQL of the Calendar Application we can do the following condition:





Where [var_login] is our global variable and users it's our field.

Step 4: We will create a control application:


 

We select the connection used:



Inform the application name created:



Step 5: Let's create the field that will serve to inform the specific user



We Inform the application name created

 


 Here we defined the field datatype to "Text". We can also change the field label 

Step 6: Let's create a new link Between the application




Select the calendar application



Now we will go pass our parameter field created in Control, linked to the global variable created in Calendar.



 

And now we can execute our control. Whenever inform a user control, the calendar will appear only with their activities.



    • Related Articles

    • Change user "admin" permissions

      Many times it happens that we modify the permissions of the admin user, and when wanting to verify some configurations or when wanting to modify some characteristics of the ScriptCase we can not have access since the permissions were changed. So what ...

    • 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) ...

    • Hide/Show "New User" field on login screen with HTML template

      In this article, we will learn how to enable the "Hide/Show" feature that is available within the "Security -> Settings" option, for the "New User" field found in the login screen that was generated with HTML template. Currently, this feature is ...

    • How to connect to MySQL 8.0

      The MySQL 8 uses a different authentication from your predecessors, that until the moment it's not accepted by PHP 7, that generates the error "The server requested authentication method unknown to the client" at connecting to Scriptcase. First, you ...

    • How to create a simple LDAP Database on Linux

      Creating a simple LDAP Database on Linux. Installing and configuring slapd We are going to use OpenLDAP(slapd) to build a LDAP database accessible for the security module WITHOUT simulating an Active Directory. This tutorial will create an LDAP ...