data-entry

How would you design a form with many dynamic fields?

We have a form that allows a user to dynamically add inputs for fields. For example if you have a form for tracking projects, you want to dynamically add tasks to that project. Just to clarify my language: you dynamically add inputs for the task field. The problem is, we have 50 of those fields. Our current solution presents all 50 field...

What is the best designed form you have ever seen?

I am looking for awesome forms that are easy and intuitive to use even though they may be overly complex. Multi-page is cool too. Screen shots of the forms would be way cool. ...

Replacing MS Access forms

We have a number of very old data entry forms that were made in Access that link to our SQL Server database. Each form may have any number of sub-forms. We'd like to move away from using these access frontends but don't have the time to create a new app or web app to replace every form that we've got. Is there another option that would...

How to detect a typo in a product search and suggest possible corrections?

Given a very large database of product names, how would you detect possible typos in user searches and suggest possible corrections (Kinda like the way Google presents them)? E.g. User enters "fork handels" and presses 'search'. They get back "No results. Did you mean 'fork handles'?" ...

Is massive Data Entry on the web feasable?

Is there any good way to design a web page for massive data entry? Datagrids seem to be the best way to handle this type of data entry and I think a client application like Access or SQLite+Frontend would be better suited for this than the web. Links to sites with a page for data entry would be greatly appreciated. ...

asp.net MVC handling dependencies between input controls?

I have an application that has two dependent dropdown lists, where if the user selects a value in list box A, it updates the available set of inputs in list box B. Such as make/model of a car. when the user selects the manufacturer, the list of models would update accordingly. In winforms, this would just be handled in the autopost back...

Automatic Webpage Data Entry based on The Page Content

Is it possible to make a program that open a page (as if a bookmark file were opened by IE), and based on its content generate a feedback, that should be fedback in a textbox on said page by pressing a button on said page? I need this program to execute on a set time schedule to feed some data to a web server based on time dependent web...

Has anyone used Sigma Grid (Javascript-based editable data grid)?

Has anyone here used Sigma Grid for JavaScript-based data grids? It was the only grid I could find that would allow fast data entry and use of the keypad, but before we spend a lot of development time I wanted to learn about the community's experience with it. (Note: we need dozens of fast, sortable, and editable grids that can be use...

Entering data into a grid

A UI question: is there some consensus on the best (defined as "the one which end-users like best") or least-bad way to implement data entry into a grid? I have a grid, with many rows. The grid's columns contain various types of properties, which the user can enter/edit. The "types" of properties include: Free text Numbers (numeric di...

Parse 'family' names into people + last name with regex

Given the following string, I'd like to parse into a list of first names + a last name: Peter-Paul, Mary & Joël Van der Winkel (and the simpler versions) I'm trying to work out if I can do this with a regex. I've got this far (?:([^, &]+))[, &]*(?:([^, &]+)) But the problem here is that I'd like the last name to be captured in ...

Do you use any 3rd party Data Entry Controls ?

Hi, In every project, i always build up data entry forms for the Entities. I have googled it a bit and found some controls like Peter's Data Entry Suite ... etc. Do you ever use these kind of controls and could you please tell me your experiences about using them ? Thank you ...

Recommended Mac GUI data entry tools for populating SQLite databases for iPhone app use?

While making an iPhone app that refers to a (not yet existing) SQLite db Are there any good, cheap programs for data entry? ...

Good methods for human-readable & human-maintained databases

So this is the scenario: You have a bunch of data that needs to end up in SQL. It needs to entered by hand. It is not an "enter once and you're done" scenario: it will need to be modified and expanded by humans in an ongoing iterative way. Comments will be associated with entries. It is also useful for data entry people to be able to ...

Linq / data object best practices

I am a new asp.net programmer and I just asked this question which left me with a more general one. What is/are the current best practices regarding Linq and data objects? Specifically when to; dim, new and dispose of them. Also what about objects that get used in many different scopes on the same page e.g. a user data object. Should t...

Weekly-based populating a database with the django admin

I'm building an small django app in order to manage a store employees roster. The employees are freelancers-like, they have weekly almost-fixed schedules, and may ask for extra ones at any weekday/time. I'm new to both python and django, and I'm using the django admin. Everything works fair enough (for me) when I "manually" add a "Turn...

[iphone] sql won't add new entries. :(

Hey, My function won't add any entry to my existing sql database. Any ideas? sqlite3 *database; sqlite3_stmt *compiledStatement; if(sqlite3_open([databasePath UTF8String], &database) == SQLITE_OK) { NSString *tmpSQLStatement = [NSString stringWithFormat:@"INSERT INTO data (test) VALUES ('teststring');"]; const c...

HTML data entry

I have gotten a project on my desk. It involves updating the bios for a bunch of people, however, my boss does not want into a database (I think that would be the best solution but lets not go there). Although, he never said anything about flat files! :) So, my solution would be to create a PHP page with some form elements with like "Ed...

Handle rollbacks for data edits in a multi-user environment?

How to you typically handle roll backs for data edits in a multi-user environment? Do you identify the transaction and build a graph of any subsequent dependent transactions and then roll them all back ? Do most RDBMS's provide an interface or mechanism to do this sort of thing? Naive as I am, I thought about restoring from backup, but ...

Is it possible to script for data entry with Drupal?

Hi, I'm planning on putting a store's inventory on a Drupal site and I'm wondering if it's possible to create a script (maybe in python/php?) to enter the data automatically to Drupal with CCK? Thanks in advance! ...

Help me choose a data entry system for multiple users at multiple sites

I've just started working on a project that will involve multiple people entering data from multiple geographic locations. I've been asked to prepare forms in Access 2003 to facilitate this data entry. Right now, copies of the DB (with my tables and forms) will be distributed to each of the sites, returned to me, and then I get to hamm...