Workflow Generator
Navigate to Javascript Workflow page by right-clicking the Tab name.
Choose Global workflow, Daily workflow, or a specific sheet first, and select what kinds of workflow. For example, generating a set value sample with post-workflow in "Sales Order".
Please note that you might need to further edit the sample.
All supported functions are as below:
1. Post-workflow
(1) Current record
...Get multi-select field values before saving
...Get multi-select field values after saving
...Get field values before saving
...Get field values after saving
...Get subtable multi-select field values before saving
...Get subtable multi-select field values after saving
...Get subtable field values before saving
...Get subtable field values after saving
...Get operation type(Insert/Modify)
...get field values
...set field values
...and add subtable rows
...and edit subtable rows
...and delete subtable rows
(2) For each subtable row on the saved record
...get field values
...update field values
2. Pre-workflow
(1) Current record
...Get multi-select field values before saving
...Get multi-select field values after saving
...Get field values before saving
...Get field values after saving
...Get subtable multi-select field values before saving
...Get subtable multi-select field values after saving
...Get subtable field values before saving
...Get subtable field values after saving
...Get operation type(Insert/Modify)
(2) For each subtable row on the saved record
...get field values
3. Action Button
(1) For the current record
...get field values
...set field values
...get subtable rows
...and add subtable rows
...and edit subtable rows
...and delete subtable rows
...recalculate formula
...do link and load
(2) For each subtable row on the current record
...get field values
...update field values
4. Approval Workflow
(1) Start an approval
(2) Cancel an approval
5. General Workflow
(1) For each record on a sheet
...get field values
...set field values
...get subtable rows
...add subtable rows
...edit subtable rows
...delete subtable rows
(2) Create a record
(3) Create a subtable row
(4) Check the user group
(5) Trigger formula recalculation for a record
(6) Trigger link and load for a record
(7) Send e-mail notification
(8) Send mobile notification
(9) Display a message
(10) Send HTTP request