Creating a formula-generated list based on a different field

HCL Domino Domino Forum
1

I have a field called “strCounty” which once the user selects a county, I want the “strName” listbox field below it to have choices that are from the selected county.

I currently have a “vName” view based on “fName” form that has catagorized hidden column 1 as the strCounty and column 2 has strName

I have been unable to locate a formula to put in the choice box of strName listbox field to generate this list.

Any assistance would be greatly appreciated.

Thanks

2

Subject: RE: Creating a formula-generated list based on a different field

Use @DBColumn with the value of the choice field as the key. Also make sure that the properties on the choice field are set to Refresh Fields on Keyword Change.

3

Subject: RE: Creating a formula-generated list based on a different field

Many Thanks!!!

One more question on formula. Where do I put “strCounty” into the formula to only pull where column 1 = “strCounty”

@DbColumn(“”; “”; “vName”; 2)

Thanks again for your assistance

4

Subject: RE: Creating a formula-generated list based on a different field

You don’t. The formula for your “driven” field choices would be an @DbLookup rather than an @DbColumn. They are similar functions, but the @DbColumn returns all results in a view column, while @DbLookup gives you a constrained result based on a lookup key:

@DbLookup(“”; “”; “vName”; strCounty; 2; [FailSilent])

Note that strCounty is not in quotes – you want to use the value in the field, not the fieldname, as the lookup key.

5

Subject: RE: Creating a formula-generated list based on a different field

that works perfect. Many Many thanks. Have a great new year!!