Hey @AIM_Rhys,
Apologies for the incomplete answer, it was late and I wanted to reply something before logging off.
One step missing for the mapped options to work is indeed mapping your ids to the values.
So in the column settings, within "mapped value" you can add a line like this one:
{{
item.map(coordinator_id => {
const staff = ImportMission.data.find(item => item.id ===coordinator_id);
return staff ? staff.name : null;
}).filter(name => name !== null)
}}
Be sure to replace ImportMission with the actual name of your query whre names are mapped .
This will basically replace the id items in each row, with the names for each corresponding item. With this. you can now mapped them using {{ item.name}} or indeed just leave it as a string as it will be hidden anyway.
Hope this helps!