Can I create a TableView and a CardView together

[Rayman Bacchus]

In Confiforms I have created a CardView that a few managers on the team will use to review project intake informations (requirements, due dates, etc....).  I also have a TAbleview from a separate form that tracks Action Items (item, required by, due date, etc...).  The two are linked in a Confluence Page by the filter IntakeRef=[entry.id] so only the action items related to the actual intake number will be shown on the Confluence Page.  Meanwhile IntakeRef (from the task form) is a SMARTVIEW of all the Intake Reference Numbers from the main intake form.

Is there a way to combine the CardView (which shows data from the main Intake Form) and a TableView (which will only show items from the Task Form)?

[Alex Medved _ConfiForms_ · Accepted solution]

Not sure why you want to complicate the things like that, but look at the queryAndRender function https://wiki.vertuna.com/display/CONFIFORMS/Virtual+functions

[Rayman Bacchus]

What I have done is this:

---

so basically created a field in the CardView with the queryAndRender function:

id.queryAndRender(FY24FrdIntakeTasks:2634557043;IntakeNumber:[entry.IntakeRef];IntakeRef|Tasks|Assigned|Status|DueDate;table)

This shows ALL rows in the form FY24FrdIntakeTasks, so about 50% there.

I have also tried this:

id.queryAndRender(FY24FrdIntakeTasks:2634557043;IntakeRef:[entry.IntakeNumber];IntakeRef|Tasks|Assigned|Status|DueDate;table)

which I think should be the correct query, but that doesn't seem to show anything 

[Alex Medved _ConfiForms_]

What is IntakeNumber ? And what is IntakeRef?

[Rayman Bacchus]

Intake Number is from the main form and is a alphanumeric field something like (FY2024-1182)
Intake Ref is the same thing but the "sub Form"

So basically I want to queryandRender the subForm and have it show the tasks in the subform on the main view.

[Alex Medved _ConfiForms_]

Both are text fields?

[Rayman Bacchus]

Hi Alex:

I got this to work.

id.queryAndRender(FY24FrdIntakeTasks:2634557043;IntakeRef:[entry.id];IntakeRef|Tasks|Assigned|Status|DueDate;table)

The card now shows the tasks as required.

Thanks, as always for your help.  It is a pleasure

[Alex Medved _ConfiForms_]

So, one of the fields is actually a smart field... OK, it makes sense now

[Rayman Bacchus]

Hi Alex:

Graphically may explain things better.  This is what I want:

Where MergedIntake.IntakeNumber = FY24FrdIntakeTasks.IntakeRef.

In the meantime, I'll take a look at the function you mentioned.

[Alex Medved _ConfiForms_]

No, this does not work - https://wiki.vertuna.com/display/CONFIFORMS/ConfiForms+app+detailed+view+over+the+plugin+macros

TableView/CardView are not able to render a nested macro