Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

Question

Software for customer forms

Feb 5, 2015 12:02AM PST

I supervise an ID Services desk at a University and we are looking to stream line our system. I explored the possibility of using Access or SQL to do this, but it cannot easily be updated or amended if needed after the database is built.

Basically, I am looking for a software (does not have to be free) that does the following:
A student or staff member fills out a form on an iPad or other tablet and clicks what kind of ID they need, and the form redirects them to the next appropriate page. There would be no more than 2 pages.
After the person submits the form, a sort of "work flow" piece is on a separate computer that will allow the ID Services staff to look at forms that have been filled out and select them, seeing the information submitted, and editing it if need be. They would then make the ID from our universities main database (separate software with no ability to deviate).
After the ID is made, the ID Staff could click a button (ie. Nursing Badge, Student Replacement, Student New, Faculty/Staff replacement) that would then sort that form record into an appropriate spreadsheet or other medium for further processing and bookkeeping based on a fiscal year schedule.
I bill replacement IDs every week, and new/damaged/faculty and staff records are stored for five years in either digital or paper format for our records.

I have used Google and talked with our IT dept (who are not the most willing to help with things like this) and came up with nothing outside of using fluid-surveys or Wufoo so any help at all would be appreciated. Thank you in advance.

Aaron

Discussion is locked

- Collapse -
Answer
Did you just describe an set of apps to be created?
Feb 5, 2015 12:20AM PST

Sounds like you have a start on your app collection and only need to design and code it all up.
Bob

- Collapse -
Kinda Sorta
Feb 5, 2015 4:10AM PST

In essence, yes, but do to bid process and the regulations of IT and Purchasing, I cannot get a bid on getting software written for me.

What comes to mind when I think of this is the sort of software that retail stores use for filling out credit apps on the credit card swipe machine and then the application is opened up on the PoS screen.

Aaron

- Collapse -
Sounds like the rules don't allow it.
Feb 5, 2015 4:43AM PST

Sorry if I was unclear. Since you seem to have a clear idea of what's needed, why don't you create it? Today's software tools and more have never been better.
Bob

- Collapse -
I would but I do not have that skill set
Feb 6, 2015 12:57AM PST

Do you have a recommendation as to how to go about it? I am very computer literate and know a little coding, but not enough to write such an involved software. Is there a software design program you recommend?

- Collapse -
Thought about and what about FileMaker Pro?
Feb 6, 2015 1:07AM PST
http://www.filemaker.com/solutions/nonprofit/ may let you get it free.

PC Magazine on FileMaker 13: "Simply the Best"

Dec 19 2013 - "FileMaker reigns supreme when it comes to building beautiful, custom apps for non-programmers. The commitment to detail and aesthetics is apparent in using the software and I actually find it an enjoyable platform on which to create an app. FileMaker Pro 13 is an easy four and a half out of five stars and an Editors' Choice for business software, and database apps."

This runs on PCs, iPads and more.
Bob