Configure drop-down form field as number type to be used in calculated property

SOLVE
Occasional Contributor

Hi all,

 

I have a form on our website where leads can request a price overview, and I want to use calculated properties for that. 

 

However, at the moment I am using drop-down fields in my form, to limit the options that customers have and those fields are text fields, so I cannot use them for the calculation.

 

Is there a way to generate a drop-down field with number properties attached, to that I can use them in a calculated property?

 

Thanks!

1 Accepted solution

Accepted Solutions
Solution
Regular Advisor

I'd suggest creating a new number property and use a workflow to set this number field based on the submitted dropdown value. Use an if branch for each value option.

 

if dropdown = A

- Yes branch > set number property to 1

- No Branch > if dropdown = B

 - - Yes branch > set number property to 2

 - - No Branch > if dropdown = C

  - - - and so on...

 

View solution in original post

4 Replies 4
Solution
Regular Advisor

I'd suggest creating a new number property and use a workflow to set this number field based on the submitted dropdown value. Use an if branch for each value option.

 

if dropdown = A

- Yes branch > set number property to 1

- No Branch > if dropdown = B

 - - Yes branch > set number property to 2

 - - No Branch > if dropdown = C

  - - - and so on...

 

View solution in original post

Resident Expert

@ndwilliams3 for those who have the free version, is there another way?

Reply
0 Upvotes
Regular Advisor

The free version doesn't have access to calculated fields, so it wouldn't be an issue. You would need a paid version of marketing or sales hub enterprise , which would also include workflows.

 

Reply
0 Upvotes
Occasional Contributor

Hi Noel,

 

Thanks, that will actually work. I'll try that out.

 

Cheers,

 

Bas

Reply
0 Upvotes