VALID_IF , ENUM and EDIT data

Steve_Fuller · 01-21-2020 12:20 AM

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.

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!

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

Kirk_Masden

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

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.

Steve_Fuller

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…

Kirk_Masden

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.

Are you using a form to change it?

Steve_Fuller

Yes, I use a form.

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

Steve_Fuller

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

Steve_Fuller

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

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

Any further suggestions?

Steve_Fuller

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

Kirk_Masden

Great! Glad you found a solution!!

Steve_Fuller

Thanks!