Hi Coda Community! Today I was working in my billing app and found a problem that i dont know how to solve.
I have a page where I create delivery note templates, I add the customer who I’m making the note for and the items he wants to buy, whose price and article ID values get calculated via lookup columns.
Here you can see Customer info and Article info on the template page:
This information is later stored on a table that connects the customer and article rows via a shared ID.
My problem is that I also need to be able to modify those delivery notes in case I made a mistake or want to later change something. The way I thought of doing that was a view of the database, filtered by the delivery note ID, and directly editing the rows from there.
Now if you think about it, the price of the articles changes from time to time, so the price column must be static…
How do I modify the Customer/Articles with the lookup columns working as I do on the template?
Thanks in advance for the help