I have this page on my site that is a form input to my database Collection.
If I give Read and Write permission to this database Collection, when I get to this page, I get the latest data in each field of my form that was entered in the db. If I change something on the form and Submit, it does modify the data in the collection (db).
This is all fine but would like to be able to use a dropdown for the user to select the data record associated with the dropdown selection for all fields of the form and then modify and submit.
I was able to configure the dropdown button to show the list of items I want the user to choose from but can't link it to every field of form (dataset) so it gathers the specific data for this dropdown selection.
How do I do this?
I am not trying to use a dropdown to select data on a repeater or a table but to gather the data for each field of my form based on the dropdown selection.