Articles in this section

See more
How to Build a Budget Form
  • Updated

If you require your applicants to complete a budget within your site this can be achieved internally within your form. Alternatively, if you wish for a budget to be uploaded to the application, you can consider uploading a template to the Files section and have them upload it to an Upload task.

NOTE: The calculations provided in this article are examples that can be referenced for formatting purposes. Your calculations will vary based on your own configurations. For more information on setting up calculations, you can refer to Advanced Expression Piping: Overview

In this Article...

 

Building the Questions

The most common question types for creating budgets are either Text Response Grid or 3D Matrix, using the Text Response variable to allow users to enter their totals. When building out a budget there are often two different sections for the user to complete: Revenue/Income and Expenses. In some cases, you may only request the expenses of the applicants.

For this example, we will walk through requesting information about someone's Income and Living Expenses.

  1. Start by Adding your questions to the form: Text Response Grid and/or 3D Matrix,
  2. Set up the rows and columns to allow for applicants to enter their amounts and any other information you need to collect
  3. Set a Floating Point Validation on the fields/columns. This will ensure that the values are entered in the correct format to be accepted in the calculation.
  4. Set an Identifier on the question. This is an important step to be able to calculate the totals.
  5. Repeat the above steps for each section that you need to collect. For our example, this may include Income, Rent/Utilities, Loans, Auto, etc. 

NOTE: For Step 3, Commas and Spaces will not be accepted in a calculation and will cause an error if the user enters them in their response.

Here are two possible examples of a question setup, however, you can customize your question as you need to. These examples will be referenced throughout the article:

Setup A: 3D Matrix

Setup B: Text Response Grid
2019-07-31_15-31-34.png 2019-07-31_15-33-58.png

  

Calculating the Sub Totals
  1. Add in either a Text Response, Hidden Field, and/or Section Heading directly below the question. After each question that we add, we want to see what the sub-total is for each question.
    For more information on which question type you should choose, you can refer to Knowing which Question Type to Use
  2. Next, we will create our calculation using the identifier we have set on the section. Follow Setup A: 3D Matrix and Setup B: Text Response Grid below for steps on creating the calculation.

 

Setup A: 3D Matrix

Since we have multiple columns in the question, in our example, we only want to calculate the second column into our subtotal.

  1. Within the Initial Value or Description of the question, start your expression by adding 2 curly brackets {{
  2. Add a space after the second bracket
  3. Enter SUM()
  4. Within the closed brackets add the identifier, which will be case sensitive. For our example, we set the identifier to be "income"
    2019-07-31_15-22-49.png
  5. Add the column indexing. The Amount column is the second column in the question so it will be [:1]
    For more information, see Index an Entire Column
  6. After your expression, add a space
  7. Close your rule with 2 closed curly brackets }}
  8. Enable Restore Initial Value to ensure your formula always recalculates if a user changes their responses.

 

When we're done, our questions will look like:

2019-07-31_15-36-38.png

 

When the applicant is completing the form they will see the following:

2019-07-31_15-40-59.gif

 

Setup B: Text Response Grid

  1. Within the Initial Value or Description of the question, start your expression by adding 2 curly brackets {{
  2. Add a space after the second bracket
  3. Enter SUM()
  4. Within the closed brackets add the identifier, which will be case sensitive. For our example, we set the identifier to be "rent"
    2019-07-31_15-41-59.png
  5. After your expression, add a space
  6. Close your rule with 2 closed curly brackets }}
  7. Enable Restore Initial Value to ensure your formula always recalculates if a user changes their responses.

 

Since we only have the one column we don't need to reference the column as we do for 3D Matrix. Therefore, our final setup will appear as

2019-07-31_15-43-03.png

 

When the applicant is completing the form they will see the following:

2019-07-31_15-44-30.gif

 

Calculating the Grand Total/Difference

First, we can find the total amount of the expenses incurred (Rent + Loans + Auto). Now that we have added all of our questions and calculated all of our Sub Totals, we want to calculate everything together to determine what the grand total or difference is. 

This calculation will appear as such, depending on the question type:

Setup A: 3D Matrix {{ SUM(rent[:1],loans[:1],auto[:1]) }}
Setup B: Utilities {{ SUM(rent,loans,auto) }}

 

If you are then looking to find the difference between your Income and Expenses, the calculation may be:

{{ (SUM(income[:1])) - (SUM(rent,loans,auto)) }}

NOTE: When performing the above calculations, be aware of our In-Form Piping restrictions which prevent you from performing calculations on a piped value on the same page. For more information, you can refer to our help section on Same Page vs. Next Page Piping

Related articles