Hi! I am trying to use the value of a lookup column to display/hide a button. The lookup value points to a text field, with the text value “true”. This value also shows in the lookup column. However, when I try to use this lookup column in the visibility section for a button (I want to display the…

Does the table containing lookup value use row owners? The data editor ignores row owners, but the app side respects them. The data editor may not be completely accurate in showing values from rows under row ownership Are you sure that your screen is pointing to the correct row?

Hi Jeff. [Schermafbeelding 2022-03-10 om 14.44.39] The most left column is a regular text field, and the most right column does a lookup on the most left. [Schermafbeelding 2022-03-10 om 14.44.52] Here you can see an example. The second row has “true” as its value in the left column, and the l…

So I assume you are not using row owners? I’m not sure I follow. The lookup column is pulling the value from the last row in the same table? How are you getting that lookup value? I assume through a relation? Which relation and how is that relation set up? The second question, is which row is …

[image] Jeff_Hager: I’m not sure I follow. The lookup column is pulling the value from the last row in the same table? How are you getting that lookup value? I assume through a relation? Which relation and how is that relation set up? Yeah, I think we need to see the configuration of that Loo…

There is a relation with a value column A to column B. I made this relation to access the value that comes up with my Lookup column. [Schermafbeelding 2022-03-10 om 20.14.11] My details screen is pointing to the row where the lookup value is “true” (have checked this in the data), so I’m sure tha…

OK, so it’s like a search with a user specific column and you are looking for a matching row that contains the same VIN, correct? Two things I would check: Does the ‘true’ in VoertuidFotoUploadCheck contain any extra spaces before or after the word ‘true’? Does your visibility condition contain a…

I found the issue, I thought the user-specific column just couldn’t be used in the lookup column, but I wasn’t aware the lookup couldn’t use it in the relation column that the lookup column is using. I have changed it to a regular column, and now it’s working. Thanks, everyone!

Hola! I think there is a confusion here: you can use a USC with a Lookup column, no problem with it… the problem is what you will see/get using it. If you want to have valid values applied to all users or any case (let’s say a “Public” value), you have to use a real/regular column to achieve it. I…

Lookup values are not showing up when referenced in a component. Seems like there is a bug in this for some reason.

Maybe. Got a video that describes the setup and demonstrates the problem?

Lookup column value is empty

Ask for Help

Darren_Murphy August 25, 2022, 7:47am 14

You already posted that question here.
Please don’t post the same question in multiple threads.

Topic		Replies	Views
Lookup columns only show data for logged-in user Ask for Help	7	260	July 15, 2023
Visibility filter inside forms not working with Lookup column Ask for Help	4	167	November 1, 2023
Lookup column not displaying in layout Ask for Help	7	217	March 16, 2024
Lookup field not working Ask for Help	8	471	January 17, 2024
Results of Lookup non-visible Ask for Help	12	449	January 17, 2024

Lookup column value is empty

Related topics