It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Script Runner how to populate scripted field with text string based on number value in another field Edited

Hi,

I'm new to Script Runner and don't know the syntax of the coding well yet.  I have successfully created one scripted field which is calculating/getting a number value.  I'd like to now look at that field and populate another field based on the number to be able to track on-time delivery metrics.  So for example, if my number in my first field is negative, (<0) i'd like the second scripted field to prepopulate with the text string "early" or if the first field =0, my second field would populate as "on-time".  >0 but < 21 would = "1-20 days late" etc.  

I don't see much of a reference to how to set this up.  Any help or direction much appreciated.  

Here's what i've started with... but it's not recognizing my syntax and i don't know where to confirm how it should be.

1 answer

0 votes
nic Community Leader Jun 19, 2017

At a glance, your code looks broadly ok.

There's a couple of neat tricks with scripted fields though.  If you edit their scripts in-line, there is a basic syntax checker built in.  So you'll get told if your code is not going to work.

Beneath the code entry box, there's also a preview option, where you fill in an issue to try the script against, repeatedly.  So set up two test issues, one with your numeric field set to 42 and the other with -4 or something, then you can test for both cases.

Also, you might want to check that the output type is set to text, as that's what you are currently returning.

Hi Nic,

I agree, the syntax and issue preview are helpful. i've made some additional changes to the code and am really close... i think.  I also do think i'm setting my output to text.  Here's what i've got now and the error i'm getting.  

Does anything jump out as being wrong?  Am i missing a bracket or is something bigger not defined?  

1PARE.PNGPAR.PNG

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Marketplace Apps & Integrations

Marketplace Spotlight: Manage your assets with asset management apps

  The role of IT professionals has become increasingly difficult over the last decade. Our organizations work in an increasingly software-powered world and IT professionals are expected to not...

259 views 3 9
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you