Triggering Record Mods
GoZync3.TriggeringRecordMods History
Hide minor edits - Show changes to output
December 20, 2012, at 12:39 AM
by - added a comma
Changed line 15 from:
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.)
to:
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.)
Changed lines 9-11 from:
Fortunately, script triggers make this pretty simple.
(Marking parent records as changed when editing children- requiredtrigger a sync. Todd added this to the InvoicesMobile sample file)
(Marking parent records as changed when editing children- required
to:
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.)
-> 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.)
Changed lines 1-2 from:
to:
!! 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 [[glossary | 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.
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 [[glossary | 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.
Added lines 1-3:
Coming soon.
(Marking parent records as changed when editing children- required to trigger a sync. Todd added this to the InvoicesMobile sample file)
(Marking parent records as changed when editing children- required to trigger a sync. Todd added this to the InvoicesMobile sample file)
