Can I create a TableView and a CardView together

Rayman Bacchus
Contributor
September 27, 2024

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)?

3 answers

1 accepted

0 votes
Answer accepted
Alex Medved _ConfiForms_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 27, 2024

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
Contributor
September 27, 2024

What I have done is this:


Capture2.PNG

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_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 27, 2024

What is IntakeNumber ? And what is IntakeRef?

Rayman Bacchus
Contributor
September 27, 2024

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_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 27, 2024

Both are text fields?

0 votes
Rayman Bacchus
Contributor
September 27, 2024

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_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 27, 2024

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

Like Rayman Bacchus likes this
0 votes
Rayman Bacchus
Contributor
September 27, 2024

Hi Alex:

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

Capture.PNG

Where MergedIntake.IntakeNumber = FY24FrdIntakeTasks.IntakeRef.

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

Alex Medved _ConfiForms_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 27, 2024

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events