Skip to main content
Question

Cancel and Go Back Button

  • September 11, 2025
  • 0 replies
  • 164 views

Forum|alt.badge.img+3
  • Quickbase Alumni

Hi Everyone, I'm new to Quickbase and could use some help.

I'm building an application with two related tables:

  • Price Request (Header Table)
  • Attachments Table (Each Price Request can have multiple attachments)

I've created a form in the Price Request table with an "Add Attachment" button that routes users to the Attachment form, allowing them to upload documents. Here's the formula I'm using for that:

URLRoot() & "db/" & [_DBID_ATTACHEMENTTABLE] & "?a=API_GenAddRecordForm&_fid_7=" & URLEncode([Record ID#]) & "&z=" & Rurl()

Now, I want to add a "Cancel and Go Back" button on the Attachment form that:

  1. Deletes the current attachment record.
  2. Redirects the user back to the related Price Request record.

Here's the formula I tried:

URLRoot() & "db/" & Dbid() & "?a=API_DeleteRecord"
& "&rid=" & URLEncode([Record ID#])
& "&apptoken=APP_TOKEN"
& "&rdr=" & URLEncode(
    URLRoot() & "db/" & [_DBID_PRICEREQUESTTable] & "/form?a=dr&rid=" & [Related Price Request])

But I’m getting this error:

<qdbapi> <action>API_DeleteRecord</action> <errcode>30</errcode> <errtext>No such record</errtext> <errdetail>Missing "rid" parameter.</errdetail> </qdbapi>



In the picture below(Attachment Form) 

Field Pricing Request ID  is a lookup field from Price Request Table(Related Price Request)
Field Price Request - Status is a look up field from Price Request Table 

Forum|alt.badge.img+4
  • Quickbase Alumni
  • September 11, 2025

Record doesn't exist until you save it (and doesn't have a Record ID), so there's nothing to delete. It's counter-intuitive to how a lot of other systems works, and causes myriad problems, but that's how it works.