LinkedIn
Twitter
Trying to create an app with the attached info. The purpose is to input info everyday under the columns into the sheet and change it according to the incoming orders for that day. I blacked out the customers for this, but app isn't generating right and will only show an error message. I also want to be able to add more than one product/description/amount under each invoice # but the app will not read it correctly. Is this a lost cause? lol
Nope, not a lost cause at all.
First, you need to provide a screenshot of the error you are receiving for us to help fix that problem.
Second, you most certainly can add additional Products, Descriptions and Amount for each Invoice. To do so you will want to structure your workbook to house the data and present it properly. The workbook is treated like a database. You will need to create a Parent/Child structure, with two tables Invoice and Invoice Details or named something like that. You then create a "relationship" between these two tables and when the data is entered in the app, it will automatically be linked together between the tables. Not magic...just takes a little setup to make happen.
I recommend starting by looking at one of the sample apps. The Quote Generator will have a structure very similar to what you need.
To find the sample apps, aka Templates, refer to the image below to find the menu in the AppSheet Editor. You will no doubt have more questions, so please come back here to ask when you need to
