How to populate table with strings from another table?

Schiffman, Aram

I have a table with many rows. A certain column (say, column 3) will be populated with strings. There will only be a certain number of distinct strings -- for the sake of numbers, let's say 7 -- so lots of repeats. I want a reference table with a column containing those 7 strings, which is easy enough. And I want something in my main table, a macro maybe, that lets me populate each cell in column 3 with a string from the reference table. (Obviously, I need to tell it which string for each cell.) If I need to update any string, I'd only have to edit it in reference table. All other instances in main table would auto-update on publication.

How can I do this? Not a link. I want ref strings to appear directly in main table, col 3. Technically Quote macro works, but it's ugly. I've scoured Confluence documentation, but found nothing.

Thanks in advance.

Aram

Stiltsoft support

Hi @Schiffman, Aram ,

If you are open to 3rd party apps, we can suggest trying our Table Filter, Charts & Spreadsheets for Confluence add-on.

Your case looks like the one about conditional formatting: when you set specific strings or statuses based on some conditions.

So, if you prefer to work with manually created Confluence tables, you may use the Table Transformer macro. Here is a similar example.

If you are used to Excel-like sheets, you may try the Table Spreadsheet macro.

If you are not familiar with the app and got stuck, please refer to our support portal directly. You'll share your source table and we'll guide you through.