In this section user can see the description of the toolbar buttons:
The buttons and sections displayed in the toolbar may vary according to the component where the Formula editor has been accessed.
|
Record
|
Save
|
Click on this button any time you need to save formulas or functions drafted in the editor. If the system is not configured to request the countersign (CM008) and the form does not have revision control, the user countersign will be requested after clicking on this button.
|
Save and exit
|
Click on this button to save the formulas or functions and close the editor afterwards. If the system is not configured to request the countersign (CM008) and the form does not have revision control, the user countersign will be requested after clicking on this button.
|
Actions
|
Check for errors
|
Click on this button, so that the system checks if there are any errors in the code entered in the formula editor.
|
Evaluate formula
|
Click on this button to visualize the different parts of a nested formula, evaluated in the order it is calculated.
|
Queries
|
This button is displayed when the Formula editor is being accessed through SE Forms. Click on this button to create SQL Queries to search for information in a database, allowing their usage in commands in the formulas.
|
General
|
Logic
|
Click on this button to see the logic functions that can be used in formulas.
|
Math
|
Click on this button to see the math functions that can be used in formulas.
|
Date and time
|
Click on this button to see the date and time functions that can be used in formulas.
|
Text
|
Click on this button to see text functions that can be used in formulas.
|
Statistics
|
Click on this button to see statistical functions that can be used in formulas.
|
Operation
|
+
|
-
|
=
|
<>
|
This section displays the operations that may be used in the formula editor. They are: sum (+), subtraction (-), equal to (=), not equal to (<>), multiplication (*), division (/), less than (<), greater than (>), open parenthesis, close parenthesis, less than or equal to (<=) y greater than or equal to (>=).
|
*
|
/
|
<
|
>
|
(
|
)
|
<=
|
>=
|
Form
|
Search for value
|
By clicking on this button, the user can see the functions that allow searching for specific values of the entities.
|
Action
|
By clicking on this button, the user can see the action functions to be executed in the form.
|
Message
|
By clicking on this button, the user can see message functions to be executed in the form.
|
Auxiliar
|
By clicking on this button, the user can see message functions to be executed in the form.
|
Process
|
Process data
|
By clicking on this button, the user can see those functions that retrieve some information related to the process.
|
User data
|
By clicking on this button, the user can see those functions that retrieve some information related to the user.
|
Action in the process
|
By clicking on this button, the user can see those functions that allow performing specific actions in the process.
|
Date/time
|
Search for date
|
By clicking on this button, the user can see those functions that retrieve current date or server date.
|
Search for time
|
By clicking on this button, the user can see those functions that retrieve current time or server time.
|
Calendar
|
By clicking on this button, the user can see those functions that retrieve calendar ID # or process calendar ID #.
|
Create date/time
|
By clicking on this button, the user can see the function that retrieves current date and time using 'dd/mm/yyyy HH:mm:ss' format.
|
Compare date
|
By clicking on this button, the user can see the functions that allow comparing two dates.
|
Compare time
|
By clicking on this button, the user can see the functions that allow comparing two times.
|
Compare date/time
|
By clicking on this button, the user can see the functions that allow comparing two dates/times.
|
Separate date/time
|
By clicking on this button, the user can see the functions that allow extracting the date or time of dates using 'dd/mm/yyyy HH:mm:ss' format.
|
Separate date
|
By clicking on this button, the user can see the functions that allow extracting some information about dates using 'dd/mm/yyyy HH:mm:ss' format.
|
Separate time
|
By clicking on this button, the user can see the functions that allow extracting some information about date time using 'dd/mm/yyyy HH:mm:ss' format.
|
Add time/day
|
By clicking on this button, the user can see the functions that allow adding days or time using 'dd/mm/yyyy HH:mm:ss' format.
|
|