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

Format source data to match acceptable form

RAA

Member
Hi Friends,

I have a complicated issue.

When a customer creates an account, I send the information to Google Sheets and then to Chargebee.

The information in Google Sheets needs to be formatted in a certain way so that Chargebee can accept it.
In the image, you'll see the pharmacy name, phone number, and zip codes need to be updated.

What's the best way to automatically update the last three columns before sending it to Chargebee on schedule?


1695910968166.png
 

Himesh

Active member
Hello @RAA You can use number formatter and Text formatter
Text formatter Video reference "
"
Number formatter Video reference "
"
 

RAA

Member
thank you - to format the zip, I wrote an extensive formular.

What is the best way to replicate this in the formatter?

=if(Len(ZIP)<=4,text(ZIP,"00000"),if(len(ZIP)>6,text(ZIP,"00000-0000"),text(ZIP,"00000")))
 
Last edited:

RAA

Member
Here is what I have in pabbly but it isn't working for me.

IF(LEN('7045')<=4, text(7045,"00000"), IF(LEN('7045')>6,TEXT(7045,"00000-0000"),TEXT(7045,"00000")))
You can write javascript to convert the code with the help of "Code" action.
hmmm... can you help me with this please?
 

Himesh

Active member
I'm not coder but yeah you can pass the same query to chatgpt. And chat gpt will give some code snippet to you and you can test that in code action.
 
Top