• 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

Recent content by Stuart

  1. Stuart

    convert numbers to ordinal numbers

    you could do that just change the last line from console.log(result) to return(result) but it is a paid task. you could do it with free tasks but I think it will be 2 steps (split, then regex).
  2. Stuart

    convert numbers to ordinal numbers

    use regex to strip out non digits
  3. Stuart

    How to replace a zero with the number 1, but not in the middle of a number.

    try number formatter > spreadsheet formula IF("{YOUR_NUM}"="0","1","{YOUR_NUM}")
  4. Stuart

    mySQL multiple queries

    That is unfortunate, but thank you anyways.
  5. Stuart

    mySQL multiple queries

    Thank you, however that is a single query inserting multiple rows of data, whereas the ones here are multiple related queries chained together as mySQL allows with a semicolon. where for example I want to insert a new client and case at the same time, but if one should fail the other one will...
  6. Stuart

    mySQL multiple queries

    something else I want to do via mySQL is checklists, that would return back if the list was complete when a check item is marked.
  7. Stuart

    mySQL multiple queries

    I have tried it and get an error like this, even though each statement by itself works
  8. Stuart

    mySQL multiple queries

    a few examples off the bat: 1) where I want either both transactions to succeed or both fail: START TRANSACTION; INSERT INTO table1 (column1) VALUES ('value1'); INSERT INTO table2 (column2) VALUES ('value2'); COMMIT; 2) or in a case where I want to do multiple things with the same data: INSERT...
  9. Stuart

    mySQL multiple queries

    Hi, is there any way to send multiple queries at once, like the way you can do with php or in the 'console' by separating them with a semicolon? There are times that I want to be sure my queries are processed together etc. Thank you!
  10. Stuart

    Google Sheets lookup column with supporting column

    That's pretty disappointing, I see there that someone requested this feature and was turned down.
  11. Stuart

    Google Sheets lookup column with supporting column

    Thank you, However the workaround only works if I want it to return one value and filter it out. my real issue is when i have duplicates of the name, but only one is a client (every new appt adds an entry, some people make multiple appts before becoming a client). I would use a router and...
  12. Stuart

    Google Sheets lookup column with supporting column

    Is there any way to do this, it exists in Zapier! Basically, I want it to only return the matched value if another value matches too. kind of like if Name = John Doe & Status = Client so if there is no john do or if he is not a client it will not return it
  13. Stuart

    re-execute workflow in the workflow

    Hi, Any way to re-execute a workflow automatically triggered by the workflow in question? for example, look up if a client is in a crm and a router after that, if client is in the crm then continue the workflow, if not add the client and start the workflow over. Otherwise I would need to make a...
  14. Stuart

    strange code error

    hi @ArshilAhmad ! its not really the workflow, which is working fine. I just thought someone should be aware of it. the error is in the log and not affecting functionality. however, I cant really test it many times anymore because the code sends some webhooks out (to pabbly, not to shopify!)...
Top