Formula for choices

HCL Domino Domino Forum
1

Hi,

How can I use this:

I have 3 dialog fields, the idea is when selecting a row in field 1, field 2 will be reconstructed to have only types that belong to size of field 1, the same thing for field 3, will have “sex” that belongs to field 2

I am starting using this for field 2:

Dialog box, editable, use formula for choices and in formula I use this:

tsize := “"” + size_person + “"”;

tform:=“"”+“Feet Measure”+“"”;

"Select (form= " + tform + “) & size=” + tsize

But nothing happen, any help ?

2

Subject: RE: Formula for choices

What you’re trying to do is possible, but you’re far from a solution. The keyword selection formula does not use the SELECT keyword to select documents – keyword selections can be any list of values and may have nothing to do with any documents (and in any case you would have to say which field in the target documents you wanted values from).

Instead, you must use @DbLookup to find the documents that match, and pull from them the value that you want to list in your choice list.

3

Subject: RE: Formula for choices

Hi,

Thank you, now I’m using @DbLookup but now I have another problem, the first time I enter in the document, I go to Field1 and select a value, in the Field2 appears the correct information but when I change again value in Field1, Field2 stays with the same data

I used “Refresh fields on keyword change” to force actualization of fields but nothing happen.

Any idea why?

Thanks in advance

Paulo

4

Subject: RE: Formula for choices

Field2 must have the option “Refresh choices on document refresh” ticked.