Scenario Overview
In this business scenario it was very important for the people paying Invoices to know the current week number & what the UTC date and time was before paying an Invoice.
North52 Decision Suite Solution
The North52 Decision Suite solution works like this,
- A formula is created which executes when the Invoice record is opened
- It calculates the current week number from the current date time & the UTC datetime
- It displays the information as a form notification
North52 Decision Suite Steps
- Create a new formula of type 'ClientSide - Perform Action'
- Set the Source Entity to 'Invoice'
- Set the Source Property to 'OnLoad'
- Copy & paste the formula below into the formula description field & click save
- Click 'N52 Commands' & then choose 'Publish Formula'
- You are ready to test
Formula
SetFormNotification(StringFormat('Current Week Number: {0} UTC Datetime: {1}',
GetWeek(LocalDateTime()), UtcDateTime() ) , 'INFO', 'msg1')