Just to add a few tools that I’ve found very helpful in keeping my sanity (or at least some of it).
- The Base Schema extension which presents a graphical view of you tables and links (still free).
- The airtable api documentation which gets created for each base via (Airtable Web API). Even if your not looking to code it’s very useful.
Other than that I agree that interfaces can be very useful in creating a more friendly and contolled environment (as Russell and Scott mention), and you can get helpful assistance from the contributors here and on the regular community site.