New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

feature: view single record as a form? #116

Open
leeoniya opened this Issue Feb 2, 2018 · 5 comments

Comments

Projects
None yet
4 participants
@leeoniya
Copy link

leeoniya commented Feb 2, 2018

Hey @ansgarbecker ,

it would be incredibly useful to be able to view/edit a single record as a form, since the information density is so much greater than is possible in a single line. it would be a huge UX enhancement, imo and may not be too difficult to implement. eg:

record-as-a-form

@lukinhaspm

This comment has been minimized.

Copy link

lukinhaspm commented Feb 2, 2018

I think its a good idea, but when the table has a lot of fields, it will not work properly no?

@ansgarbecker

This comment has been minimized.

Copy link
Collaborator

ansgarbecker commented Feb 2, 2018

Quite some effort, but I think somehow cool. I recall there were some other users asking for such a thing.

That should probably be a non-modal dialog, staying on top if it loses focus. This way the user can select a different row in the underlying grid. The dialog should then be synced to the focused row in the grid.

That may work not only for the Data tab, but also for any Query tab result - but it may also fail greatly, not sure.

  • The dialog should be resizable, and always on top.
  • when the user changes some content in one or more fields, the grid should get the same red triangles in its fields as it has currently
  • when the user closes the dialog, nothing special happens - the red triangles stay there, and saving must be done by unfocusing the row in the grid
  • perhaps there should be some additional "save" button on the new dialog, in the lower right area.
  • additional "cancel edit" and "delete row" buttons could be usefull.
  • the dialog should be resizable and should calculate its column number automatically (label + textbox + margin = 1 column), depending on the size of the dialog
  • perhaps with a user defined column width (default with: 500px?), so it's responsive to the user's screen resolution.
  • more stuff? Not too much please...
@leeoniya

This comment has been minimized.

Copy link
Author

leeoniya commented Feb 2, 2018

personally, i'm not a fan of a dialog interface. i thought it might work best as an additional pane within any grid view. similar to the query pane that has snippets, history, etc.

perhaps there should be some additional "save" button on the new dialog, in the lower right area.

the interaction can be literally like the grid. in fact, the whole thing would work great as simply a pivoted grid with 2 columns (by default) or maybe some more:

field value
id 111
sku ABC
price 9.99
field value field value
id 111 price 9.99
sku ABC
@leeoniya

This comment has been minimized.

Copy link
Author

leeoniya commented Feb 2, 2018

amusingly, if the field and value columns are sortable, it could help with #115 (though not for multiple records)

@rentalhost

This comment has been minimized.

Copy link
Collaborator

rentalhost commented Feb 12, 2018

  • The select input should display the FK values or most common values like the "More values" on data grid filter (in that case, all fields could be an editable select?).
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment