Code Components
Blog: Comidor Blog
Comidor offers a powerful workflow designer which is compliant with BPMN 2.0 where you can map and optimize any process that takes place in your company. Comidor provides a plethora of workflow components such as Basic, integration, data, RPA, and code components to cover any possible need. You can easily drag and drop any component, connect the elements between them to draw the alternative paths, and add any automation features like an automated email or an automated document creation.
Workflows can be linked with a generic process or with an app.
- To access Workflows, click on App Factory Icon > Process Automation > Process Designs. Open a record, and click on the tab Design.
- For Workflow applications, go to App Factory Icon > Application Builder> App Designer and then open a workflow-type app and go to step 2.
Code Components
Include Code Components in the Comidor Workflows Designer, and enhance your processes without using any coding. Users without development skills can add the following code components in the workflows to replace commands and queries:
- Set values
- Check existence
- SQL Creator
- String Utilities
Set values
With this component, Comidor enables users to assign values to specific fields. For example, you can give a date field the value of the current date (#DATE#), make a calculation, define a value (make a checkbox checked, or give an option in a key-value list type field), etc.
- Give a Title to the component.
- Give the Parent Stage which is the stage of the parent process as soon as this step is reached.
- In the Data map, define the fields of the workflow and the values you wish to assign to them.
- Click on the + icon to map more fields
- Click on the – icon to remove a row.
- In case you want to modify the Set values code component, you can click on the pencil icon and proceed accordingly.
-
When you run the workflow, the Set values code component will run automatically when you reach this step. The fields defined in the map will have the values you set (eg the checkbox “Paid” will be checked, the “Travel date” will be today’s date and the “Total amount” will be calculated based on the formula and the values of the other 2 fields).
Check existence
With this component, Comidor enables users to check if a record exists in a particular Comidor application. For example, you can check the existence of a contact or account based on a defined condition (eg. email).
- Give a Title to the component.
- Give the Parent Stage which is the stage of the parent process as soon as this step is reached.
- Define in which Entity, you want to search if a record exists. Choose from the list of all Comidor applications.
- Write the Condition of your query (as if you would write it in a script)
- Choose a Response field, to store the response of the check existence code component.
- If you receive value 1, the system has found at least one result to your query
- If you receive value 0, the system has not found any result to your query
- You can use the response field in workflow conditions to activate alternative flow.
- In case you want to modify the code component, you can click on the pencil icon and proceed accordingly.
SQL Creator
With this component, Comidor enables users to check if a record exists in a particular Comidor application. For example, you can check the existence of a contact or account based on a defined condition (eg. email).
- Give a Title to the component.
- Give the Parent Stage which is the stage of the parent process as soon as this step is reached.
- Type: define what kind of operation/statement you want to perform. Choose between the Select, Insert, Update, and Delete options.
- Action: choose between:
- Produce query – the component will form the statement, and write it on the Statement field so that the user can run it on a DB
- Execute query – the query will be executed and the results (in case of select) will be written on the Results field
- Advanced Query: if checked, the advanced query text area will be displayed and the user can write by themselves the query to be executed
- Recommended for complex queries which cannot be specified otherwise
- Define in which Table, you want to search if a record exists. Choose from the list of all Comidor applications.
- Choose fields: the field (select one field of the table) Value (select an app/process field)
- in case of insert: the entity which will be inserted will have the value to the respective field
- in case of update: similarily for the entity which will be updated
- in case of select: the field of the first row of the results will be stored to the Value
- Click on the + icon to add more fields to your query.
- Click on the – icon to remove a row.
- Write the Condition of your query (as if you would write it in a script)
- Order by: in the first row select the field which will sort the results, and in the second, specify if the sorting will be ascending or descending.
- Choose a Results field, to store the response of the code component.
- In case you want to modify the code component, you can click on the pencil icon and proceed accordingly.
The post Code Components appeared first on Comidor Low-code Automation Platform.
Leave a Comment
You must be logged in to post a comment.