Hi there,
If you want to get the table schema including VC, what method do you use?
I have copied the header rows from View Data and then formatted them with spreadsheet functions.
It’s easy, but I can only get the Datatype and would like to know if there is a better way.
The spreadsheet function I am using is as follows.
Get Odd Rows
=FILTER(A1:A,ISODD(SEQUENCE(ROWS(A1:A))))
Get Even Numbered Rows
=FILTER(A1:A,NOT(ISODD(SEQUENCE(ROWS(A1:A)))))
Was there a metadata API or something?
I thought about scraping AppDocument, but it seemed like a lot of work, so I decided not to… AppSheet is no-code.
PS
@GreenFlux has some great tips?
[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…
