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?
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?
 1,926 Points
Posted 6 months ago
Evan Martinez, Community Manager
 11,556 Points
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 nonnative solution but using the native formulas there isn't one at this time.
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 nonnative solution but using the native formulas there isn't one at this time.
Ⲇanom the ultimate (Dan Diebolt), Champion
 30,064 Points
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";The formula will appear in a <textarea> that is spliced into the top of the page where you can copy the formula definition.
$.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);
});
(Edited)
Related Categories

Search
 222 Conversations
 4 Followers

Tables & fields
 7229 Conversations
 182 Followers

Tips & tricks
 366 Conversations
 31 Followers