Filling values in a relation column?

1

Hello! I’m pretty sure there is a simple solution to this, but I just can’t figure out what it is.

I am pulling in tasks from a task app using a Pack table. I want to automatically tag these tasks using my existing tag system, based on the task’s label. To do this, I created a relation column in the tasks table that references my tags database. I want to Fill Values in this relation column based on the Label that was assigned in my task app. So if the task label is “X”, I want the relation column to show my corresponding “X” tag.

I created a SwitchIf formula to Fill Values based on the labels’ text, but the tags show up as text, not as a relation bubble. How do I get the tag to show up as a bubble instead?

Here is a simple dummy doc set up with the tables I’m using.

Thanks!

2

Hi @jaelyn ,

So if I understood you correctly, the Label field in Tasks is also provided by the pack?

If so, this a formula that gets what you want. I also implemented it in your doc as AutoTag column.

[My Tags].Filter([My Tag Name].Lower()=thisRow.Label.Lower())

Hope this helps,

Pablo

1 Like
3

Yes, that is exactly right! I wasn’t thinking that it was a filter situation, but it makes total sense now. I got it to work perfectly on my main doc. Thank you so much for your help!

2 Likes
4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.