I use "Import into table from clipboard" to paste the data into Quickbase from columns in Excel spreadsheets. I literally just copy and paste.
There are changes I have to make pretty regularly to the static tables. Not just the Shots table, there are a couple of other tables too that pull data from Shots and vice versa. It's only the data that I import directly into Shots though that I want to automate. I don't need a live feed, really all I'm trying to do is be able to import stuff into the static Shots table without having to go in and copy/paste lots of sheets every day. Dropping a single sheet into G-Drive for Quickbase to import automatically is perfect, if I can do that.
I'm interested in the Webhooks solution if that can help avoid synced data overriding modified data. Presumably without Webhooks the synced data would just keep overriding modified data which is definitely not what I want it to do.
Having said all this, I did read somewhere that connected table data can't be modified. Will that still be true if it's synced into a static table? Because I do need to be able to modify data in the Shots table.
When I have time after the weekend I'll read up on how to use Webhooks, unless you think there is an easier to implement solution? Like I said, I'm not a Quickbase noob but I also didn't build the database myself so I'm kind of reverse-engineering a lot of this. For that reason your help is really appreciated :)
