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 2 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,310 Points 50k badge 2x thumb
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?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,310 Points 50k badge 2x thumb
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!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,310 Points 50k badge 2x thumb
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.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,310 Points 50k badge 2x thumb
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
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,310 Points 50k badge 2x thumb
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.