• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Auto update phone number prefix in google sheets or elsewhere

Tamosukas

Member
Hello I planing to send sms or whatsap messages to clients who fill form on my website, but very often they fill wrong phone prefix or even without the prefix
as example normal phone must look like this
+37067400200
but users can fill like this
37067400200
67400200
867400200
+370 674 002 00
How to auto correct them and where best to do this. And may be you can sugest cheapest sms provider for europe
P.S. country phone specific is that all numbers must have 37067400200 number 6 and users usualy starts 3706, or +3706 or 86 or even 6...
 

Fagun Shah

Well-known member
Follow this workflow - It does proper for each number format you gave -

Country Code.png


You can try by submitting number in different formats in this form - https://fagunshah.in/code/
And see results in this GSheet - https://docs.google.com/spreadsheets/d/1HKr3z-V7VSpyFP3y5D32aigE_o0cwrG7BLPKVo1CnDg/edit?usp=sharing

In google sheet number is added with '+' but it does not show by default, to see that select the cell of number and see it in formula bar above.

Copy workflow from here - https://connect.pabbly.com/workflow/share/XRUCMFMyAisFTwd9VTgFIgsYCj0EWFNpVUVVXF04BUM#
 

Attachments

  • Sourav Copy G sheet Data.png
    Sourav Copy G sheet Data.png
    506.5 KB · Views: 69

nicx

Member
Follow this workflow - It does proper for each number format you gave -

View attachment 1005

You can try by submitting number in different formats in this form - https://fagunshah.in/code/
And see results in this GSheet - https://docs.google.com/spreadsheets/d/1HKr3z-V7VSpyFP3y5D32aigE_o0cwrG7BLPKVo1CnDg/edit?usp=sharing

In google sheet number is added with '+' but it does not show by default, to see that select the cell of number and see it in formula bar above.

Copy workflow from here - https://connect.pabbly.com/workflow/share/XRUCMFMyAisFTwd9VTgFIgsYCj0EWFNpVUVVXF04BUM#


nice info,,

what if I want to replace first string of phone number, usualy 0 replace with country code,, :

0856324234234
to
65856324234234
 
Top