Sir, please try our product Clappia (www.clappia.com). You are right that you need IF, ELSE etc. You can use the formula syntax of Excel sheet and you can still manage without learning any new coding script. That's what we do.
We have a similar concept but with frontend and permission as well. The backend is automatically created based on what is defined in the frontend. Makes it more of a business tool than a developer tool. For developers, we have CRUD APIs. APIs make it useful to collect data from different hardware devices.