Answered
display multiple quantities wihtin a collection as separate lines
Hi,
Near the
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
quantity =2
Later in
the process I would like to display multiple quantities on separate lines so an
asset number can be added to each item, e.g.
Laptop,
£100, asset no1
Laptop,
£100, asset no 2
I would
appreciate ideas on how this could be achieved
Thanks
Amber
Dear Amber
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!
Best Regards
Hi,
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
Thanks
Amber
Dear Amber
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!
Best Regards
Hi,
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/
Thanks
Hi,
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?
Amber
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:
Description: Laptop
Cost: £200
Quantity: 2
When the user returns to main form, it is displayed like this:
Laptop £200
Laptop £200
Thank you
Comments have been locked on this page!