asked on May 15 Show version history

We are self hosted on v11 and I am newer to LF. We have a New Event Request Form currently in a Google form that users complete and the answers go to a shared Google Sheet as responses come in. The responses are then separated out to tabs by department for actions and tracking with a formula. Examples of additional columns that are manipulated as new data is created by the form: When the event is entered into our registration program, it generates a number which is added to a column. There is a dropdown for the status of the event to quickly see which events are active, cancelled, completed, etc.  There is a place to put a PO Invoice date when that is generated. There is a checkbox for when attendance was completed. 

I know that I could create these tasks in the process diagram, but the user wouldn't be able to have the view of everything at once and manipulate it easily. I am attaching an image of a cleaned up version of the form. The blue is manipulated by the person, the information in the purple columns comes from the form.  There are lots of questions on the form.  

I have already created the form for the event information, but want to know best practices users might benefit from when tracking the other components throughout the lifecycle of an event.

Google form example.png
0 0