Expression Examples

Calculation field expression examples.

Use this in a calculation field to share photos in different platforms.
Use this in a calculation field to pull up the altitude of a location.
Calculate the distance between repeatable points by leveraging a 3rd party JavaScript library.
Calculate the sum of numbers in a repeatable field. Great for total cost or score if when using repeatables.
Use this in a calculation field to pull the label of the selected choice option.
Use this in a calculation field to combine two arrays together.
Use this in a calculation field to get the time between two date fields.
Use this in a calculation field to compare multiple values and return a specific value based on the values entered.
Get a total count of unanswered fields in a section.
Will provide you with the number of child records that have been created inside a repeatable section.
Count the number of selections in a multiple choice field.
Use this in a calculation field to return the day of the week from a date.
Use these in calculation fields to return latitude/longitude in degrees decimal minutes format.
Pulls the address from the address field in Australia.
Pulls the address from the address field.
This expression grabs the photo id number and adds it to a feature id field.
Use this in a calculation field to pull the last item capture in a classification set field.
Use this in a calculation field to return the latest date captured in a date field in repeatable section.
Loop through and pull a value from a fields within a section.
Pull in data from an array of objects according to the values from a choice field and number field.
Generate WKT point & line geometries from repeatable vertices.
Use this in a calculation field to return the most frequent value from a field in a repeatable section.
Use this in a calculation field to return the sum of a specific type from a repeatable section
Use this in a calculation field to split classifications into separate fields.
Use this in a calculation field or data event to split the value captured in a field.
How to generate star ratings using numeric range data as input.
Sum fields that might be blank.
Use this in a calculation field to add a full timestamp for when the record was initially generated or edited, automatically.
Using the Unix timestamp to generate a unique record value.
Maintain a field for tracking record updates by field technicians only.
Pulls values stored in a choice field that is inside a repeatable section and stores them in an array.
Use this in a calculation field to return the week number from the current date or from a date field.