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

[kirvis]

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!

[ndwilliams3 · Accepted solution]

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...

[gelflex-cc]

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

[ndwilliams3]

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.

[kirvis]

Hi Noel,

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

Cheers,

Bas