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

=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?:thinking:
I thought about scraping AppDocument, but it seemed like a lot of work, so I decided not to… AppSheet is no-code.:innocent:

PS

@GreenFlux has some great tips🤗

4 Likes

Via AppSheet Toolbox:

See also:

4 Likes