Hi community! First post, thanks for having me.
Recently a customer asked us to implement JSM for them. They have one requirement which we are afraid may not be possible.
When they open a ticket it must be associated to a contract which is associated to a client (user). One user may have tens or hundreds of contracts active at a time.
During ticket creation (which will always be carried out by agents) the system should autocomplete and not let the ticket be created if the written contract doesn't previously exist in the system.
My main worry is that a single custom field may not be able to contain tens of thousands (in the future maybe even hundreds of thousands) of options. Does anyone know if this is even possible? Is there a different way of solving this problem we may not have taken into account?
More information which could be usefull. The customer has customer data stored in an Azure SQL Server database.
Is there any way to do this? Plugins and API are an option.
Many thanks in advance!
