One of the integration we have with our FSM Mobile app require to send the email address as lower case string.
Is there a way to do that using Client Scripting, Business Rules or Custom Metadata in FSM 6U4?
Alternative, we are considering to do this via SQL scripting (a sql job that runs daily and convert the email addresses that has any Upper case character into full lower case email address.
Thanks in advance.
Daniel.
+28Hi
Can you please elaborate on the flow?
Send from where to where? How is it done? Why isn’t it in lower case now?
more details please
Cheers!
We are sending the email address from our FSM Mobile application to a Podium API (https://www.podium.com/blog/surveys) where they use the email address for a customer survey. We have to make sure all our email address are saved/stored in a lower case format.
The email address is added by humans (Service Desk or Work Force Planners) and I don’t know how to force them to enter the email in all lowe case.
+28Hi
You can achieve this in many ways.
On the Webclient you can create a client script to change the email to lower case with an SQL query.
You can validate or force lower cases with Regex in custom metadata.
On the Mobile you can create a client script to change the email to lower case with an SQL query.
You can validate or force lower cases with a client script and SQL
For example
var lowerEmail = getDBValues(‘GET_LOWER_CASE’, ‘EMAIL@EMAIL.COM’);
GET_LOWER_CASE will be SELECT LOWER('{0}') as result;!--scriptorendfragment-->!--scriptorstartfragment-->
This will return the mail in lower case.
Then you could update the field with that value.
There are more ways, just need to think of how you wish to achieve this and think out of the box.
Cheers!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
