Can we get a list of field definitions of a table?

[Y_K]

I can get a list of field names by downloading the CSV and look at the header line. But is there a way to get a list of field definitions (field type, formula details?)

[Chester_McLaugh]

This is the best I’ve been able to muster:

Metadata API for schema and mutating tables API

I found a half-way solution that will help in some use-cases while waiting for the metadata API. Visit https://airtable.com/api and select a base. Then open your browsers console (Developer Tools) and run the following (I tried simply running JSON.stringify(window.application), however there are circular references so I had to manually reconstruct the properties I wanted). var myapp = { id:window.application.id, name:window.application.name, tables:[] }; for (let table of window.applicatio…

[Hellene_Gronda]

Echoing this feature request for a way to export the list of fields and their field types, including formula or other specifications. Really helpful for generating a data dictionary and user guide.

[R_Felciano_QIAG]

We would love to see this as well

[Melissa_Frank1]

Yes, please!! We need to share a data dictionary with folks not using the bases, and keeping them updated has been very difficult and messy. If we could simply export that from Airtable, that would ensure all revisions are captured.

[Ryan1]

+1 We would benefit from being able to extract the metadata about our bases so we can annotate it.

[Brilliant_Admin]

Any word from Airtable on this? Field definitions are SUPER critical. I can get it via code for now but this (and re-ordering) fields should be pretty basic.

[Facundo_Sanchez]

Yes please. Very needed

[aaron_altamura]

+1 Incredible this isn’t available. In order to fine, having to manually edit the names to include field types and then run regex :frowning:

[itoldusoandso]

It’s going to be 3 years soon and still nothing. Looks like not a priority for Airtable. I understand they want to keep users in the system …but there are plenty of other reasons I should be able to export list of fields… e.g. training of other users or perhaps simply design of the base. Being able to see all fields and reorganize them perhaps on paper would be rather useful than tossing the fields around by dragging and dropping them in the drop down interface of hidden field which can get sluggish on slower machines and internet connections.

Post-edit:
Another reason we need export fields + formulas is to look for formulas that are broken. Example: I frequently use SWITCH or IF functions where the formula tests if a field value equals “something”. However, I often change the content of that field, so the formula no longer works e.g. the value is going to be “somebody”. Now the IF and SWITCH formulas testing a field against this value no longer work. The issue is when the condition is tested in more than one formula. If there several formulas on different places, they are all broken without even knowing it.

If I was able to export the formulas, I would be able to quickly find all formulas in table and the entire base and fix them. I know Base Schema app is there but it can be a hairball.

[Sembra_Media]

Yep, here also. It would be great to export the list of fields and their field types, including formula or other specifications. Really helpful for team training!