I'm working with complex tables whose data can be aggregated based on time (e.g., from month to quarter). Users will still be able to modify the data at a higher level (e.g., input 900 at the quarter level and then split 300 to each month).
The goal Is to allow users to select the way input data will be distributed. Selecting with the mouse is quite easy to implement: when a cell is in focus and supports distribution, an additional element with the selected distribution type appears. Users can then click on it and select from a dropdown.
It's more challenging to handle keyboard shortcuts for it:
- Everything with
Cmd+ arrows is reserved for text selection. However, I can probably use
Arrow Up/Downto change the current mode (without opening a dropdown). Because the same selection could be achieved with
Arrow Up/Downsince cells only have one line.
- Tab can't be used because it's reserved for cell navigation.
I can invent a separate shortcut, for example,
I, just for opening a dropdown, and then the user can navigate with arrows.
- As an alternative, I can begin such cell input with the dropdown always open, so then it'll be clear that the mode can be selected with the up and down arrows.
I would appreciate any suggestions regarding the direction here or examples of products with similar interactions. Thank you!