Returning a list of Table Names & Details in your Appsheet App

AppSheet AppSheet Q&A
,
1

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?

Many Thanks,
Dario

2

Hi @Dario!

I think this is related to your question too:

[Where can I check the current size of my app](https://community.appsheet.com/t/where-can-i-check-the-current-size-of-my-app/21563/2) Questions

Hi! Your question made me wonder about size limits. I found the following: AppSheet does not enforce a limit on the number of tables per application. Complex apps can have 20 to 30 tables and 20 to 30 views. According to this, I have an app with way too many views: [Screen Shot 2020-03-25 at 22.12.08] But I haven’t noticed a serious problem. My app works quite well. Many of my views are detail views that display some kind of warning or confirmation message in a special circumstance. T…

1 Like
3

Dario:

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?

Nope.

4

Ok, I was hoping there was something. Looks like I’ll have to do it manually for the time being. Thanks for getting back to me guys.

1 Like
5

@Dario Have you checked the option Info > Properties > App Documentation > The documentation page for this app is available ‘here’ ?

2 Likes
6

That was my thought. Instead of putting it in a link, I should have just said that.

7

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.

1 Like
8

I see. If no one has done so yet, you might want to write a feature request:

https://community.appsheet.com/c/requests/18?order=votes

9

Dario, maintain it yourself. Build an app to manage your apps. Include the editor link. Etc. Then you can do all sorts of fun stuff

10

One can also make a copy of the Gsheet, retain the header data and add rows to keep track of attributes, formulas, etc.

11

@Dario,
Just curious, what format do you want this data in?

12

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?

13

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…

2 Likes
14

@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.

15

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 : )

16

Dario:

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 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.

[Auto-Fill a Sheet with All Table/Column Names from Your App](https://community.appsheet.com/t/auto-fill-a-sheet-with-all-table-column-names-from-your-app/29169) Tips & Tricks ?

Have you ever wanted a list of all Tables and Column Names in your app, displayed IN your app (not just in the editor)? [Screen Shot 2020-08-11 at 7.46.38 AM] This can be useful for feeding dropdowns in other tables, especially when using another table to control security, user-permissions, etc. This method uses Google Apps Script to write a custom function that can be used as a sheet formula. [2020-08-11 07.31.28] Just open the script editor, and paste in the following code: [Screen Shot 20…

2 Likes