Hey there!
I received a request to build a Job Safety Analysis app for a technician to use to visit a site, record the basic steps of a task (like replacing a wire), record the hazards associated with each step (like electrocution), and then record the solutions for each hazard (like leather gloves). A step can have many hazards, a hazard can have many solutions. AppSheet can of course handle all this with related REFs and such, but I have a new wrinkle:
The request is now that the form in the app โstep them throughโ instead of relying on them to save the form, then add a child and save it, then go to the child and add the grandchild, etc etc. I think the problem is that itโs not intuitive to have to keep saving and going back up a level to add siblings. But because this is a hierarchy of several one-to-many relationships on top of each other, I know of no other way to accommodate the original requirements.
Have any of you seen/built anything that can put a user โon railsโ and elegantly walk them through creating a dynamic number of children and grandchildren? My requestor wanted it to be like, they save the initial parent form, then it says โWould you like to add a Step?โ you hit yes, describe the step, it asks โWould you like to add a hazard?โ, you hit yes, โWould you like to add a solution?โ, yes, โWould you like to add another solutionโ no, then back to โwould you like to add another hazard for Step 1?โ etc etc.
I hope that makes sense and honestly, Iโm 90% sure AppSheet just isnโt built to work this way, but I thought I would take a shot in the dark here and see if any of you AppSheet veterans have solved something like this already?
Solved! Go to Solution.
Incredible. And here I thought I knew AppSheet really wellโฆ thatโs some next level stuff youโre bringing! Thank you so much for taking the time to do this, itโs extremely helpful
User | Count |
---|---|
35 | |
31 | |
30 | |
19 | |
17 |