Looking for a form app that can export to Access/Excel

Mcclure · 10:48 PM

I work for a school that is looking to have a quick form that administrators can fill out on iPads. They want to have the teachers name in a drop down (about 30-40 teachers, this is needed to remove any chance of spelling errors) along with having date/time. Then there will be 40 or so "best practices" that they will check if teachers are using them. They would like this to just be a box that is clicked if a teacher is using a teaching strategy. This would then need to be exportable as a .csv or some other format that would easily import into Excel or Access. Even better would be that they could do 10-20 evaluations and then export them as one large file. Basically the file would look like:

John Smith,10Sept2011,1,,,1,,,,,,,1,,,,1,,,1,1,,,

The blank comma separation would be for the strategies that the teacher wasn't using.

I saw FormConnect, but I don't know that it would export into Excel or Access well.

Any ideas of something that would work well for something like this?

pruppert · Aug 21, 2011, 11:22 AM

You might be able to do this with the Bento app or the Filemaker app. They at least would support the form aspect you want. Not sure if they'll export to excel or access but they would sync with the respective Bento/Filemaker desktop apps.

jaseone · Aug 21, 2011, 01:24 PM

Doesn't Numbers do forms?

Edit: it does and does it fairly well so I would recommend Numbers

bluebar · Aug 24, 2011, 09:12 PM

I've used FormConnect and exported the data into a csv file and then imported it into Excel.

Aug 20, 2011, 10:45 PM	#1
Mcclure macrumors member Join Date: May 2011	Looking for a form app that can export to Access/Excel I work for a school that is looking to have a quick form that administrators can fill out on iPads. They want to have the teachers name in a drop down (about 30-40 teachers, this is needed to remove any chance of spelling errors) along with having date/time. Then there will be 40 or so "best practices" that they will check if teachers are using them. They would like this to just be a box that is clicked if a teacher is using a teaching strategy. This would then need to be exportable as a .csv or some other format that would easily import into Excel or Access. Even better would be that they could do 10-20 evaluations and then export them as one large file. Basically the file would look like: John Smith,10Sept2011,1,,,1,,,,,,,1,,,,1,,,1,1,,, The blank comma separation would be for the strategies that the teacher wasn't using. I saw FormConnect, but I don't know that it would export into Excel or Access well. Any ideas of something that would work well for something like this? Last edited by Mcclure; Aug 20, 2011 at 10:48 PM. Reason: clarify title
	0

Aug 21, 2011, 01:24 PM	#3
jaseone macrumors 65816 Join Date: Nov 2004 Location: Houston, USA	Doesn't Numbers do forms? Edit: it does and does it fairly well so I would recommend Numbers __________________ flickr \| Twitter
	0

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
thread	Thread Starter	Forum	Replies	Last Post
Looking for a dvd recorder that can also record to USB	Jamie0003	Apple TV and Home Theater	5	Feb 21, 2011 04:53 PM
Looking for external DVD reader that can be flashed to multi region capable	Tumbleweed666	iMac	0	Apr 26, 2009 03:55 PM
Database app that can export to mysql? (via phpmyadmin)	benmadrid	Web Design and Development	6	Aug 7, 2007 05:49 AM
Any Mac Apps that can Open MS Access files?	Preacher85	Mac Applications and Mac App Store	8	May 11, 2006 03:15 PM
Looking for a Mac App that can handle scheduling 15 people...	robbents99	Mac Applications and Mac App Store	1	Dec 8, 2005 12:35 PM

Aug 21, 2011, 11:22 AM	#2
pruppert macrumors regular Join Date: Jan 2008	You might be able to do this with the Bento app or the Filemaker app. They at least would support the form aspect you want. Not sure if they'll export to excel or access but they would sync with the respective Bento/Filemaker desktop apps.
	0

Aug 24, 2011, 09:12 PM	#4
bluebar macrumors newbie Join Date: Aug 2011	I've used FormConnect and exported the data into a csv file and then imported it into Excel.
	0