My Enum field is having one incorrect option

[ur_Jim_buddy]

Hi Team!

I know the subject line is kinda obscure so I will give a quick context:

1. My app has an Enum field called New Group and this has 4 different options from which Agribusiness is one of those.
2. It also has an Enum field called New Department that contains options based on New Group. So when a user chooses Agribusiness, the values in this field changes to departments that belong under Agribusiness Group.

Here's my concern:

All options from Field 2 are correct except HR Learning & Development that belongs to another Group.

Here's the mapping of my table:

Here's the formula for New Department:

Select(Key to Group[Department],([Group]=[_THISROW].[New Group]))

I am wondering why that one department, that shouldn't be there, is appearing in the New Department field's options.

Any help would be much appreciated.

Thanks!

[Denzil_Snyman]

Have you checked your database itself, filter out the new departments in group column on database and double check of one entry perhaps has HR Learning & Development there..

Otherwise I have no other idea why. 

[ur_Jim_buddy]

Hi Denzil_Snyman

I didn't just double checked but did multiple times already but to no avail. I'm thinking maybe either the Key? or Label? is the culprit? I don't really have any background of these two so am thinking it's just my lack of knowledge.

 Anyway, thanks for the response.

[scott192]

Put your formula in the Valid_If section of your column.

[ur_Jim_buddy]

Hi Scott!

Thanks for the response.

I don't know if I can do this because I want to allow users to enter new data and this feature appears to be enabled if the formula is encoded in the Suggested Values. 

[scott192]

You want to allow your users to add new values for Enum?  That's a disaster waiting to happen 😋.  Cue multiple values with the same spelling, but with upper case at the start missing.  Also user's opinions on what the correct Enum should be and adding their own versions...  Just my opinion.  

[ur_Jim_buddy]

I respect your opinion, Scott, but this app will be used by officers and not the general public so we are assured that they will input the correct values most especially new entries that we do not control. 

[jballester]

...could be some type ref column that links HR Learning & Development and New Group table

[ur_Jim_buddy]

Hi Jballster!

Thanks for the response.

Can you explain this more?

[jballester]

check all the columns of the record "HR Learning & Development", table Key to Group, and see if any of them are related with the other table, and, if it exists, A/B Test.

[Steve]

---

@ur_Jim_buddy wrote:

so we are assured that they will input the correct values

---

Ha! Wrong!