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
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,
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!