A colleague has a home-grown application in Google Documents, that involves users filling in a form, alternative questions being asked depending on what the answers are, and then outputting a recommendation based upon the values entered.
More people are using it and the 'business value' is in the logic in the calculations themselves. He wants to move from this spreadsheet approach to something more robust where he can store their data (e.g. in a relational db) and extend the logic and workflow of the application.
He isn't 'technical' as such and the investment in learning a full-scale programming language and all the related topics (e.g. data modelling / how HTTP request and response works etc), so suggesting rewriting in PHP / ASP.NET etc. isn't attractive and equally he can't currently afford to employ someone to do this.
Is there a middle ground anyone can recommend that is a step up from effectively working in an online spreadsheet, with more flexibility etc. without having to go all the way into becoming a programmer?
It seems like a fairly large gap between business users being able to create applications in spreadsheets, to the IT department programming a proper web-application, so I hope there may be some 'application creator' tools that try to fill the gap?
The main option I've found so far which appears to meet this need is Zoho app creator https://www.zoho.com/creator/ I haven't used this before, so would be interested in any advice on this too.