Hot answers tagged

6 votes
Accepted

Trello/Zapier: Move card to list automatically on due date

Using the Trello API, I created a bot that can do exactly what you want (and a lot more). It's been running for a while with very satisfied users (see this reddit thread). To use it, you invite user "...
  • 381
5 votes

Automatically post to Instagram from Twitter / Facebook / Tumblr post?

Unfortunately, the Instagram API does not allow for posting to Instagram. It can only be used to get information from Instagram. That's why IFTTT and Zapier aren't going to be able to help you here. ...
  • 51.4k
3 votes

Add date stamp when new row added by Zapier

If you want to include the time your Zap runs in your Zap (or use that as an approximation of when the trigger occurs), you can use the following field in your Zap: {{zap_meta_human_now}} Just enter ...
  • 31
2 votes

Splitting Cell information in Google Sheets

Google Sheets has the SPLIT() function that makes it very easy to split string including separators, but you could avoid this step and directly use SEARCH() to find if an element (string) is present.
  • 42.4k
2 votes

How do I get linked Google spreadsheets to auto-update when 'I am not looking'

You can also use IMPORTRANGE in a conditional formula always TRUE : =if(now()>0;IMPORTRANGE("1IyAx_*****************************************Lza5x1iVfs"; "Masterlist!AT1:TA39");"CRASH") Plus you ...
  • 21
2 votes

What is “Error -2” on Zapier

For me the problem turned out to be that my copy and paste of the URL into Zapier had white space in front of it. Pretty hard to see unless you are looking for it. I wish Zapier did an auto trim(), ...
2 votes

list indices must be integers, not str Error on Zapier

This was a temporary bug that has since been fixed. You should be able to replay any tasks that failed due to this error.
  • 21
1 vote

Catch New Rows in Existing Filter Views

AFAIK at this time the Google Sheets UI doesn't include a option to set filter views to update its range automatically for appended rows but this occurs if the new rows are inserted between the first ...
  • 42.4k
1 vote

How to synchronise a folder from GitHub repository branch upon commit to a Dropbox directory?

Have you tried: https://github.com/anishathalye/git-remote-dropbox ? A transparent bridge between Git and Dropbox - use a Dropbox (shared) folder as a Git remote!
  • 11
1 vote

I need help with sorting query in Google Sheets

It seems you are sorting a single column when you need a pair to be sorted together. Taking what is on the left and clicking Sort as shown should return the order as shown on the right:
  • 16.9k
1 vote

Mathematics and decimal places

In this case, the issue is more with how Zapier handles the data sent from Cognito Forms than with Cognito Forms itself. All data sent via integrations, such as Zapier or JSON webhooks, is sent as ...
  • 3,002
1 vote

Can Zapier set the Salesforce Owner ID as a Queue?

Yes, go to "Use a custom Value (Advanced)" and provide your Queue id, starting with 00G I think.
1 vote
Accepted

What is “Error -2” on Zapier

I found the solution. I had entered my URL without http:// in front of it. Works fine as long as I put http:// in front of the URL.
1 vote

Separate JSON Webhook for Repeating Sections

Cognito Forms allows you to post a JSON document to webhooks when new entries are submitted that accurately reflects the data being collected. Forms can be hierarchical with multiple repeating ...
  • 3,002
1 vote

Trello/Zapier: Move card to list automatically on due date

It doesn't look like you can specify a dynamic date (like "current date") for the Zapier editor custom filter section, but you could make sure that the due date "exists" and only process those cards. ...
  • 111
1 vote
Accepted

Google Spreadsheets and Zapier

I'm not sure exactly how you're pulling in the Master Sheet info to the Client Sheet, but to help with some background, when your zap adds a new row to a spreadsheet, it's literally creating a new row ...

Only top scored, non community-wiki answers of a minimum length are eligible