[Bug? 1.181016.0] Add/Remove does not affect Discord List?

[CyberShark98]

Steps to reproduce

@Axe#4037 used Add/Remove, did a TB refresh, and did not see any change in the Discord list

[PopGoesTheWza]

This is WAD (Work As Designed)

There is no limit (or at least there shouldn’t) to the number of Discord entries. This Discord directory does not need to reflect the actual guild roster. This useful to guild alliances with many members going from one guild to another. You maintain a single list of members and their Discord ids which you copy and paste in each guild copy of the TB Sheets.

Does this answer your issue?

[DarkPhoenixSniper]

@popgoesthewza maybe add those values on the Exception list? Idk Not for the Add/Remove. But maybe to put it there. So you just update the Exceptions spreadsheet?

[PopGoesTheWza]

@DarkPhoenixSniper I am not getting it. Can you elaborate?

[DarkPhoenixSniper]

I know the add/remove will be on the Roster sheet. Maybe add the Discord info to the Exclusions spreadsheet? The one with Light/Dark/Exclusions tabs that the main sheet imports?

[PopGoesTheWza]

The Discord name/mentionId list is independant from the actual guild roster by design. I still cannot get the point about this issue.

[T-Co]

My thought was that if a roster player, “Axe Grinder” already had already been selected and a discord id associated with that player, it would no longer appear as a possible selection. I wouldn’t think any player would need multiple discord IDs. So as the list of discord ids gets longer, there is no need to reconcile what players have been used/they are no longer available as an option.

[PopGoesTheWza]

@T-Co interesting. A pain to implement on first thought. There are still occurences of a member of the guild having several accounts... I need to consider how to implement and possible drawback it could have.

[PopGoesTheWza]

@T-Co @DarkPhoenixSniper Requesting feedback: I can implement that functionality, but it obviously has a side effect. Once a value is selected from the dropdown list, it is filtered out of the data validation rule... and thus you get the invalid indicator. One could say it is merely cosmetic but is also likely to cause confusion among users.

[T-Co]

Yeah, I see what you mean. I don't think it's confusing because I know what's going on. But someone unfamiliar probably would be confused. Might be worth adding some sort of "note." Otherwise, it may get posted in #ss_help_support regularly. Otherwise, I like it! Thanks for considering and implementing that!

[skiadas]

One possibility is to make the validation simply have a warning (not reject, maybe you did this step already) but to also add a conditional formatting on the cells so that the background color becomes red or something if the name is not in the actual roster? That extra visual might help out.

[PopGoesTheWza]

@skiadas now that you mention it… i’d Go for a simple conditional formatting where entries on the discord tab that match with Roster would have a light green background.

[PopGoesTheWza]

This enhancement will be in next release.

[PopGoesTheWza]

in next release