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)?
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
What is IntakeNumber ? And what is IntakeRef?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Both are text fields?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
So, one of the fields is actually a smart field... OK, it makes sense now
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.