26
Views
8
Comments
Solved
Add a input box and mass update

Can anyone help with below function?

1. Select relevant record

2. Add a input Box (i.e. Date field) which allow users to input a value and click 'update' to update specific field

3. All selected record will be updated (Remark)

2021-06-01 05-56-33
Komal Kumbhar
Solution

Hello,

Here i have attached the OML, you will find it in OnBlur screen, Kindly have a look,

Regards,

Komal

tabel.oml
2021-06-01 05-56-33
Komal Kumbhar

Hello Winnie,

What i understood from your question is you need to update the single or all records together.

To update all records or single as well use for each loop with if condition like below,

IsAllSelected will be used to select all the check boxes and IsSelected for specific record.

hope this hepls,

Komal


UserImage.jpg
Winnie Lam

Hi Komal, How can I assign the "Input value" (thats inputted by user) to Remark field to update the record?

2021-06-01 05-56-33
Komal Kumbhar

Add OnChange action on Input Value and add assign widget add follwing

Remark=Input value

Now while updating you will have the remark value from Input value.

Regards,

Komal

UserImage.jpg
Winnie Lam

Can you share your oml to show me cuz sometimes it works but sometimes stuck and can't change the input value. Thanks!

2021-06-01 05-56-33
Komal Kumbhar
Solution

Hello,

Here i have attached the OML, you will find it in OnBlur screen, Kindly have a look,

Regards,

Komal

tabel.oml
2024-07-17 07-59-24
Pratya Homhual

Is checkbox have any variable?

Then new some logic for set check is true then update data with input value where checkbox is true.

UserImage.jpg
Winnie Lam

@Pratya Homhual @Komal Kumbhar It works now. Thanks for your advise.

2023-10-10 10-21-43
Ricardo Silva

@Winnie Lam Hello, just a reminder that for bulk updates, you should use advanced query

https://success.outsystems.com/documentation/best_practices/performance_and_monitoring/performance_best_practices_queries/

Topic.  Use SQL queries for bulk operations

If you need further help don't hesitate


Ricardo. 

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