Automatically Update Existing Pages

[Adam Kurland]

Hello- I'm using the "Page Properties" and "Page Properties Report" macro summarize the status's of certain products.  The table has a separate column for each product.  But the overall list of products may expand.  Is there a macro I can use to automatically the table in each page after I've created them?  I'm using templates to create pages, but can start over.

[Tyler Brown]

Hey Adam,

What information are you looking to share about each product?

Can you share a screenshot of how our information is laid out?

Thanks,

Tyler

[Adam Kurland]

Hi- this is company internal information, but image a table where the header row has columns like "Product 1, Product 2, etc", and the second row has the RAG status.  The challenge is that may have to add products.  Does that make sense?

[Tyler Brown]

Mo worries, I was mainly curious about how you are adding the information to the pages and the structure.

Can I assume that you have a page for each RAG status and those pages have information about each of the products?

[Adam Kurland]

Sort of- there's a page for each account, and each page will have a table listing the RAG status, at that account, for each product.  But I can start from the beginning and recreate the pages

[Tyler Brown]

The best way to structure it would be to have each Product as it's own row, rather than a column.

That way when you add a new product it will have all the same information as the others and you won't have to go through an exercise to edit all of your previous pages to add in a new column to all of your existing tables.

Alternatively you could look at layering in Excerpt macros into your templates.  That way if you need to add information into your tables you can edit the Excerpt and all of your tables will be updated