Hi fellow Make users,
In Airtable we have Projects—>Rooms—>Items
We create an invoice for all Items in a Project
We need a Subtotal line inserted after every Room indicating the total amount of a room.
For Eg: We have 3 Rooms in a Project and Room-1 has 5 Items, Room-2 has 3 items, Room-3 has 4 items. So total number of items = 12
I need a subtotal line inserted after first 5 items, then after 3 items, and another one after the remaining 4 items.
I tried doing this but my solution creates 3 different invoices(one for every room) instead of one invoice. Am i doing this correct or do I need to implement something else entirely? Please guide me.