Forum Discussion

JessicaDarke's avatar
JessicaDarke
Qrew Trainee
8 years ago

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

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.
Ask about Quickbase functionality
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    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.
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    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?
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    That would need to be paid consulting time. Contact me via my gmail address at my website QuickBaseCoach.com for one in one assistance.