How do I set a field value from a table

Question

I have a table in Confluence that looks like this:

Note that this table is NOT a Confiforms field. It could be an HTML table, a table returned by a Jira filter macro or from anything that produces a table.

In a form, I define a field -- myfield -- of type Text.

I want to select the value in Col2 based on the Key column and assign the text in the cell to myfield.

I have tried reducing this to a table with a single cell with no headers, thus avoiding the lookup:

This is text.

I have not been able to find anyway to do this.

As background, I am using a Jira Filter macro and Table Transformer to produce a table of Jira issues. In a Confiforms form, I enter the JIra Key into a field and want to set a text field to the value in Col2 for that Jira Key.

Can you help? Thank you.

Alex Medved _ConfiForms_ · Answer

Not from arbitrary html table, but you can read the page properties via pageProperties virtual function

Something like

[entry._page.pageProperties(some property)]

That can be accessed in ConfiForms Field Definition Rules or the preset values parameter in the ConfiForms FormView Registrations Control macro... or anywhere in views for filtering, for example

Alex

JiraAdmin_wtid2v · Answer

Yes. Is that possible?

The reason for this is to generate dynamic JQL queries. The data in the table identifies Jira field values to be used in the query. To do that, the Confluence Jira Filter macro requires the use of [entry.myJQLquery] as the JQL string. (Yes, I know you can't do that directly. You have to edit the Storage Format to get that to work.) So I have to get the value from the table into the Confiforms field.

Alex Medved _ConfiForms_ · Answer

Hi @JiraAdmin

Sorry, you want a value from some arbitrary table to be somehow extracted into a ConfiForms field's value in a form?

Is that what you are looking for to get?

Alex