Skip to main content

Hello Airtable Community


I’ve been going around in circles on this problem, and am SO close using an automation, but not quite.


Three tables:



  1. PLACES - List of places to hire (inventory)

  2. BRIEFS - List of briefs (the requirements of the hirer)

  3. SELECTION - List of a places linked to a brief i.e. the selection to present to hirer (client portal)


The interface for internal use:

Page 1: Create a new brief (form)

Page 2: Active briefs (record view)


The workflow:

Ideally, the internal users would be able to add multiple places (linked records) to the Active briefs (record view). And when a place is linked to a brief (places can/will be linked to multiple briefs) a new record is automatically created in the Selection table as a unique record linking the location to the brief.


The client portal:

I am using the SELECTION table to create a Softr app to present the selection/response to the hirer - looking up details of the place from PLACES. The hirer can only see selections relevant to them (their email linked to the BRIEF)


The automation so far:

When a new BRIEF is linked to a PLACE (i.e. “when a record is updated”, create a new record in the SELECTION table.

Brief name and place names are automated to pull through - and work.


Where it goes wrong:

When a place is recommended in another brief (this will happen frequently) a new record is created in the SELECTION table. It pulls through ALL the previous briefs linked to that record as well as the new brief.


Seeking your expertise and advice:

How do I create a record in the SELECTION table that links one place with one brief each time?


Many thanks for your kind help. I hope I have presented the problem clearly enough.

Hey Lara - as you stated the problem is that you need to have the automation run through one record at a time to work. You can achieve this with a combination of rollup, lookup fields and views filtering out one record at a time +MIN(values)within the rollups. This base does exactly that - Airtable Automation: Cycle through one automation at a time


Simply rename the ‘value’ fields in the first and second table. Essentially, places=table 1, briefs=Items to Process, selection=🔗 Value in the base above.

Hey Lara - as you stated the problem is that you need to have the automation run through one record at a time to work. You can achieve this with a combination of rollup, lookup fields and views filtering out one record at a time +MIN(values)within the rollups. This base does exactly that - Airtable Automation: Cycle through one automation at a time


Simply rename the ‘value’ fields in the first and second table. Essentially, places=table 1, briefs=Items to Process, selection=🔗 Value in the base above.


Hey Dan - thanks so much for responding! I’ll give it a try tonight and let you know how I get on.

I appreciate the help.

Reply


Terms & Conditions