I need a little help as chatgpt couldn't answer my question.
I'm using a textfield autocomplete that is mapped to a a supabase query filtered by an onchange event (ie when you type in the field it filters the query).
When a user selects the autocomplete option (which displays the name field of the record) I'd like to add the Id of that record to a list.
How do I capture the Id field of that selection? I've only been able to map the name (which is not unique for these records).
The high level concept for this is that I want a text box someone can type in, see their selection and either press enter or click the button to the right to add it to a list (page state)