I need JavaScript help or tutorial for creating a calculated custom field . I have a field custom field A a single select value field and based on the value selected and a value selected in another Custom field B I want to generate a numeric value in a new custom field. I need the JavaScript for doing this for my Jira issue in the import
Hi @kovanp,
The best approach is to create a JavaScript calculated custom field in eazyBI that calculates the value during data import: Account specific calculated fields.
-
In eazyBI import options, tab Custom fields, choose to adda new calcauted field.
-
Use an AI assistant to write the JavaScript code to cover the logic. The algorithm might be like this: check if both fields A and B exist, then check their values, and assign the numeric value based on the combination. In the code, provide a matrix with possible value combinations and applicable numeric values.
See documentation on Custom field assistant. -
Writing code with or without an AI assistant is an iterative process; validate the code after each change and iteration. We recommend validating code on several issues with A and B fields, and also a few without A or B field to see if the code works correctly: Validate JavaScript code for an account specific calculated field.
-
When the configuration for new field is ready and tested, Save the custom field and mark it for data import.
Best,
Zane /. support@eazyBI.com