Dear all, hope you can help!
I am trying to save an invoice into a database. The invoice gets created within bubble via input fields and need to be shown afterwords whenever you like as 1 saved invoice.
While I started to save the different “products” within that invoice as “list of products” as one column in the database “invoice” I recognized that I dont know how to store the respective quantity (QTY) attached to the specific product.
a) the quantity will of course change from invoice to invoice (so putting the QTY fixed next to the product in a separate database would not make sense)
b) the invoice needs to be saved and displayed afterwards whenever you like (temporary calculations on the page would not help as the QTY needs also somehow to be recorded).