Confiforms: Filter table and slide between days using an increment of one day

Stefan Vogt_d2krgb

Dear all!

My form contains 2 fields date and name. There can be data like this:

29/11/2023   table

29/11/2023   window

30/11/2023   table

30/11/2023   window

30/11/2023   disc

01/12/2023   table

 

How i can set the table view macro (or maybe another view macro) that it displays the data only for each one day and i can move between the displayed days with arrows <-- and --> meaning -1 day and +1 day respectively? So if a am at 29/11/2023 the table shows 2 lines of data and i press forward --> the table shows 3 lines of data and again forward the table shows 1 line of data.

The table view macro has such arrows they appear if you use "Limit the number of records returned", as follows:

 

Thanks for any hints!

Stefan

Alex Medved _ConfiForms_

Hi @Stefan Vogt 

Take a look at this demo:

http://recordit.co/fyvnZ1nPXa

Configuration in storage format for the reference:

<ac:structured-macro ac:macro-id="7b0d077f-6bc6-4d05-8cb0-85e4968579c8" ac:name="confiform" ac:schema-version="1">
<ac:parameter ac:name="formName">form</ac:parameter>
<ac:rich-text-body>
<ac:structured-macro ac:macro-id="2205da31-49d9-4a81-9244-8db6f3f1a6b7" ac:name="confiform-entry-register" ac:schema-version="1">
<ac:parameter ac:name="type">Embedded</ac:parameter>
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p>
<ac:structured-macro ac:macro-id="2bdbfadb-9a4e-48e2-882a-baf95f2cd428" ac:name="confiform-field-definition" ac:schema-version="1">
<ac:parameter ac:name="fieldName">date</ac:parameter>
<ac:parameter ac:name="fieldLabel">Date</ac:parameter>
<ac:parameter ac:name="type">date</ac:parameter>
</ac:structured-macro>
</p>
<p>
<ac:structured-macro ac:macro-id="ecc13a7e-61d2-45bb-b747-e454d143fda2" ac:name="confiform-field-definition" ac:schema-version="1">
<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>
</ac:rich-text-body>
</ac:structured-macro>
<p>
<br/>
</p>
<ac:structured-macro ac:macro-id="a783c33d-4fc3-4c6e-83fc-5031e70a7a9c" ac:name="confiform-list" ac:schema-version="1">
<ac:parameter ac:name="pager">1</ac:parameter>
<ac:parameter ac:name="formName">form</ac:parameter>
<ac:parameter ac:name="distinct">date</ac:parameter>
<ac:rich-text-body>
<ac:structured-macro ac:macro-id="3fbf39fe-c05d-4701-8583-4c7459f3eeb4" ac:name="confiform-table" ac:schema-version="1">
<ac:parameter ac:name="filter">date:[entry.date]</ac:parameter>
<ac:parameter ac:name="formName">form</ac:parameter>
<ac:rich-text-body>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>
<p>
<br/>
</p>
</ac:rich-text-body>
</ac:structured-macro>

Hope it helps

Alex