Column in Table block to display combined values of multiple columns or other Collection

English Forum Questions
1

Hi all,

Thanks for any help in advance.

Is there any way I can add Table block column just for displaying purpose having combination of multiple fields’ values, or even from other Collection’s field values?
e.g.
Fields in CollectionA: col01, col02, col03
Expected columns in Table block:
Column1: col01 Column2: col02 + ’ ’ + col3

Fields in CollectionA: col01, colX
Fields in CollectionB: colX, col02, col03
Expected columns in Table block:
Column1: CollectionA.col01 Column2: CollectionB.col02 + ’ ’ + CollectionB.col03

Thanks!

Regards,
Simon.

2

Redundant fields need to be created to store these values for shared display.

3

Dear Support,

Do you mean adding these redundant fields in the same Collection?

I tried creating Formula Field, manage to setup the field and having the correct text data stored in the database table; but on Table block’s column display, it does not display the value correctly, the column seems to display it as a number even though the Formula Field’s Storage type is String.

Thanks.

Regards,
Simon.

4

Please reproduce your issue in this minimal environment: https://a_f3mpqavsiht.v7.demo.nocobase.com/admin/ttae4sfeiq0

5

image
image1913×906 96.8 KB

image
image1918×496 49.7 KB

The above are the screenshots of my testing at the shared demo website, it works correctly.
On my environment, it works correctly as well now.
Maybe it was due to some cache not cleared after I changed the field’s settings, especially the Expression value. Last night, we did restart our nocobase server, believe now it is a fresh settings of the field.

Thank you very much for your help.

Regards,
Simon.