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.
- 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.
- 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.
- 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?