Listing column names and data types

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


Get Even Numbered Rows


Was there a metadata API or something?:thinking:
I thought about scraping AppDocument, but it seemed like a lot of work, so I decided not to… AppSheet is no-code.:innocent:


@GreenFlux has some great tips🤗


Via AppSheet Toolbox:

See also: