# Inspection Form/Checklist Idea
**URL:** https://community.glideapps.com/t/inspection-form-checklist-idea/60518
**Category:** Ask for Help
**Created:** [April 14, 2023, 2:55am UTC](https://community.glideapps.com/t/inspection-form-checklist-idea/60518 "2023-04-14T02:55:17Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@biha](https://community.glideapps.com/u/biha)
#### Post date: [April 14, 2023, 2:55am UTC](https://community.glideapps.com/t/inspection-form-checklist-idea/60518/1 "2023-04-14T02:55:17Z")
I’m doing rental for machine. Before we deliver to our client, we have to do some pre-delivery inspection to make sure the machine is in good condition and as a proof that we check it.
But there’s 76 questions in total for four groups of inspection.
Every question can be answer in either, ✓, ✕ or NA
But for the summary, i need Progress Percentage and also Condition Percentage.
Eg: the question : “Check High Pressure Hydraulic Filter Condition”
Using the if then column for each question.
if the answer ✓ = Progress Percentage is Counted as 1, Condition Percentage is counted as 1 as well,
if the answer ✕ = Progress Percentage is Counted as 1, Condition Percentage is counted as 0.
So in total i have to have 76 x 3 = 228 columns basically ? it is correct?
My question is is there any shorter ways?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [April 14, 2023, 3:10am UTC](https://community.glideapps.com/t/inspection-form-checklist-idea/60518/2 "2023-04-14T03:10:45Z")
Much better to have 76 rows, and present as an Inline List/Collection.
Do you need to save the results of every question, or just the final outcome?
---
### Author:  [@biha](https://community.glideapps.com/u/biha)
#### Post date: [April 14, 2023, 3:12am UTC](https://community.glideapps.com/t/inspection-form-checklist-idea/60518/3 "2023-04-14T03:12:58Z")
I need to save results of every questions. Oooo, Inline list?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [April 14, 2023, 3:14am UTC](https://community.glideapps.com/t/inspection-form-checklist-idea/60518/4 "2023-04-14T03:14:13Z")
Yeah. I’d use a Helper Table and roll the results up into a JSON string, then store that in a single column.
---
### Author:  [@biha](https://community.glideapps.com/u/biha)
#### Post date: [April 14, 2023, 3:17am UTC](https://community.glideapps.com/t/inspection-form-checklist-idea/60518/5 "2023-04-14T03:17:53Z")
What i think is , before this
Report No | Q1 | Q2 | Q3 … Q76 | Progress Percentage | Condition Progress
but if it in Inline List, how to relate it with the each report No and the results?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [April 14, 2023, 3:27am UTC](https://community.glideapps.com/t/inspection-form-checklist-idea/60518/6 "2023-04-14T03:27:46Z")
No, you would have something like this:
```auto
{
["Question1", "Answer1"],
["Question2", "Answer2"],
["Question3", "Answer3"],
....
["Question76", "Answer76"]
}
```
And that would just be saved in a single column.
Then you use a 76 row Helper Table to manipulate it.
It’s a very effective and efficient technique, but quite complicated to explain.
---
### Author:  [@biha](https://community.glideapps.com/u/biha)
#### Post date: [April 14, 2023, 3:29am UTC](https://community.glideapps.com/t/inspection-form-checklist-idea/60518/7 "2023-04-14T03:29:35Z")
hmm do you have any sample the apps that using helper table ? oh but, it will not appear in Google sheet right?
because now i am using google sheet formulated with the answer, in one sheet, and using Apps script to convert to PDF and directly send to user,
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [April 14, 2023, 3:33am UTC](https://community.glideapps.com/t/inspection-form-checklist-idea/60518/8 "2023-04-14T03:33:19Z")
The JSON would be in the Google Sheet, yes. So you could process that with Apps Script.
I think I posted a longer explanation of how this technique works a few months ago. I’ll see if I can find it.
---
### Author:  [@biha](https://community.glideapps.com/u/biha)
#### Post date: [April 14, 2023, 3:34am UTC](https://community.glideapps.com/t/inspection-form-checklist-idea/60518/9 "2023-04-14T03:34:24Z")
I found, it is?
> [@How would you describe a helper table?](https://community.glideapps.com/t/how-would-you-describe-a-helper-table/54497/2):
>
> I use Helper Tables all the time. Most of my Glide Projects are littered with them. They have many uses, here are just a few examples: Reusable Custom Forms This is one I learned from @Jeff_Hager. The usual way to create a custom form is with a “Show Detail Screen → this item” action. This gives you a new details screen on your current row with a blank canvas, on which you then build out your form. However, another way to do this is by using a single row Helper Table. You create a Helper Table…
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [April 14, 2023, 3:54am UTC](https://community.glideapps.com/t/inspection-form-checklist-idea/60518/10 "2023-04-14T03:54:31Z")
That’s not the one I was thinking of, but yes that thread will help you understand the Helper Table concept.
Actually, this is a fairly simple use case, and so JSON might be overkill. I guess it depends on whether or not the list of questions would ever change. If they won’t, then all you really need to save is the answers.
So what you could do is create a Questions table, and list all your questions in one column. Then add a User Specific column to capture the answers. Then use a joined list column to create a joined list of all the answers, and save that.
---
### Author:  [@biha](https://community.glideapps.com/u/biha)
#### Post date: [April 14, 2023, 3:58am UTC](https://community.glideapps.com/t/inspection-form-checklist-idea/60518/11 "2023-04-14T03:58:08Z")
Do you know which apps in the Glide template that is using this Helper Table?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [April 14, 2023, 4:07am UTC](https://community.glideapps.com/t/inspection-form-checklist-idea/60518/12 "2023-04-14T04:07:18Z")
No, I’m not aware of any.
Are you using Classic Apps or new Apps?
---
### Author:  [@biha](https://community.glideapps.com/u/biha)
#### Post date: [April 14, 2023, 4:28am UTC](https://community.glideapps.com/t/inspection-form-checklist-idea/60518/13 "2023-04-14T04:28:24Z")
Ive turn to New Apps
---
### Author:  [@biha](https://community.glideapps.com/u/biha)
#### Post date: [April 14, 2023, 6:28am UTC](https://community.glideapps.com/t/inspection-form-checklist-idea/60518/14 "2023-04-14T06:28:12Z")
I have to make something like :
One sheet 74 rows with questions.
Another one sheet, single row ?
It is ?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [April 14, 2023, 6:33am UTC](https://community.glideapps.com/t/inspection-form-checklist-idea/60518/15 "2023-04-14T06:33:00Z")
Give me a little time, I’ll make an example for you.
---
### Author:  [@biha](https://community.glideapps.com/u/biha)
#### Post date: [April 14, 2023, 6:33am UTC](https://community.glideapps.com/t/inspection-form-checklist-idea/60518/16 "2023-04-14T06:33:46Z")
🥹
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [April 14, 2023, 7:57am UTC](https://community.glideapps.com/t/inspection-form-checklist-idea/60518/17 "2023-04-14T07:57:41Z")
Have a watch of this.
---
### Author:  [@biha](https://community.glideapps.com/u/biha)
#### Post date: [April 14, 2023, 8:13am UTC](https://community.glideapps.com/t/inspection-form-checklist-idea/60518/18 "2023-04-14T08:13:53Z")
Omg Darren 🥹. Best explanation! Meaning if submit button the answer will go to another new sheet right, can edit the answer as well right ?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [April 14, 2023, 8:22am UTC](https://community.glideapps.com/t/inspection-form-checklist-idea/60518/19 "2023-04-14T08:22:39Z")
Yes, it would be possible to come back and edit the answers later. Although the logic for that would be a little different. Basically, you’d need to load the RowID of the submitted answer, use a relation + lookup to fetch the joined list of answers, use a split text + single value to expand the answers across all rows, and then go from there.
---
### Author:  [@biha](https://community.glideapps.com/u/biha)
#### Post date: [April 28, 2023, 9:24am UTC](https://community.glideapps.com/t/inspection-form-checklist-idea/60518/20 "2023-04-28T09:24:48Z")
if I need to edit the answer later, i have to set the answer back to the Answer Column from the Single Value right?
But i cannot find a way to set all Single Value Column to the Answer Column.
Because of course we edit from the sheet “Log”
[Next page](https://community.glideapps.com/t/inspection-form-checklist-idea/60518.md?page=2)