Home
Get Help

Get Help

Find answers to your questions. Ask the Community for help or hire someone to help you.

29141 Topics

Recently active

Most replies Most views Newest first

DanversZapier Staff

posted in How Do I

What different ways could you create a lookup table?

The lookup table function in the Formatter by Zapier app is super helpful for creating lookup steps (check out this help guide if it's new to you), but it has its limitations. Users will sometimes want to create a lookup table that will need to be updated frequently, or they might want a lookup table that will need to be used for more than one Zap. Have you found different ways to create Lookup tables that get around these limitations? Does anyone have a lookup table that can be updated via Zap, for example?

12056

5 years ago

jesseArchitect

asked in How Do I

Help crafting an Airtable search formula in my Zap

Hey team!I am working on a Zap and trying to use a search formula to be able to find a phone number when there are multiple phone numbers in a cell. These are text strings and not linked records as I know linked records are identified by ID. Forewarning, I'm terrible with crafting formulas!Here is where I'm at with the formula:Here is the formula in textual format if you want to play with it:=IF(ISNUMMBER(SEARCH({{68474804__fromPhoneNumber}},{Client phone for Zap})),{{68474804__fromPhoneNumber}},"False")Basically, what I want to happen is for the search formula to look at a comma-separated list of phone numbers, see if the phone number from Ring Central is in that list and if so, return the number.Here are some modifications/things I know that need to change:Airtable doesn't seem to support ISNUMBER so that will have to be removedI actually don't care if the phone number itself is returned. Returning "True" or "False" will work just fine.Maybe @O

351010

5 years ago

AndrewJDavison_LuhhuZapier Expert

published in How Do I

Paid Work Offered: Build a JotForm -> WorkflowMax zap (WorkflowMax not currently on Zapier)

We received the following inquiry, but we don't build custom integrations, so I'm posting their details (with permission). If anyone is keen for the work, please contact Chris directly to discuss===Name: Chris DrinkwaterEmail: chris@rspartnership.co.ukWhat do you need help with?: I would like a quote for a connection between something like JotForm and Xero Practice Manager (WorkflowMax) so that the onboarding of new clients doesn't involve multiple duplicate entries. If possible I would like additional advice as to how to get other softwares to become apps on Zapier so that we can further automate things.===

55983

5 years ago

MartinewskiTinkerer

asked in How Do I

Searching for multiple files in Google Drive and retrieving the list

I have a workflow where I search for the title of a file in Google Drive. The search results in multiple files (which is correct) and I have to look at all of them and their parent folder name.It would be a lot easier if I got an email with a list of results and their (and their folder) links.Is this achievable using Zapier? The Find File action gives me one result only.

2-Step Verification Text Forwarding

I’m working with a company that has 2-step verification setup on quite a few systems using a specific phone number that each employee does not have access to. This same company also uses Slack internally. Is anyone aware of a method to create a phone number that can be used as their primary 2-step verification phone number and would then have the ability to forward to Slack in a Zap?In a scenario where I attempted to update their Amazon Seller’s account with a Google Voice phone number, it informed me that “this number is not valid”. I then attempted to utilize Twilio… The number was accepted, however the code was not forwarding at all and thus was undetected by Zapier to forward into Slack.

BryanBeginner

Hi, has anybody tinkered with the Facebook Ads API? Looking to collaborate with an expert in this field. Cheers,Bryan

Instagram or Twitter to Wordpress

I can't seem to figure out how to automatically post to Wordpress from Instagram or Twitter. I would like to post the title and image to my wordpress website. The image inside insta or twit post woukd be the featured image. I can't believe its not a standard Zap... Maybe Im blind ;) Any tips or tutorials for this? Thanks in advance.

2142

5 years ago

AndrewJDavison_LuhhuZapier Expert

posted in How Do I

Paid Work Offered: PayPal IPN / Shopify woes

Hi fellow @expertsI have a client he sells through Shopify and customers pay with PayPal - but he can't get PayPal to trigger in Zapier due to the IPN being overwritten.He's been given this solution by PayPal:This is out of my expertise, but if anyone else thinks they can help him he's asking people to contact him directly at:tom+zapiertask@masteringthemix.com

671110

5 years ago

VeraZapier Expert

asked in How Do I

How to populate rows in Google Sheet with the same value without using code?

Hi everyone,I’m receiving data that is in line item format, and one is just a single value not in line item format, when I write these line-items to google sheets I want each row to contain the value from the single value, not just the first row. How do I do this? And no I do not know how many line items there will be, sometimes one, sometimes 50.Thanks!

A Zap to connect Gocardless with ActiveCampaign

HiI am looking to source development of a Zap to connect Gocardless with ActiveCampaign.Thanks, Neil.

Is there a way to merge paths back together?

Does anyone know how (or if it is possible) to rejoin paths?For example, a person signs up on one platform (a survey, a webinar, a whatever) and I want to add them to a CRM but I first have to check whether they are in the CRM or not. If they aren't they have to be added (and possibly have some initial tags added that someone already in the CRM would already have) so I split the path in two. But after that I want execute the same functions because I want to record something in the CRM about the actions they have taken.From what I can see I have to duplicate the steps on each path but maybe I am missing something.Maybe it is possible to simply call another Zap from the first one and have the extra functions in that second Zap or simply trigger that second Zap by adding the data from both paths to a Google Sheet and running from there.Any suggestions on how to make this supper simple are appreciated :-)Many thanks in advance.Paul

How Do I Instantly Send Google Sheets Data to Discord?

Hi, I've gotten a connection between Sheets & my Discord server working and the setting is set to instantly send data from a new row created in the Sheet to the server. When I test the connection I immediately get the test message sent to the server, but when I actually input the data in the new row in the sheet it takes 2-3 minutes before the data gets sent to Discord. Is this something that I can't change or is there a way to make the transmission immediate just like the tests are?

5485

5 years ago

NateZapier Expert

asked in How Do I

Can a Zap move into multiple Paths simultaneously?

I'd like all scenarios to continue to Path A but filter Path B and Path C. Is that possible?

6454

5 years ago

MartinewskiTinkerer

asked in Code & Webhooks

Deleting files in Google Drive

Zapier doesn't have an action to delete files in Google Drive. Would it be possible to achieve this using Code?

Can I use Zapier make a login call, receive token, then use that token in a Webhook to POST?

I am working with a new vendor that doesn't have many connections. They have an API and said first I need to make a login call then encrypt the token to make further calls. I need to do a simple pass from an Unbounce form (4-5 fields) into this vendor. I've used Webhooks in the past but normally I pass my credentials in the query string. This is the first time I've needed to do multiple calls into an API.Is there someone here who might be able to help? Or, a blog post you could point me to?Thanks in advance.

18355

5 years ago

AndrewJDavison_LuhhuZapier Expert

published in Code & Webhooks

How to create zap delays of less than 1 minute (between 1 - 10 seconds)

One of the many useful features of Zapier is the "Delay For" step.However, one of its limitations is that delays must be a minimum of 1 minute.In a lot of situations this might be too long, so I got to thinking about a way around this.Once again, a Javascript Code step can help.Reading the documentation, one of the limitations is as follows:Code steps can run for up to 10 seconds before your zap will throw an error. So, what if we just create a Code step that does nothing for 10 seconds, then returns a dummy result?Well, this does the job:var now = new Date().getTime();var millisecondsToWait = 9900; /* i.e. almost 10 seconds */while ( new Date().getTime() < now + millisecondsToWait ){/* do nothing */}output = [{id: 123, hello: "world"}];What this code does is get the current UNIX timestamp in milliseconds, then adds 9900 milliseconds to that timestamp (9.9 seconds).A loop then constantly gets the current UNIX timestamp in milliseconds, and until it equals the previous number (i.e un

88584

5 years ago

AndrewJDavison_LuhhuZapier Expert

posted in How Do I

Any Apify / Parsehub / Import.io experts here?

Hi everyone,I've got a client wants to scrape some data and put it into Salesforce.I’ve got very little experience with scrapers. Anyone have a preferred app for this and any good howto guides?Thanks in advance!Andrew

4414

5 years ago

ChrisPConnector

asked in How Do I

Row not found - Zap Halted notification

I have action steps in some zaps that lookup Rows in google sheets.If the row is not found, the zap is halted.This happens fairly often (it is expected) and I keep getting "Halted notification" emails, which I then have to open to see which Zap halted.I could turn Halt notifications off altogether (it is an account-wide setting), but for some other zaps it is important for me to be notified if they are halted.I could also choose the option "if row not found -> add row", but in this case it is not appropriate.Usually I would put a filter, but in this case the filter would come AFTER the action, so the halted notification is already triggered.Does anybody have a workaround so that "If row not found", it doesn't trigger a halted notification?

Generating a timestamp

Often I have integrations that don't pass on a timestamp but where it is desirable to have on passed through to the next action. I've tried several things using formatter. Nothing worked properly.Does anyone have a quick and easy way to achieve this?Many thanks in advanceP

Clockify's "New Timer Start" and "New Time Entry" triggers have the same behavior

As far as I understand...."New Timer Start" should trigger immediately when Clockify initiates a start timer"New Time Entry" should trigger ONLY when a complete time entry (that is, a timer that has started and ended) is initiated.Currently, "New Time Entry" seems to exhibit the same behavior as "New Timer Start" - shouldn't it only trigger when Clockify's EndTime field is not null?Been spending too much time trying to get this right : I want Zaps to trigger Clockify when TIMER ENDS, so that it will add to my Google Calendar w/ an END TIME so that when Zapier adds to my calendar, it will include BOTH "Start" and "End" time in a Detailed Event. What am I doing wrong?At the moment, this is how I have my zap setupwhen New Timer Started in ClockifyCreate Detailed Event in Google CalendarHowever, when a new Timer Starts, there's technically no End Time. I would prefer my Google Calendar to track my time accurately by

Applying payments in QuickBooks Online

I seem to be having trouble getting the payment to apply to the invoice created in a previous step but within the same zap. I have put in a 1 minute delay between the "Create Invoice" and the "Create Payment" steps. Any tips?

9966

5 years ago

AndrewJDavison_LuhhuZapier Expert

published in How Do I

Paid Work Offered: Zapier/Podio/Infusionsoft/Keap

My agency received the inquiry below (reposted here with their permission). We passed on it because the client can only pay £30/hour, which is quite low for most experts - but if anyone is interested in working with them, please contact Simon directly.====Name: Simon PaulEmail: simon@thepropertypeopleltd.comMessage: We have a number of websites we want to set up zapier with sending email alerts and also putting into google sheets and a crm podio and infusionsoft version of Keap My telephone is +44 7966 134463====

Utilizing email by zapier can you update the from address?

If you are using the email by zapier can you update the email that is represented by the from email?

2611

5 years ago

AndrewJDavison_LuhhuZapier Expert

published in How Do I

I'm noticing a lot of dead end help links in the zap editor

Since the new help centre went live, I'm noticing a lot of the in-editor help links lead to dead ends now.For example:That link used to take you right to the 'Numbers' section on the Formatter help page, but now it just takes you to start of the guide.The REALLY annoying one is this one:It used to lead to a really helpful cheat sheet of how to construct different date formats, but now it's lost somewhere 😕

2982

5 years ago

BlakeBaileyConnector

asked in How Do I

Removing 'Flood Protection' from a specific zap.

As I write this, I'm 99.99% certain the answer is no, but just for fun, I'll ask it anyways. I've built a set of zaps for a client, to allow them to run a variable number of checklists in Process Street, based on the variable number of stores they manage (roughly 1100). The first zap runs based on a schedule, grabs the variable number of stores from a Google Sheet as a single concatenated value, pastes them into another sheet as individuals rows, which triggers the second zap. Because of this, roughly 1100 rows are created each time this runs (once a month). The second zap is then triggered by the new row created, which then takes the data, confirms it via a lookup back to the Google Sheet, and then runs a checklist in Process Street. This is a way to essentially do a loop, on a schedule, for a variable amount of entries containing variable data, using a zap. I'm gonna be making some content around this later. However, the sort of minor issue is that the sheer numbe

9615

5 years ago

1
...
1162
1163
1164
1165
1166

Page 1165 / 1166

Terms & Conditions

Sign up

Already have an account? Login

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.