Single Bulk Record Updating

I have several Airtable records that need to be updated with the same value in the same field at the same time (payroll processing IDs for projects to be paid out to employees). Since we get a new ID for each week’s payroll run, is there a way we can update all the affected project Airtable records at once via our admin portal in Softr with that’s weeks ID instead of doing one at a time? TIA

An Airtable Automation sounds like a solution to this. It could be triggered from a change you make via your Softr interface, or by conditions from within Airtable.