Is there a way to write a conditional formula that runs an API Edit record without user input?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
Basically - I want to be able to trigger an checkbox on a condition without any of my users having to edit the record manually.

The check box then being seen as an API Edit record triggers an email response.

ie:
IF(
[1st Notification Date]=False AND [Notification Date]=Today()
URLRoot()
& "db/" 
& "dbid"
& "?act=API_EditRecord&apptoken=xxxxxxxx &key="
&[Key Field Name] 
& "&_fid_xx=" & URLEncode ("1")


WebHooks and QuickBase actions need an Add or Edit record to trigger so I didn't think they would work for me in this instance.
Photo of JessicaD_QB

JessicaD_QB

  • 60 Points
  • unsure

Posted 1 year ago

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

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
There is not a native way to trigger a Notification to non users based on the passage of time.

One alternative is to have a Subscription report go to a User who would push a button to fire the Notifications.
Photo of JessicaD_QB

JessicaD_QB

  • 60 Points
Thanks. That is sadly unfortunate.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
There is a set up that I can do where your internal user would push one button and it would launch a script to fire off all the notifications that need to be fired off that day.. Would that be helpful?
Photo of JessicaD_QB

JessicaD_QB

  • 60 Points
Actually - yes. Yes it would! 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
That would need to be paid consulting time. Contact me via my gmail address at my website QuickBaseCoach.com for one in one assistance.