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.
-
Paul—-Can you share info on how to set up the update request?
Im trying to puzzle through the same issue as the original poster. Thank you, Mary
-
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives