I have a page in Confluence, which contains a table. One of the columns in the table has email addresses. This table content I export to CSV file using Export macro. Then I usually copy all the email addresses from this CSV file column to Outlook and then (Ctrl+K) will list all the email addresses.
The problem here is that my users, who update the Confluence page columns do not add a semicolon (;) after each email address. Which causes issues when I export the table to CSV then copy and paste the email addresses to Outlook (To or Cc field). Then I have to manually sort out the missing semicolons. The list of email addressses is huge (~100s) and fixing the list in Outlook is difficult.
I want to know if there is any control which I could add to the Confluence page, to the column in table containing email addresses. Which could ensure that whenever any of my users (suppose) adds an email address and tries to 'Save' the page but has forgot to add a semicolon after the email address he\she added. The page will not save and prompt him\her to add a semicolon.
I can suggest you a quite complex solution using Table Filter and Charts add-on:
So with this solution you don't care is somebody forgot to type a semicolon in a table, you'll get the correct list of emails.
If you find this solution suitable, please, contact StitlSoft support to get details on this.
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG