AnsweredAssumed Answered

Help modifying calculation

Question asked by karen_joy on Nov 2, 2016
Latest reply on Nov 2, 2016 by keywords

Hello All,

 

I Am using the Invoice starter solution and modifying it to suit my needs, In the Invoice Table, I want to add "Received all Items & the Current Date" and Forwarded to Accounting & Current Date" to the Info Field.

 

 

 

1.  Payment Info Popover

 

Case      (             

 

IsEmpty ( Method ) ; "Set Payment Status" ;

Method = "Forwarded to Accounting" ; Method & ¶ & Get( CurrentDate) ;

Method = "All items received" ; Method & ¶ & Get( CurrentDate);

 

$$PLATFORM = "Desktop" ; TextStyleAdd ( Status & "     " & Date Payment ; Bold )  & ¶ & TextSize ( Method ; 12 ) ;           

 

Status & "            " & Date Payment & ¶ & TextSize ( "       " & Method ; 16 )

 

)             

 

 

2. Info Field with the following Calculation

 

 

Status & " " &

Case (

  not IsEmpty ( Date Payment ) and Date Payment = Get ( CurrentDate ) - 1 ; "Yesterday" ;

  not IsEmpty ( Date Payment ) and Date Payment = Get ( CurrentDate ) ; "Today" ;

  not IsEmpty ( Date Payment ) ; "on " & Date Payment ;

  Unpaid Info

  )

 

My Problem is How can I put to my  "Forwarded to Accounting" or "All items Received" into Info field, when I choose them from my Payment info Popover.

 

Please see attached file that I'm working.

 

Thank you so much.

 

KJ

Attachments

Outcomes