How to display the table name from dbid

  • 0
  • 2
  • Question
  • Updated 6 months ago
  • In Progress
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?
Photo of Jim Harrison

Jim Harrison

  • 1,926 Points 1k badge 2x thumb

Posted 6 months ago

  • 0
  • 2
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 11,556 Points 10k badge 2x thumb
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. 
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,064 Points 20k badge 2x thumb
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.
(Edited)