-
Myers_KyleAsked on March 28, 2025 at 5:09 PM
One of my forms includes and Address input form field.
I would like to use the form calculation widget to calculate the quantity of numerical values included within Address Line 1.
I.E. Address Line 1: 12345 5th Ave.
Form Calculation Widget Output: 5
Should I use the Count function to achieve this?
-
Aries JotForm SupportReplied on March 28, 2025 at 10:02 PM
Hi Kyle,
Thanks for reaching out to Jotform Support. Unfortunately, this is not possible using the count function. As a workaround, you will need to separate each part of the address using a short text element and add two Form Calculation widgets, then create a formula utilizing the floor and log10 functions. Note that this formula will count all the numbers entered in the field. Let me show you how to do it:
1. Click on the Add Element menu on the left side of the page and add a Short Text element and two Form Calculation widgets. under the Widgets tab
2. Click on the Wand icon beside the first Form Calculation widget and click on Add Field, select the Short Text field, and click on the Save button.
3. On the second Form Calculation widget, click on the Wand icon and create the formula. Here's how it looks like:
Here's the sample result:
Give it a try and let us know if you have any other questions.
Your Answer
Something Went Wrong
An error occurred while generating the AI response. Please try again!