• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

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: 147

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