Hi all,
Fairly new to AppSheets so gentle please...
I have a dress rental shop and we do invoices when someone rents a dress. The invoice is the header table of all the invoice info, clientID, rental date, return date and total cost and so on. invoiceDetail is the dresses they rent and stuff they purchase, which has a lookup table of items (the dresses). Items descriptions, rental price, size and so on. I want to add a button to the Invoice header which loops through the invoiceDetails of the invoice I'm on and then updates the matching items table records with some of the reservation details,(Dates, InvoiceNumber, etc) items has a reservation text field that we currently put in these details so we can quickly scan any item and see if its available for a requested date. We currently go back after printing the invoice and fill this in manually. I want to automate this via button.
I'm thinking an action but not sure how to reference down the chain of tables.
Structure is such:
Invoice ->>InvoiceDetail (Invoices have many detail records)
InvoiceDetails have items they lookup
Any help would be greatly appreciated
-MissG's
LinkedIn
Twitter
