We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Problems with combobox and allow values not in list

adspmo
adspmo asked
on
Medium Priority
480 Views
Last Modified: 2013-12-18
HI

I am using a Combobox for a field. This is for a web enabled document

It is Editable

It is doing a lookup to view for data
When I switch on Allow Values not in List I loose the button and have no way to select from the field

Any ideas on how to deal with this

James
Comment
Watch Question

Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Let me  throw a wrinkle at ya

There is also a separate computed text field

It is returning all the values instead of just the correct value or the new value
There is a sample available on sandbox... http://www-10.lotus.com/ldd/sandbox.nsf/ecc552f1ab6e46e4852568a90055c4cd/162b0000f822865b85256b14004d9b6d?OpenDocument

> It is returning all the values instead of just the correct value or the new value

Not sure I understand that !!

~Hemanth

Author

Commented:
It is returning

Not Specified. Not Specified. Newvalue and if I save it againg it concatenates the string again on the end

The formula for the Computed Text  is CustomerCompany

I Have the following fields. I just replaced the above with these field names

CustomerCompanyNotes
CustomerCompany
CustomerCompanyNew
Give me details on how this computed field is getting this value and all other refereing field formulas ..

Author

Commented:
OK

Computed Text Field
Value CustomerCompany

CustomerCompanyNotes Hidden from Web No Default value
ComboBox Editable
LU := "-Not Specified-" : @DbColumn("":"NoCache"; "":""; "RByCustomer1"; 1);
@Unique(LU)
Input Translation @Trim(CustomerCompanyNotes:CustomerCompany:CustomerCompanyNew)

CustomerCompany Hidden from Notes   Default = "-Not Specified-"
ComboBox Editable
LU := "-Not Specified-" : @DbColumn("":"NoCache"; "":""; "RByCustomer1"; 1);
@Unique(LU)
Input Translation @Trim(CustomerCompany))

CustomerCompanyNew  Hidden from Notes No Default Value
Text Editable
Input Translation ""

Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Commented:
CustomerCompany translation s/b Input Translation @Trim(CustomerCompanyNotes)

Commented:
The JS code will work, as well.  I've used something similar.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.