4 answers
1 accepted
Hi @Rumceisz
Thank you for sharing your use case!
Ig you're open to third party apps, I can recommend you Elements Spreadsheet, which I think will cover your need through the Project Tables macro. It looks exactly like a Confluence table, it is very user-friendly and requires no learning curve.
Let's consider the following use case:
- I have 2 columns in my table, one for tracking the allocated budget, another for tracking the actual cost
- Now, I want to track the remaining budget status (Under the line/Budget met) for each row based on the following calculation: Allocated budget - Actual Cost. I can capture that information by configuring a calculation-type column:
Here is a sneak peak of the Remaining budget column formula. You can adapt the formula to anything that you'd like. You can use specific thresholds if that works best for you, e.g. IF({Allocated budget} > 30.000, "pass condition", "fail condition").
- Now if you'd like to apply a specific color code for each of these status values (Under the line/Budget met), you can use the conditional coloring feature:
And that's it.
I hope this helps! Feel free to reach out if you need further assistance!
PS: I am the Product Manager of the app
Hi guys,
The Table Filter, Charts & Spreadsheets app (that is our add-on) has been already mentioned in this thread regarding native Confluence tables: the Table Transformer macro allows you to set colorful statuses based on different conditions.
But if you prefer an Excel-like functionality, you may also use the Table Spreadsheet macro that is also provided by the app. With the help of this macro, you’ll be able to set statuses automatically using cell formulas and apply familiar Excel-like conditional formatting via a user-friendly UI.
Please book a live demo from our team – we’ll be happy to arrange it and discuss your cases.
The above code is a start for a user macro. You have to create the user macro in Confluence Admin -> User Macro. Also, the cloud offering of Confluence does not support user macros. So, you need to have server or data center. Once you create the user macro you can put it on a page just like any other macro. It will show up in the macro browser. Here is an example of the above code edited to look at the contents of a table. It will scan all the table cells and if it finds any that have the word fail in them then the status macro will be turned red. Otherwise it will be green.
## Developed by: Davin Studer
## Date created: 07/08/2014
## @noparams
#set( $id = $action.dateFormatter.calendar.timeInMillis )
<div id="table$id">
$body
<p>
<ac:structured-macro ac:name="status">
<ac:parameter ac:name="colour">Grey</ac:parameter>
<ac:parameter ac:name="title">Grey</ac:parameter>
</ac:structured-macro>
</p>
</div>
<script type="text/javascript">
AJS.toInit(function(){
var results = 0;
AJS.$('#table$id td').each(function(){
if(AJS.$(this).text().toLowerCase() == "fail") {
results = 1;
return false;
}
});
switch (results) {
case 0:
AJS.$('#table$id span.status-macro.aui-lozenge').addClass('aui-lozenge-success'); //Green
AJS.$('#table$id span.status-macro.aui-lozenge').text('Green Text');
break;
case 1:
AJS.$('#table$id span.status-macro.aui-lozenge').addClass('aui-lozenge-error'); //Red
AJS.$('#table$id span.status-macro.aui-lozenge').text('Red Text');
break;
}
});
/script>This is what the page looks like in edit mode.
This is what it looks like when the page is viewed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.