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