we are just working on creating a template which serves reporting goals for project leads. There is a table in the page with several fields to fill. Some fields should be a date picker called "Planned prtoject start", the next field will be "Duration" where you add the duration of the project in months. Is it possible to get automatically the Project end date in a 3rd field. And is there a macro which get a date picker as in JIRA?
In another field the users need to add a number which shows the quality of a project (0-5 scale). It would awesome if there would be another field which change its background colour according to the scale. E.g. if the project health is 1 then the background colour will be red, if the project health is 5 then colour will be green. It's a conditonal formatting I guess. Is it psosible somehow?
I believe what you are trying to accomplish can be done using the JIRA Issues Macro ( https://confluence.atlassian.com/display/DOC/JIRA+Issues+Macro). You can set the entire table from the Jira Issue Macro, or select to use a single table from an issue into the new table you are setting up.
Insert Jira issue macro to your table
Set JQL Query to locate desired issue / project ( Project = "Demonstration Project" And Key = DEMO-7 )
Under Display Options
Maximum issues 1
Columns to display remove all except the Due Date for desired "Project end date”
As for conditional formatting I have located a few other answers posts addressing this:
Otherwise you will have to look int third party plugins, I have located a plugin that looks like it has what you are looking for in this regard as well as the desired formatting you are looking for from above. Check out Advanced Tables For Conflunece plugin, as well as searching the marketplace for any other plugin that will do the trick for you.
Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time! We're looking for people to participate in a remote 1-hr workshop...
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
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs