Adding value to option string

poppins

Hi everyone,

I have an Option field in a table with the following OptionString: opt1,opt2,opt3
I want to add a new value between opt1 and opt2.
Is it possible?or should I add it in the end?

Thanks in advance

lvanvugt

Impossible, so add it at the end.

ftornero

It's not imposible, the only problem is that you will have the values of this field wrong.

i.e. if the new OptionString is: opt1,opt11,opt2,opt3

Then in the records with old value opt2 you'll have opt11 and in the records with old value opt3 you'll have opt2.

You can run a process to let the field with the right value after the modifcation.

Regards.

mohana_cse06

What about the code?

If you have any code with Option values then they will also change. how do you correct in all places?

If field.Opt2 = field.Opt2 then

will change to

If field.Opt11 = field.Opt11 then

mohana_cse06

So its always better to add at the end and also leave few blank values so that we don't have any issues if Microsoft adds new values

like opt1,opt2,opt3,,,,,,,,,opt11

ftornero

Yes, you need to take care of the code too, but my point was that it's not a good practice but not imposible, and is your call to use one or another way to do it.

Regards.

lvanvugt

ftornero wrote:

Yes, you need to take care of the code too, but my point was that it's not a good practice but not imposible, and is your call to use one or another way to do it.

You're too positive. Regarding all the consequences (i.e. work to be done) I call it impossible.