Discussions

Expand all | Collapse all

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

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

    Posted 08-09-2017 01:29
    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.


  • 2.  RE: Is there a way to write a conditional formula that runs an API Edit record without user input?

    Posted 08-09-2017 09:54
    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.


  • 3.  RE: Is there a way to write a conditional formula that runs an API Edit record without user input?

    Posted 08-09-2017 20:59
    Thanks. That is sadly unfortunate.


  • 4.  RE: Is there a way to write a conditional formula that runs an API Edit record without user input?

    Posted 08-09-2017 21:02
    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?


  • 5.  RE: Is there a way to write a conditional formula that runs an API Edit record without user input?

    Posted 08-09-2017 21:06
    Actually - yes. Yes it would! 


  • 6.  RE: Is there a way to write a conditional formula that runs an API Edit record without user input?

    Posted 08-09-2017 21:09
    That would need to be paid consulting time. Contact me via my gmail address at my website QuickBaseCoach.com for one in one assistance.