List displaying Value instead of Label

[aijosh]

Hello,

I have a form (FORM A) which has a dropdown element that is generated using the Advance Eval populate PHP code. Value and Labels are taken from another table (LIST B) with it (id) set as the dropdown Value and (elementx) set as the dropdown Label.

ISSUE: When LIST A is viewed. Some of the rows show (id) of List B while other show (elementx)

How do I resolve this (id) is the value and not label. I need only the label (elementx) displayed throughout.

See screenshot

Thank you

 

[troester]

Usually it's displaying the value if there's no label given.
I.e. in the database your row 3 has value 7 stored but your Advanced Eval populate doesn't contain a value 7/label something

 

[aijosh]

Thanks for the response.

I'm 100% sure the database has labels for every value.

See screenshot of database table

 

[troester]

And your Advanced Eval populate is loading all of them?

 

[aijosh]

And your Advanced Eval populate is loading all of them?

Yes.

Though I have it set to not show some time slots once more than 2 people have selected said meeting slot



As you see here, Sunday 9:00AM is not showing for this user because two people have already booked said time and I don't want it available for others to select any more.

PS: Apologies for delayed responses. I do not get notified when you reply so I don't know to check

 

[troester]

As you see here, Sunday 9:00AM is not showing for this user because two people have already booked said time

Yes, and this is exactly what happens in list view: there are no labels for all records with a time already selected twice.
So modify your code to respect the view type or add a standard dbjoin element and show this in list view.