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
- MarkShnier__You
Qrew Legend
The alias for the table name is shown in Advanced table properties. So if the Juiced formula needs the table ID of another table different from the one that the button is on, then you refer to the table as like
[_DBID_CUSTOMERS]
or dbid() for short if the table is the one where the URL formula button is button is.
If you need to reference the APP id then that is AppID()
Correct. But I want to build a field in Document Templates called "Table Alias" and then formula called "DBID lookup" so I can put [_DBID_CUSTOMERS] into the Table Alias in Document Templates and then a lookup field that tells me what dbid that alias is representing. So I can then quickly grid edit all of my document templates.
- MarkShnier__You
Maybe I'm not understanding your use case. If you really need to have a variable that will work in all tables, then the seldom discussed but very useful feature is called Application Variables. You access that in settings for the Application.
For example, you might set an application variable called User Token and then put a value in that setting. Then anywhere in the app you can refer to the pseudo field like [User Token]
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
... 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.
