This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi guys, hope you’re doing well. I’ve been sitting on this question for a week now, and haven’t found an answer when looking online. Basically, for paper document control I use a spreadsheet, however I would also like to keep track of my App Tables / links between spreadsheets and Apps as I believe it also forms an important part of document control. Is there an expression I can use to return a list of the Tables in my App and details like what is seen in the Data->Tables section?
No, there’s no expression.
However the CONTEXT() expression can return a view name. So if you use a consistent view naming convention then you can determine what table/slice you’re using…
I did check out this section earlier. Unfortunately it doesn’t suit my requirements as I wanted to return a list with custom values from the table (e.g the basic information that shows in the Data->Tables section.
I was hoping to get the data inside of my appsheet app-> Documents Control Table. I can still do it, it just has to be created manually, so first the Table Name, Source, and then the different apps that share this table name. I take all that information and place it into my existing documents table, which then allows me to use it alongside my documents for training purposes.
@Grant_Stead How would building an app to manage my apps give me a list of my tables and table attributes? Do you know of some kind of expression to get this information?
No, there’s no expression.
However the CONTEXT() expression can return a view name. So if you use a consistent view naming convention then you can determine what table/slice you’re using…
This is actually an elegant solution (CONTEXT("View) Thanks Grant. While it doesn’t return a list, it does solve another issue in appsheet which is helping to automate your folder paths (e.g when uploading images or documents from a column entry). So instead of naming your folder paths manually, you can just link them to the View Name, meaning now your files are uploaded in a more automated fashion : )
@Dario, there is a chrome add on for AppSheet released by @Stefan_Quartemont which contains the schema. It might be a good enhancement to that add on allow saving the schema in a table format like what you are looking for.
No, there isn’t a built-in expression. But here’s an Apps Script that will loop through the sheets in a workbook and list all the Tables/Columns. Assuming all your data is in one workbook, it’s effectively the same list.
LinkedIn
Twitter
