Hi,
I’m trying to set up a form where users can select from a number of options from a dropdown list, I have this already set up linking to a list in a database. I would like the ability to set a ‘save’ button on the form so that when clicked the dropdown selection is saved in a database. The most recent saved dropdown selection should then be used to pre populate the dropdown every time the page is opened until it is changed and saved again. The starting point where no data has previously been saved should just be the dropdown list as it is currently set up.
Steps I have taken:
- Created a data type called ‘safety current’
- Created a field called ‘rating’
- Created a button with a workflow that when clicked - creates a new ‘safety current’, rating = dropdown A’s value’s descriptor (this saves the dropdown value in the safety current data type, and saves a new dropdown value in a list each time a value on the dropdown is selected and then the button is clicked)
I’m guessing that the dropdown should have some dynamic data search entered in the default value area? I can’t get anything to work in there. Essentially I’m thinking I should be able to enter a search in the default value for the dropdown that pulls in the most recent saved safety current > rating data automatically once the page is opened?
E.g.
