Skip to main content

Hi,

I am trying to create an automation involving attachments. When the attachment gets uploaded into the one table (Incidents and in Incident Report/Doc… column),



it will appear in another table (Tenants and in Incidents column)


Trigger: When record matches conditions

Table: Incidents

Condition: Incident Report/Doc is not empty

Test Run: Successful


Action: Update Record

Table: Tenants

Record ID: (this is where I’m stumped). I choose Name as that is the common field between the two tables.

Field: Incidents


I have linked the fields together but it adds additional steps so I am hoping to eliminate that aspect.

Hi @Office_Manager



You should add the “Record ID” from the trigger record. So in this step, go to the “+” in the field below “Record ID” and select “Record (from Step 1: When a record …) > continue > Record ID > insert”.



I dumbed it down to maybe help other forum users as well.

Thanks @Databaser

Unfortunately, I am still getting Test Failed.

Thanks @Databaser

Unfortunately, I am still getting Test Failed.


Did you “test” the trigger step? Because it’s a waterfall system. If you don’t test the trigger, you have no data to test the action.

Did you “test” the trigger step? Because it’s a waterfall system. If you don’t test the trigger, you have no data to test the action.


Yes I did.


The Trigger passes. The action does not.

Did you “test” the trigger step? Because it’s a waterfall system. If you don’t test the trigger, you have no data to test the action.


@Databaser

I got it to run successfully now but the attachment won’t update in the table it needs to update.

Trigger: When Report Received is (checked)

AND: Incident Report/Documents is not empty

Test Successful


Update Record:

Table: Tenants

Record: Name of Other Tenant LinkedRecordID

Field: Incident Report/Documents

Test Successful


But the attachment from Trigger does not appear where it should from Update Record.


I have linked my tenants up so that helps a bit as you can see below. You will also see my Trigger and that it tests fine!



However, the action is not working despite testing successfully. It only adds the Complainant’s Name to the Record under Tenants then I have to click through to access the record. I want the attachment to appear! What is wrong with the ACTION?


@Databaser

I got it to run successfully now but the attachment won’t update in the table it needs to update.

Trigger: When Report Received is (checked)

AND: Incident Report/Documents is not empty

Test Successful


Update Record:

Table: Tenants

Record: Name of Other Tenant LinkedRecordID

Field: Incident Report/Documents

Test Successful


But the attachment from Trigger does not appear where it should from Update Record.


I have linked my tenants up so that helps a bit as you can see below. You will also see my Trigger and that it tests fine!



However, the action is not working despite testing successfully. It only adds the Complainant’s Name to the Record under Tenants then I have to click through to access the record. I want the attachment to appear! What is wrong with the ACTION?



I see that you are not specifying which attachment it needs to add within the “action” part. Use the blue “+” to select that, just like you did for the record ID.



Does that work?

I see that you are not specifying which attachment it needs to add within the “action” part. Use the blue “+” to select that, just like you did for the record ID.



Does that work?


Hi

It did not work. However, after discussions with AirTable Support, it was determine to best practice to link certain items and that works. Thank you for your help.

Reply


Terms & Conditions