Duplicate records
I’m working with HR on getting employee onboarding, offboarding and status changes processes streamlined. Currently they are using separate smartsheets for onboarding, offboarding and employee status changes. Recently HR is planning to combining all three and put it into one sheet. They want HR to enter information using Webform. They claim the webform won’t create duplicate records however it will create one record per employee.
my understanding is web forms create a new row each time when submit is hit. If HR fills two fields and hit submit. Then they again open the form and fill remaining 3 fields, this will create a new row- duplicate record.
How’s HR saying duplicate records won’t be created as form has been created in such a way. Not sure how’s that possible?
Answers
-
Hi @Harpreet ,
I think your understanding is right for the way webform works. Webforms are used to create new records in a sheet.
But there's another form called update request form which is used to update information in an existing row. This update request form can be sent to users by automation workflow or manually.
Gia Thinh Technology - Smartsheet Solution Partner.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64K Get Help
- 412 Global Discussions
- 220 Industry Talk
- 459 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 140 Just for fun
- 57 Community Job Board
- 460 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives