I'm a bit new to using wix code but I offered a friend to help solve this problem.
We have a dropdown that is connected a dataset for it options, what we would like is when the user selects from the dropdown the trip they would like it updates the text box below it to the matching "tripPrice" column that corresponds with the selection from the dropdown.
We have been googling all over searching and implemetning various methods but cant get it to update properly.
Here is the page/form:
And the database:
The dropdown is mapped to the Headline Column (fieldkey = title)
and the text box should return the "Trip Price" (fieldkey = tripPrice) column when they pick the associated trip.
I have tried:
A few others and a few homegrown ideas with no luck... any help would really be appreciated. I know were missing something, probably simple, here.