[Vtigercrm-developers] Picklist with lots of values

[nilay khatri]

Problems by approaches:

1. Text field:

It's a good approach, we can then add a JS to lookup based on the typed
characters.

Problems:
- reporting becomes difficult
- role based values would not be possible
- management of values will need dev help every time


2. Using a separate module

Problem:

- You can't have multiple selections in the Reference field. To have a
field like the Contacts field in Events with multi-selection is a pain.


Eventually you will spend the same effort as changing the behaviour of
select2 with ajax, in any of the cases above. Also that will become a
special case. So rather optimize the picklist uitype itself?


On Mon, Oct 17, 2022 at 4:16 PM Ing. Matus Sopko <sopko at its4you.sk> wrote:

> For 15k+ values, I will create new "Zip codes" Module with relation to
> Orga, Inv, ... modules.
>
> S pozdravom / Best regards / Mit freundlichen Grüßen
> Matus
> IT-Solutions4You s.r.o.
>
> Dňa 17. 10. 2022 o 12:32 Oleg Antonov napísal(a):
>
> Why don’t you use text field for zip code?
>
> I heard about integration with google address, maybe it could help.
>
> If you decide to use dropdown for it, you better implement completely new
> field type with predefined values. Maybe with regular codes update from
> some source routine.
>
> El El lun, 17 oct 2022 a las 10:49, nilay khatri <nilay.spartan at gmail.com>
> escribió:
>
>> Hi,
>>
>> In one of our setups, the user has added 15k+ values to a picklist, which
>> are the Zip codes.
>>
>> This slows the CRM like anything.
>>
>> Has anyone come across such scenarios? Any available solutions?
>>
>> Based on our initial research this happens because of the select2, and
>> the fact that all picklist values are to be fetched and initiated. This
>> leads to high resource utilization and DOM building gets slow. Imagine
>> having 2 or more zip fields :)
>>
>> As a solution we are thinking of changing the behaviour of select2 to
>> load values using ajax.
>>
>> But then the challenge would be picklist dependency setups, as that would
>> need all the mapping to be available anyways. So the load times and
>> resource utilization is not going to have any major impact?
>>
>> Happy to collaborate.
>> _______________________________________________
>> http://www.vtiger.com/
>
> --
> --
> С уважением, руководитель веб-студии PIN
> Антонов Олег.
> +7-921-922-91-91
>
> http://pinstudio.ru
> - Создание и продвижение сайтов
> - Автоматизация бизнеса
> - Увеличение продаж
>
>
> _______________________________________________http://www.vtiger.com/
>
>
> _______________________________________________
> http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20221017/0ced31a4/attachment.html>