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; } } }

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

Accepted answers

Alex Medved _ConfiForms_

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

All comments

Alex Medved _ConfiForms_

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.

Welcome!

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

Quick Links

Find more posts tagged with

confluence

data-center

confiforms

confluence-data-center