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”.