Button field to update the source record that was synced into another base

A button field is appended in a synced table. What I would like to do is that once a user clicks the synced record’s button field it will update the source record based on other appended fields in the synced table.

Is this possible? Maybe a script attached to the button field can do it.

Yes, this could be done with scripting or with a no-code automation tool like Make.com.