I modified the Planning Flow with Jira template to support just updating the Sprint (customfield_10007 in our Cloud instance) values of an issue. We would like to plan at that level using Coda - it’s annoying to bulk edit Sprints in JIRA Cloud.
I created a manually populated Sprints table in Coda to line up Sprint Names with their sprintID in JIRA. The sprintID is stored as number column in Coda and JIRA and a number is required via JIRA API to update the Sprint of an issue. However, I continually get the following error when using the UpdateIssue button to push a Sprint value update from my Coda doc:
Number() function used in values section of button formula:
Jira::UpdateIssue([Jira], thisRow.Issue.Key, 'customfield_10007', Concatenate("Number('",thisRow.[Sprint ID],"')"))
With raw sprintID value plugged in:
Jira::UpdateIssue([Jira], thisRow.Issue.Key, 'customfield_10007', 446)
Thanks in advance!