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.