Confiforms: find matching value

[Jan]

Probably an easy one: 

I have a form where two fields/values are filled: Item number and Item Text. 

Now I want to have an entry field on another page where you can search for an item number and get the matching Text as a result from above mentioned form. On the search page I do not want to have the list of all values displayed, only the result of the searched item. 

Thanks for hints :) 

[Alex Medved _ConfiForms_ · Accepted solution]

When you say "search for an item" - what does it mean? Where do you search - in Confluence search or in ConfiForms "view" macro with search functionality enabled?

[Jan]

I would like to have a search entry field on a page, so it could be in a view macro. But I do not want to show all thousands of datasets on that page. Only the one users are searching be entering the value in a filter or search field. 

[Alex Medved _ConfiForms_]

Not sure I understand - you can build a view over the ConfiForms data the way you want, and show the fields you want... Don't have to show "all thousands of datasets on that page"

This page briefly touches the ground on how you can show the data from ConfiForms

https://wiki.vertuna.com/display/CONFIFORMS/Multiple+ways+to+show+your+form+data+in+Confluence+with+ConfiForms

And of course, it can be filtered just as you like

[Jan]

Thanks Alex, maybe this helps clearing it up more: 

The form contains two fields and contains several thousand datasets with item number and item text. 

On my page there should be a dialogue where users can enter the item number with auto suggest. Once they have entered / picked an item number, the matching item text should be displayed. I am not sure how to proceed here. 

[Alex Medved _ConfiForms_]

May be something like this - https://wiki.vertuna.com/display/CONFIFORMS/Using+and+configuring+ConfiForms+Dynamic+Filter

You can setup the ConfiForms Filter macro to have a ConfiForms Field macro inside that references the "item number" and have a view connected to this filter macro to have inside the ConfiForms Field macro that references to "item text"

[Jan]

Ok, got it now. I have done it that way before, but I was missing the idea of the initial filter to show no datasets initially, so this helped. Thanks :) 

You can set "views" to show nothing initially (useful for large dataset). To do this you need to write some filter which will not match anything. One to suggest is to use internal field _today and compare it agains 0

_today:<0