When creating an app that allows end-users to submit new records you may find it necessary to add an approval process so that new records can be reviewed before they are published to the general public.  This article shows you how to set all new records to inactive in order for you to review and publish submissions through an internally facing DataPage.

Steps to create an approval process:

1.  Add an approved checkbox to the base table

  • From the Caspio Bridge homepage screen, click on Tables which shows you the list of tables  residing in your Caspio bridge.
  • Select the table that holds all of your public facing records and open the Table Design view by clicking on Design.
  • In the first available row enter the fieldname “Active” and set the data type to Yes/No.
  • Click Save.

How_to_create_an_approval_process_for_new_submissions_1

All of your records will be marked inactive by default.  You may want to mark all of your current records as active either individually, or by downloading the current table to an Excel workbook, setting all of the values of the Active column to “TRUE” and then importing the data back into Caspio Bridge using the “Replace” option.

2.  Filter the published records so only approved records are visible

  • Select the Report DataPage that your public end-users use to view records. Click Edit.
  • Proceed to the Select Search Fields screen. Move the Active field created in step one to the right-hand column using the arrow buttons.
  • Select the Active field in the DataPage Elements panel and using the Form element dropdown menu, select Hidden. Check the “Yes” value next to On load assign.
  • Click Finish to save your changes.

Now only records with the active checkbox checked will appear visible to your end users.  If you have not yet marked any records as active as explained in step one, all searches will return “no records found”.

Next, you create a search and report to view and publish unpublished records. In order to view the records internally before they are published to the public, you need to create a second DataPage.

3.  Create a search and report to view and publish unpublished records

  • Select the public facing DataPage, click More and click Duplicate.
  • Rename the page to indicate it is for internal review of records. Click Save.
  • Click Edit to open the copied DataPage.
  • Proceed to the Configure Search Fields screen. Select the Active field in the DataPage elements panel and change the form element to Radio Buttons.

Now you can choose to view only active or inactive items or both when you search.

How_to_create_an_approval_process_for_new_submissions_3

4.  Change the details page to allow modifications of individual fields

  • Proceed to the Select Details Page Fields screen.
  • Move the Active field to the right-hand panel using the arrow button.
  • Because this DataPage will be internal, you can change the default Display Only setting to an editable form element. For example, using the Form element dropdown, change the form element to a check box.
  • Click Finish.

How_to_create_an_approval_process_for_new_submissions_4

Now when you use this DataPage you will be able to edit any mistakes in the fields as well as mark the individual record as active.