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

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
3 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
    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
        ------------------------------