Help

Re: Need help pulling info from one table to another

61 0
cancel
Showing results for 
Search instead for 
Did you mean: 
SBeau
4 - Data Explorer
4 - Data Explorer

Hello! I am currently pulling info from Jira into a table, and then pulling Sprint Start / End dates from Jira into another table. Because Jira doesn't expose that information directly, it is pulled into a GSheet, which I then pull into Airtable.

  1. The Sprint Name is pulled from Jira directly into my main table, and there is an exact match for each in the Sprint Info table. 
  2. I created a Link to Another Record field which sources from the Sprint Info table, and corresponding Start / End date Lookup fields based on that table. 
  3. I created an Automation that looks for any records in my main table that have a non-empty value and updates the Sprint Info 'Link to' field with the value from the Sprint field (screenshot below).

When I generate a preview of the automation results, I can see that the Sprint Info linked field gets a value, but when I go back to my table, nothing is actually being updated. 

Any idea what I might be doing wrong, or a better way to accomplish this? 

SBeau_1-1732917147727.png

 

 

1 Reply 1

Automations only run on new datta that matches the conditions.  Could I confirm that new data's coming in and the automation isn't running?

---

If you're looking to deal with your old data, try clicking the field header of 'Sprint' and hitting CMD/CTRL + C, then click the field header of 'Sprint Info' and paste, this should link everything up the way you want