Before and after record sync formulas

When you create a GIS mapping, you can enter formulas that will run either before or after records are imported. Specify your formulas in the Before Record Sync Formula and After Record Sync Formula fields.

You can use these formulas for advanced processing. For example, the GIS layer that you're importing might contain fields that don't exist in Infor Public Sector. If you want to import the data in those fields, you can use a before record sync formula to read the values and store them somewhere else, such as in a comments field.

For an after record sync formula, you might want to associate records after they're imported from the GIS. For example, if you import a parcel with associated addresses, the records won't be associated in Infor Public Sector because the parcel and address keys aren't created until you run the synchronization. So you can use an after record sync formula to get the keys for the new parcel and address records and create the links.

In the Workflow Manager, these formulas can be found on the BeforeRecordSync and AfterRecordSync events of the GIS.SyncMapping object.

Various snippets for before and after sync formulas can be found under the GIS Sync node in the Formula Editor.