Add or Update Function

An overview on how to create a data table Add or Update Function

The Add or Update function allows the datatable to capture new data when it is entered into the app or update data that is already present in the datatable by using a data value as a reference that is already present in the data table records.

Create an Add or Update Function

  • Go to the main dashboard, click on the Admin Menu > Database > Data Tables.

  • You will land on the Data Tables List page.
  • Choose a data table for which you want to create data table functions and click Manage Functions corresponding to that particular data table.

  • You will land on the Data Table Functions page.

  • Click +Add New Function.

  • You will land on the Add Data Table Function page.

  • Select Add or Update radio button.

  • Give a Name to the function.
  • Select the elements from the Add Elements drop-down to take the selected element as a reference to update the data.

  • Select the Condition element which act as a reference elements.

  • You will see the Mapping and Condition fields display. These fields are to map and set the condition for the input element/mapped element, respectively.
  • Click on the Mapping drop-down, and it will show two values Mapped and Static.
  • You can map the element to a condition, or you can set a static value to the element field that needs to be displayed.
  • Click on Condition drop-down, and it will show you the below-given values.
  • Contains: If the element field contains a value, then the condition becomes true.
  • Not Contains: If the element field does not contain any value, then the condition becomes true.
  • Empty: If the element field is empty, then the condition becomes true.
  • Not Empty: If the element field has any value entered in it, then the condition becomes true.
  • Equal: If the element field value is equal to the selected field value, then the condition becomes true.
  • Not Equal: If the element field value does not equal to the selected field value, then the condition becomes true.
  • Starts With: If the element field value starts with the selected field value, then the condition becomes true.
  • Ends With: If the element field value ends with the selected field value, then the condition becomes True.

    • Select the Update Elements which will get updated when the condition satisfies, and Type as Replace , the elements which need to be updated in the datatable.

    • Click Submit to save the data function.

    To get a visual understanding on how the Add or Update function work in Quixy, refer to the video below.

    Data Functions part-2