• 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.

Verify or update phone country code for WhatsApp.

Gil

Member
Our lead capture form collects country and WhatsApp number onto Google sheets but some people forget to put the country code as part of the WhatsApp number entered. Has anyone created a workflow to lookup the country code and verify that it is correct or add the missing country code before being sent to WhatsApp?
 
P

Pabblymember11

Guest
Hey @Gil

If your audience is from the same country then you can use the following spreadsheet formula.

Kindly try this on your end and let us know how it works for you.

CONCATENATE('+91',(right('2. Result : +37067400200',10)))

1668754736866.png
 
Top