Here is the situation - I have these 3 sheets in my google sheet - Table A Sampling Plan indicates how many items of different products have to be picked for sampling - the Header indicates one round of picking and dispatching the samples. The detail is Table B where the entries have to come from Table A - the sampling Plan by matching the location Name (which is there in the User Profile as a column).
Ideally, I want this kinda display in the Sample Dispatch Details Screen, which is embedded in the Sample Header Details Page.
- The sampling plan should be displayed in the form of a table - the data has to come from the Sampling Plan and the extra column (Qty Picked) alone should be added to the sampling plan
- The user can enter the sampling qty and when he submits the form, all the entries where he has filled up sample entries should be written to the sample details table.
- Or I can make the user enter one row at a time into sample details table, but I want to show him the remaining sample entries only - where the Qty to be Sampled - Sum(Qty Picked) is 0 so that he sees only the remaining samples that he has to pick.
Being new to Glide, I thought of adding a Data Grid from Sampling Plan, but I am not able to add an extra column and then store everything into the sample details table. Then I tried row by row, but I am not able to filter out the items to show only the relevant items.
Any suggestion on what types of views I should use to show/edit the sampling plan Table A and sampling details Table B would be appreciated? How do I do the filter to show only when there is still some sample quantity pending.
Here is a Dropbox link to the Excel sheet with the sample data that I have captured in my screenshot above
- I just put them to take a screenshot.
