Hi, I am trying to pull in a relation column to use in a switch component. Are there reasons why the relation or lookup column doesn’t appear as an option? Also no option to pull data from another sheet. Thanks!

Am I linking this button bar to the relation column in the ‘current sheet’? I was also looking at the choice component. Is that automatically user-specified? I find they are both hard to tell which choice you are actually selecting.

You should use a set column on the relation linking back to the user profiles sheet and set the true/false value using that.

Ok, so I set the title for one button to YES and the other NO, then have set column actions for both? This is what I have: [chat89]

Yeah, but you would want to set them to true or false.

Ahh, I see it has to be exactly what’s written to the column. I think that’s kind of weird for display text. Do you know if there is a way to have display text that’s different from what’s actually written to the column?

You can name the button whatever you want, the value is configured independently in the action part, you can write the true/false value there using a custom value option.

Ahh, so like this for both sides of the button: [chat89] As you can tell , it’s my first time doing set columns :grimacing:

Let’s say you want the left button to set to Hide, then the left action will write true. The right action to set to Show, then the right action will write false.

Yes that sounds right. The Left button is set to ‘Yes’ and the Right Button to ‘No’. The question is: ‘Hide From Chat’ Ohh, Ithink I see what you mean…have this set up for Yes: [chat89] and swap out true for false for the No button?

Relation Column Not Showing as an Option

Ask for Help

Darren_Murphy February 20, 2021, 4:04am 30

Topic		Replies	Views
Setting Column Action Ask for Help	5	284	October 21, 2021
Issues with set column on button press Ask for Help	6	356	March 8, 2021
Want to add relation column in source Ask for Help	14	891	February 9, 2022
Visibility based on more that one condition Feature Requests	13	1379	May 15, 2024
Was switch visibility being worked on today? Report a Bug	4	300	August 23, 2020

Relation Column Not Showing as an Option

Related topics