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

Comments (6)

photo
1

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

photo
1

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

photo
1

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

photo
1

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

photo
1

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

photo
1

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