{
  "title": "<span style=\"font-weight: 100;\">FE:<\/span>{{name:R:::New}} \/ \r\n{{SELECT QMORE(QENT_ENCODE(fe.label), 30) FROM Form AS f LEFT JOIN FormElement AS fe ON f.id = fe.formId AND fe.id = {{id:SR0}} WHERE f.id = {{formId:SR0}} LIMIT 1}}\r\n<span class=\"pull-right\">{{ \"{{SELECT 'p:form?form=form&r=', f.id, '|b:btn-small btn-default|s|o:Edit Form: ', f.id, ' \/ ', strip_tags(f.name),  CHAR(10), 'DB: {{dbNameQfq:Y}}|t:<i class=\"far fa-newspaper\"><\/i> <i>', LEFT( strip_tags(f.name), 20), '<\/i>' FROM Form AS f WHERE f.id = {{formId:SR0}}  }}\" AS _link}}<\/span>",
  "noteInternal": "Please secure the form",
  "tableName": "FormElement",
  "primaryKey": "",
  "permitNew": "sip",
  "permitEdit": "sip",
  "restMethod": "",
  "escapeTypeDefault": "c",
  "render": "bootstrap",
  "requiredParameterNew": "formId",
  "requiredParameterEdit": "",
  "dirtyMode": "exclusive",
  "showButton": "new,delete,close,save",
  "multiMode": "none",
  "multiSql": "",
  "multiDetailForm": "",
  "multiDetailFormParameter": "",
  "forwardMode": "auto",
  "forwardPage": "",
  "labelAlign": "default",
  "bsLabelColumns": "",
  "bsInputColumns": "",
  "bsNoteColumns": "",
  "parameter": "maxVisiblePill=5\nclassBody=qfq-color-blue-1\ndbIndex={{indexQfq:Y}}",
  "parameterLanguageA": "",
  "parameterLanguageB": "",
  "parameterLanguageC": "",
  "parameterLanguageD": "",
  "recordLockTimeoutSeconds": 900,
  "deleted": "no",
  "modified": "2021-04-06 12:05:41",
  "created": "2021-04-06 12:05:41",
  "FormElement_ff": [
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "basic",
      "label": "Basic",
      "mode": "show",
      "modeSql": "",
      "class": "container",
      "type": "pill",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 10,
      "tabindex": 0,
      "size": "0",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41"
    },
    {
      "dynamicUpdate": "yes",
      "enabled": "yes",
      "name": "feIdContainer",
      "label": "Container",
      "mode": "show",
      "modeSql": "{{[{{indexQfq:Y}}]SELECT IF(COUNT(fe.id)>0, \"show\", \"hidden\") FROM Form AS f LEFT JOIN FormElement AS fe ON f.id=fe.formId AND fe.class=\"container\" WHERE f.id={{formId:S0}} }}",
      "class": "native",
      "type": "select",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 120,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#class-container\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "{{feIdContainer:FR:::{{SELECT fe.feIdContainer FROM FormElement AS fe WHERE fe.formId={{formId:SR0}} AND fe.feIdContainer!=0 AND \"{{class:FRD0:alnumx}}\"!=\"action\" ORDER BY fe.modified DESC LIMIT 1}}}}",
      "sql1": "{{!SELECT fe.id, CONCAT(fe.type, \" \/ \", fe.name, \" (\", COUNT(feSub.id), \")\" ) FROM FormElement As fe LEFT JOIN FormElement As feSub ON feSub.feIdContainer=fe.id WHERE fe.formId={{formId:SR0}} AND fe.class=\"container\"  AND (\"{{class:FRD0:alnumx}}\"!=\"action\" OR fe.type=\"templateGroup\") GROUP BY fe.id ORDER BY fe.type, fe.ord, fe.name }}",
      "parameter": "emptyItemAtStart",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "basic"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "enabled",
      "label": "Enabled",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "checkbox",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 130,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#class-native\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "basic"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "dynamicUpdate",
      "label": "Dynamic Update",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "checkbox",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 135,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#dynamic-update\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "basic"
    },
    {
      "dynamicUpdate": "yes",
      "enabled": "yes",
      "name": "encryption",
      "label": "Encryption",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "checkbox",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 140,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#encryption\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2022-12-05 15:30:41",
      "created": "2022-12-05 15:30:41",
      "containerName_ff": "basic"
    },
    {
      "dynamicUpdate": "yes",
      "enabled": "yes",
      "name": "encryptionMethod",
      "label": "EncryptionMethod",
      "mode": "show",
      "modeSql": "{{ SELECT IF ('{{encryption:FRE:alnumx}}' = 'yes', 'show', 'hidden') }}",
      "class": "native",
      "type": "select",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 145,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#encryptionMethod\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2022-12-05 15:30:41",
      "created": "2022-12-05 15:30:41",
      "containerName_ff": "basic"
    },
    {
      "dynamicUpdate": "yes",
      "enabled": "yes",
      "name": "name",
      "label": "Name",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "none",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 150,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#class-native\">Info<\/a> {{SELECT ' \\/ <span class=\\\"qfq-badge qfq-badge-warning\\\" title=\\\"A reserved word is used as a column name!\\\">Caution!<\\/span> <a href=\\\"https:\\/\\/mariadb.com\\/kb\\/en\\/reserved-words\\/\\\">Check<\\/a>' FROM DUAL WHERE FIND_IN_SET('{{name:FR}}', 'ACCESSIBLE,ADD,ALL,ALTER,ANALYZE,AND,AS,ASC,ASENSITIVE,BEFORE,BETWEEN,BIGINT,BINARY,BLOB,BOTH,BY,CALL,CASCADE,CASE,CHANGE,CHAR,CHARACTER,CHECK,COLLATE,COLUMN,CONDITION,CONSTRAINT,CONTINUE,CONVERT,CREATE,CROSS,CURRENT_DATE,CURRENT_ROLE,CURRENT_TIME,CURRENT_TIMESTAMP,CURRENT_USER,CURSOR,DATABASE,DATABASES,DAY_HOUR,DAY_MICROSECOND,DAY_MINUTE,DAY_SECOND,DEC,DECIMAL,DECLARE,DEFAULT,DELAYED,DELETE,DELETE_DOMAIN_ID,DESC,DESCRIBE,DETERMINISTIC,DISTINCT,DISTINCTROW,DIV,DO_DOMAIN_IDS,DOUBLE,DROP,DUAL,EACH,ELSE,ELSEIF,ENCLOSED,ESCAPED,EXCEPT,EXISTS,EXIT,EXPLAIN,FALSE,FETCH,FLOAT,FLOAT4,FLOAT8,FOR,FORCE,FOREIGN,FROM,FULLTEXT,GENERAL,GRANT,GROUP,HAVING,HIGH_PRIORITY,HOUR_MICROSECOND,HOUR_MINUTE,HOUR_SECOND,IF,IGNORE,IGNORE_DOMAIN_IDS,IGNORE_SERVER_IDS,IN,INDEX,INFILE,INNER,INOUT,INSENSITIVE,INSERT,INT,INT1,INT2,INT3,INT4,INT8,INTEGER,INTERSECT,INTERVAL,INTO,IS,ITERATE,JOIN,KEY,KEYS,KILL,LEADING,LEAVE,LEFT,LIKE,LIMIT,LINEAR,LINES,LOAD,LOCALTIME,LOCALTIMESTAMP,LOCK,LONG,LONGBLOB,LONGTEXT,LOOP,LOW_PRIORITY,MASTER_HEARTBEAT_PERIOD,MASTER_SSL_VERIFY_SERVER_CERT,MATCH,MAXVALUE,MEDIUMBLOB,MEDIUMINT,MEDIUMTEXT,MIDDLEINT,MINUTE_MICROSECOND,MINUTE_SECOND,MOD,MODIFIES,NATURAL,NOT,NO_WRITE_TO_BINLOG,NULL,NUMERIC,OFFSET,ON,OPTIMIZE,OPTION,OPTIONALLY,OR,ORDER,OUT,OUTER,OUTFILE,OVER,PAGE_CHECKSUM,PARSE_VCOL_EXPR,PARTITION,PRECISION,PRIMARY,PROCEDURE,PURGE,RANGE,READ,READS,READ_WRITE,REAL,RECURSIVE,REF_SYSTEM_ID,REFERENCES,REGEXP,RELEASE,RENAME,REPEAT,REPLACE,REQUIRE,RESIGNAL,RESTRICT,RETURN,RETURNING,REVOKE,RIGHT,RLIKE,ROW_NUMBER,ROWS,SCHEMA,SCHEMAS,SECOND_MICROSECOND,SELECT,SENSITIVE,SEPARATOR,SET,SHOW,SIGNAL,SLOW,SMALLINT,SPATIAL,SPECIFIC,SQL,SQLEXCEPTION,SQLSTATE,SQLWARNING,SQL_BIG_RESULT,SQL_CALC_FOUND_ROWS,SQL_SMALL_RESULT,SSL,STARTING,STATS_AUTO_RECALC,STATS_PERSISTENT,STATS_SAMPLE_PAGES,STRAIGHT_JOIN,TABLE,TERMINATED,THEN,TINYBLOB,TINYINT,TINYTEXT,TO,TRAILING,TRIGGER,TRUE,UNDO,UNION,UNIQUE,UNLOCK,UNSIGNED,UPDATE,USAGE,USE,USING,UTC_DATE,UTC_TIME,UTC_TIMESTAMP,VALUES,VARBINARY,VARCHAR,VARCHARACTER,VARYING,VECTOR,WHEN,WHERE,WHILE,WINDOW,WITH,WRITE,XOR,YEAR_MONTH,ZEROFILL') }}",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "typeAheadSql = [{{indexData:Y}}]SELECT COLUMN_NAME FROM information_schema.columns WHERE table_schema = \"{{DB_1_NAME:Y}}\" AND table_name = \"{{SELECT f.tableName FROM Form AS f WHERE f.id={{formId:S0}}}}\" AND COLUMN_NAME LIKE ? ORDER BY COLUMN_NAME\ntypeAheadMinLength = 1\ntypeAheadLimit = 100\ntypeAheadPedantic = 0\n",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "basic"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "label",
      "label": "Label",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "none",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 155,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#class-native\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "basic"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "mode",
      "label": "Mode",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "radio",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 160,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#class-native\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "buttonClass=btn-default",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "basic"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "modeSql",
      "label": "Mode sql",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "none",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 170,
      "tabindex": 0,
      "size": "80,1,350",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#dynamic-update\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "basic"
    },
    {
      "dynamicUpdate": "yes",
      "enabled": "yes",
      "name": "class",
      "label": "Class",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "radio",
      "subrecordOption": "",
      "encode": "none",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 180,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#class-container\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "{{class:FSRD0:alnumx}}",
      "sql1": "",
      "parameter": "buttonClass",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "basic"
    },
    {
      "dynamicUpdate": "yes",
      "enabled": "yes",
      "name": "type",
      "label": "Type",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "select",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 190,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#class-native\">Native<\/a>, <a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#class-action\">Action<\/a>, <a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#class-container\">Container<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "itemList={{SELECT IF( \"{{class:FRD0:alnumx}}\"=\"native\",\"annotate,chat,checkbox,colorPicker,date,datetime,editor,extra,imageCut,inputCollectionJson,note,password,radio,select,subrecord,text,time,upload\", IF(\"{{class:FRD0:alnumx}}\"=\"action\",\"afterDelete,afterInsert,afterLoad,afterSave,afterUpdate,beforeDelete,beforeInsert,beforeLoad,beforeSave,beforeUpdate,paste,sendMail\", \"fieldset,pill,templateGroup\")  ) }}",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "basic"
    },
    {
      "dynamicUpdate": "yes",
      "enabled": "yes",
      "name": "subrecordOption",
      "label": "Subrecord Option",
      "mode": "show",
      "modeSql": "{{ SELECT IF(\"{{type:FRE:alnumx}}\"=\"subrecord\" AND \"{{class:FRE:alnumx}}\"=\"native\", \"show\", \"hidden\") }}",
      "class": "native",
      "type": "checkbox",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 200,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#subrecord-option\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "basic"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "parameterLanguageA",
      "label": "Language: {{formLanguageALabel:YE}}",
      "mode": "show",
      "modeSql": "{{SELECT IF(\"{{formLanguageAId:YE}}\"=\"\",\"hidden\",\"show\" ) }}",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "none",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 210,
      "tabindex": 0,
      "size": "80,1,350",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#multi-language-form\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "basic"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "parameterLanguageB",
      "label": "Language: {{formLanguageBLabel:YE}}",
      "mode": "show",
      "modeSql": "{{SELECT IF(\"{{formLanguageBId:YE}}\"=\"\",\"hidden\",\"show\" ) }}",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "none",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 210,
      "tabindex": 0,
      "size": "80,1,350",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#multi-language-form\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "basic"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "parameterLanguageC",
      "label": "Language: {{formLanguageCLabel:YE}}",
      "mode": "show",
      "modeSql": "{{SELECT IF(\"{{formLanguageCId:YE}}\"=\"\",\"hidden\",\"show\" ) }}",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "none",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 210,
      "tabindex": 0,
      "size": "80,1,350",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#multi-language-form\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "basic"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "parameterLanguageD",
      "label": "Language: {{formLanguageDLabel:YE}}",
      "mode": "show",
      "modeSql": "{{SELECT IF(\"{{formLanguageDId:YE}}\"=\"\",\"hidden\",\"show\" ) }}",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "none",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 210,
      "tabindex": 0,
      "size": "80,1,350",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#multi-language-form\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "basic"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "check_order",
      "label": "Check & Order",
      "mode": "show",
      "modeSql": "",
      "class": "container",
      "type": "pill",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 290,
      "tabindex": 0,
      "size": "0",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41"
    },
    {
      "dynamicUpdate": "yes",
      "enabled": "yes",
      "name": "encode",
      "label": "Encode",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "radio",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 300,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a href=\"{{documentation:Y}}\/Form.html#field-encode\">Info<\/a> {{SELECT IF('{{encode:FRE:alnumx}}' = 'specialchar' AND '{{checkType:FRE:alnumx}}' = 'allbut', \"<br><span class='text-danger'> <span class='glyphicon glyphicon-warning-sign'><\/span> <span>Encode 'specialchar' is not completely compatible with Check Type 'allbut': certain user input will be converted to its HTML representation (e.g. &amp;quot;), which makes use of a non-supported character (&amp;)<\/span><\/span>\", '') }}",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "buttonClass=btn-default",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "check_order"
    },
    {
      "dynamicUpdate": "yes",
      "enabled": "yes",
      "name": "checkType",
      "label": "Check Type",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "radio",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 310,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#field-checktype\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "buttonClass=btn-default",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "check_order"
    },
    {
      "dynamicUpdate": "yes",
      "enabled": "yes",
      "name": "checkPattern",
      "label": "Check Pattern",
      "mode": "show",
      "modeSql": "{{ SELECT IF(\"{{checkType:FRE:alnumx}}\"=\"pattern\" OR \"{{checkType:FRE:allbut}}\" LIKE \"min%\", \"show\", \"hidden\") }}",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "none",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 320,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#field-checkpattern\">Info<\/a>, <a tabindex=\"-1\" href=\"https:\/\/regex101.com\/\">Regex101<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "check_order"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "ord",
      "label": "Order",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 340,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#field-ord\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "{{SELECT IF({{ord:R0}}=0,  MAX(IFNULL(fe.ord,0))+10,{{ord:R0}})  FROM (SELECT 1) AS a LEFT JOIN FormElement AS fe ON fe.formId={{formId:S0}} GROUP BY fe.formId}}",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "check_order"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "adminNote",
      "label": "Internal Note",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 360,
      "tabindex": 0,
      "size": "80,1,350",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "check_order"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "layout",
      "label": "Layout",
      "mode": "show",
      "modeSql": "",
      "class": "container",
      "type": "pill",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 390,
      "tabindex": 0,
      "size": "0",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "labelAlign",
      "label": "Label Align",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "radio",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 400,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#class-native\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "buttonClass=btn-default",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "layout"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "size",
      "label": "Size <small class='text-muted'>visual</small>",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 405,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#field-size\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "layout"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "bsLabelColumns",
      "label": "BS Label Columns",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 410,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#field-bslabelcolumns\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "{{SELECT IF(f.bsLabelColumns != '', f.bsLabelColumns, '{{bsLabelColumns:Y}}') FROM Form AS f WHERE f.id = {{formId}} }}",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "layout"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "bsInputColumns",
      "label": "BS Input Columns",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 420,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "{{SELECT IF(f.bsInputColumns != '', f.bsInputColumns, '{{bsInputColumns:Y}}') FROM Form AS f WHERE f.id = {{formId}} }}",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "layout"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "bsNoteColumns",
      "label": "BS Note Columns",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 430,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "{{SELECT IF(f.bsNoteColumns != '', f.bsNoteColumns, '{{bsNoteColumns:Y}}') FROM Form AS f WHERE f.id = {{formId}} }}",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "layout"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "rowLabelInputNote",
      "label": "Label \/ Input \/ Note",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "checkbox",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "alnumx",
      "checkPattern": "",
      "onChange": "",
      "ord": 440,
      "tabindex": 0,
      "size": "0",
      "maxLength": "10",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#field-rowlabelinputnote\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "minWidth=72",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "layout"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "maxLength",
      "label": "Maxlength",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 450,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#field-maxlength\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "layout"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "note",
      "label": "Note",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "none",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 460,
      "tabindex": 0,
      "size": "80,1,350",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#field-note\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "layout"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "tooltip",
      "label": "Tooltip",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "none",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 470,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#field-tooltip\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "layout"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "placeholder",
      "label": "Placeholder",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "text",
      "subrecordOption": "",
      "encode": "none",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 480,
      "tabindex": 0,
      "size": "0",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#field-placeholder\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "layout"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "value",
      "label": "Value",
      "mode": "show",
      "modeSql": "",
      "class": "container",
      "type": "pill",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 490,
      "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": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "value",
      "label": "value",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "editor",
      "subrecordOption": "",
      "encode": "none",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 500,
      "tabindex": 0,
      "size": "",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#field-value\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "editorType=codemirror",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "value"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "sql1",
      "label": "sql1",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "editor",
      "subrecordOption": "",
      "encode": "none",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 510,
      "tabindex": 0,
      "size": "",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#sql1\">Info<\/a><br><br>MariaDB: <a tabindex=\"-1\" href=\"https:\/\/mariadb.com\/kb\/en\/mariadb\/select\/\">Select<\/a>, <a tabindex=\"-1\" href=\"https:\/\/mariadb.com\/kb\/en\/mariadb\/functions-and-operators\/\">Functions<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "editorType=codemirror",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "value"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "parameter",
      "label": "Parameter",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "editor",
      "subrecordOption": "",
      "encode": "none",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 520,
      "tabindex": 0,
      "size": "",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#fe-parameter-attributes\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "showHistory=1\neditorType=codemirror\ncodemirror-keywords-qfq-base=acceptZeroAsRequired autofocus capture accept downloadButton fileSplit uploadType maxFileSize fileDestination fileTrash fileTrashText fileReplace autoOrient autoOrientCmd autoOrientMimeType chmodFile chmodDir slaveId sqlBefore sqlInsert sqlUpdate sqlDelete sqlAfter importToTable importToColumns importRegion importMode importType importNamedSheetsOnly importSetReadDataOnly importListSheetNames checkBoxMode checked unchecked label2 itemList emptyHide emptyItemAtStart emptyItemAtEnd buttonClass dateFormat data-pattern-error data-required-error data-match-error data-error decimalFormat htmlAfter htmlBefore extraButtonLock extraButtonPassword extraButtonInfo extraButtonInfoClass extraButtonInfoMinWidth editor-plugins editor-toolbar editor-statusbar fileButtonText fillStoreVar page title extraDeleteForm detail new subrecordTableClass subrecordTableAttribute min max processReadOnly retype retypeLabel retypeNote characterCountWrap hideZero emptyMeansNull showSeconds showZero timeIsOptional typeAheadLimit typeAheadInitialSuggestion typeAheadMinLength typeAheadSql typeAheadSqlPrefetch typeAheadPedantic typeAheadTag typeAheadGlueInsert typeAheadGlueDelete typeAheadTagInsert typeAheadTagDelimiter wrapRow wrapLabel wrapInput wrapNote trim sqlValidate requiredList expectRecords messageFail dataReference requiredPosition indicateRequired minWidth clearMe defaultValue qfqLog alert inputType step textareaResize htmlAllow subrecordColumnTitleEdit subrecordColumnTitleDelete subrecordAppendSql subrecordAppendClass subrecordAppendForm subrecordAppendExtraDeleteForm subrecordAppendEmptyText orderInterval dndTable dragAndDropOrderSql orderColumn editorType editor-forced_root_block editor-extended_valid_elements editor-content_css codemirror-mode codemirror-lineNumbers codemirror-lineWrapping codemirror-tabSize codemirror-styleActiveLine codemirror-matchBrackets codemirror-autocloseBrackets codemirror-keywords-qfq-base codemirror-keywords-qfq-level codemirror-keywords-sql-function codemirror-tableColumns sendMailTo sendMailCc sendMailBcc sendMailFrom sendMailSubject sendMailReplyTo sendMailAttachment sendMailHeader sendMailFlagAutoSubmit sendMailGrId sendMailXId sendMailXId2 sendMailXId3 sendMailMode sendMailSubjectHtmlEntity sendMailBodyHtmlEntity showHistory showHistoryTitle showHistoryFeUserSet",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "value"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "clientJs",
      "label": "Client JS",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "editor",
      "subrecordOption": "",
      "encode": "none",
      "checkType": "all",
      "checkPattern": "",
      "onChange": "",
      "ord": 530,
      "tabindex": 0,
      "size": "",
      "maxLength": "0",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,label,\/label,input,\/input,note,\/note,\/row",
      "note": "<a tabindex=\"-1\" href=\"{{documentation:Y}}\/Form.html#fe-parameter-attributes\">Info<\/a>",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "",
      "sql1": "",
      "parameter": "editorType=codemirror\ncodemirror-keywords-qfq-base=acceptZeroAsRequired autofocus capture accept maxFileSize fileDestination fileTrash fileTrashText fileReplace autoOrient autoOrientCmd autoOrientMimeType chmodFile chmodDir slaveId sqlBefore sqlInsert sqlUpdate sqlDelete sqlAfter importToTable importToColumns importRegion importMode importType importNamedSheetsOnly importSetReadDataOnly importListSheetNames checkBoxMode checked unchecked label2 itemList emptyHide emptyItemAtStart emptyItemAtEnd buttonClass dateFormat data-pattern-error data-required-error data-match-error data-error decimalFormat htmlAfter htmlBefore extraButtonLock extraButtonPassword extraButtonInfo extraButtonInfoClass extraButtonInfoMinWidth editor-plugins editor-toolbar editor-statusbar fileButtonText fillStoreVar page title extraDeleteForm detail new subrecordTableClass subrecordTableAttribute min max processReadOnly retype retypeLabel retypeNote characterCountWrap hideZero emptyMeansNull showSeconds showZero timeIsOptional typeAheadLimit typeAheadInitialSuggestion typeAheadMinLength typeAheadSql typeAheadSqlPrefetch typeAheadPedantic typeAheadTag typeAheadGlueInsert typeAheadGlueDelete typeAheadTagInsert typeAheadTagDelimiter wrapRow wrapLabel wrapInput wrapNote trim sqlValidate requiredList expectRecords messageFail dataReference requiredPosition indicateRequired minWidth clearMe defaultValue qfqLog alert inputType step textareaResize htmlAllow subrecordColumnTitleEdit subrecordColumnTitleDelete subrecordAppendSql subrecordAppendClass subrecordAppendForm subrecordAppendExtraDeleteForm subrecordAppendEmptyText orderInterval dndTable dragAndDropOrderSql orderColumn editorType editor-forced_root_block editor-extended_valid_elements editor-content_css codemirror-mode codemirror-lineNumbers codemirror-lineWrapping codemirror-tabSize codemirror-styleActiveLine codemirror-matchBrackets codemirror-autocloseBrackets codemirror-keywords-qfq-base codemirror-keywords-qfq-level codemirror-keywords-sql-function codemirror-tableColumns",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41",
      "containerName_ff": "value"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "Check Name Conflict",
      "label": "",
      "mode": "show",
      "modeSql": "",
      "class": "action",
      "type": "beforeSave",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 650,
      "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 fe.id FROM FormElement AS fe WHERE \"{{class:F:alnumx}}\"=fe.class AND fe.formId={{formId:RF}} AND fe.name!=\"\" AND fe.name=\"{{name:F:alnumx}}\" AND fe.enabled=\"yes\" AND fe.id!={{id:R0}} }}\r\n\r\nexpectRecords=0\r\n\r\nmessageFail=There is already another {{class:F:alnumx}} form element with name \"{{name:F:alnumx}}\".",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41"
    },
    {
      "dynamicUpdate": "no",
      "enabled": "yes",
      "name": "Check Name Empty Container",
      "label": "",
      "mode": "show",
      "modeSql": "",
      "class": "action",
      "type": "beforeSave",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 660,
      "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 '1' FROM (SELECT '') AS _fake WHERE \"{{class:F:alnumx}}\"=\"container\" AND \"{{name:F:alnumx}}\"=\"\"}}\r\n\r\nexpectRecords=0\r\n\r\nmessageFail=Form elements of class container must have a unique non-empty name.",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2021-04-06 12:05:41",
      "created": "2021-04-06 12:05:41"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "tableDefinition",
      "label": "Table Definition",
      "mode": "show",
      "modeSql": "",
      "class": "container",
      "type": "pill",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 670,
      "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": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2022-08-28 09:41:12",
      "created": "2022-08-28 09:37:36"
    },
    {
      "dynamicUpdate": "no",
      "encryption": "no",
      "encryptionMethod": "Default",
      "enabled": "yes",
      "name": "Table Definition",
      "label": "",
      "mode": "show",
      "modeSql": "",
      "class": "native",
      "type": "note",
      "subrecordOption": "",
      "encode": "specialchar",
      "checkType": "auto",
      "checkPattern": "",
      "onChange": "",
      "ord": 680,
      "tabindex": 0,
      "size": "",
      "maxLength": "",
      "labelAlign": "default",
      "bsLabelColumns": "",
      "bsInputColumns": "col-md-12",
      "bsNoteColumns": "",
      "rowLabelInputNote": "row,input,\/input,\/row",
      "note": "",
      "adminNote": "",
      "tooltip": "",
      "placeholder": "",
      "value": "#!report\r\n#\r\n# FormElement: Tabledefinition\r\n#\r\ncheckId {\r\n  dbIndex={{indexQfq:Y}}  \r\n  sql = SELECT '<h3>Table: <code>[{{DB_{{indexData:Y}}_SERVER:Y}}] {{DB_{{indexData:Y}}_NAME:Y}}.', tableName AS tableName, '<\/code><\/h3>'\r\n            , IF(f.tableName='formElement' OR f.tableName='form'\r\n              , {{indexQfq:Y}}\r\n              , {{indexData:Y}} ) AS _idx \r\n          FROM Form AS f \r\n          WHERE f.id={{formId:SR0}} \r\n  althead = Form to get tablename not found.\r\n            \r\n  tableDefinition {\r\n    dbIndex={{idx:R}}\r\n    sql = SELECT COLUMN_NAME, COLUMN_TYPE, COLUMN_KEY, COLUMN_DEFAULT, EXTRA\r\n          FROM information_schema.columns\r\n          WHERE table_schema = '{{dataBase:RE}}'\r\n            AND table_name = '{{tableName:RE}}';\r\n              \r\n    \r\n    head = <h3>Table: <code>[{{DB_{{idx:R}}_SERVER:Y}}] {{DB_{{idx:R}}_NAME:Y}}.{{tableName:RE}}<\/code><\/h3><table class=\"table table-hover qfq-table-50\"><thead><tr><th>Field<\/th><th>Type<\/th><th>Null<\/th><th>Key<\/th><th>Default<\/th><th>Extra<\/th><\/tr><\/thead>\r\n    tail = <\/table>\r\n    rbeg = <tr>\r\n    rend = <\/tr>\r\n    fbeg = <td>\r\n    fend = <\/td>\r\n    althead = Oops, table not found, maybe a special Multi-DB Setup.\r\n  }            \r\n\r\n}",
      "sql1": "",
      "parameter": "",
      "parameterLanguageA": "",
      "parameterLanguageB": "",
      "parameterLanguageC": "",
      "parameterLanguageD": "",
      "clientJs": "",
      "deleted": "no",
      "modified": "2022-08-28 09:40:13",
      "created": "2022-08-28 09:40:13",
      "containerName_ff": "tableDefinition"
    }
  ]
}