The next step is to create the necessary fields for the user to enter their name, desired amount and number of installments. We create a Control application in order to add the fields we want to show the user and from which we will then carry out the process that will calculate how much the user will have to pay and how much he will pay each month including interest. Once inside our project in the Scriptcase, we create the connections that we will need to consult the table in PostgreSQL (conn_Parameter) and then insert into the MySQL table (conn Sales). Within the table “Parameter” we have the percentage of interest that the user will pay based on the number of months that he chooses in our application. The process that we will do will calculate the percentage of interest that the user will have to pay based on the amount desired and the number of installments (months) that he needs to pay back. The table “Parameter” in a PostgreSQL database. In terms of Database structure, we have two tables which are shown below: We will use the following Scriptcase Macros to make our work easier: On the other hand the user will enter some parameters and then complete the calculation and insert the result into the Database. The data processing that we will show as an example here is the one done at the Application level, to execute this example we will take certain parameters from the Database.
Depending on how big the volume of data to handle are and the interaction that the user must have, one or the other may stand as the best option in some cases.
The toolbar of the application is divided into two guides: Desktop and Mobile, so it is possible to define which buttons will be displayed on each device type.Ĭlick the button below to view the application running.Data Processing in Control Forms: Using Macros to query and insert into Databaseĭata processing can be done at the Database level (with Stored Procedures, Triggers, Functions and so on) or Application level.
Open a Form application and go to the “Toolbar” item in the application menuĢ. Selecting buttons to show on the mobile applicationġ.
Scriptcase open form with onclick event how to#
In this sample we will show how to set up a different toolbar buttons for your mobile application.
Scriptcase open form with onclick event code#
When a form application is created on Scriptcase, automatically, two different folders are also created, one with source code for the desktop form and the second one with the source code for the mobile form, and then, when the applications is being accessed by an end user, Scriptcase will identify what device it is and will redirect the end user to the best form, either mobile or desktop. Form with Mobile Responsiveness: Applications now have adapted to mobile environments, so the user can access their applications directly from your tablet or smartphone independent of the size of the device screen used to access the application Scriptcase always display the contents of the friendly form.
0 kommentar(er)
