Hi Community there,
Could anyone please help, many thanks!
I want to user field 'phone_mobile' to filter all related user via calling endpoint: XXXX/Contacts/filter
I can get some records by setting pload in the request:
Hi Community there,
Could anyone please help, many thanks!
I want to user field 'phone_mobile' to filter all related user via calling endpoint: XXXX/Contacts/filter
I can get some records by setting pload in the request:
Hi Dmytro,
Thanks a lot for your reply.
Do you have any sample about logic builder please?
I’m totally new to sugar...
The number format in sugar system is inconsistent since it’s typed by every single individual.
I just want to make the phone number have a consistent format so that I can filter better.
Thanks a lot!
Hello Sophie,
Sorry for the delay with the response.
Could you specify first if you are trying to filter users or contact?
Actually, I see 3 types of efforts that could help with the challenge:
1) to set up phone validation logic, preventing users from entering non-formatted phones
2) to format entered phone automatically - each time the user profile is saved - according to the preconfigured logic
3) to set up a custom endpoint for the external call, so that users keep their phones formatted in Sugar as they want, but get them formatted on the fly for search purposes when the endpoint is called
The first option is preventive, the second is supportive, and the third is "to configure for me" - due to a relatively high computing load, the last wouldn't work if you have dozens of thousands of records (like Contacts) but should work for hundreds (like the number of Users)
Which of 3 would better work for your circumstances?
Best Regards,
Dmytro Chupylka
integroscrm.com
We make work in Sugar CRM system faster, more convenient and efficient
Hello Sophie,
Sorry for the delay with the response.
Could you specify first if you are trying to filter users or contact?
Actually, I see 3 types of efforts that could help with the challenge:
1) to set up phone validation logic, preventing users from entering non-formatted phones
2) to format entered phone automatically - each time the user profile is saved - according to the preconfigured logic
3) to set up a custom endpoint for the external call, so that users keep their phones formatted in Sugar as they want, but get them formatted on the fly for search purposes when the endpoint is called
The first option is preventive, the second is supportive, and the third is "to configure for me" - due to a relatively high computing load, the last wouldn't work if you have dozens of thousands of records (like Contacts) but should work for hundreds (like the number of Users)
Which of 3 would better work for your circumstances?
Best Regards,
Dmytro Chupylka
integroscrm.com
We make work in Sugar CRM system faster, more convenient and efficient
Hi Dmytro,
Thank you for your reply.
First, I'm trying to filter the module 'Contacts' and it has 30K records. I want to get id when the phone number field matches.
So I guess the third option is not suitable.
As to the first option, when you're saying 'it is preventive', do you mean it's forbidden to do so ?
And how can I do the second option, please?
Thanks a lot!