I am using sheets as the data source, I am able to create a relation based on foreign keys. I am struggling to get the view to display a field using the relation.
This is the data:
This is the view which isnt showing the relation column:
I would like the list to use the job title based on the matching job_id
Please help in this regard, All suggestions are greatly appreciated.