Using Multiple Forms to Update a Single Row
Is there a way to use multiple forms to feed into a single row?
An example would be our orthopedics program. Our coordinator collects several pieces of information from multiple departments (OR, Pre-Surgical, Med/Surg Nursing Floor, Education, etc.)
Can I build something so she can create a row per patient with their ID number and have others use a form to fill in their specific pieces, but everyone's information would be housed on the same row linked to the original patient ID number?
Thanks!
Regina
Answers
-
You would need to use either an Update Request so that the info populates the same row directly, or you would need a separate sheet with the forms and use formulas with cross sheet references to the form sheet on a "summary" sheet to gather all of the data.