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.
...
- 51k
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
3
votes
How do I get linked Google spreadsheets to auto-update when 'I am not looking'
I was able to find a way to solve my problem (detailed here) using an Apps Script with a custom function.
If you replace =IMPORTRANGE(spreadsheet_url, range_string) in your spreadsheet with =...
- 442
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
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.
- 41.6k
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 ...
- 41.6k
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.6k
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 ...
- 2,972
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.
- 11
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.
- 659
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 ...
- 2,972
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