EzDevInfo.com

An If-This-Than-That like service fire an HTTP requres triggered by Github Gists

I'm trying to fire a webhook(HTTP request) from Zapier(An If This Then That like service) when a new Github gist is posted, ie have a new gist as the trigger.

Zapier has GitHub integration, and supports webhooks, but sadly does not support gists.

I know there is a work around - create an RSS feed for the gists and use that as a trigger, but I'd prefer not having to do that.

Is there a way I can do this with Zapier, or if not, are there any other web-services/apps that have a similar functionality?

Microsoft Lync Integration w/ IFTTT or Zapier?

I'm running Microsoft Lync for Mac (v14.2.1) on my work computer, where I do not have admin privileges. [NB: I think Lync is being renamed Skype for Business.]

Lync should save conversation history, but it seems quite spotty and misses a lot.

Does anyone know a way to connect my Lync account to IFTTT, Zapier, or a similar service such that all conversations get saved somewhere outside the Microsoft ecosystem?

Splitting Cell information in Google Sheets

I'm bringing in data from WooCommerce into a Google Sheet via Zapier. It's incredibly helpful for most of the data, but there are options I need that come in as 'line items' that are not very user friendly.

I tried a split formula, but the issue I'm having is that if certain selections are not checked they don't show up in the code, so they aren't always in the same order.

This is how the line items come into the sheet:

item_meta: {u'': [u'Set Trip Details', u'45r6tfyg', u'09/28/2015', u'1', u'05', u'AM', u'Pick me up from the address I provide', u'Round Trip $85.00', u'r6ftgyuh', u'09/29/2015', u'1', u'00', u'AM', u'15% $25.50'], u'pa_airport': u'Hou'}

Now since I made the form, I'm familiar with what is what, as well as what is missing, but it will be very hard for my client to use this information on a daily basis to process orders.

Is there any way to separate out the information, as well as use conditional logic to skip cells if certain objects are unchecked?

I know this is a crazy specific question, but any help would be much appreciated!

What is the behavior when Zapier matches more than one row?

Zapier has a Lookup Spreadsheet Row - action.

The docs say "Lookup Spreadsheet Row - Finds a row by a column and value. Returns all the values on that matching row."

What is the behavior if the lookup matches more than 1 row? Which row gets returned?

Zapier/Trello Link Causing Duplicate Cards

I currently have a zap on Zapier which takes Formidable forms entries on my WordPress website and creates a card on one of my Trello boards with the entered details.

There are quite a number of fields and it seems to split the entry over 2 cards on Trello.

Is there a solution/setting that can force Trello and/or Zapier to create a single card only?

Cognito Forms: math & decimal places

Decimal Places
I'm trying to send number data through Zapier, but Zapier does not seem to pick up the 2 decimal places when they are '.00'. In addition, it only picks up one number after the decimal place when the second number is 0.

Here's what I'm doing: form user enters 2 numbers. My form then:

1. Adds these numbers together (SUBTOTAL)
2. Multiplies SUBTOTAL by 0.23 (VAT)
3. Adds SUBTOTAL to VAT (TOTAL)

On Cognito Forms, all of these numbers display to two decimal places (even when they are '.00'). However, when I send the information through Zapier, Cognito Forms appears to have dropped the 2 decimal places if they are '.00', or dropped one decimal place if it is, for example, '.20'.

I have read the support section on math functions and it looks like Math.Round(Number, Number) might be what I'm looking for, however based on the provided instructions I cannot get that to work.

Does anyone have any advice?

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

In Trello, I've got a "Hold until Date" list. These cards have due dates, so all of the data exists such that something could programmatically watch the cards in that list until the due date has passed, and then move the card in question to the "Inbox" list.

Realizing that API programming is off-topic, services like Zapier exist, and even offer the ability to set open-ended HTTP requests. So I'm wondering if what I'm trying to do is possible within the scope of the existing software, and/or what parts might fall outside that scope and be possible with some amount of API programming.

For starters, I've attempted to set up a Zapier trigger that watches cards in a specific Trello list, and can even filter those cards by due date, however, it's unclear if I can set the criteria for that filter relative to the current date. (i.e. Filter when card due date < current date).

In the even that this is not possible within the scope of Zapier's pre-made Trello integration, is this possible within the scope of Zapier's webhook integrations, or does this start to enter the territory of "rolling my own" application server without the use of Zapier at all?

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

My question is similar to this one, for which no answer has yet been posted. How can I get Google Sheets to auto-update a reference to another sheet?

I am filling one Google Spreadsheet with Zapier which creates new rows of data. I then use ImportRange to take that some data from that sheet into another, where it is processed and generates text that I use to send out emails or SMS.

This 2nd sheet is read by Zapier in order to send the email or SMS.

The problem is that the 2nd sheet does not automatically update when I am not logged in an making changes. i.e. importrange() is not updating 'when I am not looking'.

I have both sheets set to refresh every minute and Zapier 'reads them' once every 5 mins (writing to the first sheet, only reading from the second").

I have tried any scripts, although I have tried using the Now() function and concatenate() functions in order to amend the data pulled in by importrange() - which did not fix the problem.

The second sheet is a bit complex and takes time to load.

What is “Error -2” on Zapier

I am trying to set up a zap on zapier.com with a webhook to my own site. However, I am getting the following error:

Bargle. We hit an error creating a post. :-( Error:
-2

I can't seem to find a reference to -2 in relation to Zapier on Google.

I tested my URL on my site and it executes without error.

Does anyone know what the issue is?

Add date stamp when new row added by Zapier

I am trying to add a submission date to column 1 whenever a new row is automatically added through Zapier. Is this possible? E.g.,

 C1                              C2              C3
 (DATE STAMP WHEN SUBMITTED)     John            Smith
 (DATE STAMP WHEN SUBMITTED)     Sam             Hardy

Can Zapier set the Salesforce Owner ID as a Queue?

Importing leads into Salesforce via Zapier.

Owner ID in Zapier won't display the Queue names and you can't enter arbitrary values.

Is it possible to set the Lead Owner ID to a Queue using Zapier?

Averaging the column F3:F breaks as script adds new rows above row 3 [duplicate]

I have Google Sheet connected via Zapier to automatically add a new row to my spreadsheet everyone time someone fills out a satisfaction survey on my website. I have =AVERAGE(F3:F) as the top row to show running averages of numerical values.

Problem is, when Zapier adds a new row, it seems to use the "Insert 1 Above" on Row 3, thus the formula changes automatically to =AVERAGE(F4:F) and the cell outputs #DIV/0! divide by zero error. How to avoid this?

list indices must be integers, not str Error on Zapier

Creating a lead in Salesforce. Get this error.

list indices must be integers, not str

I have tested the steps of the Zap. Re-done each field pulling in Salesforce.

When I google this, it is a Python error, which Zapier uses. Is this something I can fix on my side?

Separate JSON Webhook for Repeating Sections

Due to some limitations of the current Zapier integration I have been forced to use the JSON webhook functionality instead. The way that the repeating section data is presented through the current JSON WEBHOOK function is pretty useless. It would be nice to be able to specify a separate JSON WEBHOOK URL for repeating sections that cognito would send a new hook for each iteration of the repeating section. That would make adding "child" rows in a traditional database format so much easier than how we have to do it right now.

The current setup returns ALL data in that repeating section as one field. For instance, I have a test form with a section called "Children". That section is repeating and has 2 fields - name and sex. So when you pull the list of available fields, it lists "Children" as a single field with all the data like this:

Children: ChildName: A Sex: Male ChildName: B Sex: Female ChildName: C Sex: Other

Wouldn't it be easy to have another hook that would publish each item along with the parent form ID?

processing pre-existing data with IFTTT

How can I get IFTTT to process data that was created in the past?

If I create a recipe to save liked YouTube videos to Evernote, how can I use it to save all the videos I liked before creating the recipe?

Alternatively is there another service that can do that with a similar amount of effort, ie quicker than writing my own python/perl/js script to do it? Maybe Zapier?