Dynamic Answers & Calculations (Dynamic Values)

Dynamic Answers & Calculations (Dynamic Values)

Often you may need to display some text or calculate a value in a dynamic fashion. For example, you may want to show different text in a field based on what the user has previously answered. Or maybe you have a product order Form that should calculate the total amount to pay. This is where the Dynamic Value property found on most form fields comes in handy. Dynamic Values allow you to create a formula that generates or calculates a result that is assigned as the given field's answer.

So, for example, imagine you have the following Form fields:

    "Enter Product Name" - a Text field with Data Name of productName

    "Enter Product Cost" - a Number field with Data Name of productCost

    "Enter Number of Items" - a Number field with Data Name of numberItems

  1. Add a new Hidden field to your Form, and set the Data Name to be "totalIncludingTax"
  2. On this new field, find the Dynamic Value property. It is found near the bottom of the properties list, in the Advanced section.
  3. Enter the following formula into the Dynamic Value:

{{productCost}} * {{numberItems}} * 1.10

What we've done so far is add a hidden field (a field the app user will never see) which will store the result of the formula calculation. The formula is applying a 10% tax rate to the product cost amount. This is the first example of how you can use the Dynamic Value property to calculate results.

Now we're going to use Dynamic Value again to display a message to the app user. We want to summarize their order details using a read-only Text field.

  1. Add a new Text field to your Form and set the Data Name as "orderSummary."
  2. Find the Read Only property and tick the box. This will make the field read-only so the user cannot change the displayed answer text.
  3. Find the Dynamic Value property and enter the following formula:

concat('You ordered ', {{numberItems}}, ' of ', {{productName}}, '. Total (including tax) is: ', {{totalIncludingTax}})

What we're doing with the above formula is building up dynamic text by concatenating together pieces of text. The concat() function is used to build up the final text from the values from the various fields (the {{dataName}} bits).

See the Creating a Formula page to learn more about how a formula works.


    • Related Articles

    • Dynamic Features

      The Form Designer provides advanced functionality such as: Custom Invalid Messages Your own message to display to the App User if the answer to the question is invalid. Conditional Logic (Visibility of Questions) Whether or not a question or group of ...

    • Action Field as Dynamic Buttons

      The Action Field is an advanced dynamic field that creates up to 5 buttons and allows customized user interactions. Action buttons may be used to upload completed forms, navigate between form pages, open web links, launch e-mails, open documents, or ...

    • Referring to column values of a selected Data Source row

      The Form Designer allows you to link Choices fields to a Data Source that you have previously uploaded. Data Sources can have as many columns as you like, and you may want to refer to the values in these columns when creating a Form. To do so, you ...

    • Validating Answers (Custom Validation)

      TABLE OF CONTENTS Example: Social Security Number Example: Time Example: Multiple Email Addresses When it comes to validating user answers, you have the following standard options: Required - forces the user to provide *something* as an answer ...

    • Dynamic Titles and Hints

      Sometimes you may want your field's Title or Hint text to dynamically include a value from a previous field. This is useful in cases where the answer to one question sets the context for the fields that follow. For example, say you have a Choices ...