[Vtigercrm-developers] Picklist with lots of values

[Alexander Allen]

I have an airport field based on country. To do this I separated the fields
in another module and dependency via jquery

El lunes, 17 de octubre de 2022, nilay khatri <nilay.spartan at gmail.com>
escribió:

> 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/ec5a95b7/attachment.html>