Dec 04, 2019 02:59 PM
hi, we have a department that’s been using Excel for 10+ years to manage a daily list of items, and it seems a great fit to port to airtable.
There’s a rub: the list has 5 columns, and approx 120 rows, they like having a bird’s eye view of the entire list on 1 page, so in Excel they chop the list in 2 approx halfway down, and show it as 2 side-by-side matrices, each w/ 5 colums and ~ 60 rows. Is there a built-in feature for that in airtable? I assume “not really”, since all table/view layouts I’ve seen feature a single xy grid, rather than side-by-side xy grids.
Thinking aloud here I suppose we could create a view of 10 columns, have the first 5 columns show the first half of the list, have the second 5 columns show the second half of the list, but, ugh!
I’ve looked into the airtable api, and it should be straightforward enough to create a custom webpage/dashboard formatted any way we want … but I’d rather not go that route, either
pls advise? thx!
Jan 21, 2020 08:30 AM
What I ended up doing was writing a mithril SPA fetching data from the airtable api to create a very custom dashboard (figure A). It embeds the api key in the SPA and would need to add an encryption mechanism (e.g. using public keys)
I will likely move to using a secure intermediary agent – aws-lambda/azure-function – to talk to airtable (figure B)
(apparently I can’t include images; shrug )