Using Multiple Forms to Update a Single Row

rshelnutt

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

Paul Newcome

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.