TableView Merger Active Filter

[Enrico Steinbach]

Hi everyone!

I have to forms (Form1 and Form2). In Form1 i write Changes concerning new instructions (Field Content as text). In Form2 the co-workers must sign these Changes. So in Form2 is a Field Content as smart dropdown referenced to Field Content in Form1.

Now I would like to display the respective change and with it the names of the co-workers who signed it. But Table View Merger shows all changes. Is there a filter with which I can select the changes and it shows me the associated co-workers?

Thx for help!

[Alex Medved _ConfiForms_ · Accepted solution]

Hi @Enrico Steinbach 

Your forms dont have a common key that ConfiForms can use to merge data rows

Trying building a TableView over your form 1 and add an additional ConfiForms Field macro that uses queryAndRender function to retrieve rows from form 2 matching the form 1 row

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

id.queryAndRender(Form2:@self;Content:[entry.id];Name;table)

Alex

[Enrico Steinbach]

Hello Alex,

I built it as you described:

But i got only an empty id column back:

[Alex Medved _ConfiForms_]

Recorded a video for you, hope it helps

[Enrico Steinbach]

It works! You are great! Thank you!

[Enrico Steinbach]

Hi @Alex Medved _ConfiForms_ 

there is one question left (probably the last :-))

Is it possible to build a "created" into the queryAndRender function? So that i can see, when the sign was made?

[Alex Medved _ConfiForms_]

While recording the demo for you I have also tried to show the "created" field, but found out that it was not working (that will be fixed shortly)

And this construction will work

id.queryAndRender(Form2:@self;Content:[entry.id];Name|created;table)

To workaround this issue now you can set up an IFTTT macro that auto-assigns the value to some hidden field and use that

This is what I mean

IFTTT to update field onCreated

entryId=[entry.id]&signedWhen=[entry._now]

Rule to hide the field

and the field itself, added to Form2

Changing the expression to use the new field

id.queryAndRender(Form2:@self;Content:[entry.id];Name|signedWhen;table)

Alex

[Enrico Steinbach]

You are my HERO!! Thx!

[Enrico Steinbach]

Ok, i have a very last question:

Is it possible to hide any content? I made a Form3 with  Content as Smart Dropdown and used the queryAndRender - expression as above with a tableview Form3. So when i chose the Content i would get the Names only for the chosen Content. Unfortunately i get no Names in the Table.

[Alex Medved _ConfiForms_]

I dont quite understand your "very last question", sorry.

[Enrico Steinbach]

@Alex Medved _ConfiForms_ 

Maybe I haven't quite understood it yet either :-)

In Form3, I select a single content that is saved as the only value in the database (ConfiForms Rules for Field Definition 'reset value'). This value references to the names in Form2 that were drawn for this value.

So that I get all the names listed only for the single value 'content' in Form2.