CRM

AKhakimova
Participant

Number property - ensuring consistent form submissions

SOLVE

Hi all,

 

What can be the reason for form submissions to contain comma and decimal separators in a number property even though the set up for the property is the following:

unformatted number + limit of number of decimal places to 0.

 

Context: we would like to ask for people to submit only absolute (full) numbers like, 5100000 (for 5.1 million)

 

Thank you in advance!

1 Accepted solution
Lucila-Andimol
Solution
Most Valuable Member | Platinum Partner
Most Valuable Member | Platinum Partner

Number property - ensuring consistent form submissions

SOLVE

Ok,

so with the rules in an unformattef number this should work

or at least used to work.

Have you tried creating a support ticket?

María Lucila Abal
COO Andimol | Platinum Accredited Partner
HubSpot Expert, Top Community Champion | Hall of Fame IN23&IN24
Certified Trainer (12+ years) | SuperAdmins Bootcamp Instructor

Have questions? Get answers:

Get Premium Support

Did my post help answer your question? Mark this as a solution.

View solution in original post

0 Upvotes
6 Replies 6
erin-pfcla
Participant

Number property - ensuring consistent form submissions

SOLVE

I have had the same problem. I have fields where I want to capture only whole numbers without having to make it a drop down. I tried changing my Number field to unformatted but people can still type a decimal in the forms.

decimals still allowed in form submissiondecimals still allowed in form submission0 decimal places allowed0 decimal places allowedNumber field set to Unformatted NumberNumber field set to Unformatted Number

 

When I spoke to Hubspot support, they pointed me to this help article which explains that validation rules do not work for data submitted via form submission, which answers why this does not work, but sadly does not solve my problem. Set validation rules for a property (hubspot.com)

0 Upvotes
Jigar_Thakker
Key Advisor | Diamond Partner
Key Advisor | Diamond Partner

Number property - ensuring consistent form submissions

SOLVE

Hey @AKhakimova 

 

As I can see in this article unformatted numbers can not contain formats like numbers with commas: https://knowledge.hubspot.com/properties/property-field-types-in-hubspot 

Jigar_Thakker_0-1710165847670.png

 

 

Can you share some screenshots in this context so that I understand this better

0 Upvotes
AKhakimova
Participant

Number property - ensuring consistent form submissions

SOLVE

Hi, appreciate your time! Attaching screenshots below.

Screenshot 2024-03-11 at 16.00.56.png

Screenshot 2024-03-11 at 16.01.04.png

Screenshot 2024-03-11 at 16.01.39.png

  

Screenshot 2024-03-11 at 16.01.55.png

Screenshot 2024-03-11 at 16.01.52.png

Screenshot 2024-03-11 at 16.02.06.png

   

Lucila-Andimol
Most Valuable Member | Platinum Partner
Most Valuable Member | Platinum Partner

Number property - ensuring consistent form submissions

SOLVE

Hey @AKhakimova 

so unformatted number option for properties will clear any other configuration that you do in the next screens and keep the numbers without format.

So if you want people to put decimals, you need to use a formatted number and then set the number of decimals to admit.

Hope this helps

María Lucila Abal
COO Andimol | Platinum Accredited Partner
HubSpot Expert, Top Community Champion | Hall of Fame IN23&IN24
Certified Trainer (12+ years) | SuperAdmins Bootcamp Instructor

Have questions? Get answers:

Get Premium Support

Did my post help answer your question? Mark this as a solution.

0 Upvotes
AKhakimova
Participant

Number property - ensuring consistent form submissions

SOLVE

Hi @Lucila-Andimol ,

 

I don't want people to put decimals that's why I restricted it in the property settings but through Forms they still can, and this is my problem. When I go to these submitted properties in Contacts/Companies, the decimal points are still there even though the number should be unformatted and with no decimals.

Lucila-Andimol
Solution
Most Valuable Member | Platinum Partner
Most Valuable Member | Platinum Partner

Number property - ensuring consistent form submissions

SOLVE

Ok,

so with the rules in an unformattef number this should work

or at least used to work.

Have you tried creating a support ticket?

María Lucila Abal
COO Andimol | Platinum Accredited Partner
HubSpot Expert, Top Community Champion | Hall of Fame IN23&IN24
Certified Trainer (12+ years) | SuperAdmins Bootcamp Instructor

Have questions? Get answers:

Get Premium Support

Did my post help answer your question? Mark this as a solution.

0 Upvotes