Define formatter for Jira Excel export of Custom Fields

I have defined a Custom Field and added a formatter expressions like this

modules:
  jira:customFieldType:
    - key: foo-bar
      name: Foo Bar
      type: object
      formatter:
        expression: "`${value.selection.map(o => o.name).join(', ')}`"

However this expression seems to be ignored for Excel export, whereas it is considered in Word.

Any ways to fix this? Is this a known issues?

Thanks in advance,
paul

Hi @ppasler,

Right now the formatter is not used in CSV/Excel exports. This is a feature thanks to which if you ever wanted to import the exported values back into Jira, it would still work.

That said, we are considering different options of addressing this, as we realize in some use cases exporting with the formatter would be preferable. Unfortunately, I can’t share any details or dates at this point.

Hope this helps, let me know if you have any more questions.

1 Like

Thanks @kkercz for the explanation! I better understand the intention for not using the formatter in this case.

Can you think of any workaround to get a nicer export format for our custom field?

Not really, apart from using a string type custom field with human-readable values, which would deny you all benefits of the object type, so I imagine isn’t feasible.

Thanks again! Last question: is there a ticket to watch?

In fact, yes, we’ve already had this feature request: [FRGE-1127] - Ecosystem Jira

2 Likes

UPDATE: the issue is now resolved and can be set up in the manifest.yml

https://developer.atlassian.com/platform/forge/manifest-reference/modules/jira-custom-field-type/#using-formatters-in-csv-export

2 Likes