Hi,
i’m wondering how to compute a field value in a backend workflow (payment-success) that has the following formula:

EndDate = StartDate + nbCreditsx7 + 7x(number of days with date:extract day is 0 in a list of days)

Do i have to do it with Expression js in the page workflow or is it possible in backend?

Thanks

Try using Current Date/Time +Days and then using Arbitrary text to calculate the last bit (nbCredits x 7 + 7 x number of days ) and then :converted to number (on the Arbitrary text). This latter approach is a way to do calculations and then the Current Date +Days is a way to tell Bubble you want it to be today + < a number of days >

You can also nest Arbitrary text:Converted to Number if you need to.

Thank you @manipaje, using Arbitrary text wasn’t something i thought about that time. Perfect :slight_smile:

1 Like