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:
No external tool needed for accomplishing such formatting. SugarLogic formula is able to do the job.
Create one custom field for each phone field and set a sugarLogic formula this way:
ifElse(
equal(subStr($phone_mobile,0,1),"+"),
strReplace(" ","",$phone_mobile,false),
concat("+",strReplace(" ","",$phone_mobile,false))
)
Regards
No external tool needed for accomplishing such formatting. SugarLogic formula is able to do the job.
Create one custom field for each phone field and set a sugarLogic formula this way:
ifElse(
equal(subStr($phone_mobile,0,1),"+"),
strReplace(" ","",$phone_mobile,false),
concat("+",strReplace(" ","",$phone_mobile,false))
)
Regards
Hi Andre,
It works!
Thank you so much!
Just one thing, how can I update the history records for the custom field via action recalculating?
When I choose the records in Contacts list view, there's no 'recalculate' in the action.
Thanks!
Hi Andre,
I just found the 'recalculate' action.
But one more help, please:
Because our phone number format is really inconsistent, it has space , '-', etc. It's really dirty.
I know I can just nest the ifElse,
but I just want to know, is regular expression possible?
Could you please share a sample?
Thank you very much!
Hi Andre,
sorry about so many messages...
just two more thing to check,
1. what’s this language is? What else I can use except ifElse?
2. If I use a quite long nested ifElse, will it affect my instance’s performance? I have 30K records.
Million thanks!