This is a screenshot of what the proposal currently looks like for us:
Each of the drop down menus links over from the second sheet, this is just a small selection of those options. I know there is a drop down selection menu in Airtable that would work well for this.
The main goal is to have each of our committees submit their filled out form and compile them all into the same sheet where it will auto-total expenses for each committee and also for all proposals submitted.
So far, this is what I’ve tried. This should be the link to the base:
There are two different attempts that I’ve labled - one is just the first table, and the second attempt includes the next three tables that are all linked together.
- The first attempt seems to compile the information the way we need it, but it isn’t easy to fill out and it doesn’t print in a concise way.
- The second attempt prints in a nice way and is straightforward to fill out, but I haven’t figured out how to calculate cost per person or how to have a box pull a specific number from another table (if that’s even possible).
In each of those attempts, I’ve made notes in the places where I couldn’t figure things out by myself.
Some important things:
- It needs to be able to print to a single page. (We still print these proposals out to distribute them, which isn’t ideal but that’s something we’ve got to keep.)
- The form needs to say pretty user-friendly.
I am a super newbie to Airtable so I will do my best to follow along, but screenshots would be super helpful along with explanations. I’m completely open to any and all suggestions, even (or especially) if they scrap my previous attempts! And let me know if anything I’ve said doesn’t make sense or if I need to clarify something.