Search results

  1. Lars

    Scheduled execution also only fires for rows with new values in trigger column, right?

    I've created som Google Sheets sheets with triggers that I've set to scheduled mode, simply because I update the trigger column for a large number of rows at a time and figure that selecting scheduled mode provides more robustness. Maybe that isn't so, but regardless of this, I just want to...
  2. Lars

    Corrupted worklows

    I emailed this to support@ a few days ago. Since i haven’t received a ticket yet (no, not in deleted/spam/junk etc) I’m now posting here, too. And to be clear, I’ve repaired the workflows. What I’m eager to understand is how this could happen and how to avoid future occurrences: I've just spent...
  3. Lars

    SMTP returning error

    Hi, thanks, after updating SMTP configuration it now runs as intended. What I don't understand is why I didn't get any execution error messages.
  4. Lars

    SMTP returning error

    Thanks, after updating the connection today it works again. Strange that I wasn't getting eny errors from this workflow - normally when steps don't work this would trigger an email with an error message. Any idea why?
  5. Lars

    SMTP returning error

    I just discovered that an integration which has been running correctly for a long time is suddenly returning an errorin the SMTP step. So I checked/updated the connection and all the details in the connection form were blank. I then re-entered them and saved, but it still didn't work. So I...
  6. Lars

    Scheduled updates not happening

    Hi, no, no queries in the sheet the values originate from. Not sure what you mean by concern - my problem is that updated values don't trigger syncs from the sheet B as intended. Any changes in a trigger column in a sheet should trigger syncs any time the scheduled hourly checks are performed...
  7. Lars

    Scheduled updates not happening

    Hi, re-raising this topic here. What I need to accomplish is simple enough: sync data from query result in Google Sheet to - in this case - Mailerlite. Since PC doesn't currently trigger on queries of formulas, I'm relying on scheduled syncs instead. Setup works fine, as does test send, but then...
  8. Lars

    Empty cells not syncing

    I just discovered that when syncing data between Google sheets, a cell where a value has been deleted does not get synced, so the old value remains in the target sheet. Process: User updates data via google form Update triggers workflow to update target sheet with corresponding values Updated...
  9. Lars

    Disabled FB leads workflow

    I just received the below for my two FB leads workflows and I don't know how to resolve this without having to remap everything. Is there a better way? I'm posting here because lately the support people at Pabbly have been pretty sluggish in their responses. Thanks, Lars. -- This email is to...
  10. Lars

    Capture change in any column in a Google Sheet?

    Indeed it does! All good - the problem was ind the router conditions, not in the trigger. Thanks :)
  11. Lars

    Capture change in any column in a Google Sheet?

    Oh, ok, I understand the misunderstanding now. Yes, test data sent and received. When I recorded the screen I re-did the dialogues, just didn't send the test data again.
  12. Lars

    Capture change in any column in a Google Sheet?

    What makes you think that? I've done exactly this.
  13. Lars

    Capture change in any column in a Google Sheet?

    https://www.loom.com/share/53d1a8c24c754556b5e086bf8295facb
  14. Lars

    Add or update row in Google Sheets

    I shared the sheet as instructed last Sunday, and of course I'm not checking literals! Before the router comes a Google sheet lookup which return either a row number of key already exists, or zero if it doesn't. QUESTION: Does it return zero or som other value of the row doesn't exist? Can't...
  15. Lars

    Add or update row in Google Sheets

    Hi, starting to narrow this down a bit. It appears that the trigger does appear to fire as intended, but the router at the end of the workflow returns false for both conditions. What I’m trying to achieve is that once triggered, perform a lookup in another sheet for a unique value in the...
  16. Lars

    Capture change in any column in a Google Sheet?

    Ok, så even though an existing forms response is updated, it's counted as a new row? Well, not a problem for me - and I still have the problem that the workflow is not being triggered.
  17. Lars

    Capture change in any column in a Google Sheet?

    And a forms submission that updates the row counts as manual, right?
  18. Lars

    Capture change in any column in a Google Sheet?

    Ok, but the trigger should still fire when a new or updated timestamp is logged vid google forms entry to the google sheet, right?
  19. Lars

    Capture change in any column in a Google Sheet?

    Looks like this was a response ti my original question aboce, and not really helpful since the need remains to trigger based on changes in any column in an updated forms answer. Is there a solution to this requirement?
  20. Lars

    Add or update row in Google Sheets

    Strangely, although setup, test send and submit all returned success messages, this automation isn't triggering. I've emailed your support about this, no reply yet.
Top