21
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)

Solution

Hello,

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

Regards,

Komal

tabel.oml

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


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

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

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

Solution

Hello,

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

Regards,

Komal

tabel.oml

Is checkbox have any variable?

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

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

@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.