List of Dynamic Fields

Dynamic Fields

Below is a list of dynamic fields for Templates, Emails, Report Rules etc

User Title  #TITLE#

First name #FIRST_NAME#

Last name #LAST_NAME#

Email #EMAIL#

Mobile number #MOBILE#

Date of Birth #REPORT_USER_DOB#

Home number #PHONE#

Street number #ADDR1#

Street #ADDR2#

Town #ADDR3#

City #CITY#

Postcode #POSTCODE#

User Country #USER_COUNTRY#

Region #REGION_ID#

Organization #ORGANIZATION_ID#

UPRN #USER_UPRN#

Current time #CURRENT_TIME#

Current date #CURRENT_DATE#

Current date / time #CURRENT_DATETIME#

Report question(s) / answer(s) #REPORT_INFORMATION#

Report question(s) / answer(s) – RBAC #REPORT_INFORMATION_RBAC#

Service request / case category #REPORT_CATEGORY#

Service request / case close date #REPORT_CLOSE_DATE#

Service request location country #REPORT_COUNTRY#

Service request device detail #REPORT_DEVICE#

Service request / case form #REPORT_FORM#

Service request / case # #REPORT_ID#

Service request location #REPORT_LOCATION#

Service request location post code #REPORT_PINCODE#

Service request / case priority #REPORT_PRIORITY#

Service request product #REPORT_PRODUCT#

Service request location state #REPORT_STATE#

Service request / case status #REPORT_STATUS#

Service request location #REPORT_LOCATION#

Service request location post code #REPORT_PINCODE#

Service request / case priority #REPORT_PRIORITY#

Service request product #REPORT_PRODUCT#

Service request location state #REPORT_STATE#

Service request / case status #REPORT_STATUS#

Service request / case submit time #REPORT_SUBMIT_TIME#

Case summary #REPORT_SUMMARY#

Service request location ward #REPORT_WARD#

Service request location area #REPORT_AREA#

Service request location address number #REPORT_ADDRESS1#

Service request location street name  #REPORT_ADDRESS2#

Service request location dependent locality #REPORT_ADDRESS3#

Current date / time - yyyymmddhh24miss #CURRENT_DATETIME_YMD#

Service request incident latitude #INCIDENT_LATITUDE#

Service request incident longitude #INCIDENT_LONGITUDE#

Service request / case UPRN #REPORT_UPRN#

Incident date #INCIDENT_DATE#

Report user title #REPORT_USER_TITLE#

Customer first name (Web only) #REPORT_USER_FIRST_NAME#

Customer last name (Web only) #REPORT_USER_LAST_NAME#

Customer email (Web only) #REPORT_USER_EMAIL#

Customer mobile number (Web only) #REPORT_USER_MOBILE_NUMBER#

Customer home number (Web only) #REPORT_USER_HOME_NUMBER#

Customer Address Line 1 (Web only) #REPORT_USER_ADDRESS#

Customer Address Line 2 (Web only) #REPORT_USER_ADDRESS2#

Report User Address Line 3 #REPORT_USER_ADDRESS3#

Customer city (Web only) #REPORT_USER_CITY#

Customer pincode (Web only) #REPORT_USER_PINCODE#

Customer state (Web only) #REPORT_USER_STATE#

Customer region (Web only) #REPORT_REGION_ID#

Customer council (Web only) #REPORT_COUNCIL_ID#

Customer UPRN (Web only) #REPORT_USER_UPRN#

Product payment grand_total #PRODUCT_PAYMENT_GRAND_TOTAL#

Merge Custom 1 #MERGE_CUST_1#

Merge Custom 2 #MERGE_CUST_2#

Merge Custom 3 #MERGE_CUST_3#

Merge Custom 4 #MERGE_CUST_4#

Merge Custom 5 #MERGE_CUST_5#

Merge Custom 6 #MERGE_CUST_6#

Merge Custom 7 #MERGE_CUST_7#

Merge Custom 8 #MERGE_CUST_8#

Merge Custom 9 #MERGE_CUST_9#

Merge Custom 10 #MERGE_CUST_10#

Assets booking start time #ASSETS_BOOKING_START_TIME#

Appointment Booking End Time #APPOINTMENT_BOOKING_END_TIME#

Appointment Booking Start Time #APPOINTMENT_BOOKING_START_TIME#

Appointment Booking Date #APPOINTMENT_BOOKING_DATE#

Appointment Booking Type #APPOINTMENT_BOOKING_TYPE#

Assets booking title #ASSETS_BOOKING_TITLE#

Assets booking date #ASSETS_BOOKING_DATE#

Bulky waste booking end time #BULKY_WASTE_BOOKING_END_TIME#

Bulky waste booking start time #BULKY_WASTE_BOOKING_START_TIME#

Bulky waste booking date #BULKY_WASTE_BOOKING_DATE#

Report user language #REPORT_USER_LANG_CODE#

Language #USER_LANG_CODE#

Assets booking end time #ASSETS_BOOKING_END_TIME#

Report USRN #REPORT_USRN#

Report service SLA time #REPORT_SLA#

Service request location City #REPORT_CITY#