How Do I Get Started?
I have built one AppSheet app that takes input and drops the info into a SS for further analysis so I have some experience with AppSheet.
Now I need to build an app that needs to reference data that is in QuickBooks. Export the data (sales order) to a PDF, use Able2Extract to pull the relevant fields from the exported PDF to Excel.
This data then needs to be pulled up in AppSheet so our users can go through and QC the items in each order for defects. This is where I can’t get started. The number of Fields will be fixed, but not the number of items (rows). Could be 3 or 37.
Each item needs to be QC’ed, it may or may not have a QC value. As the number of rows for each order is a variable, how do I tell AppSheet where the start and end of an order is, and how to display each item on screen for QC? Then write it back to Excel for analysis.
Any advice or samples on how to tackle this? Thank you in advance!