How to assign same input to certain rows in a column

[Alina]

Hello dear Gliders!

Please, advise what is the best way to do the following.

I have a list of workers, I check a few of them who worked for 8 hours today, and assign this number to all of them at once (see screenshot).

It might not be a problem if there are just 5 of them, but imagine that there are 50 workers. And I need to input not hours only but some other inputs to certain multiple workers too.

What is the best way to make it work?

[ThinhDinh]

@Alina

some other inputs to certain multiple workers too.

What are “some other inputs” here?

[Alina]

I mean I need to put not hours only, but also locations, types of activities etc. the same way as hours

[Alina]

They can be predefined choices

[Uzo]

What you are looking for is bulk editing… not possible in native Glide components, but there are some workarounds for that:

Bulk clear, edit, restore and delete columns plus Undo action

A little fun with Glide columns, using Java It works well and fast. You can edit or clear the whole column in one click… then undo, edit, or restore all to default. I used a regular inline list. You can still edit, add or delete individual rows as usual. It is a free app with no scripts and no Google Sheets… Pure Glide Page (App) [Screen Shot 2023-03-22 at 3.02.52 AM]

[ThinhDinh]

@Alina

I have a list of workers, I check a few of them who worked for 8 hours today, and assign this number to all of them at once (see screenshot).

Is the column you’re working with a basic column or a user-specific column? If it’s a basic column you can leverage the Glide API to do it.

[Alina]

Thank you for your idea.

Can you explain it to me a bit more, please?

[ThinhDinh]

Using Glide Tables API | Glide Docs

You can use a Call API action (Business/Enterprise) or a combination of webhook & Make.com to do HTTP calls and adjust the values using the “set-columns-in-row” action.

[Alina]

Thank you! I will try to do this.