Relative Airtable newbie here but hit my first real roadblock and hoping the community can help.
I have a base with two tables linked via one field. For context, it’s an action figure DB. Cause that’s how I roll.
Figures is linked to Accessories via 1 field that allows multiple entries. eg: 1 figure can have many accessories. Accessories are a seperate table as they have their own unique properties that don’t fit in the Figure table such as colour, type and picture.
Each Figure record has a 100% Complete field that is a tick box. Each accessory has an Owned field, also a tick box. While you can tick each Accessory accordingly, I’m looking for a way to automate it such that when ticking Complete on a figure, it looks at all the linked records and flags them as Owned
Is this possible? I’ve looked in Automations but can’t seem to work it out.