Thank you to those who responded to my question. I checked out the solutions you suggested. Unfortunately none of them seem to do what I want.
Perhaps I wasn’t as clear as I need to be. I am not trying to sync a base with a (Google) sheet. As I said in my original post, I’m doing this simply in order to have a way to print a report. If Airtable weren’t so bad at this, I’d do it entirely in Airtable.
It looks like I’ll end up doing this by hand. These are the steps I’ll have to take:
- Go to the right view in the Airtable base and make sure that filter is showing precisely the records I need to see.
- Copy all those records.
- Switch to Google Sheets and open the template I’ve created for the report
- Go to the appropriate starting cell (might not be A1) and paste
- Print the report and confirm that it looks okay.
- Close the sheet without saving.
- Return to the base and mark those records as having been printed
The key issue seem to be, first, triggering the process, and second, copying not just a single record but the entire set of filtered records in a particular view. Most of the connection services (like Zapier) seem to use record-level triggers (e.g., record created, record modified) and then they work only on the record that triggered the zap or whatever it is. Perhaps I should investigate a macro utility. I could do step 1 above manually, and step 2 (selecting all and copying) could certainly be done by a macro utility, and so could step 3. I’m just not sure whether that’s much help.
Anyway, perhaps one day Airtable will make the page designer block work better for multipage reports. Then I will be very happy.
Thanks to all who responded!