299
Views
11
Comments
Solved
How to show list/table based on dropdown list
Question

Hello All, 

So i have list item based on Category item,
In here the example, it having 3 category : Room, Projector, Car.
Then category room have Room A101,A102,A103.
Category Projector have Projector A.
Category Car have Car A, and Car B.

then i have dropdown list that shown the category.

I want to ask, how to create when the user choose Room, then the list will show only RoomA101,A102,A103.
And when user choose Projector, the list will show only Projector A.

Also i want to ask, why i cant put my dropdown above the records/lists.

Thankyou guys!

2020-11-13 07-48-15
Khuong Truong
Solution

Hi Bhetrand,

I updated your .oml (see Items screen), please take a look.

Regards,

Khuong

BookingSystemBackup.oml
UserImage.jpg
Bhetrand Dwilangga

Hi Khuong, nice to meet you again.
Really appreciated it !You helped me again and that was i expected.. Thankyouu!!
Also thankyou for u all guyss!! i learned so much from u guys!

Thankyouu Khuong,

Best Regards,
Bhetrand

2020-11-13 07-48-15
Khuong Truong

Hi Bhetrand,

You're welcome and glad that it helped you again.

Cheers,

Khuong

2021-01-12 14-29-49
Prajakta Roshankhede

Hello Bhetrand,

Please check sequence of dropdown from widget tree, add it before table.

You can display list based on category selection by two ways:

 Option 1: Add 3 tables and display on basis of category id selection

Option 2: a. Create structure 

b. add local list on your page with structure datatype

c. Clear list and append new list based on category on OnChange event of category dropdown


Thanks

Prajakta Roshankhede

UserImage.jpg
Bhetrand Dwilangga

Hello Prajakta, Thanks for respond.
In option one, how to display basis of category id selection?
Thankyou

2021-01-12 14-29-49
Prajakta Roshankhede

Please refer attached sample for the same, I have added both options in two different pages

CategoryChangeSample_v4.oml
UserImage.jpg
Bhetrand Dwilangga

Thanks for responding! 

But, Here i attached my OML file so you guys can see the detail of mine, hope someone can help me , thanks guys ! 

BookingSystem.oml
2021-12-22 12-25-29
Vaishnavi Bokade

Hi @Bhetrand Dwilangga 

please find attached oml.


I hope this help you.

Thanks

vaishnavi Bokade


TableRecords.oml
UserImage.jpg
Bhetrand Dwilangga

Thanks for responding! 

But, Here i attached my OML file so you guys can see the detail of mine, hope someone can help me , thanks guys ! 


BookingSystem.oml
2023-12-14 09-56-57
Yogesh Javir

Hey ,

You can add filter on you aggregate/data action which list bind to table as

filter : catagory.id=selectedCatagoryId

here selectedCatagoryId is variable bound to dropdown list.

So when you changed value from dropdown aggregate refresh inside onchange action so your list will get refresh as per your selection.

Thanks

Yogesh

UserImage.jpg
Bhetrand Dwilangga

Thanks for responding! 

But, Here i attached my OML file so you guys can see the detail of mine, hope someone can help me , thanks guys ! 



BookingSystem.oml
2020-11-13 07-48-15
Khuong Truong
Solution

Hi Bhetrand,

I updated your .oml (see Items screen), please take a look.

Regards,

Khuong

BookingSystemBackup.oml
UserImage.jpg
Bhetrand Dwilangga

Hi Khuong, nice to meet you again.
Really appreciated it !You helped me again and that was i expected.. Thankyouu!!
Also thankyou for u all guyss!! i learned so much from u guys!

Thankyouu Khuong,

Best Regards,
Bhetrand

2020-11-13 07-48-15
Khuong Truong

Hi Bhetrand,

You're welcome and glad that it helped you again.

Cheers,

Khuong

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