Discussions

 View Only
  • 1.  Table report- Need to show only most recent record per member

    Posted 05-02-2022 13:38
    Edited by Mrunali Kadam 05-03-2022 09:30
    Hi, 

    I've created this table report. One person can vote multiple times and current report shows all votes submitted by each person. Need to update it to show only most recent vote per voting member (highlighted one).

    @Mark Shnier (Your Quickbase Coach) Please advise if this can be achieved or would like to know if you have any other ideas. thank you! 





    ------------------------------
    Mrunali Kadam
    ------------------------------


  • 2.  RE: Table report- Need to show only most recent record per member

    Posted 05-03-2022 11:54
    Assuming that you have a relationship where one member has many votes then he would make a summary field to summarize the maximum record ID of all the votes for that number. Then look up that maximum record ID down to the trial table and filter the report so that you only show where the record ID of the vote record is equal to the maximum record ID.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Table report- Need to show only most recent record per member

    Posted 05-03-2022 13:27
    Thank you Mark!

    I've a form to capture votes. I've a relationship between main form and voting section. 


    ------------------------------
    Mrunali Kadam
    ------------------------------



  • 4.  RE: Table report- Need to show only most recent record per member

    Posted 05-03-2022 16:59
    I am not sure if that is a question but if it is can you tell me the tables involved in their relationships?

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------



  • 5.  RE: Table report- Need to show only most recent record per member

    Posted 05-04-2022 10:03
    Thanks for getting back Mark! I was able to fix it using pipeline to identify the most recent record per user, id.

    ------------------------------
    Mrunali Kadam
    ------------------------------