i'm using wix data to create a workflow website. (1 of several projects) I am using user input data and then displaying it as an order form.
(little background) I'm in the HVAC business. We have a project that we inspect an entire apartment building then order materials, do the job, record the info from the install and finally bill the job. I'm attempting to do all of this from our new workflow website.
On the inspection all data is entered into the database for each unit. (1 building is 10 units) in the database I have 10 units with the same Building Number and same Date. I have built a dynamic collection page (not item page) that has every item that was entered into the database listed on the page. I have connected each item on the dynamic page to their respective items in the data collection.
the problem I am having is that the dynamic page is only showing 1 of the 10 units. If I change the building number it builds another dynamic page for me (that's great, just what I expected) but I needed each page to display the totals for the building. How can I display the collective totals for these fields?
so just to clarify... using this example, I have entered 10 separate user input forms and have 10 lines in the data collection. every entry in the data collection share 2 things, the Building Number and the Date. I have a total of 7 furnaces between the 10 lines in the data collection. I need to display them as a total not individually so it clearly shows we need 7. I have somehow got this far without having to write any code but I believe this will take added code. Is there code that I can add to the entire page that tells the page to add the items in each field title together?
below is how the order form looks in the editor. If I goto preview mode everything that we order id displayed in the user input boxes. I entered 1 unit into the database and tested in preview mode and everything was displayed perfectly but as I added the 2nd and 3rd units into the database the data was not being added to the 1st units like I wanted. As I thought about it I never asked for the data to be displayed collectively, I guess I was expecting the computer to read my mind. I don't know how to ask for the collection to do what I need it to do and Im about 99% sure that this is a common and simple function.
I will be VERY greatfull for some help on this one