Let me preface by stating that I am new to airtable.
I have 1 table that lists every compartment of a project. This table has a priority field that changes as the project progresses.
I have another table that lists the tasks of every craft/discipline in all compartments. Each compartment has numerous tasks in it. Each task has a compartment priority field. I would like this field to be automatically updated to match changes made to the priority level in the compartment table. I'm sure this is possible and have attempted to do so with a script but have been unsuccessful so far.