Forum Discussion

manoharvankired's avatar
manoharvankired
Qrew Trainee
3 years ago

I am receiving an error when attempting to use a formula without saving the record in the 'In Progress' table (B). However, once I save the record in the 'In Progress' table (B), the same formula works fine.

I have two tables. I added a new record to the 'New Request' table (A) using the Quickbase auto-generate API button, and then attempted to add the same record to the 'In Progress' table (B) by clicki...
APIs and custom code
Errors
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago

Please post your actual code. Which is not working. Perhaps you have a space in front of the application token string. 



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
manoharvankired's avatar
manoharvankired
Qrew Trainee
3 years ago

Hi Mark,

I'm Using below code 

If(IsNull([Start Date Time]),URLRoot() & "db/" & [_DBID_SITES_PIPELINE] & "?act=API_EditRecord&apptoken=apptoken&rid=" & [Record ID#] & "&_fid_10=" & Now() & "&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_SITES_PIPELINE] & "?act=dr&rid=" & [Record ID#]) )

Thanks,
Manohar



------------------------------
manohar vankireddy
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago

    Is that your actual code or have you supplied a valid application token?



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • manoharvankired's avatar
      manoharvankired
      Qrew Trainee
      3 years ago

      Yes Mark,

      After saving record, it is working fine with valid token

      Thanks,
      Manohar



      ------------------------------
      manohar vankireddy
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        3 years ago

        So is everything ok now? I don't understand if you have a question. 



        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------