Custom fields: how to select more than one item on dropdown list

[eko]

@Patch

I would create several custom fields, repeating the contents of the drop down list if multiple items from a particular list are likely to be selected. So if customers mostly bring in less than 3 items then 4 drop down lists would be created.

I would consider to use non-inventory items instead of custom fields, it would allow you to add a description if needed.

@Patch

To do so a free text field would be required adjacent to each drop down list items selected.

You would as you do in reality take the items in and then give them back, that is best handled this way.

[bayeboafo]

If I understood the case study, in my opinion, ,now that line custom fields is available on transaction forms, you can also handle this issue by creating line custom fields on the transaction forms. You can then use multiple lines to record the difference items and in each case select the appropriate option for each item.

[Davide]

This is not correct in most of cases:

1. custom fields doesn’t apply only to transactions
2. you may have to link a transaction to many different values of a custom fields but you may not know how to split the value
3. It may be even illegal in some counties to create dummy transaction lines just to add a custom fields, ie tags that have nothing to do with accounting

[Patch]

@Davide

illegal in some counties to create dummy transaction lines

For the only actual use case describe in this thread, that is very unlikely.
There is no reason an invoice for the repair of a customers electronic device should not specify the equipment supplied for repair, and that the customer supplied equipment was done at zero cost.

There maybe another use cases which creates a legal problem for a user with a specific problem in a specific jurisdiction, however such a use case has not been describe here.

[eko]

@Patch did you try my suggestion? I think that non-inventory items at 0 value are a much cleaner way to deal with this.

1. Create an income account in Charter of Account as follows:
   

   

2. Create a customer and copy this customer to supplier so the customer is both a buyer and a seller

3. Create as many non-inventory items in settings such as example below, where both When sold and When purchased are allocated to the income account created in point 1 above and where you could autofill the amounts to 0 (no value) :
   

   

4. Enable Goods Receipts tab in customize and create a goods receipt as for example below (descriptions where written manually and are optional):
   

   

5. When the customer picks up the items copy the Goods Receipt you created in view to a New Sales Invoice or New Receipt and add any other line. Sort the lines as you wish.

[Patch]

@eko

@Patch did you try my suggestion?

Yes which is why I wrote above

@Patch

it would probably work better again to use zero value Non inventory Items, for example “Customer bag”, “Customer protector” etc.

But thanks for illustrating it so well

By the way @compuit has the business with a use case for this functionality.

[eko]

@Patch

However in practice, in such a database I would want information to identify what the customer actually supplied (what sort of bag, what sort of protector, what cables etc). To do so a free text field would be required adjacent to each drop down list items selected.

Sorry @Patch my mistake to answer a request by @compuit but my solution would address the second point you raised where you can select and write descriptions in the absence of any other solution that would do the same at the moment.

[lubos]

This has been added to the latest version (22.8.19).

Under Settings, then Custom Fields, there is new screen named Multiple Value Custom Fields

You can create new multiple value custom field on both top-level and individual lines.

Then it will be shown as follows:

And when viewing…

[ries]

No Custom Field showing in view mode.

[Tut]

Show the Edit screen of the custom field, please.

[ries]

Edit screen of custom field [test].

[lubos]

@ries this wasn’t related to multi-value custom fields as none of these new custom fields would show. Anyway, this has been implemented in the latest version now (22.8.20)

[Ahm]

Weldone Lubos, excellent work. I am very happy.

[Chariz_Flores]

THANK YOU SO MUCH FOR THIS UPDATE…

[ibadlon]

Hi. I am not sure if all will concur with me on this, but is it possible that values chosen in multiple dropdown list be shown in view screen as bullet list?

instead of like this,

can it be shown like this?