List results in Line Breaks and not Comma Separated

App Development
1

Greetings Tada Folks-

Does anyone have a work around for what appears to be a bug for a Details Component > 1:Many connected value to show a result with comma separations. Currently, even with the “Comma” selected the result is a line break display.

2023-01-19_15-35-10
2023-01-19_15-35-101190×780 85.3 KB

Thanks,
Adam

2

Hi Adam, @SafetyUniversity

You can make a rollup field and then concatenate.
I did this for roles of a user.

image
image1110×593 19 KB

Not sure this translates to your case, but it might give some pointers…

3

Thanks @Peter for the idea. Unfortunately a rollup won’t work since the field is in the same table and you can use a rollup to concat another field in said table.

Cheers mate,
Adam

5

Greetings all-

I was able to synthesize a javascript posting (Display Addresses in a Single Line in Table Components)

Works like a charm.

TB.render('component_XX', function(data) {
    var linebreaks = $(".breaks"), x;
    for(x of linebreaks){
        y = x.innerHTML;
        x.innerHTML = y.replace(/<br>/g, ", ");
    }
});

Replace the component number with your own specific one and use “breaks” in the CSS class (or change it to something more suiting for your needs).

Hope this helps,
Adam

1 Like