Skip to main content
Question

Retrieving a record using a code page...

  • Mar 31, 2025 6:27 PM UTC
  • 1 reply
  • 63 views

Forum|alt.badge.img+2

Building on the method described in the link below to post to Quickbase using an HTML form and EOTI access, is there a way to retrieve records to a similar form using an rid in a custom URL link (or any other way)? If so, how would you do it?

https://community.quickbase.com/discussions/quickbase-discussions/posting-from-an-html-form-directly-to-quickbase/90206

1 reply

Top Step
Forum|alt.badge.img+12
  • Observing
  • Nov 2, 2026 9:50 PM UTC

Yes. Pass the rid on the code page URL, then have the page call API_GetRecordInfo for that record and drop the values into your inputs.

Your link to the page would look like this:

URLRoot() & "db/" & AppID() & "?a=dbpage&pageID=5&rid=" & [Record ID#]

Then in the page, give each input an id like fid_6 that matches the field ID, and add this (swap in your table’s DBID and your app token if the app requires one):

<script>
const rid = new URLSearchParams(location.search).get('rid');
fetch('/db/TABLE_DBID?a=API_GetRecordInfo&rid=' + rid + '&apptoken=YOUR_TOKEN')
.then(r => r.text())
.then(xml => {
const doc = new DOMParser().parseFromString(xml, 'text/xml');
doc.querySelectorAll('field').forEach(f => {
const el = document.getElementById('fid_' + f.querySelector('fid').textContent);
if (el) el.value = f.querySelector('value').textContent;
});
});
</script>

To save changes back, use API_EditRecord with the same rid instead of API_AddRecord.

One caution with EOTI: if Everyone on the Internet can view that table, anyone who guesses a rid can read the record, so keep that role’s view access as narrow as you can.

https://help.quickbase.com/docs/api-getrecordinfo

Want more detail? I wrote a full walkthrough here: https://www.topstep.tech/blog/quickbase-code-page-edit-record-form