R Revisable5987 Member Licensed User Jun 12, 2020 #1 I currently have two applications built in B4A & B4J that work as employee management software, using a SQL database. I'm looking to add a forms feature so that the manager can create a questionnaire on the pc which the employee would then complete on the android app. Obviously I need to avoid the form being coded directly into the app, So would need to somehow load a layout with questions and then be able to save the user inputted data. Similar to the way Google Forms or Microsoft Forms work, but with the ability to store the information on my database. I am looking for any suggestions on the best method to implement it. I'm not necessarily looking for a completed library or anything, rather some advice what method people think would be best to use. I've looked into creating a WebApp then embedding it into my Android app but was hoping for a cleaner solution that I'm possibly not thinking of.
I currently have two applications built in B4A & B4J that work as employee management software, using a SQL database. I'm looking to add a forms feature so that the manager can create a questionnaire on the pc which the employee would then complete on the android app. Obviously I need to avoid the form being coded directly into the app, So would need to somehow load a layout with questions and then be able to save the user inputted data. Similar to the way Google Forms or Microsoft Forms work, but with the ability to store the information on my database. I am looking for any suggestions on the best method to implement it. I'm not necessarily looking for a completed library or anything, rather some advice what method people think would be best to use. I've looked into creating a WebApp then embedding it into my Android app but was hoping for a cleaner solution that I'm possibly not thinking of.
Jeffrey Cameron Well-Known Member Licensed User Longtime User Jun 12, 2020 #2 Honestly, I'd just use Google Forms and display a WebView with the relevant URL loaded. I think Google has an API that you can use: https://developers.google.com/apps-script/reference/forms/ Upvote 0
Honestly, I'd just use Google Forms and display a WebView with the relevant URL loaded. I think Google has an API that you can use: https://developers.google.com/apps-script/reference/forms/
R Revisable5987 Member Licensed User Jun 12, 2020 #3 Jeffrey Cameron said: Honestly, I'd just use Google Forms and display a WebView with the relevant URL loaded. I think Google has an API that you can use: https://developers.google.com/apps-script/reference/forms/ Click to expand... Thanks. From what I can gather using google forms requires a google account which makes it unsuitable unfortunately. Upvote 0
Jeffrey Cameron said: Honestly, I'd just use Google Forms and display a WebView with the relevant URL loaded. I think Google has an API that you can use: https://developers.google.com/apps-script/reference/forms/ Click to expand... Thanks. From what I can gather using google forms requires a google account which makes it unsuitable unfortunately.
udg Expert Licensed User Longtime User Jun 13, 2020 #4 Do you know about FormsBuilder and B4XPreferenceDialogs? Clearly its eventual adoption depends on the complexity of your questionaires, but I personally used it for a Covid-oriented project and it worked well. Upvote 0
Do you know about FormsBuilder and B4XPreferenceDialogs? Clearly its eventual adoption depends on the complexity of your questionaires, but I personally used it for a Covid-oriented project and it worked well.
Indic Software Active Member Licensed User Jun 13, 2020 #5 If your questions are MCQ type it would be possible to build a way to read questions from remote database and show them to user in Android App. I had built one such desktop app long long time back. I don't have access to the data structure at present but I will search for it and post it here. Regards, Upvote 0
If your questions are MCQ type it would be possible to build a way to read questions from remote database and show them to user in Android App. I had built one such desktop app long long time back. I don't have access to the data structure at present but I will search for it and post it here. Regards,
R Revisable5987 Member Licensed User Jun 13, 2020 #6 udg said: Do you know about FormsBuilder and B4XPreferenceDialogs? Clearly its eventual adoption depends on the complexity of your questionaires, but I personally used it for a Covid-oriented project and it worked well. Click to expand... Yes that was something I had considered. Seems like a good idea. Upvote 0
udg said: Do you know about FormsBuilder and B4XPreferenceDialogs? Clearly its eventual adoption depends on the complexity of your questionaires, but I personally used it for a Covid-oriented project and it worked well. Click to expand... Yes that was something I had considered. Seems like a good idea.
R Revisable5987 Member Licensed User Jun 13, 2020 #7 Sor Indic Software said: If your questions are MCQ type it would be possible to build a way to read questions from remote database and show them to user in Android App. I had built one such desktop app long long time back. I don't have access to the data structure at present but I will search for it and post it here. Regards, Click to expand... Took me a second to figure out MCQ But yes, that would be the plan. Maybe I need some sleep before I attempt this ? Upvote 0
Sor Indic Software said: If your questions are MCQ type it would be possible to build a way to read questions from remote database and show them to user in Android App. I had built one such desktop app long long time back. I don't have access to the data structure at present but I will search for it and post it here. Regards, Click to expand... Took me a second to figure out MCQ But yes, that would be the plan. Maybe I need some sleep before I attempt this ?
