Skip to main content

Get Help

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

28685 Topics
A
araffayNew
asked in How Do I
line break (ctrl+enter) messages mapping from slack to google sheets

How do i seperate lines of text that exceed their column width? When editing sheet, one can easily use ctrl+enter to do this, but there are a lot of messages being imported from slack, how do i automize this formation?

1
Troy Tessalone
2 years ago
Z
ZinZapBeginner
asked in How Do I
How to convert list of selected items to boolean field value for Salesforce?

I feel like this should be really easy to do with all of the Zapier formatting functions, but I’m just not getting it and I’m stuck.The source system has a set of ‘add-ons’ that the user may or may not choose (i.e. camp stove, bear spray, chairs, etc.).The data is only included in the connector if the customer selects it, and each are passed as an “item”.  So if the customer selects 12 Add-ons, we get 12 ‘items’, if they choose 2, we get 2 etc.   Each add on has a unique id and a name.  If the user chooses an add-on item, I want to map that to a Boolean field in Salesforce.  So in the example below, since the user chose Bear Spray, I want to mark the corresponding Bear Spray check box field to True in Salesforce.  Any direction is appreciated. The data looks like this: 

2
Z
2 years ago
E
ExotelBeginner
asked in How Do I
Pipedrive - round robin where leads are not distributing evenly

Hi All, I created a zap to distribute leads across our sales team evenly through a round-robin. When I checked this on Pipedrive after a month, I could find that the lead distribution is not happening evenly. It is skewing towards a few sales agents, and some are barely getting any. I set up the zap as belowI’ve Created a zap to distribute leads evenly across our sales team  We have a team of 20 sales agent and have used the appropriate formulaAdded the IDs of our sales agents Mapped the owner to Round robin output Please let me know if there are any errors and how I can rectify them.  

6
Troy Tessalone
2 years ago
P
PeterCeraBeginner
asked in How Do I
How to use Regex to split postcode if no space is provided?

Hi folks, I’ve got a regex expression splitting UK postcodes so I can use just the first half of it in a zap and it works perfectly until someone enters a postcode without a space. The working regex is:(?P<Incode>\w+)(?P<outcode>\s\w{1}\w{2})So OL10 4TQ comes back with OL10 in the incode fine… but OL104TQ doesn’t match.Can anyone help me work out a fix for this or propose a different solution? Thanks so much

3
Troy Tessalone
2 years ago
L
lucasbertramBeginner
asked in How Do I
Create custom Shopify order with Typeform

Hi everyone!I have a Shopify Store and want to sell a custom health product. I need to ask the customer a few questions before I can let him order my product. For that I created a Typeform that he can fill out. The idea is that the customer just answers a few questions to create an account and to get directed to the shopping basket with the product in it. He can then just click order. I on the other side can then see his product wishes attached to the order. Do you know if and how I can make it possible to:1. automatically create a user account from the information the customer provides in the form and then2. somehow attach the product relevant information to the order.

6
Troy Tessalone
2 years ago
T
TGPNew
asked in How Do I
Specific campaigns not showing up when trying to make DRIP zap

I’m trying to make a zap connection from DRIP into TAVE. When someone becomes a new subscriber to our drip email campaign, we then want that person to be put in as a new LEAD in TAVE. It looks like I can make the connection but the only problem is that there’s not an option to choose a specific campaign (we have multiple) 

1
Troy Tessalone
2 years ago
B
ben0632New
asked in How Do I
Is an integration between Capsule CRM and ClickUp necessary?

Hi I have been tasked to explore how to integrate Capsule CRM and Clickup.I understand it can be done with Zapier.But how does it benefit our operations effectiveness and efficiencies?I am using Capsule for CRM activities and Clilckup for projects follow up. I also understand that Clickup has CRM function.Therefore, is it really necessary to use Capsule CRM?Thanks in advance for kind advice.

2
Troy Tessalone
2 years ago
B
B U BhandariNew
asked in Code & Webhooks
How to use webhook to edit list of entities?

I am unable to link webhook with Google Sheet & edit list of entities. Please help me, if anyone knows.

1
Troy Tessalone
2 years ago
V
veetiokNew
asked in How Do I
Possible to create new Google Chat workspaces using Zapier?

we are moving to google chat from slack since we upgraded to google workspace.is it possible to create new workspace with zapier and add correct members to it?it looks like it only allows to choose which workspace to choose from. is there a work around that?maybe i am missing something but in slack it was pretty easy to do that. 

1
Troy Tessalone
2 years ago
J
JeroenNew
asked in Code & Webhooks
Zapier JavaScript not working with (for i=0) loops

Hello,  To cut things short, I am experiecing errors when creating JS for-loops with Zapier Code. I have pasted in some dummydata instead of working with inputData for arguments sake. Whenever I try to run this code, I always get an error that ‘i’ is not defined.  The point is that I am looking for a targetID, given that it matches my originalName. To my understanding there isn’t anything wrong with the code. Perhaps someone could point out what I’m obviously not seeing? Biggest thanks! var originalItemName = 'Banana';var targetItemIDs = [123, 456, 951, 654, 321, 147];var targetItemNames = ['Apple', 'Kiwi', 'Pineapple', 'Mango', 'Pear', 'Banana'];for (i=0; i < targetItemIDs.length; i++) { if (originalItemName === targetItemNames[i]) { var newItemName = targetItemNames[i]; var newItemID = targetItemIDs[i]; return {newItemName: newItemName, newItemID: newItemID } }}Here is a screenshot of the result:  

2
Troy Tessalone
2 years ago
G
GoHoistBeginner
asked in How Do I
Cannot create case in Capsule

Hello Community Great application that we just started using to connect our PayPal activity to our capsule CRM . We hooked up Zapier to our PayPal and Capsule and we can create a new contact in Capsule when we get a payment activity in PayPal, yeah! However, we cannot create a new case in Capsule attached to the contact we created from the same Paypal payment activity.  We get the Zapier error statement “The app returned "party not found".”   We are searching  in Capsule by the payer email,  the search that works in the create contact in capsule in our working zap.  It looks as though Zapier  is telling us that the required name field does not match when looking in capsule.  We do review the historical Zap run and it looks like the fields are correct in the run event.The problem may be is that we do not understand what the required field name refers to, is this the  contact in capsule, or is it the name of the new case in capsule ?Thanks in advance 

8
G
2 years ago
A
Ashley WatsonBeginner
asked in How Do I
Pattern matching from Shopify

Hello,I’m hoping you can help me :)I’m connecting Shopify to my accounting software. All was pretty straightforward, the last thing to get right is the ‘Project’ so I can allocate sales properly.Each product I have has it’s own project and my book keeping software requires each to have a number prefix - e.g. ‘01 Project Name’When bringing a product in from Shopify, the product name doesn’t have the ‘01’ infront of it and so the two don’t match-up. Is there a way to add a regular expression before product name so that I’m able to get everything connected properly?Thanks in advance for your help.Ashley 

23
A
2 years ago
K
kthomasNew
asked in How Do I
Slack automated reply between certain hours

Hello everyone, I’m looking for some assistance on how to use Zapier with Slack to post an auto-reply to any Slack messages posted in a channel between 5pm-8am. Any help or direction on if this is possible and how to accomplish it would be appreciated. ExampleUser posts message in #example-channel at 5:34pm Zapier checks the message and recognizes it was posted between the hours of 5pm-8am Zapier triggers a custom auto-response message to the user in that Slack channel

1
SamB
Community Manager
2 years ago
T
Trade FolkNew
asked in How Do I
Shared SMS apps that integrate with Google Contacts

We have been reviewing SMS Shared text messaging apps such as Salesmsg, Text Magic, Prokeep etc What we are struggling to find is an app that allows us to integrate our google contacts such that we would us in regular texting app into a shared messaging app. We currently use google Messages on the desktop because we deal with so many contractors, but wanted to have a way to centralized those exchanges in one manageable place. that is why we are looking to shared messaging apps but we dont want to lose the integration with google contacts and have to import them all trying to keep them in sync.

1
SamB
Community Manager
2 years ago
C
charlyNew
asked in How Do I
Discord bot icon appears as “null”

Hi, I am not able to display an icon in the bot messages at Discord. I paste a url of the image but it appears “null”. I just want a cactus icon  I saw this but does not solve my problem. 

2
SamB
Community Manager
2 years ago
P
PeterCeraBeginner
asked in Code & Webhooks
Regular Expression - pattern extract based on previous word?

Hi folks, I’m struggling to figure out a very specific regex pattern matcher. I need to extract some question answers from an email job application using the plain text field extracted from the email. These are single word answers as so: This is an employer-written question. You can report inappropriate questions to Indeed through the 'Report job' link at the bottom of the job description. 'Do you have experience providing care in the UK?' Yes This is an employer-written question. You can report inappropriate questions to Indeed through the 'Report job' link at the bottom of the job description. 'What is the first half of your postcode?' Wv12 This is an employer-written question. You can report inappropriate questions to Indeed through the 'Report job' link at the bottom of the job description. 'Do you drive and have access to a vehicle?' Yes This is an employer-written question. You can report inappr

3
P
2 years ago
A
Anai-sBeginner
asked in How Do I
How to create a ticket in HubSpot when a prospect contacts support in Intercom?

Hi everyone,First time creating a Zap so I need a little bit help. I would like to create a ticket on Hubspot each time a Hubspot ‘s prospect contact the support in Intercom. I try to have all the follow informations from the intercom’s conversation: the email content, the hs_user_id of the prospect who contacted the support, the contact owner of the contact in Hubspot, the email subject if there is one and the link of the intercom conversation.Therefore I did this : Is someone could tell me if this workflow is correct ?I also have few issues for action “3.create ticket in hubspot” . I couln’t find the contact owner in the properties settingand when i test my action it creates a ticket on hubspot but when i click on the ticket then i couln’t see all the additional properties to retrieve I set up. Thanks in advance pour those who could help me ! 

2
A
2 years ago
J
jbuttimerBeginner
asked in How Do I
How to set Google Sheets column to be the formula value instead of the formula?

When I create a new row in Google Sheets, I need to set the ContactID to a randomly generated ID, using this formula:  =DEC2HEX(RANDBETWEEN(0, 4294967295), 8) When I use this formula as the value, what gets recorded in the sheet is the formula instead of the VALUE. Is there a simple way to force it to save the calculated VALUE in the sheet?  Thanks!

1
robschmidt
2 years ago
J
jamNew
asked in How Do I
Is it possible to set user-defined object metadata on Amazon S3 uploads?

Amazon S3 support user-defined object metadata when creating S3 objects, but I don’t see that as an option in the Upload Amazon S3 Action. Is it possible to provide custom metadata here? If not, how do I submit a feature-request to Zapier? 

2
J
2 years ago
K
Kalps.bBeginner
asked in How Do I
TeamUp event found but not updated

 I wonder if anyone can help please?I have created a Zap to find an event in my Team Up Calendar - which works fine.It then looks to find a value from an Excel Sheet based on matching a contact name from the Team Up Event - which works fine.It then attempts to update the Team Up Event with a value from the Excel Sheet. I believe it must be finding the event to update, however I get the following error in Zapier which prevents me from creating the Zap successfully.  I cannot therefore update the TeamUp Event.I have recreated multiple access keys i.e. for the TeamUp Calendar, have checked permissions behind those access keys.  Have also created the connection from Zapier to my Team Up calendar multiple times.  Still no joy…  About to give up lol after a few days of trying to do something which feels simple in concept.Please restore my faith lol :-)   I wonder if you can help me please?

1
Troy Tessalone
2 years ago
L
LJParsonsNew
asked in How Do I
Kajabi Grant Access to an Offer action - name and email fields blank

Hello - I am trying to use Zapier to connect a sales page on Leadpages (trigger) to grant an offer on Zapier (action).  I can get the zap to work correctly, but I cannot get the “Name” and “email” fields to populate with information from the Leadpages submission form. How do I do this?  Please help - I’m desperate!Thanks,Leslie

1
Troy Tessalone
2 years ago
A
Anonymous
asked in Troubleshooting
Delay by Zapier is sending email instantly rather than waiting until delay date

Hi,I am trying to create a Zap that sends out multiple reminders for invoices which are Overdue in my Xero account. My idea was to create a trigger for New Sales Invoice using the Xero app.  Then I would use the Delay Until function to schedule when the reminders are sent.  I have loaded the delay until dates into a comma separated list using formatter:  I have then created a loop to loop through the dates:  Within the loop I have created the delay until action:  Within the loop I then create the MailerSend action: This post has been edited by a moderator to remove sensitive information. Please remember to obfuscate any personally identifiable information prior to posting as this is a public forum. When this Zap is run, it sends the same email to the test email address 3 times.  There is no delay applied.  I have received all 3 emails today and no emails have been delayed. Any idea whats gone wrong here? Thanks

1
Troy Tessalone
2 years ago
W
WeyogNew
posted in How Do I
Connecting Sendinblue to update emails in Podia

Bonjour,Je n’arrive pas à faire fonctionné mon zap, je ne comprends pas certaines demandes lors de sa création.Je souhaite seulement connecter PODIA à SENDINBLUE pour update les nouveaux mails reçus sur podia vers zapier mais ca ne fonctionne pas…Merci pour votre aide

1
christina.d
2 years ago
R
RPratesPBeginner
asked in Troubleshooting
Swarm connection error: "the app returned credits exhausted"

My zap “Create event in Microsoft Outlook when new checkin in Swarm” isn’t working. The Swarm connection appears not working. When i try to recconect, i receive a message "the app returned credits exhausted"

3
christina.d
2 years ago
M
MandolynnBeginner
asked in How Do I
Will Zap still run if delay value coming from Google Sheets is changed?

We have a Google Sheet that houses start, end and various other dates for clients (coaching program). From time to time clients must pause or extend their start date. I want to set up a Zap that is from Google Sheets to either mailchimp or gmail that says send an email but delay until X date. X date will actually be fed over from Google Sheets and will be the trigger column. My concern is if the date is changed will that mess anything up? So let’s say I have someone due to start on 12/7 and on 12/6 they say it needs to be delayed a week so I change the date in Sheets to 12/14 will the zap still run ok? 

1
Troy Tessalone
2 years ago
Terms & Conditions