Getting the DBID from an Alias
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 ...
Forum Discussion
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
This is what I need, but I want to be able to pass the alias into it rather than it telling me the current DBID.
- MarkShnier__You
Qrew Legend
... but if you copy the app and hence copy the Juiced URL button then the button will still be correct, right? It will refer to dbid() which will be the new table, right?
I need it to tell me the DBID of another table, well rather 10+ different tables.
- MarkShnier__You
Assuming that there are no Cross App relationships involved you should never ever hard code the Table ID. That is why you go to the Advanced Properties of each of your 10 tables and get the table alias, like in my example above.
