display multiple quantities wihtin a collection as separate lines

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