May 6th, 2015, 11:28 AM
Hello Ricardo -
Have you installed FormTools and begun to use it ? The installation instructions in Documentation explain how to install it on a web server so that its form data will be linked to your MySQL database on that server. At that point, the form data is stored in tables inside the MySQL database you specified during installation.
Regarding integration of forms and the MySQL database into other applications, I often use Microsoft Access, installed on my clients' workstations, as an additional ODBC front end for the Form Tools MySQL form data, to quickly and easily generate user reports in a WYSIWIG environment, and to establish relationships between, and report on, Form Tools data and add that data to information gathered from other sources.
Regarding your question about multitable forms, by using the Hooks Manager (and lots of custom coding embedded there) with Form Tools internal forms, I can both pre-fill, and post-fill forms with data from other internal forms. So, in that way, yes it is possible to generate a multitable form -- meaning one form that pulls in data that has been entered in other forms, and that can even modify data entered in other forms. It does requires the use of both php and html, along with some skill in software and database design concepts, but it can be done.
There are many tips and solutions on this forum, but I have discovered it often takes reading through many posts to locate clues that lead me to answers
, so be patient and search and read. I wish you happy researching !
Have you installed FormTools and begun to use it ? The installation instructions in Documentation explain how to install it on a web server so that its form data will be linked to your MySQL database on that server. At that point, the form data is stored in tables inside the MySQL database you specified during installation.
Regarding integration of forms and the MySQL database into other applications, I often use Microsoft Access, installed on my clients' workstations, as an additional ODBC front end for the Form Tools MySQL form data, to quickly and easily generate user reports in a WYSIWIG environment, and to establish relationships between, and report on, Form Tools data and add that data to information gathered from other sources.
Regarding your question about multitable forms, by using the Hooks Manager (and lots of custom coding embedded there) with Form Tools internal forms, I can both pre-fill, and post-fill forms with data from other internal forms. So, in that way, yes it is possible to generate a multitable form -- meaning one form that pulls in data that has been entered in other forms, and that can even modify data entered in other forms. It does requires the use of both php and html, along with some skill in software and database design concepts, but it can be done.
There are many tips and solutions on this forum, but I have discovered it often takes reading through many posts to locate clues that lead me to answers
, so be patient and search and read. I wish you happy researching !