nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

confiform view on records with smart multi row

Maximilian Neufeld

Hey there,

I have a form that has the identical function as in the example provided on the confiform documentation. (Picture beneath)

It has a field that is a smart multi row (getting the fields of form2).

What I want to know: Is it possible to analyse and visualize the records individually grouped by the data of the smart multi row field.

So referencing the example in the picture I would like to make a table view that shows me every record in which the name of the participant is Alex.

I know I could just make a view on the data of Form 2 where the records get saved as well but there I have no field that connects the record to the Testname of Form1.
Any ideas or approaches to solve that?
Greetings Max

Accepted answers

Alex Medved _ConfiForms_

You can have a filtered data, yes

Multiple options and expressions.. for example using this as a filtering expression

participants.asFilteredBy(Name:Alex).asCount:>0

Re: Based on the forms configured in this tutorial

Alex

All comments

Alex Medved _ConfiForms_

You can have a filtered data, yes

Multiple options and expressions.. for example using this as a filtering expression

participants.asFilteredBy(Name:Alex).asCount:>0

Re: Based on the forms configured in this tutorial

Alex

Maximilian Neufeld

Is this working when I put it in the Table view of the "testsForm" from the example you linked?
Or do I have to put it in a Tableview on the participantsForm ?

Alex Medved _ConfiForms_

Yes, that is the filtering expression to put over the views that are configured over the "testsForm"

Screenshot 2023-08-17 at 08.40.29.png

Alex

Maximilian Neufeld

It seems like this is not working for me... But I am not sure if Im missing something.

Main Form = CRCTest

Second Form (for Multi Row input) = OS

(I hope it is okay if I add the Source Code here.. Probably its easier to find a solution then.)

<ac:structured-macro ac:macro-id="cf75128c-6851-4fc4-bc04-acb636b91484" ac:name="confiform" ac:schema-version="1">
<ac:parameter ac:name="formName">CRCTest</ac:parameter>
<ac:rich-text-body>

<ac:structured-macro ac:macro-id="f8f9b10c-81c3-4899-8888-b65c064cf871" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">PName</ac:parameter>
<ac:parameter ac:name="fieldLabel">PName</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
</ac:structured-macro>


<ac:structured-macro ac:macro-id="56d67033-5baa-45a0-94d2-be6023468675" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">participants</ac:parameter>
<ac:parameter ac:name="fieldLabel">participants</ac:parameter>
<ac:parameter ac:name="values">[324136445:OS]Amount,Size,Typ,</ac:parameter>
<ac:parameter ac:name="extras">table</ac:parameter>
<ac:parameter ac:name="type">smartmultirow</ac:parameter>
</ac:structured-macro>

</ac:rich-text-body>
</ac:structured-macro>

 

<ac:structured-macro ac:macro-id="181b58ca-bfc4-415d-8bdb-f5b1575241c7" ac:name="confiform-entry-register" ac:schema-version="1">
<ac:parameter ac:name="formName">CRCTest</ac:parameter>
<ac:parameter ac:name="type">Embedded</ac:parameter>
<ac:parameter ac:name="regControlLayout">true</ac:parameter>
<ac:rich-text-body>

<ac:structured-macro ac:macro-id="a4290318-0f79-4f38-9844-768827d17460" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">PName</ac:parameter>
<ac:parameter ac:name="withLabel">true</ac:parameter>
</ac:structured-macro>


<ac:structured-macro ac:macro-id="4208268c-3fd5-4a25-9dcf-c0bd642adb61" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">participants</ac:parameter>
<ac:parameter ac:name="withLabel">true</ac:parameter>
</ac:structured-macro>

</ac:rich-text-body>
</ac:structured-macro>

 


 

<ac:structured-macro ac:macro-id="7997be99-41ab-448e-8190-eb2afa587de3" ac:name="confiform-table" ac:schema-version="1">
<ac:parameter ac:name="filter">participants.asFilteredBy(Typ:Windows).asCount:>0</ac:parameter>
<ac:parameter ac:name="enableFilterSupport">true</ac:parameter>
<ac:parameter ac:name="formName">CRCTest</ac:parameter>
<ac:rich-text-body>

 

</ac:rich-text-body>
</ac:structured-macro>

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server

confiforms