Add multiple data items per model

[thaishin_TH]

How do I get my app data to look like this?

What I mean is

1. Models have multiple specs, up to 14 specs. Some models have only 10 or 12 specs.

How should I design it?

[jballester]

Templates - Use templates in an automation
https://support.google.com/appsheet/topic/11445504

Example query

<<[inspection id]>>
<<start:[inspection content]>>
<<[spec]>>
<<[up]>>
<<[low]>>
<<[method]>>
<<End>>

Example of html template to integrate the query

<<[inspection id]>>
<table>
<thead> <tr> <th>Inspection Content</th> <th>Spec</th> <th>up</th> <th>low</th> 
<th>Inspection Standard</th> <th>Inspection Method/Tool</th> </tr> </thead>
<tbody>
<tr> <td><<start:[inspection content]>></td> <td><<[spec]>></td> <td><<[up]>></td> <td><<[low]>></td> <td><<[MAX MIN]>></td> <td><<[method]>> <<End>></td></tr> 
</tbody>
</table>