Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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

Stefan Vogt December 1, 2023

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:

arrows left right.jpg

 

Thanks for any hints!

Stefan

2 answers

1 vote
Alex Medved _ConfiForms_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 6, 2023

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

0 votes
Stefan Vogt December 10, 2023

Dear Alex!

Million thanks. Sorry for the delayed answer. But i was able to check it only now. I built this I/O: https://collab.dvb.bayern/x/sYH0Dg

There is one issue: If i "jump" to a certain day using the filter, certainly the nice arrows for sliding between the single days disappear. Is there an idea about how one can select a specific day but still can move between the days +1 / -1 from this certain day on?

Best

Stefan

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events