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
manoharvankired's avatar
manoharvankired
Qrew Trainee
2 years ago

Hi Mike,

Im getting error, The Application Token dpvtvtrbuvtrjjd5ydp38bccn9np has not been assigned to this Application. To read about assigning an Application Token to your application go to https://help.quickbase.com/user-assistance/app_tokens.html

Same Api I'm using across the application but it is working fine

Thanks
Manohar



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

Manohar,

I suggest that you the the Settings for the application, and Advanced settings and then disable the need for Application Tokens.

If you're asking for help with a formula from this community it's very important to copy and paste your exact formula into the discussion so we can see exactly what you have.  



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

    Hi Mike,

    The app token is functioning correctly within the same table and another table, but I receive an error when attempting to use it with the formula below

    var text RID = If([Record ID#]>0, ToText([Record ID#]), "%%rid%%");
     
    var text EditRecord = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord"
    & "&apptoken= Apptoken" // if you have the need for Application Tokens enabled.
    & "&rid=" & ToText($RID)
    & "&_fid_10=" & Now(); // sets this field to current date time but you can set any fields you need as typical 
     
    var text DisplayRecordButMissingRID = URLRoot() & "db/" & Dbid() & "?a=dr&rid=";
     
    var text URL =
    $EditRecord
    & "&rdr=" & URLEncode($DisplayRecordButMissingRID) & $RID; // the %%RID%% does not like being URLEncoded.
     
    //below makes the button. Save before navigating and data-replaceRID=true are the important bits
     
    "<a class='SaveBeforeNavigating' data-replaceRid=true style=\"text-decoration:none; background: #1ba802; border-radius: 5px; color: #ffffff; display: inline-block; padding: 2px 2px 2px 2px; width:200px; text-align: center; text-shadow: none; border: 2px solid #1ba802; font-size: 18px \"href='"
    & $URL
    & "'>Button Words Here</a>"


    Thanks,
    Manohar



    ------------------------------
    manohar vankireddy
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      2 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
        2 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
        ------------------------------