I have a need to develop a relatively simple data entry form to be used on a mobile phone. I can create a suitable form easily in Excel and save it on Google Drive but the dropdown (data validation list) doesn't work. Is there a way of doing it without having to buy a full version of Excel for every user?
I have looked at various commercial providers of forms for mobile phones but none of them are realistically suitable.
Basically what I need is some basic data at the top, (i.e. Name and lunch break mins) and then a small table with about 10 rows and the following columns:
Doing (This needs to be a drop down with about 10 or so choices)
JobLoc (Free text)
Transport (This too needs to be a drop down with about 10 or so choices)
When I get the data I need to enter the data in a job costing program that I plan to develop using MS Access