Calculated

 Calculated Field

On Builder:

 

 

 New Device Magic UI: Original iOS Device Magic UI:

 

The Calculated Field is for calculating values, based on values provided or the outcome of other questions within your form.

Field Properties:

Label:

Name the field.

Set Expression:

Here you can set the expression that will determine what is calculated.  A few sample expressions you can use:

  • Addition - SUM(sample_integer_1 , sample_integer_2 , sample_integer_3)
  • Subtraction - sample_integer_1 - sample_integer_2
  • Multiplication - sample_integer_1 * sample_integer_2
  • Division - sample_integer_1 / sample_integer_2

Calculating hours worked - (Time_Out - Time_In) / 3600

Please note, you can take this a step further and round your answer (ex. ROUND((Time_Out - Time_In) / 3600, 2)).  In this example, your answer would be rounded to the nearest hundredth.  

Advanced Settings:

Hint:

This allows you to give a hint to help people answer a specific question. This will be displayed below the field, on the device.

Initial Answer:

A default answer provided by you, placed in the question field. This text can be removed by the user.

Identifier:

How the field is identified in the form (the name of the field). You can also provide custom identifiers for long questions, to simplify template creation. Even though longer identifiers take up more space on the template, the data pertaining to that placeholder may not use all the given space and could possibly throw your template out of bounds.

Active:

  • Always (always shows in the form and returns answers in submissions)

  • Only When (only shows in the form and returns answers in submissions under certain conditions – decided upon by you when you click the “Set Rule” button that appears)

Read-Only:

  • Never (not a read-only question)

  • Always (always a read-only question)
  • Only When (only a read-only question under certain conditions – decided upon by you when you click the “Set Rule” button that appears)

Validate Value:

Allows you to set a rule so as to ensure the question is answered according to a particular condition.

You are also able to set an error message so as to indicate to the person how they went wrong with their answer and what they need to do in order to correct it.

Timestamp answer:

Records down the time the question was answered.

Geostamp answer:

Records down the location where the question was answered.

Hidden:

Hide from User - Hidden questions are not visible to the user, but they are still active based on the active rule.

They may be used in calculations and the answers will be included in the submission.

Have more questions? Submit a request

Comments

  • Avatar
    Mark

    Could you provide a couple of examples of how the calculated field could be used.

    Thanks

  • Avatar
    Steven Button

    Probably really simple, but how do you 'subtract' one form field from another to yield a result in the calculated form field. For example, I want to calculate total machine run time from inputted start number and inputted end number... 'end number - start number = machine run time'.

    Thanks!

  • Avatar
    George Clarke
  • Avatar
    1st Rate Pool Service, Inc

    I'm looking for current examples and syntax details on expressions and functions; however, I'm only finding limited information. Are the provided functions based on sql or something else? The article referenced above was somewhat outdated. Any guidance would be greatly appreciated.

  • Avatar
    CleanFast USA

    Still looking for a solution on how to calculate total machine run time... can anyone help with an expression that would yield: 'end machine hours - start machine hours - total machine run time'...

    Thanks!

  • Avatar
    1st Rate Pool Service, Inc

    CleanFast, I'm just getting started with these too. I think using the steps defined with this blog post will accomplish the same thing as machine run time. http://www.devicemagic.com/blog/using-the-time-in-time-out-calculations-on-your-forms
    Good luck.

  • Avatar
    George Clarke

    If you send the data to Google drive as a spreadsheet you can do some calculations there. You would be amazed with the automation that can be done with Google drive.

  • Avatar
    CleanFast USA

    couldn't get the calculation to work in the form... George, I've been sending the submitted forms to Google Drive since we started using it - never thought of just using the calculation in the spreadsheet. Thanks!

    Hopefully catch up with you at an event sometime this year!

  • Avatar
    Outdoor ProWash

    I'm sure there is a way to do it right in the form, but none of that feature makes sense to me. I can call you and walk you through some things if needed. Google drive does some cool automation stuff with calculations and automatic emails. Will catch up soon!

Powered by Zendesk