• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 465
  • Last Modified:

Problems with combobox and allow values not in list

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
0
adspmo
Asked:
adspmo
  • 3
  • 3
  • 3
2 Solutions
 
qwaleteeCommented:
That feature does not work on the web.  If you take a look at the discussion database Categories field, you will see taht Lotus also had to work around this problem.

The usual way is to have thre fields:
1) main field hidden from web
2) mai web select field, hidden from notes
3) web "new keyword" field, hidden from notes

Let's say teh fields are Categories, CatWeb, and CatWebNew

The trabslation formula for Categories would be:
@Trim(Categories:CatWeb:CatWebNew)

The choices for CatWeb would be identical to Categories.
The translation formula for CatWeb would be Categories

The translation formula for CatWebNew would be "" (null string)

Make sure the fields appear in the listed order, so Categories has a chance to pick up changes before the other two fields reset themselves.
0
 
adspmoAuthor 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
0
 
HemanthaKumarCommented:
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
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
adspmoAuthor 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
0
 
HemanthaKumarCommented:
Give me details on how this computed field is getting this value and all other refereing field formulas ..
0
 
adspmoAuthor 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 ""

0
 
HemanthaKumarCommented:
I think it is much simpler by doing it using Javascript

Create a button with following JS Code

frm=window.document.forms[0];
var response= prompt("Please add the new value","-New Value-");
if (response !=null) {
var i=frm.Categories.length;
frm.Categories.length++;
frm.Categories.options[i].value=response;
frm.Categories.options[i].text=response;
frm.Categories.options[i].selected = true;
}


Replace Categories with the name of the list field accordingly

0
 
qwaleteeCommented:
CustomerCompany translation s/b Input Translation @Trim(CustomerCompanyNotes)
0
 
qwaleteeCommented:
The JS code will work, as well.  I've used something similar.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

  • 3
  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now