Adding option to delete a record

To setup a page to enable users to delete a record from the database, you can do so following the
example JSON below:

{
"title":"Authorised",
"action":"query",
"queryreference":"AU - Annual Leave Last 12 Months",
"role":"AU",
"message_no_data_content":"No authorised requests.",
"message_no_data_title":"Authorised",
"options":"Select",
"select_mode":"Single",
"next_action":"form",
"next_reference":"AUDALREQ",
"next_action_title":"Delete Holiday",
"submit_button_text":"Cancel",
"FieldsToExtract":[

{


"DELETE_ME":"Yes"


}


]

}

The key properties are listed below and need to be included for this functionality to work:

Property Description
options This is required.
select_mode Enables selection of a single record to open a popup form to display additional details.
next_action This property is required to open a popup form from a grid.
next_reference The form that appears on clicking the select button is determined by the reference that is entered here. This reference should match with the reference code of a form found in the Form Builder
next_action_title This is the title that appears at the top of the popup form that opens on clicking the select button.
submit_button_text This is the caption of the submit button on the popup form.
“FieldsToExtract”:[
{
“DELETE_ME”:”Yes”}
]
Required so that once the submit button is clicked, the record is deleted and not amended.

The form referenced should contain purely display only fields, but the form type should be set to
“Update – 0 Authorisation”.