Lookup Select Box values display Null in the native UI and not visible on the portal

Moe13 · ‎12-08-2023

Hello and thank you in advance for your help.

I created a new table with a list of locations to use for a variable in a catalog item. I removed the created ACL role to "read" the table and selected display. This particular catalog item was using a previous custom table but the client asked to created a new table for this variable. The problem I'm having is, the values are not visible on the portal (its there but you can't see it) and on the backend with the "try it" button, they are all listed as null. Please help, what am I doing wrong?

-O- · ‎12-08-2023

The ACLs look OK, seem to be standard ones.

However I seem to see a field labelled Organization - singular (in the 1st screen shot).

But Lookup label field(s) (in another screen shot) contains a field name in plural - u_organizations!

Are you sure u_organizations is the correct, valid field name?

View solution in original post

Peter Bodelier · ‎12-08-2023

Hi @Moe13,

Did you set a field in the table as display field?

If yes, please show the configuration of your variable.

Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.

Moe13 · ‎12-08-2023

Hi @Peter Bodelier ,

Yes, this field is set to display. Please see configuration below:

Peter Bodelier · ‎12-08-2023

Hi @Moe13

Please verify if the lookup label field is the correct field name for the display field.

Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.

Moe13 · ‎12-08-2023

@Peter Bodelier ,

It is the correct field for the display field. I have also tried other tables and they work but not this table.

Peter Bodelier · ‎12-08-2023

What type of field is the display field?

Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.