How to use a formula field to query a table and insert field values into another table's field

Are you asking how to do this using the API's or using native Quick base techniques.  It is possible to do natively for a limited number of unique names, say a half a dozen using a series of looping relationships.

I presume in your example above, you are looking for a field in the task table to contain the value 

John, Austin