Listing column names and data types

[takuya_miyai]

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

[Steve]

Via AppSheet Toolbox:

See also:

FREE Chrome Extension that enhances the Expression Assistant [AppSheet Toolbox/QREW Tools] Tips & Tricks 💡

Hi AppSheet Community As someone who is in the App Editor 24/7, I frequently catch myself trying to remember the syntax for a particular expression, re-reading a formula several times to figure out where my missing parentheses are, or searching my mind for some fancy formula I put together ages ago. I know many of you have experienced the same. To make life a little easier on our favorite app making platform, the QREW Technologies team has released the first version of a Chrome Extension, QR…