How do I create a custom macro

Zavery Jones

I don't think I have much access to Confluence other than editing pages. I have a table that has a bunch of dates listed in it. The dates represent when our SSL certficates, for various websites, expire. I would like to have something that highlights dates (in the table) that are close to the current date.

Would this need to be a macro or something else? If it's a macro then how do I go about adding a custom macro and what kind of access do I need in order to do this?

Stephen Deutsch

Hi Zavery,

You would probably need to be a Confluence administrator to create any sort of customizations as far as that is concerned (unless your administrator has activated the HTML macro). Here's some options:

1. Just doing Javascript? You could insert it into the Custom HTML in the General Settings.
2. You could activate Javascript for a single page by using the HTML macro and inserting the script inside it.
3. You could create a user macro that has code inside it (allows both Apache Velocity code and HTML/Javascript).

Here is some sample Javascript code that probably would do what you want. This code highlights dates that are within 3 days of today in yellow and days that are past the current date in red (you can change the number of days by changing the number 3 below):

<script>
var limitDate = new Date();
limitDate.setDate(limitDate.getDate() + 3);
jQuery("time.date-upcoming").each(function() {
 var timedate = new Date(jQuery(this).attr("datetime"));
 if (timedate < limitDate) {
 jQuery(this).attr("style", "border:1px solid #ffab00;");
 }
});
jQuery("time.date-past").attr("style", "border:1px solid #ff5630;");
</script>

If you're going to insert it as a user macro, then you'll need to include the following line at the top:

## @noparams