Apologies for the bad title. Not sure how best to put this but I am wondering if anyone has come across a situation where they needed a table for data entry inside an entity.
The use case I have in mind is for tracking invoices and progress payments. At the beginning of a project, I would like to setup a work breakdown structure or list of tasks and the allocated budget for each item. As I get invoices, I would be charging amounts to some (or all of these line items/rows). I would like to be able to track how much has been spent so far and how much is remaining. Normally, I would be able to create an excel table like this:
However, I am really struggling on how to model this with entities in Fibery and how to I can do the data entry without a table or matrix representation. Here is how I was thinking of modeling the entities:
My big challenge is how to enter each row of partial payments for each task for each invoice. Hoping there is a straightforward way of doing this.