Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Is there a way to tie a web form to a specific record?
I have a SmartSheet where the user enters the preliminary information via a webform, which assignes an autonumber to that record. I would like them to be able to update that record via a webform without me having to send an update request. Is there any way to create a webform where the user enters the item number and it automatically updates the specific record?
I would prefer not to have the individual users have access to the whole sheet so they couldn't update the wrong record.
Comments
-
Debbie,
Not sure if this will solve your problem, but I'd recommend trying Google Forms with SS.
https://www.smartsheet.com/apps/google-forms-smartsheet-sync
Hope you find a soluton.
Tim
-
We've used that Tim and it allows the functionality Debbie seeks. Nice workaround!
There are other ways but they involve other Apps via the API.
Good luck
Richardr
-
Update requests were designed to do almost exactly what you are looking for. You cant enter a number and see the field but it will allow users to update rows on sheets they are not shared to.
If they were shared to the sheet they could use the search feature to search for the item number then update the field inline, without having to open the sheet.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives