Is it possible to design a line break in a column after a specific number of entries in a multiple values field?The background is: I have a tick box with up to 34 selections. Each of the entries has 2 digits.
I would like to have a column width of about 20, having a line break in case there are more than 10 entries in the multiple value field.
I’m thinking about an @if formula with @elements etc., but I have no concrete idea.
Can anyone help me?
Thank you in advance,
Leini
Subject: line break in a column
Off the top of my head; could be a simpler way – and it might not work, as I haven’t tested it – Add a computed field to the form which you display in the view column:
mag := 10;
lst := TheFieldYouWannaSplit;
@while(@elements(lst) > mag;
leftlst := @subset(lst; mag);
leftstr := @implode(leftlst; " ");
newlst := @trim(newlst) : leftstr;
lst := @subset(lst; @elements(leftlst) - @elements(lst))
);
@trim(newlst) : lst
Then set your column to display separate values with a new line.
Hope that worked…
Subject: RE: line break in a column
I’ll test it. In the meantime I did the following:in the view tab set up row height 3 and shrink to content.
That works fine but for all ‘fields’ in the view. I would prefer only to have this rule applied to 1 column. I’ll post again, whether your formula works.
Thank you!
Leini