copyFormFromExt.sql

INSERT INTO `Form`
VALUES (80, 'copyFormFromExt', 'Copy a form (external)', '', 'Clipboard', 'sip', 'sip', 'c', 'bootstrap', '', '',
        'exclusive', 'close,save', 'none', '', '', '', 'url-sip-skip-history',
        '?id={{pageId:T}}&form=form&r={{formId:P0}}', '', '', '', 'submitButtonText = Copy Form', '', '', '', '', 900,
        'no', '0000-00-00 00:00:00', '0000-00-00 00:00:00');

INSERT INTO `FormElement`
VALUES (NULL, 80, 0, 'no', 'yes', 'idSrc', 'Source Form', 'show', '', 'native', 'select', '', 'specialchar', 'alnumx',
        '', '', 10, 0, '', '', '', '', '', 'row,label,/label,input,/input,note,/note,/row', '', '', '', '', '',
        '{{!SELECT f.id, CONCAT(f.name, \" / \", f.title) FROM ExtForm AS f ORDER BY f.name}}', '', '', '', '', '', '',
        '', 'no', '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `FormElement`
VALUES (NULL, 80, 0, 'no', 'yes', 'myNewFormName', 'New Form Name', 'show', '', 'native', 'text', '', 'specialchar',
        'alnumx', '', '', 20, 0, '', '', '', '', '', 'row,label,/label,input,/input,note,/note,/row', '', '', '', '',
        '{{SELECT f.name FROM ExtForm AS f WHERE f.id={{idSrc:F0}} }}', '', '', '', '', '', '', '', '', 'no',
        '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `FormElement`
VALUES (NULL, 80, 0, 'no', 'yes', 'clearClipboard', '', 'show', '', 'action', 'beforeSave', '', 'specialchar', 'alnumx',
        '', '', 100, 0, '', '', '', '', '', 'row,label,/label,input,/input,note,/note,/row', '', '', '', '', '', '',
        'sqlValidate={{!SELECT f.id FROM Form AS f WHERE f.name LIKE \"{{myName:FE:alnumx}}\" LIMIT 1}}\nexpectRecords = 0\nmessageFail = There is already a form with this name\nsqlAfter={{DELETE FROM Clipboard WHERE cookie=\"{{cookieQfq:C0:alnumx}}\" }}',
        '', '', '', '', '', '', 'no', '2017-08-20 18:01:32', '2017-08-20 20:01:32');
INSERT INTO `FormElement`
VALUES (NULL, 80, 0, 'no', 'yes', 'updateClipboardRecord', '', 'show', '', 'action', 'afterSave', '', 'specialchar',
        'alnumx', '', '', 110, 0, '', '', '', '', '', 'row,label,/label,input,/input,note,/note,/row', '', '', '', '',
        '', '',
        'sqlAfter={{UPDATE Clipboard AS c, Form AS f SET c.cookie=\"{{cookieQfq:C0:alnumx}}\", c.formIdPaste=f.id /* PasteForm */  WHERE c.id={{id:R}} AND f.name=\"{{form:SE}}\" }}',
        '', '', '', '', '', '', 'no', '2017-08-20 18:01:32', '2017-08-20 20:01:32');
INSERT INTO `FormElement`
VALUES (NULL, 80, 0, 'no', 'yes', 'formId', '', 'show', '', 'action', 'paste', '', 'specialchar', 'alnumx', '', '', 200,
        0, '', '', '', '', '', 'row,label,/label,input,/input,note,/note,/row', '', '', '', '', '',
        '{{!SELECT {{id:P}} AS id, \"{{myNewFormName:FE:allbut}}\" AS name}}',
        'recordSourceTable=ExtForm\r\nrecordDestinationTable=Form\r\n', '', '', '', '', '', '', 'no',
        '0000-00-00 00:00:00', '0000-00-00 00:00:00');
INSERT INTO `FormElement`
VALUES (NULL, 80, 0, 'no', 'yes', 'formElementId', '', 'show', '', 'action', 'paste', '', 'specialchar', 'alnumx', '',
        '', 210, 0, '', '', '', '', '', 'row,label,/label,input,/input,note,/note,/row', '', '', '', '', '',
        '{{!SELECT fe.id AS id, {{formId:P}} AS formId FROM ExtFormElement AS fe WHERE fe.formId={{id:P}} ORDER BY fe.ord}}',
        'recordSourceTable=ExtFormElement\r\nrecordDestinationTable=FormElement\r\ntranslateIdColumn=feIdContainer', '',
        '', '', '', '', '', 'no', '0000-00-00 00:00:00', '0000-00-00 00:00:00');