How to set up an discount calculation formula in BoldSign?
Formula fields in BoldSign allow you to apply discount operations within your documents. These formulas are dynamically calculated based on form fields and do not store any static data.
Example Scenario
To understand how discount calculations work, let’s consider a subscription-based pricing model where the total cost is determined based on the number of users and the selected subscription duration.
Start Date: Automatically set as the first day of the next month after signing.
End Date: Determined based on the selected duration (12, 24, or 36 months).
User Count: A numerical input field to specify the number of users.
Monthly Cost Calculation: The number of users multiplied by a fixed cost per user (e.g., $150 per user per month).
Discount Application:
- No discount for 12-month subscriptions.
- A 5% discount for 24-month subscriptions.
- A 15% discount for 36-month subscriptions.
By setting up formula fields, the system can automatically calculate subscription costs, applying discounts when applicable.
Step-by-Step Guide to Configuring Discount Calculation in BoldSign
Follow the steps to configure and use formula fields to calculate discount operations In BoldSign:
Step 1 : Create a new document
- Click
Create New
and selectCreate New Document.
- Fill in all the required fields in the Prepare document for signing page and click the
Next
button. - On the Configure field page, add all the necessary form fields to your document, such as Textbox or Dropdown, before adding formula fields.
- Assign meaningful IDs to these fields and configure them as Number to simplify the formula creation process.
Step 2: Add the DateSigned Field
- Drag and drop the Date Signed field into the document. This field automatically captures the date when the signer completes the document.
Step 3: Configure the Start Date Field
- Drag and drop the Formula field to your desired location in the document, then assign it a unique ID in the formula settings panel.
- To set up an start date formula, click
Set Formula
to open the Formula Builder.
- The Formula Field supports four basic arithmetic operations: addition, subtraction, multiplication, and division, represented by their respective operator symbols.
- Use supported fields and the required arithmetic operators to create your formula. For example, if you want to set the start date as the first day of the next month after signing, click on the Formula expression field and enter the following formula.
- Check the formula for any mistakes, then click
Save.
Step 4 : Add a Duration Dropdown Field
- Insert a Dropdown Field in the document.
- Configure the dropdown options with predefined subscription durations, such as 12, 24, or 36 months.
- Assign Field ID: Months for consistency and easier reference in formula calculations.
Step 5: Configure the End Date Field
- Drag and drop the Formula Field to calculate the subscription’s end date.
- To set up an start date formula, click
Set Formula
to open the Formula Builder and assign Field ID as EndDate to this field for easy identification
- Set up the formula to calculate the end date based on the selected duration by adding the specified number of months to the start date and adjusting it to display the last day of the previous month.
- Check the formula for any mistakes, then click
Save.
Step 6: Add the User Count Field
- Insert a Text Box Field into the document where users can input the number of users.
- Configure this field to accept only numerical values by enabling the NumberOnly validation setting. and assign field Id as UserCount to clearly define its purpose.
Step 7: Calculate the Monthly Cost
- Add the Formula field for calculate the monthly cost and assign field ID as MonthlyCost to this formula field for easy reference
- Set up the formula by multiplying the user count by the cost per user per month. For example, if the monthly cost per user is 150, use the formula UserCount * 150 to calculate the total monthly cost.
- Check the formula for any mistakes, then click
Save.
Step 8: Calculate the Total Cost with Discounts
- Add a Formula Field to calculate the total subscription cost, incorporating applicable discounts based on the selected month duration.
- Set up the formula as follows:
- If the selected duration is 12 months, no discount is applied.
- If the selected duration is 24 months, a 5% discount is applied.
- If the selected duration is 36 months, a 15% discount is applied.
- Check the formula for any mistakes, then click
Save.
- Use the
Preview
option to test the formula and make sure it works correctly. Adjust it if needed to achieve the desired results.
- Proceed to send the document for signature.