Sc_lookup: Find records from a data table Sc_field_display: whether to display a certain field Sc_ajax_message: pop up an Ajax message window Using these macros can greatly reduce the development workload and save you time, such as: $check_where = "field = 'condition'" // Where clauseĬhange the $ check_table and $ check_where, it can be used directly, is it not very simple?
#Scriptcase email field type code#
Developers only need to click the available code block (the icon in front of the available code block is a small green dot), you can insert a whole code into the code window, modify the parameters and you can use it immediately, which is very convenient.įor example, we often need to find whether a certain record of a certain table exists, at this time we can click Check for an existing recordĪt this time, the system will automatically insert the following code blocks: When an event window is opened, the code blocks that can be inserted are displayed on the far right of the editor, and the code blocks are classified according to their types, such as ajax, database, date, email, error, and so on. If the event already has a code, it is displayed as a yellow lightning mark if the event has no code, it is displayed as a gray mark You can easily know which events are programmed by clicking here, and click the event name to open the code window. Under the "Event Management" menu on the left panel of ScriptCase, you can see the events that can be used by the current program. You can also see the commonly used methods in the code prompt box. , most development environments use CTRL + Space for code hinting). When using an object, press CTRL + Space to open the code hint (yes, it conflicts with the Chinese switching of the system.
#Scriptcase email field type how to#
Let's show you how to use ScriptCase's code editor with screenshots: Even users who do not understand PHP can easily write standardized PHP code. Fortunately, ScriptCase provides some very convenient tools for PHP code writing. After all, more complex businesses require code to achieve.
In the settings of the field, use the “Accumulated” option and select the field “CreditLimit” in “Accumulator Field”.ĭo you want to see more Scriptcase examples? Click HERE to check it out.Although ScriptCase has reduced the workload of programming to a very low level, it still allows developers to write code at design time.
We will create one field called “Accumulated” of the “decimal” type.ĥ. In the application, menu opens the Fields folder and click on the item New FieldĤ. To select the fields click on Fields Positioning located in the application menu.ģ. Select the fields CustomerID, CompanyName, ContactName, ContactTitle, BirthDate, Country and CreditLimit. Create a new grid application using the Customers table.Ģ. In this example, we will develop a report using the accumulated field option, which allows accumulating the values of a column in another one.ġ. Accumulated type of field on Scriptcase is used to show a sum of a specific field based in the number of records loaded in a report application, it will show the total amount of all records already loaded on the applications, for example, in the image below Scriptcase will show the SUM of the credit limit field from the previous records and show it on the Accumulated field created by the developer.Ĭlick on this LINK to see the example running.
0 kommentar(er)
