499
Views
13
Comments
Solved
Use checkbox to add data to your table
Question

Hi! 

Can I use a checkbox to add data to my DB table? For example if I checked the first row of my table as seen below and click the accept button, the STATUS field will  have a value of "VALIDATED"


Thank you!

2024-06-19 07-19-32
JitendraYadav
Solution

Attaching sample application..Thanks!

SampleDemo.oml
2020-07-08 17-58-02
Suprio Roy

Yes u can do so. Inside the action associated with the accept button , update the status field with the selected table record id and then use the update entity action. It will reflect.

UserImage.jpg
Mark Frederick Mabbun

Suprio Roy wrote:

Yes u can do so. Inside the action associated with the accept button , update the status field with the selected table record id and then use the update entity action. It will reflect.

 Hi! 

Sorry I'm actually new in using outsystem. Do you have any sample for this?

 

2021-09-06 15-09-53
Dorine Boudry
 
MVP

Mark Frederick Mabbun wrote:

Suprio Roy wrote:

Yes u can do so. Inside the action associated with the accept button , update the status field with the selected table record id and then use the update entity action. It will reflect.

 Hi! 

Sorry I'm actually new in using outsystem. Do you have any sample for this?

 

 Hi Mark,

welcome to Outsystems.

What you are asking here is very basic stuff, so for starters, take in some of the courses that are available for free.  

relating to your current question, maybe look at

widgets 1

widgets 2


but really, you will learn a lot in short time just going through a whole learning path, such as web developer, mobile developer or reactive. 

Good luck,

Dorine

 

2024-06-19 07-19-32
JitendraYadav

Hi,


Yes just follow below steps,

1. Call list filter based on checkbox selected variable it will give u all selected rows.

2. Then loop through on filtered list and call entity create action and pass the value for saving including status field value.

3. use refresh data to refresh aggregate value

4. call ajax refresh to refresh the table records.

5. Accept button should be ajax submit.


Please let me know.


Thanks

UserImage.jpg
Mark Frederick Mabbun

JitendraYadav wrote:

Hi,


Yes just follow below steps,

1. Call list filter based on checkbox selected variable it will give u all selected rows.

2. Then loop through on filtered list and call entity create action and pass the value for saving including status field value.

3. use refresh data to refresh aggregate value

4. call ajax refresh to refresh the table records.

5. Accept button should be ajax submit.


Please let me know.


Thanks

 

 Hi,

I'm not sure if I did it right? It still now working. Please see below my Accept button action

Do you have any sample .oml example file that I can study? Thanks!

UserImage.jpg
Mark Frederick Mabbun

JitendraYadav wrote:

Hi,


Yes just follow below steps,

1. Call list filter based on checkbox selected variable it will give u all selected rows.

2. Then loop through on filtered list and call entity create action and pass the value for saving including status field value.

3. use refresh data to refresh aggregate value

4. call ajax refresh to refresh the table records.

5. Accept button should be ajax submit.


Please let me know.


Thanks

 Sorry I'm now sure what do you mean with the 1st step call list filter? I have already added call entity update action but still not working. 


 

UserImage.jpg
Mark Frederick Mabbun

Thanks!

2024-06-19 07-19-32
JitendraYadav

Cool enjoy OutSystems World!

2024-06-19 07-19-32
JitendraYadav

In the loop you have to update records.


Call entity update action to update the value.


Thanks.

2024-06-19 07-19-32
JitendraYadav
Solution

Attaching sample application..Thanks!

SampleDemo.oml
UserImage.jpg
Mark Frederick Mabbun

It's ok now! I got it! Thanks!


2024-06-19 07-19-32
JitendraYadav

Cool finally..Thanks!

UserImage.jpg
Mark Frederick Mabbun

Tried this method heheh

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