How to display missing entires in confiforms

[Christian Perry]

Hi there, I currently have 2 forms on 2 pages. Lets say form 1 holds a master list of 3 fields: name, subject, clasroom (some names will be associated with multiple subjects)

form 2 is where I gather scores from the teachers

as of now I have a smart classifier in form 2 to reference the name and subject of a teacher in form 1 (which spits out a string like this "name > subject"). I named the smart classifier nameSub

in form 2 I have a table that shows nameSub (unless there is a way to separate it back to name and subject) and score.

Is there a way I can reference this table in form 1 to show me what name subject combinations have not submitted scores?

thanks

[Alex Medved _ConfiForms_ · Accepted solution]

Hi @Christian Perry 

Yes, of course, this is possible

In the ConfiForms Field's field name parameter put 

nameSub.name

to show the name

And 

nameSub.subject

to show the subject

That is if you want to build the view over the form2

If the view is over form1 then add a ConfiForms Field macro and utilize the queryAndRender function - https://wiki.vertuna.com/display/CONFIFORMS/Virtual+functions

Alex

[Christian Perry]

Thank you for the answer, that's going to make things much easier. Is there a way I can reference this table in form 1 to show me what name subject combinations have not submitted scores?

[Alex Medved _ConfiForms_]

Yes, that is also possible - that is what the queryAndRender function could be used for

Basically rendering form2 data filtered by

nameSub:[entry.id]

[Christian Perry]

So if form 1 is called mainList and form 2 is called testScores and I want the missing entires to show up on a separate page would I create a tableview on that page that references testScores with a field called nameSub.queryAndRender(testScores:pageid;nameSub:[entry.id];table)?

[Alex Medved _ConfiForms_]

In this case you create a view over the "mainList" form, dont you?

And the field name expression would be

id.queryAndRender(testScores:pageid;nameSub:[entry.id];name|subject;table)

[Christian Perry]

I created a test form to try this out but it doesn't seem to be showing the not submitted entries 

[Christian Perry]

the first screenshot didn't make it in 

id.queryAndRender(entryTest:7400956470;nameSub:[entry.id];name|subject;table)

[Alex Medved _ConfiForms_]

I am confused - lots of other forms... but this barely makes sense

id.queryAndRender(entryTest:7400956470;nameSub:[entry.id];name|subject;table)

I dont see fields name and subject in the entryTest form

What are you trying to do?

I was trying to answer the initial question, based on the information you have given

[Christian Perry]

sorry yeah I created a page that I can play around with that won't break the main page. 

entryTest is where score is submitted from nameSub

nameList is the master list with all of the teacher names and subjects

nameSub is a smart classifier of name and subject from nameList

my goal is to display a table of name subjects that have not submitted a score. 

I have viewed the info here  https://wiki.vertuna.com/display/CONFIFORMS/Virtual+functions but im still a little confused where to put this field in order to get the data that I want to show

[Alex Medved _ConfiForms_]

What do you have in ConfiForms Field's field name parameter here?

[Christian Perry]

I couldn’t figure out if I needed the query to be like a calculated field or to just put the formula in the field spot. As of now it has no name but we can call it missing 

[Alex Medved _ConfiForms_]

Maybe this video could help

With the test storage format for form's configuration for the reference

<ac:structured-macro ac:name="confiform" ac:schema-version="1" ac:macro-id="9ae82ea2-f642-4a69-896c-c7fa29223909"><ac:parameter ac:name="formName">nameList</ac:parameter><ac:rich-text-body><p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="1201328e-292a-41d4-bec2-2392fdd271a3"><ac:parameter ac:name="fieldName">name</ac:parameter><ac:parameter ac:name="fieldLabel">Name</ac:parameter><ac:parameter ac:name="type">text</ac:parameter></ac:structured-macro></p><p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="662bc6eb-588f-4a25-926d-b61dc4cf26bf"><ac:parameter ac:name="fieldName">subject</ac:parameter><ac:parameter ac:name="fieldLabel">subject</ac:parameter><ac:parameter ac:name="type">text</ac:parameter></ac:structured-macro></p><ac:structured-macro ac:name="confiform-entry-register" ac:schema-version="1" ac:macro-id="93d22506-c11c-4656-b455-196faa5a2cca"><ac:rich-text-body><p><br /></p></ac:rich-text-body></ac:structured-macro><p><br /></p></ac:rich-text-body></ac:structured-macro><p><br /></p><ac:structured-macro ac:name="confiform" ac:schema-version="1" ac:macro-id="0d5dbf93-df2d-461b-aa79-5bc3ce941f79"><ac:parameter ac:name="formName">testScores</ac:parameter><ac:rich-text-body><p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="cbd00bc5-2349-4b61-8632-cf3dc56c36a6"><ac:parameter ac:name="fieldName">nameSub</ac:parameter><ac:parameter ac:name="fieldLabel">nameSub</ac:parameter><ac:parameter ac:name="values">[218464398:nameList]name,subject,</ac:parameter><ac:parameter ac:name="type">smartclass</ac:parameter></ac:structured-macro></p><p><ac:structured-macro ac:name="confiform-field-definition" ac:schema-version="1" ac:macro-id="83434333-91da-46cf-8481-4d93ec3f9224"><ac:parameter ac:name="fieldName">score</ac:parameter><ac:parameter ac:name="fieldLabel">score</ac:parameter><ac:parameter ac:name="type">number</ac:parameter></ac:structured-macro></p><ac:structured-macro ac:name="confiform-entry-register" ac:schema-version="1" ac:macro-id="7547fbfc-d015-449d-bacf-ae036377ea79"><ac:rich-text-body><p><br /></p></ac:rich-text-body></ac:structured-macro><p><br /></p></ac:rich-text-body></ac:structured-macro><p><br /></p><p>All scores</p><ac:structured-macro ac:name="confiform-table" ac:schema-version="1" ac:macro-id="d788d7e4-8350-4d7d-a647-794943b659c7"><ac:parameter ac:name="formName">testScores</ac:parameter><ac:rich-text-body><p><ac:structured-macro ac:name="confiform-field" ac:schema-version="1" ac:macro-id="5e08a0fd-b992-41df-b2c4-b142b7447334"><ac:parameter ac:name="fieldName">nameSub.name</ac:parameter></ac:structured-macro></p><p><ac:structured-macro ac:name="confiform-field" ac:schema-version="1" ac:macro-id="156bb85a-3efd-4709-bafc-e2a02f31c966"><ac:parameter ac:name="fieldName">nameSub.subject</ac:parameter></ac:structured-macro></p><p><ac:structured-macro ac:name="confiform-field" ac:schema-version="1" ac:macro-id="4d75ae54-34c3-40c9-aa4f-6243df7f8ba2"><ac:parameter ac:name="fieldName">score</ac:parameter></ac:structured-macro></p></ac:rich-text-body></ac:structured-macro><p><br /></p><p>all nameLists</p><ac:structured-macro ac:name="confiform-table" ac:schema-version="1" ac:macro-id="bdba31d6-6193-441d-836d-86cf12b2c63b"><ac:parameter ac:name="formName">nameList</ac:parameter><ac:rich-text-body><p><br /></p></ac:rich-text-body></ac:structured-macro><p><br /></p><p><br /></p><p>nameLists that dont have a score</p><ac:structured-macro ac:name="confiform-table" ac:schema-version="1" ac:macro-id="e9bd16d5-1ba3-42e4-a288-57c59b9f320f"><ac:parameter ac:name="filter">_func.queryCount(testScores:@self;nameSub:[entry._func.asEntryRef(entry.id)]):0</ac:parameter><ac:parameter ac:name="formName">nameList</ac:parameter><ac:rich-text-body><p><br /></p></ac:rich-text-body></ac:structured-macro><p>nameLists and number of scores</p><ac:structured-macro ac:name="confiform-table" ac:schema-version="1" ac:macro-id="7c778a55-ca7d-416c-be63-611e7446e88b"><ac:parameter ac:name="formName">nameList</ac:parameter><ac:rich-text-body><p><ac:structured-macro ac:name="confiform-field" ac:schema-version="1" ac:macro-id="b0d8a24c-5ac0-4164-90a2-c8c5eaa6825d"><ac:parameter ac:name="fieldName">name</ac:parameter></ac:structured-macro></p><p><ac:structured-macro ac:name="confiform-field" ac:schema-version="1" ac:macro-id="4433ef40-2f9f-49e3-a74f-c6a2700f0821"><ac:parameter ac:name="fieldName">subject</ac:parameter></ac:structured-macro></p><p><ac:structured-macro ac:name="confiform-field" ac:schema-version="1" ac:macro-id="31993a51-de77-4f67-bb52-9f6ed974a1ce"><ac:parameter ac:name="overrideLabel">Number of scores (count)</ac:parameter><ac:parameter ac:name="fieldName">id.queryCount(testScores:@self;nameSub:[entry.id])</ac:parameter></ac:structured-macro> </p></ac:rich-text-body></ac:structured-macro><p>render scores inline</p><ac:structured-macro ac:name="confiform-table" ac:schema-version="1" ac:macro-id="35848b61-af11-4459-8e35-a1e5966b8b66"><ac:parameter ac:name="formName">nameList</ac:parameter><ac:rich-text-body><p><ac:structured-macro ac:name="confiform-field" ac:schema-version="1" ac:macro-id="611408ae-f2ac-4919-b1a4-af8dd8c60f3e"><ac:parameter ac:name="fieldName">name</ac:parameter></ac:structured-macro></p><p><ac:structured-macro ac:name="confiform-field" ac:schema-version="1" ac:macro-id="9a583f61-7ee9-462b-a8ce-5c1daf8d206f"><ac:parameter ac:name="fieldName">subject</ac:parameter></ac:structured-macro></p><p><ac:structured-macro ac:name="confiform-field" ac:schema-version="1" ac:macro-id="359bc004-ec74-4d60-be34-6d369187eb0d"><ac:parameter ac:name="overrideLabel">Number of scores (count)</ac:parameter><ac:parameter ac:name="fieldName">id.queryAndRender(testScores:@self;nameSub:[entry.id];score;table)</ac:parameter></ac:structured-macro> </p></ac:rich-text-body></ac:structured-macro><p><br /></p>

[Christian Perry]

Thank you so much for the video I see, that makes sense. In pasting your html everything works but trying to implement it to my main page it shows a list of all names and doesn't update. 

in my main site, nameSub and scores are on a different page from name and subject but that table has other things from name and subject (it has classroom and department as well). is

_func.queryCount(testScores:@self;nameSub:[entry._func.asEntryRef(entry.id)]):0

referencing an index or is it just looking for entry.id? is there documentation for this function anywhere?

im basically trying to isolate where my issue is stemming from

[Christian Perry]

nevermind, i had the wrong pageid... THANK YOU SO MUCH