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](https://www.scriptcase.net/docs/en_us/v9/manual/06-applications/14-calendar-application/23-new-application/))

![](https://desk.zoho.com/DocsDisplay?zgId=716875472&mode=inline&blockId=o3xri384058ef3d774216bbec9220a2c9fcc0)

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

![](https://help.scriptcase.net/galleryDocuments/edbsn6ff69a5d87d9319dd596476a1f7b5a0525535b1097029cc18f4b6ed1bb8cf1c917c6c18d4ae13b9bf6add97c31cc882f?inline=true)

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

![](https://help.scriptcase.net/galleryDocuments/edbsn3cb080266f9a50d343a90ce0d76b280fb9ac369ea024820d48376a999ae7c0b9c79614ab2c9fb5da203048b2d4b0b568?inline=true)

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

![](https://help.scriptcase.net/galleryDocuments/edbsnb44a80119e9a4b1852528a23a24fc921fbf9ce9ecfe8c9e2347bea72f9739602fe513e0cc44fff847648a8224ec30e15?inline=true)

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

![](https://desk.zoho.com/DocsDisplay?zgId=716875472&mode=inline&blockId=0a12g605aae3bf4954cfa9ab223d2d07891c2)

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

![](https://help.scriptcase.net/galleryDocuments/edbsnc1b5f9535814fe687c59e11fe646ab460465f97f9436fe81cc7503297e275c19e5d8f30de6bb43db921338ed1ac2dc23?inline=true)

![](http://cdn1.netmake.com.br/img_kb/en_us/calendar_by_user/imagem2.PNG)

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:

![](https://desk.zoho.com/DocsDisplay?zgId=716875472&mode=inline&blockId=0a12g766c929cd97642f69880f41d876a01f7)

Where [var\_login] is our global variable and users it's our field.  
  
Step 4: We will create a control application:

![](https://desk.zoho.com/DocsDisplay?zgId=716875472&mode=inline&blockId=0a12g86119e92af8344109d06574c8758f518)

![](http://cdn1.netmake.com.br/img_kb/en_us/calendar_by_user/imagem4.PNG)

We select the connection used:

![](https://desk.zoho.com/DocsDisplay?zgId=716875472&mode=inline&blockId=0a12g497acc88dd5043e18b948f43d7141a44)

![](http://cdn1.netmake.com.br/img_kb/en_us/calendar_by_user/imagem5.PNG)Inform the application name created:

![](https://desk.zoho.com/DocsDisplay?zgId=716875472&mode=inline&blockId=0a12g18b469836e8a4b99a9bc411d1a73d34c)

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

![](https://desk.zoho.com/DocsDisplay?zgId=716875472&mode=inline&blockId=0a12g008de791b6264ead9f960194cae439b6)

We Inform the application name created

![](https://desk.zoho.com/DocsDisplay?zgId=716875472&mode=inline&blockId=0a12g384cf6644d1149bd9b6276f34c9bd322)

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

![](http://cdn1.netmake.com.br/img_kb/en_us/calendar_by_user/imagem9.PNG)

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

![](https://help.scriptcase.net/galleryDocuments/edbsn24041ad79a548edc983c6fc9d32fca2f2e5f0b981a343e884b46fedef676e39594351a7252ee6725f89a224282280fe6?inline=true)

Select the calendar application

![](https://help.scriptcase.net/galleryDocuments/edbsnb44a80119e9a4b1852528a23a24fc9211be5dd3a9801787c067852b325969e6ee00d03cf91c95f145ac312c640d8ff87?inline=true)

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

![](https://desk.zoho.com/DocsDisplay?zgId=716875472&mode=inline&blockId=0a12ga6d07d7b297141fd833ca0ff0e16e662)

![](http://cdn1.netmake.com.br/img_kb/en_us/calendar_by_user/imagem10.PNG)

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