Form builder - pull sheet data
I have a sheet for equipment maintenance logging. I don't want users to have the ability to modify this sheet and they don't need to see the entire log. I created a form so they could easily enter daily maintenance checks into a log from their phone. I'd like to be able to filter and display some of the data from the sheet on the form. So while maintaining one master sheet for all logging I could create individual forms for each piece of machinery. The operator can view the entry form in the morning and can see a short history that the checks have been done each day this week. If not the form gives them no information of history, only input. Is this possible?? Any ideas would be appreciated. Thanks.
Best Answer
-
HI @Bob M. 2024
Got a few for you…
Forms cannot reveal contents from the source sheet, they only allow input to a new row. Alternatives…
- Build a Row report on the source sheet and display via a dashboard machines that require maintenance. Cons. If several machines need maintenance, technicians in the field, unless communicating with each other could all select Machine 1 for example. Forms cannot feedback information, you may end up with several rows in the sheet all with data for machine 1…
- Establish some automation that looks for checks to be done then set up an "Alert Someone" automation with the form link. & placeholders {{Machine X}} that needs checks. Automations can be set up to alert a specific person OR a contact in a Contact List column. Using contact list option would mean machines are assigned to specific technicians. You could allow techs to reallocate the alert by making the Automation a Request an Update type. Once at the form techs select the machine # asked for, and through Conditional logic in the form, the only cells that need data are revealed...
- last option I have for you (open to community) premium add on Dynamic View.
Report building.
Automation and form link.
Automations in general.
Dashboards.
Hope this helps Bob.
Cheers.
Answers
-
HI @Bob M. 2024
Got a few for you…
Forms cannot reveal contents from the source sheet, they only allow input to a new row. Alternatives…
- Build a Row report on the source sheet and display via a dashboard machines that require maintenance. Cons. If several machines need maintenance, technicians in the field, unless communicating with each other could all select Machine 1 for example. Forms cannot feedback information, you may end up with several rows in the sheet all with data for machine 1…
- Establish some automation that looks for checks to be done then set up an "Alert Someone" automation with the form link. & placeholders {{Machine X}} that needs checks. Automations can be set up to alert a specific person OR a contact in a Contact List column. Using contact list option would mean machines are assigned to specific technicians. You could allow techs to reallocate the alert by making the Automation a Request an Update type. Once at the form techs select the machine # asked for, and through Conditional logic in the form, the only cells that need data are revealed...
- last option I have for you (open to community) premium add on Dynamic View.
Report building.
Automation and form link.
Automations in general.
Dashboards.
Hope this helps Bob.
Cheers.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65K Get Help
- 443 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 129 Brandfolder
- 150 Just for fun
- 70 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
