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 …

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?

I need to save results of every questions. Oooo, Inline list?

Yeah. I’d use a Helper Table and roll the results up into a JSON string, then store that in a single column.

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?

No, you would have something like this: { [ "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 a…

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,

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.

I found, it is? [image] How would you describe a helper table? 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 …

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 ne…

Do you know which apps in the Glide template that is using this Helper Table?

Inspection Form/Checklist Idea

Ask for Help

biha April 14, 2023, 3:34am 9

I found, it is?

Topic		Replies	Views
Personalized checklist per user Feature Requests	2	515	March 14, 2020
Would this be the right approach for an Audit Checklist app? Ask for Help	2	419	September 30, 2019
Fetch JSON and JSON transform Ask for Help	16	703	November 2, 2022
600 columns for a form? Ask for Help	20	1739	February 4, 2021
Add progress bar to check items in checklist (individual) Ask for Help	3	437	July 22, 2020

Inspection Form/Checklist Idea

Related topics