You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
I'm looking to create a very basic form/database thing for taking details from visitors on a show stand.
Only needs be very very basic.
Ideally outputting to a local csv xlsx or similar so i can deal with the data easily once I'm back in the office.
I've done similar before on web pages but used an online tool thing from the hosts, in this instance that's no good as it needs to be completely offline.
( way back in the darkest of history i think i coded one or two in php, but it's been so long since i did any of that i can't even think where to start.)
Can anyone suggest a nice easy (and quick) to use application for doing something like this, it's not worth significant time investment at this point
I don't really want something which is imediately visible (i.e. fill in a new line on a spreadsheet for each) so i can hand three device to folks to fill in themselves. As a result a web type form with output to a second file would be preferable.
Form would be something like 5 fields, name, company name, email, post code, interested in.
Any pointers would be appreciated.
Oh Windows 10 based ideally.
Ta.
Multiple inputs to a single off line data source is going to be a challenge - or maybe I've misunderstood?
https://www.typeform.com
https://forms.office.com
Or a customised excel sheet storing to local files which are then merged/synced into a single sheet later.
DPA constraints pointing you offline?
If you could get a very lightweight LAMP server running where you are collecting the data, you could have it online offline and knock something up in php again.
https://play.google.com/store/apps/details?id=com.andi.serverweb
MS access? Unless I've misread this is exactly what you need?
Or something like this off the shelf
http://www.fastfieldforms.com/forms-software.html
I’d pop for MS Access if you could sync in real time, other easier option is an Excel Spreadsheet offline with links to a pivot and output to save as CSV then slammed into MS Access or just piddle around in Excel for whatever results you seek..
Access is probably exactly what I'm after, just fills me with a bit of a shudder (to many years spent using access to do non access things and excel to do access things because "that's the way we've always done it).
Offline requirement is simply connectivity really, can't be sure I'll have connectivity all the time, had zero signal last year at the same show (vanished at the door) then an exorbitant hourly for connection to their (appallingly slow) on-site Wi-Fi.
Will have a look see at access. Ta.
You sound proficient in Access, I’m going to plumb for that option because you know how it works and it’s capabilities.
Keep the form as simple as possible, don’t forget any data stored/used/controlled will need to conform to GDPR Regs from May18.
If it's just lead information, why not just use a CRM directly?
Something like ZOHO should have a mobile app which can work without network connectivity.
Bingo - https://www.zoho.eu/crm/help/mobile/
Looks like Dynamics 365 will also do it, not sure on pricing though.
That’s a marvellous app !
Access works offline, or it used to.
Access works best offline really. You should be able to save to CSV or Excel. There are a lot of built in database templates that may already do what you need as well if you take a look