Hi @tom_and,
Answering directly to your questions:
- Retool recenty launched Retool University but going through the modules they explain how to set up your queries and so on. They don't go into detail on how to create a spreadsheet-like interface. I haven't seen anything very detailed on this.
- I think you could layout the functionalities that you want to achieve in a post (before starting to build) and the forum members will be able to guide you on the best approaches to take.
With regards to building a spread-sheet like interface. There are many rabbit holes you could go into (see recent example here regarding "undoing" things), but it all boils down into what are the "non-negotiable" functionalities you want to achieve, and those you could change to a more "Retool approach". I understand the need of replicating what a business already has in a spreadsheet, but sometimes I've seen that when I present my clients other options that make the work more consistent, they understand it and accept the change.
I hope this helps as initial input!