Dialog List Changes when user goes back into list

Hola from Sunny Florida, Experts, maybe this is a bug or maybe I have something selected improperly but I have a dialog list with these options:

Deletion
Name Change
New Hire
Other Request
Transfer

The user will pick Other Request, they will then go back out and go to change it the problem is the Other Request now is broken into 2 words so the list looks like this:

Deletion
Name Change
New Hire
Other Request
Transfer
Other
Request

The user will then either select other or request which completely invalidates my hide when formulas and my worlk flow.

How do I fix it so that if they selected th ewrong one and go back to change the slection they don't see the current selection as 2 separate selections.


Kinda Hot this is in a production form.
Ray PadillaIT DirectorAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ray PadillaIT  DirectorAuthor Commented:
I've temporarily changed it to a combo box but it isn't very nice looking on the form.......I'd rather use the dialog list.
mshogrenCommented:
In the field properties check under the third tab and under multi-value options and make sure you do not have space selected as the separator for users to enter.
Ray PadillaIT  DirectorAuthor Commented:
They can only select one value so that option is greyed out....
Become a Certified Penetration Testing Engineer

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

mshogrenCommented:
Right you are.  I guess that is a bug then.  Unless any one else has a different opinion?
marilyngCommented:
Hi padillrr,

How is the list concatentated?

List:="Deletion":"Name Change":"New Hire":"Other Request":"Transfer"

Or do you have a series in the dialog box:
Deletion|0
Name Change|1
New Hire|2
Other Request|3
Transfer|4

Try:
Create a multivalue field, separate on new line only, computed with the name= "MyList"
Formula = "Deletion":"Name Change":"New Hire":"Other Request":"Transfer"

In the dialog box select "Use Formula for Choices" and then enter the field name: MyList
Be sure you don't have a translation formula.  What's happening is that there is a translation formula or a typo in some field that is taking the value they've selected and turning it into two words.


Other
Request  <>"Other Request"

Because something is adding a space or separating Other Request into  two values Other:Request

Regards!
Sjef BosmanGroupware ConsultantCommented:
mshogren is more or less right, in advising you to deselect the space as multi-value separator. "But I said it is not available!" Yeah, I know, so enable multi-value, disable ALL separators, and disable multi-value again. By the way, this is not a bug, this is just another feature...
mshogrenCommented:
marilyng, I tested your solution on a blank form with nothing else on it but it didn't work.  Same for sjef_bosman.  I think padillr is on to something here.  My tests were conducted on Notes 6.5.4.
marilyngCommented:
mshogren.. what exactly didn't work?   The list, the form, the values.. my tests on 6.5.3.

No, I agree with sjef.. if you had a field that was a dialog box with multiple entries, and then changed it to single entries, the old multi-value separators are cached in the form, you have to go back to the multivalue version, and set the separators, and then change it to single.. or create a new field.

I don't think its a bug, because I was unable to duplicate the same problem.  I have seen the problem happen when
a b c <> abc or
abc (space) <> abc(no space)
marilyngCommented:
Ok, mshogren, apologies.  I was finally able to duplicate the problem. Here's the poop.  If you create a dialog list with set values, save it and then change anything on the field, i.e.  change the dialog to drop down, combo box, etc. after you've saved the form, you get the split:

This One
This Two
This Three
Other Options
Other
Options

Delete the field, recreate it, and either populate the list from a field or write the list in, and the values appear correctly.  

Tested v R6.5.3
Sjef BosmanGroupware ConsultantCommented:
Hi Marilyn, instead of deleting the field, did you try to set it to multi-value, remove the separators, reset to single value?
marilyngCommented:
Yup, I specifically tried that, and it caused the duplication when you go back in.  I, like you, assumed that would fix it.  
marilyngCommented:
padillrr,
How are you doing with this?  Still stuck?
Ray PadillaIT  DirectorAuthor Commented:
Yes I am no real fix I tried deleting the field recreating it and still the same issue
marilyngCommented:
throw a new replica of design with no documents, if documents contain the previous field, it may be caching.  

Or recreate the form.

Point is, you have to delete or rename the OLD form, OLD field and then compact the database.  To remove all documents in a database, set the replication space spavers settings to 0, and enable - it will remove all documents, then reset the space savers to "30" and disable, so you don't have delete stubs from when the pilgrims arrived.

I found the problem occurs if you change the field settings after you've saved it.  Think it has something to do with the designer cache, too.
Ray PadillaIT  DirectorAuthor Commented:
I've tried all recommended solutions but none has worked, could it be a version issue?
Sjef BosmanGroupware ConsultantCommented:
Can you send us a working test database (form, some data, nothing important of course) so we can test hands-on? It might be necessary to add some silly statement like

    Request := Request

in the Translation formula of the Request field, in order to get it recomputed. There is an earlier similar question, see http:Q_21183587.html#12446326 for the solution in that case. Maybe it'll help you...
GranModCommented:
PAQed with points refunded (250)

GranMod
Community Support Moderator

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Lotus IBM

From novice to tech pro — start learning today.