Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

get changes to compartment table priority to show on work list table

Topic Labels: Formulas
173 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Carlwilk
4 - Data Explorer
4 - Data Explorer

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. 

1 Reply 1
Mike_AutomaticN
10 - Mercury
10 - Mercury

Hey @Carlwilk!

I might be missing the point completely. But what I believe you are looking for is actually a Lookup Field on your tasks table which looks from the Compartment table the field Priority. 

You can find more information on Airtable’s Lookup Fields in this link

I hope this helps, but otherwise please share some more context and/or screenshots. 

Mike, Consultant @ Automatic Nation