Trouble setting Default value on drop-down field (dynamic from option set)

[wetterux]

I found an existing topic that seems the same as mine, however the solution didn’t work for me.

I’m trying to set up my drop downs on a form to have a default value of the Service I’m editing, so my form can be used to create AND edit.

However, when I fill it out like the above, I get an error

I tried deleting and recreating the drop down, but it is still giving me the same error.

[hergin]

So you are saying Current page's Services's Category is not text but its type is option set Service Categories?

[wetterux]

Yeah, my Service’s Category are option sets

[hergin]

Can you please show Services data type?

[wetterux]

But I’m storing it in my DB like this… maybe that’s incorrect?

[hergin]

Yes. Thats incorrect. This should be of type option set as well.

If you like to insist storing as text (which is not good practice), then, while setting the default, you should filter all option sets by display value and get the one with this text in it.

[wetterux]

So, I should do this instead?

[hergin]

Yes, a starter.

[wetterux]

That seems like it did the trick! Thank you!

Just curious, you said “a starter”… is there something else I need to consider?

[hergin]

I said because I dont know the context of your application and whethet that would help you or you would need other things

[wetterux]

I understand
What you said was extremely helpful and has put me in the right direction. Thanks again!