Automatic Daily Link and Load Sync

To automate the daily synchronization of Link and Load fields for all records in a specific sheet, you can use Workflow. Below are two setup methods:

Method 1: Copy and Paste Script

Follow these steps to set up:

Step 1: Open the Javascript Workflow Editor

Right-click on any sheet name and select Javascript Workflow.

Step 2: Switch to Daily Workflow

Step 3: Enter the Sheet Path for Synchronization

For example, if the sheet path you want to sync is:

https://www.ragic.com/accountname/tabname/1?PAGEID=wSM (ignore the ?PAGEID=wSM part), enter the following in the script:

db.loadLinkAndLoadAll("/tabname/1");

Then click Save to complete the setup.

Method 2: Using the Workflow Generator

In addition to manually copying and pasting, you can use the Workflow Generator to select Execute all link and load sync for the entire sheet, then click "Insert Script" to generate the example quickly.

Modify the script according to your sheet path.

For example, if the sheet path you want to sync is:

https://www.ragic.com/accountname/tabname/1?PAGEID=wSM (ignore the ?PAGEID=wSM part), adjust the path in the script to: /tabname/1.

Then click Save to complete the setup.

The daily Link and Load synchronization will execute according to the "Daily Workflow" schedule in the Job Schedules. To test if the setup was successful, you can also manually click "Execute Daily Workflow Now".