Skip to main content
Question

Getting the DBID from an Alias

  • February 5, 2025
  • 0 replies
  • 194 views

Forum|alt.badge.img+4

I want to be able to put a text field into a cell and it be the table alias, then another formula field that converts it to the DBID.

Reason being when we copy an app, the tables stay the same, but the DBIDs all update and we have to go manually change all the juiced URLs.

Forum|alt.badge.img+4

Have you tried using the DBID() formula in a Formula Text field?

https://login.quickbase.com/nav/app/9kaw8phg/table/6ewwzuuj/action/dr?rid=137&rl=8g


MarkShnierYou
Forum|alt.badge.img+24

For the Document Templates take you can change the fields which hold the table IDs and the App IDs to be formula fields.  That will break the Juiced configurator tool as it won't be able to write to them, but for the parent template table, Its really just a list of fields which you cab maintain manually.

But the syntax for the settings field for the Subtables would be horrible to do manually, virtually impossible.  I think you would need to ask Juiced for a suggestion.