• 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

Text replacement

jod.z

Member
When replacing text, do I need to create a separate action for each possible output?

For example, I have a form that outputs:
Shipped to you|5
Pick up in St. Louis Park|0
Pick up at a meeting|0


I want to change it so it just says:
Shipped
St. Louis Park
Meeting


Do I need to create a new action for each of those or can I do all of them in one action?

I've already set up similar actions for another form output, but wondered if it can be combined into one action. I'm just learning the tool and want to know the best way to go about it :)

Thanks,
Jodi
 

Supreme

Well-known member
Staff member
Hey @jod.z

As per your concern. You might need to add new action steps to split the text for each line.

2021-08-12_11h35_38.png
 

jod.z

Member
I'm unable to get it to work. I've got the actions set up, but when it sends to Google Sheets, it's not formatting like I asked it to. Do I need to add the formatting actions before the Google Sheet action? I tried both and can't get it to work either way.

Also, is there a way to send the whole task as a test without actually filling in the form and using up one of my tasks? If I click "Save and Send test Request" on the Google Sheet action, is that just sending to the sheet without doing the formatting steps?

Either way, it doesn't seem to be working for me.
 

jod.z

Member
It's still not working. Maybe I'm not understanding what it's supposed to do. Here's what I'd like to happen:
  1. This form is filled out and a purchase is made: https://mnrovers.org/cycling-jersey-order/
  2. The results are sent to a Google Sheet
  3. On the way there, I'd like some formatting and text changes
    • Date - MM/DD/YYYY
    • Shirt size - only show the size, not the other stuff
    • Shipping method - only show Shipped, Meeting, or St. Louis Park, depending which was chosen
When setting it up and looking at your example, it looks like it's working, but when it's sent to my Google Sheet, none of those actions seem to have come through.
 

jod.z

Member
I've played with it more and I'm understanding better now and have it mostly working. But how can I get the shipping method to work because the text replace/parser/splitter will be different, depending on the option chosen.

Output possibilities:
Shipped to you|5
Pick up in St. Louis Park|0
Pick up at a meeting|0


Should be sent as:
Shipped
St. Louis Park
Meeting
 

jod.z

Member
I understand how it's working for the sizing. But for the shipping option, your example only works if they choose "Shipped to you|5".

Is there a way to say,
if
Pick up at a meeting|0
is chosen
then
replace it with "Meeting"

and the same for the other two options?
 

jod.z

Member
I think I have it working now. I ended up changing the form to these choices:

Pick up (Meeting)|:$0.00
Pick up (St. Louis Park)|:$0.00
Sent to you (Shipped)|:$5.00

So I have something consistent to split:
(
and
)|
 
Top