How to merge to table

[jean meheust]

Hello I have created two table with confiform witch have one column in common

The fist one is like this

F1 : two fields

Number title

124.        Bbbb

The second

F2 : two fields

Number notation

124.     6

124.     7

After the merger i want to have this

124   6 Bbb

124   7 Bbb

Tableview merger is it a good way to to this

If yes how to configure the field

Thank you for your response

[Alex Medved _ConfiForms_ · Accepted solution]

Hi @jean meheust 

With such structure there is no way you can merge data into this result

There seems to be different "common keys" - one is just a 124 and another one should be merged with a 124+6 and 124+7

There is no way ConfiForms could know that the row in form 1 belongs (somehow) to those 2 rows

Alex

[jean meheust]

Thanks a a lot. 

How can i do this. 

Must i use SQL 

Thank for your response

[Alex Medved _ConfiForms_]

You can probably build a view over the form2 and add an extra ConfiForms Field macro where you can utlize the "queryAndRender" or "queryAndSet" functions to lookup values form the form 1 

https://wiki.vertuna.com/display/CONFIFORMS/Virtual+functions

[jean meheust]

I will try but i think i will bee a bit difficult for me. 

Thanks a lot. 

[jean meheust]

Hello

Is it a good idea to add a new field to the forme F2 and to feed this field automaticly with the value from the form F1.

If it-is, I do not know how to manage this. Must i use something like iftt 

How to configure the filter to select the good value in F1. 

How to feed this value in the form F2. 

Thanks for your response

[Alex Medved _ConfiForms_]

Not sure I get your last comment, but here is what I was trying to suggest as a solution to your question

Storage format

<p style="text-align: left;">
<br/>
</p>
<ac:structured-macro ac:macro-id="85e37aaf-14e5-4a6e-9f71-1879a2d078af" ac:name="confiform" ac:schema-version="1">
<ac:parameter ac:name="formName">F1</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="f6683e90-b4b3-4f44-b79d-fd15da5b972d" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">Number</ac:parameter>
<ac:parameter ac:name="fieldLabel">Number</ac:parameter>
<ac:parameter ac:name="type">number</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="13cd3061-114c-45bb-ae0f-80bb8a898117" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">title</ac:parameter>
<ac:parameter ac:name="fieldLabel">title</ac:parameter>
<ac:parameter ac:name="type">text</ac:parameter>
</ac:structured-macro>
</p>
<ac:structured-macro ac:macro-id="19866c81-fca7-43a4-b6fb-be59be1e84c6" ac:name="confiform-entry-register" ac:schema-version="1">
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="512bfa39-0f43-4ed7-a621-f2ffaed81d86" ac:name="confiform-table" ac:schema-version="1">
<ac:parameter ac:name="formName">F1</ac:parameter>
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p>
<br/>
</p>
<ac:structured-macro ac:macro-id="5e62ec4d-f328-4025-87ca-6f82ce40bf24" ac:name="confiform" ac:schema-version="1">
<ac:parameter ac:name="formName">F2</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="87af3be1-3848-4705-b444-cd1fee86f163" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">Number</ac:parameter>
<ac:parameter ac:name="fieldLabel">Number</ac:parameter>
<ac:parameter ac:name="type">number</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="5e46cee4-4381-4372-a9c7-030941f56db8" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">notation</ac:parameter>
<ac:parameter ac:name="fieldLabel">notation</ac:parameter>
<ac:parameter ac:name="type">number</ac:parameter>
</ac:structured-macro>
</p>
<ac:structured-macro ac:macro-id="25ea2e6f-c504-4fb2-8d64-c3a73ac4dab4" ac:name="confiform-entry-register" ac:schema-version="1">
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="8a6e0f31-b424-4f03-9364-34d817e5e050" ac:name="confiform-table" ac:schema-version="1">
<ac:parameter ac:name="formName">F2</ac:parameter>
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<ac:structured-macro ac:macro-id="8c7ebc16-9bed-4426-9ccd-5da201d98756" ac:name="confiform-table" ac:schema-version="1">
<ac:parameter ac:name="formName">F2</ac:parameter>
<ac:rich-text-body>
<p>
<ac:structured-macro ac:macro-id="f4336ff4-d872-4e55-8add-267b24c8b497" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">Number</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="a6f1e759-717f-42c2-9e78-a89526119b46" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="fieldName">notation</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="a7b4e42a-57c3-4028-a106-e9b8e4d275fb" ac:name="confiform-field" ac:schema-version="1">
<ac:parameter ac:name="overrideLabel">Title</ac:parameter>
<ac:parameter ac:name="fieldName">id.queryAndSet(F1:@self;Number:[entry.Number];title)</ac:parameter>
</ac:structured-macro> id.queryAndSet(F1:@self;Number:[entry.Number];title)</p>
</ac:rich-text-body>
</ac:structured-macro>

Video

https://wiki.vertuna.com/download/attachments/178782502/Community%20-%20How%20to%20merge%20to%20table.mov?version=1&modificationDate=1713459200028&api=v2

Hope it makes sense and helps

Alex

[jean meheust]

great.

thank you very much