Auto-Insert

Email notification templates can be setup to automatically insert data from the related module. This will provide crucial information, like the Work Order Number, or allows personalization of the notification based on information in the record.

As well, Lucity stores address data in a series of fields, not all of which every organization uses. There is a function to auto-insert and concatenate address data in a notification, which provides a more readable format.

Finally information can be inserted from fields in children tables, both for a single record, or list of records. This allows attaching useful information from child records like addresses, assets, or inspection information.

Type the field name enclosed in brackets [ ] where the data should be auto-inserted into the notification. This can either be in the Subject or Body.
Now, whenever the notification is sent, the data will appear in the subject line of that email.
Note: These fields must be in the stored in the modules main table, not a child table. ie. For a Fleet Notification, the fields must come from the EFFLEET table not the EFFUEL table

Examples

This example will add the Fleet ID to a fleet notification email.

Please bring vehicle [FL_VEH_CD] [FL_VEH_TY] in for service.

Single Field

Add a line, using the syntax in the following example, into the body of the email.
Replace the field names with the corresponding field names for the module this notification is for.
Do NOT use any spaces.

Example

This example adds the address from the Sewer Overflow Module

[ADDRESS:OF_ADR_BDG,OF_ADR_B2,OF_ADR_DIR,OF_ADR_PT,OF_ADR_STR,OF_ADR_TY,OF_ADR_SFX]

addressinlucity

Add a line using the following syntax into the body of the email. (without the ( ).)

<#BeginRepeat (count symbol) (table name)#> ([field name1] [field name2] [etc…]) <#EndRepeat#>

Count Symbol - Because one parent record can have multiple children records the count symbol is used to control how many children records are used. There are two choices:
- 1 – this will only show information from one record in the child table. It will be from the first record the computer finds.
- * - this will show information from every record in the child table.
Table name – the name of the child table the information is coming from. (ie WKORDERLOC for Work Order Location)
Field names – the name of each field you want displayed from the child table. Each field name must be enclosed in brackets. []
Note: This can also be used in the Recipient list to pull email addresses out of fields in a module

Examples

This first example will add information from the first asset in the Work Order's asset list.

<#BeginRepeat 1 WKWOASSET #> [AS_SEQNCE] [AS_CAT_TY] [AS_LINK1] [AS_LINK2] [AS_TEXT1] <#EndRepeat#>

childrecone

This second example will add information about all the requesters on a request.

<#BeginRepeat * WKREQSTR#> [RC_NAME1] [RC_NAME2] [RC_HM-PHN] [RC_EMAIL] <#EndRepeat#>

childrecone

Note: Nesting Children will NOT work. In other words you can not have a Begin repeat for Work tasks and inside that have another Begin repeat for Resources and then a End Repeat for both

Note: The format must be followed exactly.