I have spreadsheet tabs as follows:
writers (name, bio, etc.)
articles (writer name, article title, etc.)
On the article screen I want to show the bio of the writer, so I finally was able to create a look up column and I can see that in the data, BUT it won’t let me show it in the article, the only place I can see it as an option is in title component image, which makes zero sense to me.
I read somewhere else that my relation column can’t be multiple but as soon as I make it not multiple, the bio column gets deleted, so again, it’s a loop.