Workapps access without logging in
Is is possible to create an app in workapps and have the users enter/edit information through reports without having them to log into smartsheets?
I need users to provide input to specific action items but I don't want to have to set up a username and password to access SS.
thanks in advance.
Best Answer
-
The only way for someone without a Smartsheet account to provide information to Smartsheet is via a form or update request.
One workaround I've been using lately is to use dynamic form urls.
Let's say you have a simple sheet with just one column for Information and one for Due Date. You want your user to be able to update both of these cells.
What you could do is this:
- Add an auto number column if you don't already have a unique ID for each row.
- Create a second helper sheet with three columns: Reference Number, Information, and Due Date.
- Create a form on that sheet with those three fields.
- Grab that url and pop it into the Update Form Link column on your master sheet. Add dynamic form field queries, so that when your user clicks on the link it autofills the current info. They can edit the info as needed and hit submit.
- Use cross sheet formulas to pull the latest Information and Due Date entries from your helper sheet.
- Publish the master sheet and provide it to your users.
Answers
-
The only way for someone without a Smartsheet account to provide information to Smartsheet is via a form or update request.
One workaround I've been using lately is to use dynamic form urls.
Let's say you have a simple sheet with just one column for Information and one for Due Date. You want your user to be able to update both of these cells.
What you could do is this:
- Add an auto number column if you don't already have a unique ID for each row.
- Create a second helper sheet with three columns: Reference Number, Information, and Due Date.
- Create a form on that sheet with those three fields.
- Grab that url and pop it into the Update Form Link column on your master sheet. Add dynamic form field queries, so that when your user clicks on the link it autofills the current info. They can edit the info as needed and hit submit.
- Use cross sheet formulas to pull the latest Information and Due Date entries from your helper sheet.
- Publish the master sheet and provide it to your users.
-
Thank you Julie.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives