Calculation field expression examples.
Transfer Photos through payloads
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.
Distance between repeatable points
Sum of numbers in a repeatable
Calculate the sum of numbers in a repeatable field. Great for total cost or score if when using repeatables.
Pull Selected Choice Option Label
Use this in a calculation field to pull the label of the selected choice option.
Combine arrays together
Use this in a calculation field to combine two arrays together.
Time between two date fields
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.
Count blank fields in a section
Get a total count of unanswered fields in a section.
Generates the number of child records
Will provide you with the number of child records that have been created inside a repeatable section.
Count multiple choice field selections
Count the number of selections in a multiple choice field.
Generate the day of the week from a date
Use this in a calculation field to return the day of the week from a date.
Get address from address field (in Australia)
Pulls the address from the address field in Australia.
Get address from address field
Pulls the address from the address field.
Grab the photo id number
This expression grabs the photo id number and adds it to a feature id field.
Get last item in a classification set
Use this in a calculation field to pull the last item capture in a classification set field.
Return the repeatable latest date
Use this in a calculation field to return the latest date captured in a date field in repeatable section.
Obtain Values from fields within a section
Loop through and pull a value from a fields within a section.
Calculate radius for plot sampling
Pull in data from an array of objects according to the values from a choice field and number field.
Vector geometries from repeatables
Generate WKT point & line geometries from repeatable vertices.
Return the most frequent value
Use this in a calculation field to return the most frequent value from a field in a repeatable section.
Return Sum of Specific Type
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.
Split Value Captured in a Field
Use this in a calculation field or data event to split the value captured in a field.
Star ratings from a numeric range
How to generate star ratings using numeric range data as input.
Sum nullable fields
Sum fields that might be blank.
Generate a full timestamp
Use this in a calculation field to add a full timestamp for when the record was initially generated or edited, automatically.
Unix timestamp for unique record value
Using the Unix timestamp to generate a unique record value.
Track who has updated a record
Maintain a field for tracking record updates by field technicians only.
Values from choice field in repeatable
Pulls values stored in a choice field that is inside a repeatable section and stores them in an array.
Generate the week number
Use this in a calculation field to return the week number from the current date or from a date field.
Fulcrum on GitHub