- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 29, 2025 01:40 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 29, 2025 08:18 PM
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
