Skip to content

UX Issue: Difficulty Editing Number Cells in Glide Data Grid #1000

Open
@vpsinghg

Description

@vpsinghg

Description

When editing a number in a grid cell that uses NumberCell, there's a UX issue where leading zeros are ignored after deleting digits. This makes it difficult for users to maintain the correct formatting and length of numbers during editing.

Example:

Suppose the current value in the cell is 1000023, and I want to change it to 2000023.
I delete the leading 1 using backspace, expecting to enter 2, but the input resets to just 23 because all the leading zeros (00000) are ignored.
As a result, I lose track of how many zeros were there, making it hard to format the number correctly.

Other examples:

For a value like 5000078, if I delete the 5, it will reset to 78, and I don’t know how many zeros to add after 7.

For 3004005, deleting 3 would result in 4005, again with no indication of the number of zeros that were present.

Use case:

This behavior is problematic in cases where the length and structure of the number are important (e.g., financial values, IDs, etc.). The user needs a way to edit numbers without losing critical formatting, as it's hard to guess how many zeros were originally present, leading to frustration and potential errors in data entry.

Expected Behavior:

While editing, the grid cell should preserve the existing structure of the number (including zeros) until the user finalizes the edit, allowing them to modify only the desired parts of the value.

Current Behavior

glideapp.current.mp4

Fixed and Expected behavior

expected.and.fixed.mp4

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions