Special fields to a template or page in Confluence - how to?

[Rumceisz]

Hi,

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?

Thanks,
Rumi

[Earl McCutcheon]

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.

Exe:
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
Select table
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:
https://answers.atlassian.com/questions/3562/conditional-formatting-in-confluence
https://answers.atlassian.com/questions/103734/conditional-formatting-for-table-cells-in-wiki-markup-or-other-method

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.