Update Function

An overview on how to create a data table Update Function

When new data is entered in the app, the update function allows the data table to replace the data present in the data table with fresh data coming from an app while keeping a data value as a reference which is already present in the data table.

Create an 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 the Update radio button.

  • Give a Name to the update function.
  • Select the Input Function element, the selected element will act as a reference element and the data corresponding to it will update in the data table when a new data is entered in the application taking the input element as reference.
  • On selecting an element field, the element field will act as a reference element to the data table.

  • You will see the Mapping and Condition fields display. These fields are to map and set the condition for the input element/mapped element.
  • 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.
  • 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.

  • Click on the Plus button to add more Input Function elements.

  • Select the Output Function Elements which want to be updated when changes are made through the app.
  • Select the Type as Replace.

  • Click on Submit to save the data function.

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

Data functions Part-1