May 19, 2021 10:25 PM
Is it possible to get visible fields for a chosen table and view? I checked the Airtable scripting documentation and I cannot find the property to check if a field is visible for that view
Solved! Go to Solution.
May 27, 2021 09:08 AM
Hi @Carmel94 - you can get information about the fields in a table, but not from a view. The fields from the table will be all fields.
for (let field of base.getTable("Table").fields) {
output.text(`Field "${field.name}" (${field.type}) options:`);
output.inspect(field.options);
}
=======================
Want to learn Airtable Scripting? 1 day bootcamp coming soon!
=======================
May 27, 2021 09:08 AM
Hi @Carmel94 - you can get information about the fields in a table, but not from a view. The fields from the table will be all fields.
for (let field of base.getTable("Table").fields) {
output.text(`Field "${field.name}" (${field.type}) options:`);
output.inspect(field.options);
}
=======================
Want to learn Airtable Scripting? 1 day bootcamp coming soon!
=======================
Jun 06, 2021 03:23 PM
Check out the Airtable API documentation, you should be able to improvise a fetch request that will retrieve the data you need. Filtering views is a typical use case for the API. As to why this kind of behavior isn’t more readily available from within the Scripting app, :man_shrugging: