Create a Varchar field for eack Link Multiple item

[Athensmusic]

Hi there, looking for a solution (if it is possible) to create a new varchar field for every selected item in a Link Multiple field.
Example, Have an Entity "Assets", and in another Linked entity I need to select some records from the existing records in "Assets".
Then after selecting for example 4 Assets items, we need to create 4 Varchar fields named "Quantity" so then we can input appropriate quantity.

OR

I can create an Array or MiltuEnum field (display as list could do the job) but does not accept same values, is it possible to make an Array or MultiEnum field accept douplicate/same values?

Any help on this?
Thanks

[Firyo]

Hi,

You can add additionnal fields in the middle table when you have a linkMultiple with hasMany <-> hasMany

https://docs.espocrm.com/development/metadata/entity-defs/#additionalcolumns

[esforim]

Good luck Athens, hope you share result. I been wanting to do this as well but never been able to just based on Documents.

[Athensmusic]

Thanks,
I really don't get it too...seems there is no hope, unfortunately.