Is there a pattern, which allows mapping the following datastructure to table columns?

The clue is, that there are 2 attributes, which depend on each other, one should be entered, when the other was entered - so mapping them to table columns is not satisfying, because then it is suggested to enter one datum without the other.

enter image description here

  • So are you asking how best to allow input a pair of required data, how best to display rows of these data pairs in an editable fashion, or both?
    – Evan
    Sep 19, 2012 at 13:52
  • I am asking about best way to layout pairs of editable data in a table
    – Skip
    Sep 19, 2012 at 14:21
  • From your screenshot, it appears that this is for a desktop application?
    – msanford
    Sep 19, 2012 at 14:33

3 Answers 3


If both latitude and longitude are necessary, or both are to be left blank, then the coordinates pair should be treated as a single field.
The column header should designate the pair, like "coordinates".
When the coordinates cell gets focused, it should change its appearance to look like a coordinates pair input, with the two sets of degrees, minutes ans seconds, and the N/S or E/W choices.
Once the user has entered acceptable data (here is where you enforce the rule) and exited the coordinates field, then display the data in the cell normally as in any map or geolocation writing.
Notice that there are two suggestions combined here:

  1. Handle both coordinates as a single field, and
  2. Dissociate the way you display the data entered from the input artifact.
  • Thank you, I found an example for your approach: jquerytools.org/documentation/dateinput/index.html
    – Skip
    Sep 21, 2012 at 8:45
  • @skip: yes! a date is a similar case, a single datum made up of several pieces. I suggest writing a jQuery simple plugin for the purpose of accepting and checking the coordinates, both latitude and longitude, and returning them as a js object, to encapsulate this behaviour in order to reuse it and to be able to test it in isolation to ensure it's rock solid.
    – Juan Lanus
    Sep 21, 2012 at 13:25

These are clearly geographic co-ordinates. Without knowing more about the function of your application:

Your row pair is used to input geographic co-ordinates: do you have users who will know how to decompose geographic co-ordinates and input them raw into a form like this without knowing that describing a location requires two of them? (I had a look at another of your questions, which I assume is a higher-fidelity mock-up of this question? If you are assigning different IDs to latitude and longitudes, how do you relate them?)

Depending on the rest of your interface design, you could do it several other ways:


download bmml source – Wireframes created with Balsamiq Mockups

Additionally, I would strongly recommend not putting the last unit " outside the text box. It's strange, because it implies that the value of the entire cell is to be expressed in ", rather than that it applies only to the last segment of the value. (That is, unless this is an accepted standard in Germany.)


I think that there are few people who are comfortable with entering coordinates like these at all. While you can make entering them an option, I would not make it the first or only way of displaying and entering them. As an alternative, considder allowing users to point out locations on a map. Most users are familiar with interfaces like Google Maps, so navigating a map should be relatively straightforward for them.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.