• 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 $249 — View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249 — View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249 — View Offer

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

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.

    This way does not cost a task!
  4. 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}")
  5. Stuart

    mySQL multiple queries

    That is unfortunate, but thank you anyways.
  6. 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...
  7. 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.
  8. Stuart

    mySQL multiple queries

    I have tried it and get an error like this, even though each statement by itself works
  9. 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...
  10. 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!
  11. Stuart

    Google Sheets lookup column with supporting column

    That's pretty disappointing, I see there that someone requested this feature and was turned down.
  12. 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...
  13. 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
  14. 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...
  15. 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!)...
See more
Top