Skip to main content

Hi,

Sorry if these are sill questions, but while in my trail phase, I have linked an SQL server (TESTInstance) and my TEAM accounts and I am trying to get a chat message to happen when Zappier see a row added to amended in a certain table (MyUsers) ( it is looking at a specific column (Hash) which changes when a row is added or a user updates information) . Zappier tests work, but when I do an actual change to an existing (dummy) user, nothing happens. Polling is set to 2 . I know that changes has happened as a) I did it, b) I can see the details in HASH has changes. Could someone  advise what I am doing incorrectly ? 

Hi ​@GOker 

Help us have more info by posting screenshots showing how your Zap steps are outlined and configured in EDIT mode with the field mappings visible.


Here are the screenshots, thank you :-) so when a change is made, this hash column / cell for the effected row changes. 

@GOker 

TIP: Click field labels that are underlined to see tooltips with more info.

 

Have you tried testing with your Zap turned ON?

Check your Zap Runs history for activity and to see the DATA IN/OUT for each step: https://zapier.com/app/history/

 

Help links for using SQL Server in Zaps: https://zapier.com/apps/sql-server/integrations


ZAP is On. 

I make a change, and i wait 2 minutes. NOTHING. ZAP test when constructing it work, but not IRL .

 


@GOker 

Did you review the help links?

 

Help links for using SQL Server in Zaps: https://zapier.com/apps/sql-server/integrations

 


could very well be this then. 🤦‍♂️ Thankyou :-) 


Hi ​@GOker,
 
We just wanted to see how everything is going with your Zap. Did Troy's recommendation get the job done? Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
 
We're looking forward to your response.


Hi, yes, sorry, Forgot to amend the Ticket.  Basically, the table I was trying to use doesn’t have a DateTime column. 


Wow! That’s good to know. Thank you for confirming that Troy’s resolution got the Zap running. This will significantly help our Community members to have as a reference for the same issue.