Confluence User •

06 Oct, 2020 •

confluenceUser •

•

confluenceUser •

This can be done via Javascript in a custom HTML form element.

Do try my sample code snippet below and replace the necessary parameter values:

var values = FormUtil.getGridCellValues("spreadsheetId.columnId");
FormUtil.getField("targetFormFieldId").val(values[0]);

Confluence User •

06 Oct, 2020 •

confluenceUser •

•

confluenceUser •

I change my spreadsheet to grid and try the code but it did not return the grid data to field Plant(s) and PIC as an array. 

Here what I did;

Thank you!

Confluence User •

06 Oct, 2020 •

confluenceUser •

•

confluenceUser •

As mentioned, my script is Javascript, not Java (Bean Shell). Place code in custom html form element.

1

CSV | Excel | XML | PDF