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

  • Paul Newcome
    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.

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com