Using the SQL API Connector to get a list of clients & Client ID’s to put into a dropdown and displaying the client Name. This works fine when first selecting one. But if I want to set a specific one as a default when the user pulls up a popup screen (based on a selected record in a RG) it does not work. I either get red, meaning my entry is invalid or it doesn’t work. Tried making it the same API Call and limit it to the ID (to try to find the one/unique matching record) but can’t get past the red (meaning it’s not a valid statement). Also tried to change the type to Text and load from a RG, but then I lose the associated ID with when the user selects a name.
Any ideas on how to set this?