2. PHPRunner General questions
  3. tool for offline/online forms that write data to MySQL or REST API
This topic is locked

tool for offline/online forms that write data to MySQL or REST API

 		9/21/2023 05:54:16
PHPRunner General questions
mbintex author

Hi
has anybody ever searched or better found a tool that is able to build
flexible forms
mobile apps
and is able to save the data offline and synchs data to MySQL or REST API?
Plus it should be affordable ... :-)
And a big plus would be if normal users would be able to build the forms.
Solutions like MS Forms and Google Forms miss the ability to save to MySQL without Plugins or Zapier automation and don´t build mobile apps.
Jotform only exports SQL code, but does not write to the database.
Typeform can only do it via Zapier where MySQL is a premium feature, which doubles the price
...
Idea is, that customers using my solution could build their own custom forms and send the data fetched to it.
Sergey Kornilov admin 9/21/2023

Forms template?
https://xlinesoft.com/forms
mbintex author 9/21/2023

Sadly PHPRunner does not generate mobile apps nor do we have an offline/synch capability. And I guess this is true for the forms template too.
mbintex author 9/25/2023

If anybody is interested.
To my searches
forms.app
is the most interesting:

  • there is an app which you can use offline


  • nice editor for forms


  • hidden fields to populate database user fields etc.


  • you can use Webhooks to save data to your PHPRunner solution without extra cost


  • if you prefer, you can use the Zapier integration to talk to your MySQL database directly


  • there is a free account, which is enough for seldom usage, and full accounts aren´t that expensive


  • it is not only English language
fhumanes 9/25/2023

Thanks for sharing.
fernando
S
 		salus2 9/25/2023

You can also use Excel, Sheets, or Acrobat forms to interact with SQL databases or REST APIs using either PDO or cURL.
Forms that can calculate can communicate, using native functions to format, validate, merge, and send user-supplied parameters to PHP scripts that interpret the parameters, execute queries based on the parameters, filter the responses, and return the results to specified form fields in real-time.
Also, PHPRunner can generate mobile interfaces, examples at https://customdataservices.net/mobile_sql_applications_list.php
fhumanes 9/27/2023

Hello,
To create very powerful forms and be able to save them in JSON format, I have tried Surveyjs https://surveyjs.io/
It is impressive what can be fossed with him.
If you want to see my example, you can access it in: https://fhumanes.com/blog/integracion/gestion-de-encuestas-integracion-surveyjs/
Greetings,
fernando