What is date formula? I want today's date if Text multiple choice field is "paid". I get a formula sytax error with: If( [Status:]=Paid, Today(), false)

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
Photo of Suzanne

Suzanne

  • 10 Points

Posted 3 years ago

  • 0
  • 1
Try this

If([Status:] = "Paid", Today())



BUT, I have answered the question that you have asked, but probably not what you need.  The function for Today() will always return the value of Today.  It will not stay frozen.  So that formula when the Status is Paid, will also show the current date. 
Photo of Suzanne

Suzanne

  • 10 Points
Yikes, you're right!  How do I freeze the date?
If all editing of these records are being done on a form and not in Grid edit, then you an have a Dynamic Form Rule which says

When Multiple conditions are true
When Status: equals Paid
When [Date Paid] is (blank  .. just leave blank)
Change [ date Paid] to  " the current date"  ( no quotes, it will offer up that drop down).

I would uncheck that box at the very very bottom.

If there is the possibility of Grid End (which do not support form rules), then we need to go to Plan C.
Photo of Suzanne

Suzanne

  • 10 Points
QuickBooks will sync status, but not date paid.  I think this will work.  I'm not sure if form rules is relevant.  Made the change but interface isn't complete to test yet.  Thanks!
OK, so now I am vert confused.  Are you Syncing from QuickBooks?  I was assuming that you were doing data entry on a QuickBase form.
Photo of Suzanne

Suzanne

  • 10 Points
No data entry on QuickBase form.  We are Syncing from QuickBooks.  Q2Q Connect can't pass date paid or amount paid, only status.  So I'm trying to work around it.  When QuickBooks tells QuickBase the invoice is paid, I want to know when.
This sounds like it would need to use a Webhook to fire to do this update.  Are you using the native QuickBooks to QuickBase sync setup?
Photo of Suzanne

Suzanne

  • 10 Points
VARC Solutions
So, yes you could use Webhooks for this.  

But a step by step "how to" on webhooks is beyond the scope of what I have the time to do on this forum.  it would probably take an hour to get this up and running.  Contact me directly via the information in my profile if you would like one on one assistance to set up a Webhook to do this.