• 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

    Urgent Urgent Urgent !!! Invalid Credentials or Host or Database or Port !!! Again !!!

    We are also having this issue!!! This is not acceptable! The database is working both manually and via Zapier, just not with Pabbly
  2. 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).
  3. Stuart

    convert numbers to ordinal numbers

    use regex to strip out non digits
  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...
Top