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!
Solved
Exporting field names and IDs
+14Best answer by kuovonne
Ricardo11 wrote:
Thanks! On marketplace and on the board, I couldn't find a ready-made solution. Do you whether such a solution exists?
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.
+27You 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.
1 person likes this
+14kuovonne wrote:
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.
Thanks! On marketplace and on the board, I couldn't find a ready-made solution. Do you whether such a solution exists?
+27Ricardo11 wrote:
Thanks! On marketplace and on the board, I couldn't find a ready-made solution. Do you whether such a solution exists?
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.
+4kuovonne wrote:
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.
THIS DESERVES SO MANY MORE KUDOS, thank you!!!!! 🙌
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.