Skip to content

Ensure that adding new terms does not change the IDs of existing terms #25

@surchs

Description

@surchs

At the moment it seems that the GDrive Spreadsheet we use auto-regenerates the values in the ID column if a user inserts a new row in the middle. This is no good, because this will change the ID of existing terms. See e.g. here:

f950817

We should

  • Confirm this is a setting in Google Docs that causes the ID regeneration
  • If so, see if we can turn the setting off
    • Some possible solutions:
      • In template, change format of id column in GSheet from "Automatic" to "Plain text"
      • Document that the id column should be a Plain text column as above
      • Always recommend that users add a ' instead of the ID to store it as a plain value (this should not be rendered or read by gspread)
  • Or: document clearly that communities should only ever add rows at the bottom
  • And: discuss with users what ordering they want for the terms in their spreadsheet (e.g. maybe ordered by ID column is not the most useful to them

Metadata

Metadata

Assignees

No one assigned

    Labels

    flag:discussFlag issue that needs to be discussed before it can be implemented.somedayNot a priority right now, but we want to keep this around to think or discuss more.

    Projects

    Status

    No status

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions