Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • How do I select a table when connecting JotForm to SQL when no table is available?
Best answer

How do I select a table when connecting JotForm to SQL when no table is available?

X

Currently using Jotform to capture information for 3rd party database.

The configuration between Jotform and SQL via Zapier has been done. 

 

Currently face a challenge when selecting a table the is No choices available. 

 

Could someone please assist if they have had this challenge before and what needs to be done next. 

 

Please 

 

Thank you

Best answer by RALaBargeBest answer by RALaBarge

Hey there @XsourceIT !

If you open a ticket with our support team, we would be happy to take a look directly at the Zap and the logs we have to see if there are any hints we can give you.

I can say that if you are not getting an error back from us, that is a great first step!  That means your SQL account is working and we are able to talk to your server.  If this is indeed the case, then it could be a permissions or misconfiguration issue on your server.  


I do see that we have answered a similar topic in the forms and we decided the best answer there as well was due to a permissions issue: 

https://community.zapier.com/how-do-i-3/mysql-tables-not-showing-up-1057

I would say if the above link does not help you, please move forward with opening a ticket with our team @ http://zapier.com/contact-us and we can look at more specific data from your account!

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

MohSwellam
Forum|alt.badge.img+8
  • MohSwellamZapier Expert
  • Zapier Expert
  • 840 replies
  • October 5, 2022

Hi @XsourceIT , 

 

Can you share screenshots of the current setup please? 

 

Also, this wasn't the case before but it is happening now? i.e.: the zap was working fine but no longer is? Maybe there is a change in the DB? 

Founder of GeekyAir.com
X
  • XsourceITBeginner
  • Author
  • Beginner
  • 2 replies
  • October 5, 2022

Hi 

 

Please see the screenshot below 

 

The Zap has not been created as yet , This is the setup stage. 

MohSwellam
Forum|alt.badge.img+8
  • MohSwellamZapier Expert
  • Zapier Expert
  • 840 replies
  • October 5, 2022
XsourceIT wrote:

 

The configuration between Jotform and SQL via Zapier has been done. 

 

Im referring to this part, you did not do this part yet? 

Founder of GeekyAir.com
X
  • XsourceITBeginner
  • Author
  • Beginner
  • 2 replies
  • October 5, 2022

Hi 

 

This is not complete as the im not able to select a table and there is not viewable tables. 

 

What should i do next ?

R
Forum|alt.badge.img+7
  • RALaBargeZapier Staff
  • Zapier Staff
  • 102 replies
  • Answer
  • October 7, 2022

Hey there @XsourceIT !

If you open a ticket with our support team, we would be happy to take a look directly at the Zap and the logs we have to see if there are any hints we can give you.

I can say that if you are not getting an error back from us, that is a great first step!  That means your SQL account is working and we are able to talk to your server.  If this is indeed the case, then it could be a permissions or misconfiguration issue on your server.  


I do see that we have answered a similar topic in the forms and we decided the best answer there as well was due to a permissions issue: 

https://community.zapier.com/how-do-i-3/mysql-tables-not-showing-up-1057

I would say if the above link does not help you, please move forward with opening a ticket with our team @ http://zapier.com/contact-us and we can look at more specific data from your account!

Terms & Conditions