Update all records in a specific report

Do these records have anything in common? For example do they all fall within a payroll period?

A native ACTION may be xble to do this but the set of records to be updated need to be able to be defined by a report link.

Tell us more about the filters in the report.

The report parameters would be:
Manager Name = Current User
AND
Status = Approved

There might also be a period ending date, but that's still up in the air depending on how some of the other development goes.

This can be done with script, but that is coding.
It can be done with a formula URL button and using API_RunImport

But let's see if we can do this with no code.

Make a new table called Payoll Approval.    On that record put a user field (and Make the Key field be a User field),  and a Report Link field and a formula text field called [Link to my Payroll Entries for Approval]

For the [Link to my Payroll Entries for Approval] field make the formula

List("-",UserToName(User()), "Approved")

The effect of that will calculate to John Smith - Approved.

Then on the Payroll records, make a similar formula

List("-", [Manager name userid], "Status")

Use those two fields to configure the Report Link field.

Put the Report Link field on the form for the Payroll Approval and list the records right on the form.

You should see all the records waiting to be Approved for that manager User on the form.

So what we have done is to have created a Report Link field which defines the records to be updated.

Now, make a new checkbox field on the Payroll Approval record.

Now, make an ACTION on the Payroll Approval form that says when the checkbox is checked

EDIT the related records defined by that Report Link and change the value in the field [Status] to the value Approved.

Take a shot at that and we can tidy up the rough edges once you get the ACTION to fire.

Note that when you check the checkbox, you will need to refresh the record  to see the effect.  The effect should be that the report link field goes empty as a report, since there are no longer records waiting  to be Approved.

Hi - Thanks for your help so far, this is working great.....

I'm up to "Now, make an ACTION on the Payroll Approval form that says when the checkbox is checked"

I don't have an option to Edit the Related records when the checkbox.  I've tried to make the dynamic rule both based on either the checkbox being checked or the record being saved AND the checkbox being checked, but I can't see where I'd instruct the application to edit the related records.  

Do I need to have a relationship between the tables, or is there something else I've missed?

By Action, I am referring to an Action, which is quite different that a form rule.

https://help.quickbase.com/user-assistance/creating_a_quickbase_action.html

Okay - I suspected that might be the case.

Let me work on that and I'll come back with (hopefully good) news.

It worked beautifully!!!!

So now, as more records are created and approved, we would simply need to refresh that same record in the Payroll Approval table and repeat that process, and that we would need 1 record in the Payroll Approvals table for each manager.

Good for you!  
Thx for letting me know.

Hurray for Low code / No Code.  In this case we managed to do mass updates with No Code.

I may be too busy to reply but my robot informed me of your comment.

I think the only improvement I need to make to it is to get a button to do multiple steps for the user, and come out of it with the Process for Submission checkbox unchecked again.