I am struggling with a checkbox that is behaving very wierdly. The checkbox choices are set as"Use formula for choices" and the formula is a field name, FRM_Courses. The field, FRM_Courses, is a Shared Field, Text, Computed (Computed for Display didn’t work at all), Allow multiple values, and uses a semicolon for separating multiple values for both input and display.
The code for computing this field is:
names:= @DbColumn( “Notes”:“NoCache” ; “” ; “CourseNames” ; 2 );
codes:= @DbColumn( “Notes”:“NoCache” ; “” ; “CourseNames” ; 1 );
retVal:= names + " | " + codes;
@Return(retVal)
The idea being that it returns a list of label | value pairs for the checkboxes (4 in the set) ie:
Catchments: their character, waters & chemical composition | C; Ecology and river function | ERF; Waterway assessment | WA; Waterway assessment workshop | WAW
This works fine when viewed over the web for creating a new document, and when viewing a web created document in the notes client, however:
- When I edit the checkbox values in a document in the notes client, save it and go into read mode, the one checkbox that has a comma in it’s label is changed to display as two checkboxes. (as the associated text field has changed the comma to a semicolon despite its separator values not being a comma ie:
Catchments: their character; waters & chemical composition | C; …)
- When I create a new document in the client, the checkboxes display with only one ‘box’ (rather than four) and with no label. (Yet the field FRM_Courses has the expected value)
This is driving me nuts (especially as I was supposed to have this DB up yesterday!)
Does anyone have any ideas …