12
Views
10
Comments
Solved
How Connect Dropdowns and Tables for a client order

I Have a dropdown list in a screen.


how to connect with a table supposing a client select a service?

I create a clientorder variable 

the list of dropdown are 3 static entity


WhatsApp Image 2023-09-16 at 12.46.09.jpeg
Champion
Solution

Hello

As I have understand you need to filter the data in a table on selection of a value from a dropdown.

I am attaching a sample for you that might help 

https://personal-ejuytnht.outsystemscloud.com/DropdownSample/Employees?_ts=638305051177779770

I hope this helps

Thanks & Regards
Tousif Khan

DropdownSample.oml

I Have a Screen with Dropodown Selection and  I need to Select one service in Dropdown List and then create an action to see the price of service and than get an appointment for this service. 

Tousif, thank u 

U really help me

I think this sample will help me a lot

Regards from Brazil :)

Champion
Solution

I have shared you an example, in this way you can implement the same

So first you must have a database tables created with 1 to many relationship like the diagram below

Ignore the Self loop here.

Now you just need to follow what I have done in a  Oml I have shared, do the same, Just change your entity

I have shared you sample with employee and department, you can change it with services

I hope this works

Thanks
Tousif Khan

Champion
Solution

I am glad that I was able to help you, If you find this helpful, please mark the post as a Solution, it will be a reference for other with similar issues in future.

Thanks
Tousif 

I will work on this application till next Monday.

I will share with u when its done :)

Champion
Solution

I have shared you an example, in this way you can implement the same

So first you must have a database tables created with 1 to many relationship like the diagram below

Ignore the Self loop here.

Now you just need to follow what I have done in a  Oml I have shared, do the same, Just change your entity

I have shared you sample with employee and department, you can change it with services

I hope this works

Thanks
Tousif Khan

Champion
Solution

I am glad that I was able to help you, If you find this helpful, please mark the post as a Solution, it will be a reference for other with similar issues in future.

Thanks
Tousif 

Hi,

I didn't get your question, do you want to filter the data based on the user's selected "clientorder" or you want to save it in the database?

I Have a Screen with Dropodown Selection and  I need to Select one service in Dropdown List and then create an action to see the price of service and than get an appointment for this service. 

Champion
Solution

Hello

As I have understand you need to filter the data in a table on selection of a value from a dropdown.

I am attaching a sample for you that might help 

https://personal-ejuytnht.outsystemscloud.com/DropdownSample/Employees?_ts=638305051177779770

I hope this helps

Thanks & Regards
Tousif Khan

DropdownSample.oml

I Have a Screen with Dropodown Selection and  I need to Select one service in Dropdown List and then create an action to see the price of service and than get an appointment for this service. 

Tousif, thank u 

U really help me

I think this sample will help me a lot

Regards from Brazil :)

Champion
Solution

I have shared you an example, in this way you can implement the same

So first you must have a database tables created with 1 to many relationship like the diagram below

Ignore the Self loop here.

Now you just need to follow what I have done in a  Oml I have shared, do the same, Just change your entity

I have shared you sample with employee and department, you can change it with services

I hope this works

Thanks
Tousif Khan

Champion
Solution

I am glad that I was able to help you, If you find this helpful, please mark the post as a Solution, it will be a reference for other with similar issues in future.

Thanks
Tousif 

I will work on this application till next Monday.

I will share with u when its done :)

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.