Ragic Logo
<< Guide to server-side Javascript WorkflowTable of ContentsHow to make major design changes to live production systems >>

Repopulating loaded fields from their source sheet for link & load

For fields that load data on a sheet A, that links data from another sheet B with the link & load method, changes that are made on the data in sheet B will not be reflected on sheet A on previous entries.

The reason for this we can explain with an example. Let's say sheet A is sales orders, and sheet B is customers. When a sales order is entered by user Martha Stewart, her address information is populated with link & load on your sales order. Let's say Martha changed her address. Her previous sales order would still be under her previous address for the records, but new sales orders will be saved with her new address.

We do understand this might not be how you use link & load, and that you will need to repopulate the loaded fields in all your previous records in sheet A.

To do so, navigate to the Form page Design Mode, and click on Sheet Linking Tools to see a list of sheets that are linked with Link & Load under the category. Click on the gear icon next to the appropriate sheet.

A prompt will show you the option for dynamic filtering above, and the option for repopulating below, that gives you the option to synchronize a single set of linked fields with the updated source value for all records, or all of your linked fields on this form.

After choosing your option, a prompt will state that loading has started. This means that your loaded fields are reloading in the background, so you may now close this window and continue using your database while your data is synchronizing.

As an alternative method, the following URL (modified according to your own account) will run a script that will force the loaded fields to reload according to the current data in sheet B, provided you still have the same info on the linked field, like an ID number.

If the URL link of the sheet you want to run this script is

https://www.ragic.com/accountname/tabname/3

Use this URL to reload all loaded fields according to the current data from where it is linked from:

https://www.ragic.com/sims/dev/loadLinkNLoad.jsp?a=accountname&p=/tabname&si=3

Top of Page
<< Guide to server-side Javascript WorkflowTable of ContentsHow to make major design changes to live production systems >>
Learn more about Ragic:
Why we created Ragic
Webinars
User Guide
Keep in touch:
Blog
Email
Facebook
Twitter
Ragic, Inc.
1-888-666-8037
Terms
Privacy