This used to work ok in r6.5.3, but since we upgraded to 7.0.3 it no longer does.
I have a CRM database which has a view of people, categorised by company id, where column2 shows department name. This allows me to do a lookup from within a new person document and return a list of all departments for other people in that particular company and lets me select one of them for the new person.
The problem starts when editing a person after the first save.
When a user clicks the dropdown button to look at the list of departments available the current value held by the field is split (using space as a separator) with the last word of the department being selected by the highlighter bar.
e.g. Say I have several people spread over 2 departments. “Department of Physics” and “Department of Mathematics”.
When editing someone the dropdown shows:
"Department of Physics
Department of Mathematics
Department
of
Physics"
The last word, “Physics”, is highlighted, and if I press OK that is what is put in the field.
The Department field is not multivalue, and the original formula for it was:
T := @DbLookup(“”:“NoCache”; “”; “PersonDepartment”; IDOrg; 2);
@If(@IsError(T) | T = “”; “”; “-select or add value-” : @Unique(T))
(I only added NoCache for testing. Normally the result would be cached.)
Column 2 of the IDOrg view has been set to various values of ‘multivalue separator’ (space, none, semicolon etc.) but makes no difference, since each Person’s department is a single value, not a multi one.
I’ve tried putting the formula in a multivalue computed for display field on the form - dLookupDept - and the results of the lookup are formatted correctly - i.e. the duplicated values are removed and the list contains no blanks, only shows the correct department names and the separator is shown correctly as semicolon, but when I try to select them using the editable field I still get the current department name split using space as the separator.
Is this a known bug?