{
  "title": "Json Form Editor: {{SELECT id, \" \/ \", name FROM Form WHERE id = {{r:S0}}}} (DB: {{dbNameQfq:Y}})",
  "noteInternal": "",
  "tableName": "Form",
  "primaryKey": "",
  "permitNew": "sip",
  "permitEdit": "sip",
  "restMethod": "",
  "escapeTypeDefault": "c",
  "render": "bootstrap",
  "requiredParameterNew": "",
  "requiredParameterEdit": "",
  "dirtyMode": "exclusive",
  "showButton": "new,delete,close,save",
  "multiMode": "none",
  "multiSql": "",
  "multiDetailForm": "",
  "multiDetailFormParameter": "",
  "forwardMode": "auto",
  "forwardPage": "",
  "labelAlign": "default",
  "bsLabelColumns": "col-md-1",
  "bsInputColumns": "col-md-10",
  "bsNoteColumns": "col-md-1",
  "parameter": "dbIndex={{indexQfq:Y}}",
  "parameterLanguageA": "",
  "parameterLanguageB": "",
  "parameterLanguageC": "",
  "parameterLanguageD": "",
  "recordLockTimeoutSeconds": 900,
  "deleted": "no",
  "modified": "2021-04-09 11:38:15",
  "created": "2021-03-22 11:42:00",
  "FormElement_ff": [
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "name",
      "label": "Name",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "pattern",
      "checkPattern": "[a-zA-Z0-9._+-]+",
      "onChange": "",
      "ord": 10,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "autofocus\r\ndata-pattern-error=Allowed characters: alphabet, number or . - +",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-09 11:38:15",
      "created": "2021-03-22 11:57:51"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "myJson",
      "label": "Json",
      "mode": "show",
      "modeSql": "{{ SELECT IF({{r:S0}}=0,'readonly','show') }}",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "none",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 20,
      "tabindex": 0,
      "size": "1,6",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "#!report\r\n\r\n# Use Data URI to download given base64 encoded json string as text file\r\n\r\n10.sql = SELECT \r\n                  '<a download=\"{{name:R}}.json\" class=\"btn btn-default\" href=\"data:application\/octet-stream;base64,'\r\n                  , 'fid:{{r:S0}}|b64' AS _formJson\r\n                  , '\"><i class=\"fas fa-file-download\"><\/i><\/a>'\r\n               FROM (SELECT '') AS _fake WHERE {{r:S0}}!=0",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "#!report\r\n\r\n10.sql = SELECT 'fid:{{r:S0}}' AS _formJson\r\n\r\n15.sql = SELECT IF({{r:S0}}=0, 'Please save this form first.', '')",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-22 15:27:31",
      "created": "2021-03-22 11:44:22"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "myBackupNote",
      "label": "Backups",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "note",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 25,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "{{ SELECT IF('{{id:RE}}'!='', 'Form backup location: {{qfqProjectPath:Y}}\/form\/.backup\/{{id:RE}}\/', 'Please save this form first.') }}",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-09 11:38:15",
      "created": "2021-04-08 10:40:09"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "myJsonReduced",
      "label": "Json reduced",
      "mode": "readonly",
      "modeSql": "",
      "class": "native",
      "type": "note",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 27,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "#!report\r\n\r\n# Use Data URI to download given base64 encoded json string as text file\r\n\r\n10.sql = SELECT \r\n                  \"Json version without 'modified' and 'created' and without keys holding default values: \"\r\n                  , '<a download=\"{{name:R}}.json\" class=\"btn btn-default\" href=\"data:application\/octet-stream;base64,'\r\n                  , 'fid:{{r:S0}}|b64|reduce' AS _formJson\r\n                  , '\"><i class=\"fas fa-file-download\"><\/i><\/a>'\r\n               FROM (SELECT '') AS _fake WHERE {{r:S0}}!=0",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-22 15:30:18",
      "created": "2021-04-22 15:11:12"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "",
      "label": "save Json",
      "mode": "show",
      "modeSql": "",
      "class": "action",
      "type": "afterSave",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 30,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "saveFormJson={{myJson:FE:all:S}}\r\nsaveFormJsonName={{name:RE:all}}",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-09 11:38:15",
      "created": "2021-03-24 14:44:04"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "",
      "label": "Delete FE",
      "mode": "show",
      "modeSql": "",
      "class": "action",
      "type": "beforeDelete",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 40,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "sqlAfter={{DELETE FROM FormElement WHERE formId={{id:R}} }}",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-09 11:38:15",
      "created": "2021-03-30 09:13:40"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "",
      "label": "Check for double form name",
      "mode": "show",
      "modeSql": "",
      "class": "action",
      "type": "beforeSave",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 50,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "sqlValidate={{!SELECT f.id FROM Form AS f WHERE  f.name!=\"\" AND f.name=\"{{name:F:alnumx}}\" AND f.id!={{id:R0}}  }}\r\nexpectRecords=0\r\nmessageFail=There is already another form with the name \"{{name:F:alnumx}}\".",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-09 11:38:15",
      "created": "2021-03-30 09:14:48"
    }
  ]
}