How to apply a mass update like this video in SC?

Can you help me please

And how can I search multiple records by copy and paste?

You can do it with SC. I did see the video. I think you must filter your records for then update them. same way that video you can create a grid and un buton with a form for fill the data for update the selected records.

1 Like

It’s a wonderful solution, So I tried a lot and couldn’t.
Can you help me please?
I want to filter the grid application by any field, such as the employee number field, So when I copy and paste the employee numbers into the employee number field ,The program will automatically filter the grid.
Then I select these employee numbers with a check mark,
Then I choose the variables above, and based on them, the employee numbers that you specified earlier are updated.

I think you must begin to create the GRID like show this link for you can select and filter your record.

1 Like

Many thanks for your response.
I am very grateful to you for all that you have helped me.
You explain this solution before in this link:
Run button insert multiple record from search fields in Grid application
But I need some to update the selected data based on filed variable .
Also I need multiple search one time using copy and paste technique.

and this suggestions :

But I don’t know how to apply it
And this also:

Thanks in advance

The directions in my post are pretty clear and detailed as to how to do it…
make a Control application with a Multiple Line text box

Right I test it ,But really not working for me

Post your code and let us take a look

1 Like

I changed the code in SQL like this:
SELECT
Accommodat_Emp_ID,
Accommodat_Emp_Date,
Room_IDF,
Room_IDF_Previous,
RoomChange_Date,
House_IDF,
House_IDF_Previous,
HouseTransfer_Date,
Supervisor_Name,
Supervisor_Previous,
Supervisor_Date,
EmployeeNo,
Housing_Date,
Housing_Reason
FROM
emp_accommodate
WHERE EmployeeNo IN (’[myarray2]’)

So now result

a grid application working very good alone without a control app like this:

but control application show error like this:
image