Pre fill drop down with data

anon75185386 · 2024-12-11T06:31:24.580Z

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.

image375×420 24.7 KB

Nick22A · 2024-12-11T07:39:53.052Z

Yes, you are correct, use dynamic data in the Default Value field. Then you can either use “Parent Group” to find the value, or do a “Search for” and use “:last item”

image322×371 9.9 KB

system · 2025-02-19T06:31:43.743Z

This topic was automatically closed after 70 days. New replies are no longer allowed.