Calc Fields

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).

Can GoZync Sync Calc Fields?

Yes, after a simple modification.

By default GoZync will skip any calc, global, or summary fields on your sync layouts. (You should still remove them from your layouts as that will speed up the sync.)

But there may be times when you want to sync a calc field, pulling it down from the server and placing it into a non-calc field on the mobile side. (You can't set it into another calc field, obviously, as trying to set calc fields throws errors in FileMaker.) This could be useful, for example, when you want to bring down a contact's credit limit, but that limit is stored in a related table: rather than sync the related table, you could create an unstored calc for this value in the contact's record in your hosted file, and then sync that down to a regular field in the contact's record in your mobile file.

To enable this you need to turn off GoZync's skipping of calc fields. This very easy.

Edit the script "Get Fields { FileName } (LayoutName; LayoutTableName)" in GoZyncHosted and find the line shown in blue below. Remove the "or test" for calc fields. That's it.

If you need to push a calc field, you'd edit a similar script in GoZyncMobile:

Note, GoZync will try to match the field names between the hosted and local tables, so if your cal and regular fields don't have the same name (like one is z_CreditLimitCalc and the other CreditLimit) you'll want to use transformations to link the two field names.

And remember, in our example above, you won't want the local version of that credit limit on your sync layout on the local side: that would push it back to hosted where setting it into its calc counterpart would fail. =)

[email protected]
Follow us: