Multi Step Form Usage

john.lamirande

I have established workflows that requires input from a large number of sources (over 150 people who don't need access to the base sheet) in two or three steps. For security reasons, I want the secondary data to come in through Forms and not by Update Request (which requires that I set the security permissions up to allow anyone access). As a temporary solution, I have had to set up multiple sheets, each with a single form, and then use a common field and INDEX-MATCH to consolidate information. I would like to have the ability to identify a common field in a new form for the same sheet and have them send the additional information when needed. If there is no match on the common field, it should make it a new line. Please consider this as a possible future enhancement.