Skip to main content
Solved

Automation to Update Linked Record with Same Name

HaraldPalma
Forum|alt.badge.img+4

I'm trying to set up an automation in Airtable and could use some help. Here's what I'm aiming to achieve:

Scenario: I have two tables in my Airtable base:

  • Table A (Products): This table contains product records.
  • Table B (Orders): This table contains order records, each of which is linked to a product from Table A.

Goal: Whenever a new record is created in Table A (Products), I want to automatically update a linked record in the same Table with the same product name (Products).

Issue: I'm unsure how to set up the action to update the linked record in Table A with the same product name  (Products).

Could someone guide me through the steps to set up this automation in Airtable? Any detailed instructions or tips would be greatly appreciated!

Thank you in advance for your help!
Also include a picture

Best answer by TheTimeSavingCo

Hmm, try using the record ID of the triggering record like so:

Resulting in this:

Link to base

I'm very curious what the business logic here is though!  Why do you need to link the record to itself?

View original
Did this topic help you find an answer to your question?

3 replies

TheTimeSavingCo
Forum|alt.badge.img+28

Hmm, try using the record ID of the triggering record like so:

Resulting in this:

Link to base

I'm very curious what the business logic here is though!  Why do you need to link the record to itself?

Adam, Consultant @ thetimesaving.company
HaraldPalma
Forum|alt.badge.img+4
  • HaraldPalma
  • Author
  • Participating Frequently
  • 6 replies
  • July 5, 2024

Hi Adam, good point, thank you very much. This question already answered my problem :-). You are right, why would I do this... at the end, this was my mistake where I was thinking too complicated.

TheTimeSavingCo
1 person likes this
  • TheTimeSavingCo
    TheTimeSavingCo
S
Forum|alt.badge.img+2
HaraldPalma wrote:

Hi Adam, good point, thank you very much. This question already answered my problem :-). You are right, why would I do this... at the end, this was my mistake where I was thinking too complicated.


Hello, I read this nice article. I think You put a best effort to write this perfect article. I appreciate your work. thank you so much. 8 Ball Leather Jacket 

Reply


Most helpful members this week

Terms & Conditions