selectRecordAsync only returns record ID and Name

[Ricardo]

Hello community, how would you go about exporting a table or even base's field names and IDs? In an ideal case, I would sync on intervals a sorted list of all fields and their properties, similar to how it's shown under manage fields. Thanks!

[kuovonne]

You can get all the fields and most of their properties from scripting. Either scripting extension (manually) or scripting automation action. You can also get much of the info using the web api. 

[Ricardo]

Thanks! On marketplace and on the board, I couldn't find a ready-made solution. Do you whether such a solution exists? 

[kuovonne · Accepted solution]

Several people have written scripts that extract field IDs. I do not know which have been published or which match your use case. 

I wrote the "Field List" extension which extracts field IDs and additional info. On2Air Schemas extension provides even more info. Both extensions have different workflows and features. There is also a metadata script published by Airtable, but I have not used it and this cannot comment on it. 

[Sara_Tamez1]

THIS DESERVES SO MANY MORE KUDOS, thank you!!!!! 🙌