VALID_IF , ENUM and EDIT data

I have taken an example from these pages to use a Valid_If statement to load the choices into an ENUM. This works very well for me as the ENUM is copied across a number of forms so having them load from a table is great.

However, I’ve noticed that when I edit data the previous saved choice is not shown, which prompts the user to reselect the data choice - this can lead to mistakes.

Screenshot 2020-01-21 at 08.13.49

Interestingly, even though this ENUM is a Required field, as shown by the *, selecting NEXT does not produce an error and when the form is saved the existing data still exists!

Screenshot 2020-01-21 at 08.13.33

Is there a method for the edited form to show the underlying table data when editing?

Interesting. I haven’t had that problem. I wonder why it’s working in my case but not in yours.

Screen Shot 2020-01-21 at 20.36.23

The Chinese characters are highlighted because I selected that tag a few days ago. Now, whenever I go to this menu, it looks like this.

Thank you for taking the interest to reply.

I note that your example is not a required entry.

I wonder if this is the difference…

Perhaps so. I’ll try to check later when I have time.

Ah, now that I think of it, it may have to do with the fact that I only change the value via the “quick edit” feature.

Screen Shot 2020-01-21 at 20.41.34

Are you using a form to change it?

Yes, I use a form.

I’ll quickly change the Required status to see if anything happens :wink:

It is the same result if I make the field Not Required :thinking:

Once I select an ENUM option then it works correctly afterwards!

Screenshot 2020-01-21 at 11.58.56

BUT I don’t want to go through each record to fix this!!!

Any further suggestions? :slight_smile:

SOLUTION:

In my table I had a space between my SPLIT character “;” and the beginning of the next word

I have removed this space and it now works as expected :slight_smile:

3 Likes

Great! Glad you found a solution!!

1 Like

Thanks!

1 Like