Hi. I am a QC supervisor in a factory. I want to creat Inspection app for QC team as bellow:
My factory has 10 production lines, each with 5-10 different inspection items. I’ve created a list of the production lines and their corresponding inspection items. I want that when QC selects the order name and then the production line, the appsheet automatically displays all the inspection items for that line simultaneously. For each inspection item, IPQC can input the inspection result (OK, NG, N/A) and an image. The inspection data will be saved as a separate line for each inspection item: for example:
Order NameA, Production LineA, Item 1, Result 1, Image 1
Order NameA, Production LineA, Item 2, Result 2, Image 2
Order NameA, Production LineA, Item 3, Result 3, Image 3
In fact, I’ve created an app where there are many processes to check, each with multiple items to check. Each item to check is a column; if I have 100 processes, that’s 100 columns. I want all the items to be in one column. When I select a process, all the items for that process are displayed, and IPQC will input the results for each item. Each item will be saved on a different rows . I try to seach many resoure but still can not solve it. Please help make a guide for me for do that
THank for your feedback. I have 02 sheets as shown in photo, Sheet Itemcheck_master have list of process and Item_check for that process.
Check_record is record of checking history of each QC. I try to use GEmini or Chat GPT to support , both of them suggest use Action, and Parent_–child table, but none of them work for me. can you make a tutorial detail step by step. THanks so muck, I already stuck with this item 02 months till now
CHECK_RECORD with the columns id_check_rcord, QC, date, id_process, id_item, result, photo
you will just have to create an action that will create a row in CHECK_RECORD for each items whenyou add a new process
action: execute an action on a specific row from table PROCESS to ITEMS
reference rows: ITEMS[id]
For the reference action you will have to create an action in the table ITEM to add row in the table CHECK_RECORD and use the dynamic input option to get the id of the process
refer to this documentation if you don’t know how it’s done
thanks for join support me. it alomost look like what I expected. when I chose process, all itemcheck belong that process will display, but after I finshed checking, each itemscheck will be save as in different rows. can verify with your sample app.?
HI @YvesG , I use action and already push the table is correct fomat but still stuck in how to update the result of each checking item, could you please make a sample app and shave me via many thanks
Sorry, the final result is different, not like the table you requested. For the check items, I changed them to columns because I consider this a mandatory process and only requires one save process. If you want results like the table you requested, you can use a POS (Point of Sale) application. I think you will get the results from the table you requested. Make the check items like a food menu list. There are several save processes to get the results you want.
Normally, in the detailed view of the PROCESS table, you should have a “related check_records” column that filters the record of your current process. All you need to do is create a ref view for the table records, which will act as the inline view of the “related check_records” column.
Afterwards, if you want to change the result, simply click on the edit button for the record you have selected.
