Hi @Kishore Perumal ,

The best way to implement this is by using a Checkbox or Switch for the Status field, since is directly maps to a Boolean (Yes/No) Variable.

You can bind the checkbox variable to: GetAggregate.List.Current.Status.

This way, when the user checks or unchecks the box, the value automatically updated in the record. 

On Submit, you can loop through all the records using a For Each and update them in the database accordingly.

If you want to achieve using Dropdown,

1. Create a local list with values like YES and NO during screen initialization.

2. Bind the list to the dropdown

3. In the OnChange action of the dropdown, assign the selected value to the corresponding record variable.

4. On Submit, use a For Each Loop to save all updated records.

Here you can check the Documentations: Checkbox, Switch, Dropdown

Hi @Kishore Perumal ,

In this case, you can use  Checkbox or Switch. I think dropdowns don't support boolean. 

However, you can add another integer output and when dropdown onchange you can check integer value and reassign the boolean field.

Hope this helps!

Huy Hoang

hi @Kishore Perumal
I’ve created a sample OML—could you please take a moment to review it? I hope it meets your requirements. 

Hi @Kishore Perumal ,

I completely agree with the approach suggested in @Balu 's Table_Drop OML. This idea puts you on the right track and is a good approach to move forward.

The current implementation uses OnAfterFetch to populate the status dropdown with hardcoded values, which works functionally. However, from a best‑practice and maintainability perspective, I would recommend using Static Entities to manage dropdown options and binding the dropdown source to those entities instead. 

Using Static Entities: 

• Improves consistency across the application 
• Avoids hardcoded values in logic 
• Makes future changes easier and safer 
• Aligns better with OutSystems architectural best practices

Thanks again, @Balu , for sharing the solution and for your continued support to the community.

Best

Saugat

Now i have the container which has class

.table-scroll-wrapper {  overflow-x: auto;  width: 100%;}.table-scroll-wrapper table {  width: max-content;}.table-scroll-wrapper th,.table-scroll-wrapper td {  white-space: nowrap;  min-width: 120px;}.table-scroll-wrapper {  max-height: 400px;        /* adjust as needed */  overflow-y: auto;          /* vertical scroll */  overflow-x: auto;          /* horizontal scroll if wide table */}.table-scroll-wrapper thead th {  position: sticky;          /* makes header sticky */  top: 0;                    /* stick to top */  background: white;         /* prevents overlap */  z-index: 3;                /* above data rows */}.table-scroll-wrapper th,.table-scroll-wrapper td {  white-space: nowrap;     /* prevent shrinking */}

inside this i have a table with class "table table-scroll-wrapper"

now all i want is the first two columns of the table to be fixed and other columns should be scrolled horizontally. Here the table has almost 20+ columns.

can anyone suggest?

Hi  @Kishore Perumal , this is completed. The first two columns are fixed and the rest are scrollable. Please check. 

@Balu thanks for the solution i would like to have the table header fixed when scrolled vertically. could you provide me a solution?

@Kishore Perumal, please just add the below CSS alone

The max-height: 400px; is just an example — you can set it as per your requirement. 

.FixedColTable-wrapper {

  overflow: auto;     

  position: relative;

  max-height: 400px;     

}

.FixedColTable thead th {

  position: sticky;

  top: 0;

  z-index: 3;

  background: var(--color-background-primary, #fff);

}