can we use table aliases in scripts files

Question

My application uses lots of jquery script files and the TABLE ID is hard coded everywhere.

The problem is that these IDs changes when the application is either copied or a new sandbox environment is created and the IDs have to be changed in all the scripts.

Is there a way to use the DB aliases in the script file or many be a better approach to handle this?, I tried using the DB aliases but that didn't work.

chuckgrigsby · Answer

You should be able to use _DBID_TABLENAME but I could be wrong about that. I definitely know that gDBID is global variable for the table ID your on. Hope that helps.

_anomdiebolt_ · Answer

You can't use table aliases in scripts.&nbsp;However you can determine the mapping between table aliases and dbids using the API.Call dbid?act=API_GetSchema on the application dbid and the names and dbid's of each table will be listed within the&nbsp;&lt;chdbids&gt; tag.See also:How is the name of a table alias determined ?https://community.quickbase.com/quickbase/topics/how-is-the-name-of-a-table-alias-determined

davidmaskasky · Answer

Oh I just posted on this.&nbsp; Yes you can as long as you have the app dbid.https://community.quickbase.com/quickbase/topics/using-table-aliases-in-the-urls

Forum Discussion

can we use table aliases in scripts files

3 Replies

Related Content

Filter records based on table connection

Save Table Aliases and use in formulas?

Do unused tables related to currently used tables cause functionality problems?

Summary Table

Script Error

Recent Discussions

Filter Monthly, Quarterly, Yearly from one Date field

Extrapolating nuanced data

Forms help

Share your feedback on the new Qrew Discussions

Generating QR Code with URL to record