No problem. If you find more straight-forward way, then I hope you’ll post here so that others may learn! A lot of these things also really depend on what you’re doing. If your value doesn’t exist in the database, then you’ll end up “hard coding” with some variation of my first suggestion anyway.
Here’s another path for if the value you’re looking for does exist in your DB:
If your dropdown is a dynamic list of Things, and the value that you want to save versus the caption of each choice are separate fields within the Thing data type, then you can simply say field = This dropdown’s value’s [value field].
For example your dropdown is a list of cars in your database, and you want to save the selection’s horsepower.
Source = search for cars
Caption = “current option’s model name”
When dropdown’s value is changed > field = this dropdown value’s horsepower.
There are usually many ways to achieve the same thing in Bubble, with some ways more more efficient than others. All really depends on what you’re doing. Hope this helps!