Bulk update values in drop down editor

Hi Everyone,

I am looking for a solution where we have a drop down in opportunities for the amount of users.

We want to import around 250+ different values into this drop down but I am not seeing any import options only manually adding each value one at a time.

We are currently using a drop down field which is sub-optimal but we are wanting to change to a lookup field.

Does anyone know a better solution to doing this or any recommendations in to how I would proceed?

Thanks in advance,

Sam

Parents

0 Tony Romano over 1 year ago

For your use case, why not use an integer field instead, is there a reason not to?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sam Hennessy over 1 year ago in reply to Tony Romano

This is a possible solution if I was able to only pick in blocks of 25 as there was an issue before where anyone was selecting any sort of number skewing the data as we only sold licenses to 25, 50, 75, 100 etc...

Thanks everyone else for the helpful recommendations.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Francesca Shiekh over 1 year ago in reply to Sam Hennessy

why not use Two fields:

- an integer field for the number of blocks they want to buy,

- a calculated integer field for quantity that is the number of blocks entered multiplied by 25.

So if I enter 1 for the number of blocks I get quantity 25,

If I enter 9 I get a quantity of 225 etc...

FrancescaS
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Francesca Shiekh over 1 year ago in reply to Sam Hennessy

why not use Two fields:

- an integer field for the number of blocks they want to buy,

- a calculated integer field for quantity that is the number of blocks entered multiplied by 25.

So if I enter 1 for the number of blocks I get quantity 25,

If I enter 9 I get a quantity of 225 etc...

FrancescaS
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data