Jump to content
  • 0

Tabular Report - Show Results of 1 User At A Time



Hello. I am trying to create a tabular report that works a little different than usual.

I am trying to make it so the currently viewed Results page only shows 1 user - clicking on the "right arrow" on top will take you to the next employee, showing all of their related records. 

Something like the image below. Instead of having to use the search form above to change the user, it would be great if I could just set the Dates in the search form and have a place for the user to navigate next employee.

Has anyone set up something similar to this or have any ideas?


Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

To do this, you'll need to keep the search form on top of the tabular report, and not on separate pages. 

You need to make sure you have the User field set as a dropdown on the search page. Then, you need to add 2 HTML blocks - one before the User field and one After. I selected the "Continue next element on the same line" and got rid of the User field label so that they were all aligned nicely.

For the HTML blocks, add this for the left/previous (i used fontawesome to create left and right arrow icons, you can change out the <i> tags for text if you want):

<button id='previous' onclick="selectPrev()"><i class="fas fa-chevron-circle-left"></i></button>

and this for the right/next:

<button id='next' onclick="selectNext()"><i class="fas fa-chevron-circle-right"></i></button>

Then this little guy in the footer:

function selectNext(){
  var select = document.getElementById('Value7_1');

function selectPrev(){
  var select = document.getElementById('Value7_1');


Also, just to note, clicking on the previous/next buttons seem to submit the search on their own. This is totally fine for my workflow, so I didn't change it and I hid the original "Search" button.




Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...