Recent content by woodennickel

  1. W

    Unable to Connect Gmail

    It is working.. no idea why it took so long to not be greyed but ... hopefully not again for awhile
  2. W

    Unable to Connect Gmail

    Good to know. Just watching a video on what this looks like. thank you.
  3. W

    Unable to Connect Gmail

    I did try that. Now that being said, as I have played with this for the last hour, suddenly the google sign in is no longer greyed out. No idea why or how.. but i think I have fixed it as of a couple of minutes ago. Still to be tested. Thank you
  4. W

    Unable to Connect Gmail

    I have a workflow with the final step being Gmail - sending an email. It has worked fine for 4 months. Today it failed. I tried to update the connection but the Sign in to Google is greyed out. I tried to add a new connection but the sign in to Google is greyed out. I opened both Pabbly...
  5. W

    Routing: Adding a new route - Suggestion

    When we have a route in place with multiple routes, and have it all nicely laid out.. if we add a new route, Pabbly jumbles everything we have done. I think a better option for Pabbly is to not change what we have already laid out. See demo...
  6. W

    GoogleSheets... and a formula

    Got it. I was looking for merge data function in the Text Formatter. What I realized just now is that in the Text Formatter / Split function; in the text field, I can create my URL - merging the constants and variables - AND then do the Replace %20... all in the one step. Which i then pulled...
  7. W

    GoogleSheets... and a formula

    Yes, I understand that. But my URL is currently built just inside of Pabbly Gmail, because I can't use the URL from GoogleSheets. (the formula for each each row would need to be added first, then I could use this and text formatter/replace. Or even easier still, if in Text Formatter... with...
  8. W

    GoogleSheets... and a formula

    What I did is just use pabbly text formatter to pull and split the date into its components of dd, mm, and yyyy Then in gmail for the URL I just referenced all the fields directly in the pabbly gmail. The only problem is that doing this, any spaces stop the URL, as opposed to if they were an...
  9. W

    GoogleSheets... and a formula

    This is my sheet formula: =concatenate(P2,"?eventDate[year]=",Year(E2),"&eventDate[month]=",Month(E2),"&eventDate[day]=",day(E2),"&type=",F2,"&billTo=",G2,"&additionalNotes=",I2,"&meetingHours=",H2,"&comment=",D2) This is the result...
  10. W

    GoogleSheets... and a formula

    Here is the video: https://www.berrycast.com/conversations/ce51aff8-3b36-51c5-a4bd-a182f4928eb1 I think if I could pull the data into Pabbly from Google sheets using Last Row, And then pull apart the date in Pabbly into its components of D, M, Y using Text Formatter, And then concatenate the...
  11. W

    GoogleSheets... and a formula

    I have a form that is capturing data. All of the data is added to the last row in a Google Sheet. What I want to do is use concatenate on that data in googles sheets to join some constants, and some of the variables from the LAST ROW of the googlesheets into one unique URL. Looking online AI...
  12. W

    Microsoft Excel as an Action: Populating using the new beta view

    It is a new connection, just created it. URL is there.
  13. W

    Microsoft Excel as an Action: Populating using the new beta view

    I have used the classic view with excel and been able to map the fields I want to the excel columns no problem, adding a row of data each time. However, I do not understand what this step is in the new beta view. How do we map a field to a column? Listing the data in the order of the columns...
  14. W

    Manual routing

    ahhh.. chatgpt my friend: What I want to is test FIELD1. There is a yes or no answer. 2 routes for FIELD1. But when this is done I want to test both of the prior routes for FIELD2. Again yes and no. So each submission will be tested and actioned for FIELD1 and for FIELD2. But after a...
Top