Triggering Record Mods

These are the notes for GoZync 3. Docs for the latest version of GoZync--GoZync 4--can be found here. GoZync 4 is a free upgrade and is highly recommended (hint: it's faster).

Making parent records look modified when you're only changing child records.

Even though GoZync asks you to add a modification timestamp field to every table, GoZync looks at the modification time of the parent record (or primary TO) to see if the entity as a whole has been modified.

(Not sure when we mean by "entity"? Check the glossary.)

This means that if you're only changing the quantity on an invoice line item, for example, you'll need to somehow modify the parent record (the invoice) as well, in order for GoZync to pickup that change.

Fortunately, script triggers make this pretty simple. Here is a very simple an effective way to do this.

1. Create a script that sets the field "gz_ModTimeStamp" in your primary TO (invoices, in this example) to 1. (This simply triggers the field's auto enter option; the value won't actually be 1).
2. On the layout where you edit invoices (NOT your sync layout--as that can't have script triggers on it) add a layout level script trigger "On Record Commit" which calls the script you wrote in 1 above.

Now, whenever you edit data in any portal on this layout, the script will set the invoice's mod timestamp as soon as any of the related records are committed. (Note that this only works for changes made ON this layout: if you're editing related records elsewhere, you'll need to script those edits to change their parents' mod timestamp as well.)

[email protected]
Follow us: