Dropdown Population

[Raymond_Woodley]

Good Day all,

Just want to ask if I am missing something obvious, as always your help would be appreciated

I am trying to populate a dropdown with items that are specific to the user. (Truck Registration)

In the image below the table contains a property called customer, we have vehicles related to customers.

Here is the logic I have used on page entry

with a custom function to get Customer

with the data binding to the option logic.

not sure what I have missed.

But thank you in advance.

Kind Regards,
Raymond

[Inna_Shkolnaya]

Hello @Raymond_Woodley

Does the logic you have constructed work for you?

Regards,
Inna

[Raymond_Woodley]

Hi @Inna_Shkolnaya,

Thank you for your response, no it’s not retrieving anything at the moment.

from the pics there are two vehicles available but neither are reflected by any users.

Regards,
Raymond

[Raymond_Woodley]

[Inna_Shkolnaya]

Yes, I can see the problem. Unfortunately, your whereClause for the table is wrong. Your whereClause should pass the following data owner.objectId='objectId'

I think the following should help you. In the get Customer function, you need to return objectId. Monosnap
Monosnap

Regards,
Inna

[Raymond_Woodley]

Hi @Inna_Shkolnaya,

No Joy yet

As always your help is appreciated.

Regards,
Raymond

[Inna_Shkolnaya]

I recommend that you read the following article.

How to populate the Select Component with dynamic data in UI Builder

In this topic, I will share how to populate the Select component with dynamic data. This approach will work for any kind of dynamic data, whether it comes from the database, an external data source, or a collection of data you manage within your application logic. The example I review below works with the database as the data source. Let’s review the page setup. My page consists of a select component and three input fields marked as read-only. The select component will have a list of countries …

Also, you have Label and Value capitalized and should be in small letters.

monosnap.com

Regards,
Inna

[Raymond_Woodley]

Hi @Inna_Shkolnaya

My problem was not related to anything related in the article, the problem I have discovered is due to the values I require in the Owner column are a relation to another table, thus not a string. How can I structure the where clause to convert the relation data to a string, because I am certain then my problem will be resolved.

Kind Regards,
Raymond

[stanislaw.grin]

Hi @Raymond_Woodley,

is there any chance that there is no value in the Company variable? Have you tried to print it in logs (using the print block)?
Also, you can check what data you retrieve from the table by putting the result in the variable first and then printing it too.
Could you please let us know your results?

Regards,
Stanislaw

[Raymond_Woodley]

Hi @stanislaw.grin

I have simplified things for now to try find the issue. I am not retrieving anything from the owner column in the vehicles table, but can receive string from any other column for instance make.

is there a syntax that i must use to reference the relation(which is a link) converting it to string.

Kind Regards,
Raymond

[Raymond_Woodley]

[stanislaw.grin]

Yeah, in the Load Table object block you can see the relations input. Put there a create list with Owner (just like you did it for the sort by field, but with the Owner value inside).

[stanislaw.grin]

Keep in mind that full user object in the Owner property will be returned

[Raymond_Woodley]

Thank you will give it a go