can i create an easy user interface for searching a spreadsheet

We have a hidden sheet we don't want people to see and have a dashboard with links to forms, reports and calendars, but now have enough lines we need to build out a search function. Each line is a test request meant to keep for years. How could we create a search function to look at a report or the sheet to narrow down their info based off of a value from a couple of the columns? This might look like, machine #, date range, key words, requestor....

First post -sorry if I missed the answer in a previous one (I did search )

THX

Krafty

Find more posts tagged with

Accepted answers

All comments

Andrée Starå

Hi @Mr.Kraft

I hope you're well and safe!

Can you share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Mr.Kraft

This is a report of the "closed" test. we are creating about 50 a month so will soon have thousands. I want to be able to have a user find a test that was run 8 months ago based off of search criteria.

THX

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.