I am trying to build a base for a nonprofit that will have several tables; these tables need to have forms associated, and also link information from each other.
What I want is for the first form used creates the new “event” this form gathers several things; name. priority, volunteers, time requested, and similar. I already have this set up by importing an existing csv, One of the columns has a status level to indicate priority, I was able to set up a view to show only active events. I also was quickly able to add a volunteers table by linking it from the existing data which give a list of events they participated in.
Now comes my problem; I want to be able and have a second form that users can provide summary updates of progress. These have several different types; morning, end-of-day, status change, etc. These all will likely include other volunteers, not in the initial report. I cannot seem to figure a way to add a dropdown selection on the form that is created from the active events, or a drop down of the volunteers. The goal is to help with quickly being able to post these updates and have them update the status table with priority changes, and who is working on it.
Any thoughts? Maybe I need a formula? Do I need some other reference tables? Whats my best approach?