I don’t know if this fits your exact situation but I have a sheet with a list of competitions for students. In another sheet, I use the UNIQUE function to build a list of unique competition names. I then use that unique list to populate a choice component in a form. The form is used to add a new competition for a student. In my example, I allow the user to either type in a new competition name, or select from a list of existing competitions. This gives a warning in the builder because I’m using 2 components to fill the same column in the sheet, but it works great for me.
