Skip to main content
Solved

Exporting field names and IDs

  • December 23, 2022
  • 4 replies
  • 453 views

Ricardo11
Forum|alt.badge.img+16

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!

Best answer by kuovonne

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. 

4 replies

kuovonne
Forum|alt.badge.img+29
  • Brainy
  • 6009 replies
  • December 23, 2022

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. 


Ricardo11
Forum|alt.badge.img+16
  • Author
  • Inspiring
  • 50 replies
  • December 23, 2022

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? 


kuovonne
Forum|alt.badge.img+29
  • Brainy
  • 6009 replies
  • Answer
  • December 23, 2022

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. 


Forum|alt.badge.img+4
  • New Participant
  • 4 replies
  • January 4, 2025

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!!!!! 🙌