Multiple filelds in one column
Hi!
Hi! I have a form in which I have the following fields...
Approver1, Approver 2... Approver8.
DateApproved1, DateApproved2,? DateApproved8
Remarks1, Remarks2 ? Remarks8
I would like to display these 8 fields as a different row under the each column titled APPROVER, DATE, REMARKS in a view.
I don't know how to bring in the corresponding columns that go along with the corresponding level number.
Would appreciate it if someone can help me out on this asap as I need to solve it urgently.
Thanks so much in advance?
Software/Hardware used:
Software/Hardware used:
ASKED:
December 4, 2006 1:03 AM
UPDATED:
December 4, 2006 9:33 AM
Answer Wiki:
Just set the value for your Approver column to be:
Approver1:Approver2:...Approver7:Approver8
Use similar entries for the other columns, e.g.:
DateApproved1:DateApproved2:...DateApproved7:DateApproved8
for the Date Approved column.
To see all answers submitted to the Answer Wiki: View Answer History.
The reply from user 017468 is the first step in configuring a view to show multiple values on separate lines. You also have to
– change the Column properties Multi Value Separator to “New Line”
– change the View properties Style tab setting under Rows – Height to “8.”
– Usually have to then choose “Shrink Rows to content.”
– Finally, use @left on any list that can have elements that get too long (e.g. “remarks”) to reduce it to a valid length so your view’s rows stay single-line — the view will not keep values together across columns if one column wraps a value to an additional line.
If any list does not format to multi-line, try using a variable. Sometimes it seems like that is necessary. For instance:
varList := Approver1 : Approver2 : Approver 3;
varList
This assumes you are trying to get a view like this
Approver Date Remarks
Joe Blow 11/2/2006 This is great work
Jane Doe 11/3/2006 This looks good.
Mike Dink 12/4/2006 It’s passable, I appro
and so on.