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__You3 months ago
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()
- JeffHughes3 months agoQrew Trainee
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__You3 months ago
Qrew Legend
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]
- JeffHughes3 months agoQrew Trainee
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__You3 months ago
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?
- JeffHughes3 months agoQrew Trainee
I need it to tell me the DBID of another table, well rather 10+ different tables.