8/10/2023 0 Comments Web form builder sql server![]() again reliance on one person for support and the timezone issue (especially from Australia) but again, I have to stress that Matt is very helpful and will hopefully stick around for eternity!Īs far as I could find, there is definitely not a direct migration path from Access to Web/PHP. it also helps to know JavaScript as you can do a lot more customisation with this I am still learning this and it's a struggle, but again Matt has been very helpful with this. it really does help to know PHP, especially the debugging process. a steep learning curve, with a lot of fields, attributes and features to learn (this would be easier if you already know some PHP) They have 2 purchase options - either cloud-hosted by them at a cost of $USD12 per month and only $5 for the first month, which makes it very affordable to trial or a self-hosted version for USD$110 once-off for life, for 2 domains, including all upgrades! This is almost unbelievably affordable. it is extremely cheap for what you get. I also had a couple of video calls with him and he was very responsive and helpful. although there are no support forums and I've only ever had contact with the chief developer/owner (Matt), he is very responsive and always got back to me within 24 hours, and his usual method of answering questions is to upload a YouTube video specifically addressing those questions. plenty of sample applications and a lot of documentation, although some of this is incomplete, also a lot of video tutorials you can white-label a solution quite easily But I could migrate to SQL Server later if I have the need. I decided on the MySQL back-end, at least for the trial, as it is free. integration with SQL Server and MySQL and a few others (including MS Access via ODBC) - I found their solution to this to be far above any others that I tried so this was the one killer feature. (I also researched a lot of other options, including Wordpress with various plug-ins, ADOBE forms, FastField, Formstack, Paperform, Outsystems, Pabbly, Pronto Forms, Typeforms, Wufoo, Zoho but none of them ticked all the boxes for various reasons.) This is a low-code, very powerful tool that provides a lot or wizards and builders, and generates the PHP-coded pages for you. ![]() RackForms - a nice package with a complex but feature-rich IDE, built-in syncing to SQL Server or MySQL and VERY affordable. Alpha Anywhere and Alpha Transform - again a lot of power but quite expensive ![]() ![]() Frevvo - very good product, had local support, no support for off-line forms which could be an issue in low-coverage areas, otherwise probably would have been my choice Flowfinity - again very powerful, they said they could provide 2-way database syncing but could not show me an example of such a scenario Snapforms - similar to JotForms, Australian and browser-based but SQL connection was going to be expensive to setup But users had to install an app to run the forms so it's not available simply through a browser. Very powerful, lots of features and very good local support. Appenate - another web-forms tool, similar to Jotform. JotForm - probably the most popular webforms solution, no code, with many APIs and sync options BUT no direct syncing to a SQL database (otherwise this would have been my choice) Azure logic apps - was recommended by a MS partner dev house that I knew and it has built-in syncing with Azure SQL DB but the licensing and subscription costs would add up and possibly price me out Microsoft PowerApps - much more complex than Forms but requires a license for each user and an app to run Microsoft Forms - was too basic and required an MS license to develop I trialled a whole bunch of packaged solutions, which I will list here: And of course it had to be as cheap as possible, especially during the start-up stage for my client. And we needed to host it locally in Australia, either on-prem or on a local cloud hosting platform (due to privacy regulations), and preferably with local support within Australia. And it had to be able to be white-labelled so that my client could package up their application to sell it under their own brand. So this would be a de facto replacement for Access on the Web.Ī couple of other restrictions: users would be scattered far and wide and not only be part of one enterprise and I wanted to keep it self-contained as much as possible, meaning not having to use any connector tools such as Zapier, Automate.io, REST API etc. Just to remind you, I was basically looking for a low-code/no-code solution that would work with a web front-end, to have users fill in forms through their browser and to have data syncing back-and-forth, as directly as possible, to a SQL database, preferably SQL Server. Hey gang, 3 months later I thought I'd come back and share my experiences with this little project.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |