Email Page Properties

Question

Our team here are publishing pages with a page properties macro that has the following table:

We want to send an email that uses information from within the page properties table.

I have seen mention of creating a variable with {{page.body.storage...}}

I thought this might work:
{{page.body.storage.substringBetween("CCustomer Affected","")}}

But I dont understand what it's doing and I cannot for the life of me find anything that explains it.

Is it even possible to fill an email that is sent with a confluence automation on publication of a page that contains the information that has been entered in the Page properties table?

Thanks for your help.

Tomislav Tobijas · Answer

Hi @Sonja Altmann ,

You might want to check out the following question/discussion: https://community.atlassian.com/forums/Confluence-questions/Email-recipients-based-on-Page-properties-smart-values/qaq-p/2902922

It's definitely tricky to get information from page properties macro as you'd need to parse content from the whole page body/storage and then extract only the part that is relevant to you. By using the methods described in the linked question, you could probably construct something that would cover your use case, but again, it needs a bit more experimenting to get it completely right and to cover a lot of different use cases.

Cheers,
Tobi

Marc -Devoteam- · Answer

Hi @Sonja Altmann

This previous community article should provide you with context on this and how to achieve this.

See, Confluence-automation-Send-email-with-page-content-details