![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/04\/imx01-1024x622.jpg\")
<\/p>\n<\/p>\n
I had a couple of attempts at creating a mobile phone app for surveys. See this post<\/strong><\/a> and this one<\/strong><\/a>. I got distracted by the CRUD process and let it rest for a while.<\/p>\n Whilst looking for some Python Mapping tools, I came across this article<\/a><\/strong> regarding capturing GPS data and was taken with the free EpiCollect<\/strong><\/a> tool. I thought I’d give it a try. I had seen a few other app builders on the web but they were paid ones. This one is free.<\/p>\n I found these videos on YouTube demonstrating the app:<\/p>\n https:\/\/www.youtube.com\/watch?v=yVq3yR-5YmE<\/a><\/p>\n https:\/\/www.youtube.com\/watch?v=PomxKYAKDig<\/a><\/p>\n Also there is a new version out, EpiCollect5<\/strong><\/a>. This is the one that I have tested.<\/p>\n The Mobile Apps are available for free for Android from Play Store or Apple from their store. The surveys from your Mobile can be done off-line and the data sinc’ed to the web later when you have wifi, or you can do it live and use 3G or 4G.<\/p>\n If you have a windows tablet you will need to be on-line and do it on the web page directly.<\/p>\n You need a Google Account to be able to use the programme. And you need to log in. No major drama with setting up an account.<\/p>\n You then CREATE A PROJECT and then build forms. The Interface is pretty sensible and doesn’t take too much clicking around to find what you need.<\/p>\n When you create projects they go into a folder called My Projects (based on your login)<\/p>\n Clicking on the top project takes you to a dashboard about it.<\/p>\n On the left it gives you options for:<\/p>\n I haven’t explored API but you can only use it for GET requests.<\/p>\n On the right it shows the settings of the project, in this case it is a private project & not accessible to the public). The Status you can change to Trash and delete the project.<\/p>\n If you click on the LINK<\/strong> in top left Corner where it say’s project Homepage<\/strong> this will take you to: Where you can click on the left green button (Details) and be taken to the dashboard of the image 2 above, if you click on the right green button (View Data ) It will take you to the TOP level of your Data.<\/p>\n Here I only have one building with rooms (children data sets) off this parent Data. You can see that you can edit or delete this data, you can also download it or view it as a table or map. Hitting the Exit button takes you back to the overview of the project.<\/p>\n The child form that I built is Room Data and here I have 3 entries.<\/p>\n The Key to the process is the FormBuilder.<\/p>\n <\/p>\n In this project I wanted to capture, on the FIRST form Building Address, GPS data and some other Data about the building.<\/p>\n I chose from the palate on the left the type of information I wanted to have inputted with some explanation.<\/p>\n After gathering data about the building I wanted to go into the rooms within the building and gather specific data about each room. So I made the Room FORM a CHILD FORM of the building. I then stuffed it up and made Exterior FORM a child of Room, that should have been the other way around. I will have to redesign the form for that.<\/p>\n So after setting up the project Form you now go and test it on your Android or Apple App.<\/p>\n <\/p>\n As you can see, all of the Form Inputs that were built come out onto the App.<\/p>\n One the rooms are surveyed and when you have wifi you can sync your data with the web.<\/p>\n Once that is done, you can go and view your data on the web on the map<\/p>\n or else you can download to CSV or JSON<\/p>\n Now data comes out as a CSV file per form. So for this I ended with 2 CSV files, one for the Building Data & One for the Room Data.<\/p>\n This is Building Survey Data.CSV. The Parent Level of The Data showing Building address etc. Column 1 has UID (unique Identifier ) of this object Data<\/p>\n This is Room Data.CSV. The CHILD Level of The Data showing information about each room of the Building etc. Column 1 has UID (unique Identifier ) of EACH Room. The 2nd Column has the Parent UID (of the Building). So the parent UID links the 2 tables.<\/p>\n So you have to do a JOIN to link the 2 tables of data.<\/p>\n I may think about writing a Python Executable to take the 2 CSV’s and join them. For another time.<\/p>\n You can update the forms mid survey (to an extent) and then add the rest of the data into the fields that you missed on the initial survey.<\/p>\n Also , you can edit on the web page, so if you have gathered further data (eg in comment box) then you can edit that in the web page later.<\/p>\n I am looking to find a tool that will let you cascade<\/em> your questions, like:<\/p>\n Wall finish, Pick one:<\/p>\n After you have picked one you then want:<\/p>\n What is its condition? pick one:<\/p>\n After you had picked a condition then:<\/p>\n How many years remaining from Baselife of element?<\/p>\n (it would be good if you could actually put in a number)<\/p>\n So a specific element can have a condition and a remaining baselife (so you can calculate its condition year on year as per this post<\/a><\/strong>)<\/p>\n Using this tool you can have your building, then the rooms are “Children” of the building, and you can loop through the rooms by creating as many as you wish.<\/p>\n Then to drill down to the next level where you want :<\/p>\n Wall\/Floor\/Ceiling Finish and a condition and remaining life for each, you can put these in as individual groups. Which is good.<\/p>\n But, with this tool, you cannot put a group within a group. So it only has a certain strength for drill down. So I looked at using ODK as an alternative to this tool. Its formbuilder uses Excel spreadsheets and is a bit more flexible. I write about this tool in another post.<\/p>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/04\/imx36-1024x627.png\")
<\/p>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/04\/imx04-start-1024x617.jpg\")
<\/p>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/04\/imx06-1024x285.jpg\")
<\/p>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/04\/imx07-1024x350.jpg\")
<\/p>\n\n
![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/04\/imx05-1024x495.jpg\")
<\/p>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/04\/imx037-1024x157.png\")
<\/p>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/04\/imx02-1024x294.jpg\")
<\/p>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/04\/imx08-1024x458.jpg\")
<\/p>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/04\/imx09-1024x540.jpg\")
<\/p>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/04\/imx10-1024x542.jpg\")
<\/p>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/04\/imx11-1024x566.jpg\")
<\/p>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/04\/imx20-512x1024.png\")
<\/p>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/04\/imx24-512x1024.png\")
<\/p>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/04\/imx23-512x1024.png\")
<\/p>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/04\/imx22-512x1024.png\")
<\/p>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/04\/imx25-512x1024.png\")
![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/04\/imx26-512x1024.png\")
<\/p>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/04\/imx27-512x1024.png\")
<\/p>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/04\/imx28-512x1024.png\")
<\/p>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/04\/imx29-512x1024.png\")
<\/p>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/04\/imx30-512x1024.png\")
<\/p>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/04\/imx31-512x1024.png\")
<\/p>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/04\/imx32-512x1024.png\")
<\/p>\n<\/p>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/04\/imx03-1024x321.jpg\")
<\/p>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/04\/imx37-1024x193.png\")
<\/p>\n![\"\"](\"https:\/\/max-drake.cc\/wp-content\/uploads\/2018\/04\/imx38-1024x220.png\")
<\/p>\nTesting<\/h3>\n
\n
\n
\n
Comparison with ODK<\/h3>\n