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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives