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.
Bump of old question - User input for reporting
Jamison
✭✭✭✭✭
Original Question: "https://community.smartsheet.com/discussion/use-web-form-return-row-or-report-another-sheet#comment-6824"
essentially, I would like to have people with shared access be able to enter in a search term or term and then run a report off of that. The only way I see to do something like that is to re-run the report builder every time. The sheet is 2000+ rows, so doing a search on the sheet is not ideal.
Is this possible? Am I missing somethign that already exists? If not, is this something that the API could handle?
Comments
-
- You could allow users to just open the sheet and do a simple search with Ctrl+F. If you want to provide a customized UI for the experience, and you have some programming experience, you can use the API to conduct a search in a specific sheet. The SearchResultItem objects that are returned from a search API request will indicate if the search result item is a Row which gives you the ability to only display search results that were found in a Row (as opposed to discussions for example).
-
Great info - thanks. I have always wanted to learn how to use an API...
This discussion has been closed.
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives