Is there a way to have an external lookup field autopopulate a value if there is only one query result?

[VynetaRy]

I have a lookup project for markets and many of them are 1:1 with a single city. If someone chooses a market and there is only one city resulting, is there any way to autoselect that value instead of them manually having to select the single result from the dropdown?  Is this a place where a Fusion scenario might be a better fit than an external lookup field?

[Sven-iX · Accepted solution]

You can't auto-populate a field based on the query returning a single result. 

You definitely could let Fusion do that but what if there are 2 markets to the selected City?

How many Cities are in the dropdown and how many are 1:1 with a market? 

A different approach could be to return the combined string City + Market in one external lookup. 

[GregoryBu5]

I hear what you are saying, but I'm not sure that is what the OP intended. I have a situation right now - where I know I'm only going to get 1 result in the External Lookup.  I don't want the user to have to "select" it to get it to display - I just want to display the value - once it's returned. 

Can't this also be an "output" option - like the "multi select" options?  Or is there another way to do this with the External Lookup? 

[Sven-iX]

Hey Greg - I get that; but if an external lookup is a single-select, it works like a normal dropdown - you still have to click the choice. (or maybe I'm still missing what you mean?)

Would be cool though if we could have a calculated field that can make the API call and just display the returned value.