Saving form data to the database as an array

🌐 This document is available in both English and Ukrainian. Use the language toggle in the top right corner to switch between versions.

To load an array of data to the data factory, use the Edit Grid component when modeling the UI form.

The Edit Grid component enables you to model records from different components as a single array and upload them to the database. The array must follow the structure defined by the data model.

If the structure of an array in a form does not follow the model defined in the database, the values from the form will not be loaded, and the system will return an error.
This topic demonstrates a test scenario of modeling a data array for loading documents using the Edit Grid component.

  1. Sign in to the Administrative portal.

  2. Open the UI forms section.

    ui forms 1

  3. Create a form or select one from the list.

  4. Open the Builder tab.

  5. In the components panel on the left, select Updated.

  6. Find the Edit Grid component and drag it onto the modeling canvas.

    edit grid sort as number 1

  7. In the new window, click Save.

    edit grid sort as number 2

  8. Add components to the Edit Grid according to the business logic—​for example, Text Field (twice) and Date / Time.

    edit grid sort as number 3

    edit grid submit data as array 1

    As a result, the modeling canvas looks like this:

    edit grid submit data as array 2

  9. Open the Preview tab to see how the form will appear in the UI.

  10. Click Add to fill out the table.

    edit grid submit data as array 3

  11. In the new window, fill out the fields and click Save.

  12. Add more records to the table if necessary.

    edit grid submit data as array 4 en

This is how you create a table with columns of different types (in our example, components Text Field and Date / Time) combined into a single array under the Edit Grid component. From now on, officer users can fill out the UI forms with real data as part of the business processes. After the data is digitally signed, it will be saved to corresponding tables in the database.

edit grid submit data as array 5 en
Figure 1. Request to data factory in a JSON format