Views:

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.

N52 Formula Manager Solution

The Formula Manager 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

N52 Formula Manager 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')