Hello. I’m relatively new to Appsheet and I’m having troubles orientating my data/tables and app to the purpose of the vinyl record shop I work in.
Scenario is this:
We have a table with the list of all the records which includes columns such as CATALOGE # (this is the ID that is embeded in a QR code and that) I understand this is the key.
We need the app to do the following:
-
One view will be for consulting (someone in the team needs to see a detailed view of a record, add and edit entries) This I already have it
-
We need to have another view to create invoices and register sales (let’s name it create order). This is: when a customer give us the records he/she will be buying, the view is able to create consecutive order rows (INV0001, INV002…), then build a list from scanned QR codes, Take the [CAT#], [Name+Title] [Sell Price] and an extra “quantity” columns for that record. Then we need to take this list and add it to an invoice template that will be emailed to the customer (or maybe the customer is not interested in leaving his email, we still need to have a register of the sale)
If you could please help me structure the project. I have no problem going into the webinars and support documentation to learning about the use of expressions, workflows and more, but I need to know what to look for and how the stricture of this app will be:
How many tables do I need?
Best way to relate those tables?
List of expressions/actions/workflows needed to fulfill the app objective?
Having this guidelines allows me to move on confidently. Thanks in advance for your help community!!