Airtable’s Scripting app contains a really useful reference space at the bottom of its UI. I recommend using that for general reference on how to access tables, view, records, record data, etc.
As far as output goes, you’ll want to build an array of objects. The structure of each object should be the same in terms of the names of the properties that you add. For example, here’s a simple array of objects that stores the first and last names of people:
const example = [
{
first: "Justin",
last: "Barrett"
},
{
first: "Andrew",
last: "Davies"
}
]
To display that as a table, use the output.table() method:
output.table(example)
…which gives me this:
As you can see, property names become field headers, and each object becomes a row. Also note that rows are displayed in the order that the objects appear in the array.
I recommend figuring out the object structure first, then work on building a script to parse your data and create an appropriate array of those objects. While working on the script, I also recommend running lots of iterative tests along the way. Don’t try to build the whole script all at once. Build it in pieces, breaking down the logic into small segments, and testing each segment once it’s written to ensure that it does what you want it to do before moving on to the next segment. Feel free to ask questions here if you get stuck on something.
