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

    • Enabling Amazon S3 API

      This tutorial shows you how to obtain access credentials for S3 storage. 1) Create a new AWS account, and then log in as root User, entering the email and password that were informed in the registration. If you already have an account, proceed to the ...

    • Getting Credentials on Braintree

      1-Access your Braintree Sandbox or Production account Log in to your Braintree account  To use the API it is necessary to have an account. 2 - Acesse o dashboard no menu Settings > API 3 - In the Private Key column, click on the View link to access ...