display multiple quantities wihtin a collection as separate lines
start of my process a user can add items to a collection whereby one line can
have multiple quantity. e.g. description = laptop, unit price = £100 and
the process I would like to display multiple quantities on separate lines so an
asset number can be added to each item, e.g.
£100, asset no1
£100, asset no 2
appreciate ideas on how this could be achieved
Thank you for your question.
We believe you can create a collection within a collection. In this case you can create a collection of "AssetNumbers" within a collection of "Items". To do this, you can simply create collection of "Items" in your ProcessEntity . The "Item" entity would have attributes "Description", "Price", "Quantity" and a collection of "AssetNumbers".
In your "AssetNumber" entity you can create an attribute called "AssetNum".
Then you can create "Add" and "Edit" forms for your "Items" table/collection.
On these forms you can drag the fields you need from the "Item" entity and you can also drag the "AssetNumbers" collection as needed.
Hope this helps!
Thanks for your response. Will this work for inline edit as I wanted the users to be able to simply add the asset numbers to the existing line items using in line edit
One solution to add "AssetNumbers" on the same form could be to have a Related Entity of type "Item". This will hold the row the row that you select from your "Items" collection. You may have to write a script to set this related entity every time you select a row in you table of items.
Once you have selected an item, you can display the collection of "AssetNumbers" below your "Items" collection. Here the end user can view/update the assets of the selected item.
Hope this helps!
Thanks for the info. So, will this solution display all individuals lines when opening the form, then allow the user to add the asset numbers next to the items via in-line edit function/
Will this display the line items individually so when the user opens the form so they can simply add the asset numbers next to them from the main form using in line edit?
How about a different approach as I don't think this is going to meet the project requirements:
Table where you can add products using only an add form.
Attributes are; Item description, price, quantity
When you complete the add form, the rows are added to the table individually, so in the following scenario:
In the add form. the user enters:
When the user returns to main form, it is displayed like this:
Comments have been locked on this page!