Skip to main content
Solved

Need help with Field Update Automation

R
Forum|alt.badge.img+3

Hey all, 

I have a table which is a  synced report from Salesforce that shows me opportunities coming up for renewal. 

I also created a different table with the same fields but is populated from the Salesforce report "SFDC Renewals Report" via automation: When condition is met (opportunity ID is not empty) - then create record in the second table "AE<>RAE Worksheet". 

My issue is that we moved accounts around in Salesforce and now some accounts have a different Renewal Account Executive or Sales Person. 

I cannot figure out how to automate the update of that Renewal Account Executive field in the "AE<>RAE Worksheet" to match the one in the synced salesforce report. 

 

Any help is greatly appreciated

Best answer by DisraeliGears01

Ah, I didn't notice how you were working across tables.

The issue is your update automation can't identify the records in the AE Worksheet, because the trigger is referring to an Airtable Record ID in the SFDC table. You need to add a "Find Records" step that matches the records in the tables. 

I've attached a screenshot of a similar one I'm using to correlate a registrations table with a contacts table. For your instance, the trigger ids a record in SFDC. Then for Find, you say "Find records in AE where Opportunity Name = Opportunity Name from IDed record in SFDC". Now the automation knows the record it needs to edit in the AE table, and you use the Record ID output from the Find action in the Record ID field for your update action. 

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

5 replies

DisraeliGears01
Forum|alt.badge.img+17

Your issue may be the Record ID field in the second screenshot. Rather than your "Opportunity ID" it should probably be the Airtable Record ID, which is identified in the trigger. That problem would also result in weird looking Record ID displayed in screenshot 3. 

TheTimeSavingCo
1 person likes this
  • TheTimeSavingCo
    TheTimeSavingCo
TheTimeSavingCo
Forum|alt.badge.img+28

Yeap @DisraeliGears01 's got it right

Here's a screenshot of how to select it:

Adam, Consultant @ thetimesaving.company
R
Forum|alt.badge.img+3
  • Rahmanberrada
  • Author
  • New Participant
  • 3 replies
  • August 23, 2024

I tried that but then I get "The Record Doesn't Exist". 

I then went and looked up the Airtable Record ID for both and they don't match since it's not duplicating the record but creating a new one. 

Below is the original automation to create a record in the AE<>RAE tab from the SFDC report when "record matched conditions" as "Opportunity Id" is not empty. 

In this case, should I have not have it create a record but simply have it duplicated in the AE<>RAE Tab? That way it would have the same Airtable ID ?

1 Attachments
DisraeliGears01
Forum|alt.badge.img+17

Ah, I didn't notice how you were working across tables.

The issue is your update automation can't identify the records in the AE Worksheet, because the trigger is referring to an Airtable Record ID in the SFDC table. You need to add a "Find Records" step that matches the records in the tables. 

I've attached a screenshot of a similar one I'm using to correlate a registrations table with a contacts table. For your instance, the trigger ids a record in SFDC. Then for Find, you say "Find records in AE where Opportunity Name = Opportunity Name from IDed record in SFDC". Now the automation knows the record it needs to edit in the AE table, and you use the Record ID output from the Find action in the Record ID field for your update action. 

1 Attachments
R
Forum|alt.badge.img+3
  • Rahmanberrada
  • Author
  • New Participant
  • 3 replies
  • August 23, 2024
DisraeliGears01 wrote:

Ah, I didn't notice how you were working across tables.

The issue is your update automation can't identify the records in the AE Worksheet, because the trigger is referring to an Airtable Record ID in the SFDC table. You need to add a "Find Records" step that matches the records in the tables. 

I've attached a screenshot of a similar one I'm using to correlate a registrations table with a contacts table. For your instance, the trigger ids a record in SFDC. Then for Find, you say "Find records in AE where Opportunity Name = Opportunity Name from IDed record in SFDC". Now the automation knows the record it needs to edit in the AE table, and you use the Record ID output from the Find action in the Record ID field for your update action. 


Thank you so much!!! 

Reply


Most helpful members this week

Terms & Conditions