Skip to main content
Question

How to display the table name from dbid

  • Nov 8, 2018 10:47 PM UTC
  • 0 replies
  • 125 views

JimHarrison
Forum|alt.badge.img+19
This may be obvious but I am not finding a solution anywhere.
I have a field where the dbid is input as text. I want to use a formula field to convert the dbid to the table name. Is this possible?
This topic has been closed for replies.

Forum|alt.badge.img+17
  • Quickbase Staff
  • Nov 9, 2018 12:10 AM UTC
Hi Jim,

I can confirm unfortunately there isn't currently a pre existing formula function to convert a DBID into the corresponding table name. It is possible someone may have a non-native solution but using the native formulas there isn't one at this time. 

  • Qrew Corporal
  • Nov 13, 2018 2:04 AM UTC
Here is a novel solution. Paste this code into the console and it will generate a Case() formula that will lookup the dbname from the dbid:
var formula = "Case([dbid],\n";
$.get("main?act=API_GrantedDBs")
  .then(function(xml) {
    $("dbinfo", xml).each(function() {
      formula += '  "${$("dbid", this).text()}", "${$("dbname", this).text()}",\n';
    });
    formula += '  ""\n)';
    $("body").prepend("<textarea id=mytextarea>");
    $("#mytextarea").val(formula);
  });
The formula will appear in a <textarea> that is spliced into the top of the page where you can copy the formula definition.