Autofill values in specific column

Looking to do:

Is text "unit" in file name?

If yes then perform following tasks:

1. Look for cell containing text "location".
2. Change the cell value to "1" for cells in the following range: From the cell immeadietly below the "location" cell, all the way until the last row with data in ANY column on the spreadsheet.

Very important to note that the cell with value: "location" could be anywhere in the spreadsheet. I attached a sample with one possible example of where the cell could be, and how I need the script to adapt to it.

Spreadsheet has before and after example.