Hello, I need to fill a dropdown with a table query. I have a table called COMPANY that has a column called ID, another Name and Users, the objective is to query the ID and show the Name in the dropdown as long as the user is equal to USERMAIL(). I hope you can help me.
Depending on exactly what you want to achieve, you can either:
Thank you for your response, but what I am looking for is to load the companies from the user settings screen, eligible after the user enters their UserID, the companies loaded as a result of the query can be several, so I require that they can be selected in a dropdown . I hope you can help.
Then in the company column you can use the suggested values option and a SELECT() expression to generate the list you want based on the UserID.
User | Count |
---|---|
27 | |
26 | |
23 | |
22 | |
15 |