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
  • For your use case, why not use an integer field instead, is there a reason not to?

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

  • Hi  ,

    You can ensure an integer field is in a certain increment using a supporting Sugar Logic field. I was able to accomplish this with a custom text field that is both required and calculated. The calculation will only populate a value into the field if purchased licenses is in an increment of 25. In other words, the user would not be able to save the record until they put in a proper license count since the field is required:

    Sugar Logic does not have a remainder function, so you need to work around that by manually evaluating for a remainder. Here is the formula I used:

    ifElse(
        equal(
            subtract(
                multiply(
                    25,
                    round(
                        divide(
                            $licenses_sold_c, 
                            25
                        ),
                        0
                    )
                ),
                $licenses_sold_c
            ),
            0
        ),
        "Yes",
        ""
    )

    So, if the licenses sold is in an increment of 25, then the field will display 'Yes' and the record can be saved. For any other value, the field is empty and the record cannot be saved.

    The field needs to be added to the record view for this to work since required fields not on the record view will not be evaluated.

    I hope this helps!

    Chris

Reply
  • Hi  ,

    You can ensure an integer field is in a certain increment using a supporting Sugar Logic field. I was able to accomplish this with a custom text field that is both required and calculated. The calculation will only populate a value into the field if purchased licenses is in an increment of 25. In other words, the user would not be able to save the record until they put in a proper license count since the field is required:

    Sugar Logic does not have a remainder function, so you need to work around that by manually evaluating for a remainder. Here is the formula I used:

    ifElse(
        equal(
            subtract(
                multiply(
                    25,
                    round(
                        divide(
                            $licenses_sold_c, 
                            25
                        ),
                        0
                    )
                ),
                $licenses_sold_c
            ),
            0
        ),
        "Yes",
        ""
    )

    So, if the licenses sold is in an increment of 25, then the field will display 'Yes' and the record can be saved. For any other value, the field is empty and the record cannot be saved.

    The field needs to be added to the record view for this to work since required fields not on the record view will not be evaluated.

    I hope this helps!

    Chris

Children
No Data