Calculation examples

[samikuivalainen]

I’d like to see some awesome examples of calculation field here community site.

Best wishes from Finland!

/Sami

[Kevin]

Progress bar calculation…

`<progress value="${@Progress/100}"/>`

[Eric]

One more - “add a week to a date field”

date_fns.addWeeks(@Created on, 1)

[Tim]

Great examples! And my big hello to Finland @samikuivalainen

Possibly helpful at this point for one or the other is our calculation introduction.
Calculation fields can range from simple additions to custom JavaScript code. Furthermore, the output rendering supports Markdown, HTML, and CSS. Check out more →

[1F2Ns]

Here is a favorite of mine for rendering headers.
(note: since we can use HTML this is less exciting)

[samikuivalainen]

Id like to use dates in calculation field, for example:

@startdate + @daystoadd = result of calculation.

what would be the best way to handle this?

[Tim]

Hi @samikuivalainen,

agree, that is indeed a common scenario. A code snipped like this turned out useful, utilizing the library date_fns to add the days to your date field value and calculate a new one:

The result inside the record will show the calculated date like this:

Hope that helps.

Cheers & happy Sunday
Tim