5 Replies Latest reply on Sep 23, 2014 7:54 PM by bigtom

    record thumbnails portal list view


      I was using a layout to display 50 records at a time as thumbnails. It was set up using a self-join relationship between a unique "Picture ID" field and a Calculation field with 50 repetitions, shown below:


      GetNthRecord( Extend(Picture ID) ; Get(RecordNumber) + Get(CalculationRepetitionNumber) - 1)


      I am a little confused at how this was originally even set up, but am looking to revamp this into a more seamless layout.

      Instead of going page to page, viewing 50 records, then another 50... I want to set it up in a list view where there are 10 records per row, where you can just scroll down until there are no more records.


      Right now I have the single row set up with 10 portals all one row in height, showing record 1, then record 2, then record 3, etc...


      my problem comes in when i hit the second row, it's currently showing the records as something like this:


      list row 1 : [1][2][3][4][5][6][7][8][9][10]

      list row 2 : [2][3][4][5][6][7][8][9][10][11]

      list row 3 : [3][4][5][6][7][8][9][10][11][12]

      list row 4 : [4][5][6][7][8][9][10][11][12][13]


      should be something like this:


      list row 1 : [1][2][3][4][5][6][7][8][9][10]

      list row 2 : [11][12][13][14][15][16][17][18][19][20]

      list row 3 : [21][22][23][............................................]


      any thoughts?

        • 1. Re: record thumbnails portal list view

          Did you try using get(portalRowNumber) in place or get(recordNumber) ?


          you might also have to use a multiplier for rows 2 and up (IE get(portalRowNumber) * 10, so it starts at 20, 30, 40, etc...)

          • 2. Re: record thumbnails portal list view

            I finally got this working for the most part, not sure if it will end up being ideal in the long run performance wise...


            One flaw I just need to work out is having extra rows being displayed from the Find Results.


            This is how I have it working now:


            Each record contains a unique ID number which is related to itself through a calculation field shown below


            GetNthRecord(Extend(Picture ID) ; Get(RecordNumber)*10 + Get(CalculationRepetitionNumber) - 10)


            The calculation's repetition number is 10 in this case.


            As for displaying results, the layout is displayed as list view with one row of 10 portals, each starting a new initial row. 1, 2, 3, 4... 10


            It does return something like this...


            list row 1 : [1][2][3][4][5][6][7][8][9][10]

            list row 2 : [11][12][13][14][15][16][17][18][19][20]

            list row 3 : [21][22][23][............................................]


            However, I do believe due to having the multiplier shows many additional blank rows.


            For example, a search result contains 120 records where the grid of results should have 12 rows, 10 records each.  What is happening though, 120 rows are being returned, with the proper records on the first 12 rows... I am looking to find someway to hide/remove the extra rows... I've tried a script that omits rows 13 thru 120, but this has caused issues with the proper records being displayed.

            • 3. Re: record thumbnails portal list view

              dear Mike

              the get(PortalRowNumber) doesn't work in my Filemaker ???


              I get the message : "This parameter is an invalid Get function parameter"




              I'm using FM12, also have a copy of FM 13, where it's not working either...


              how can this be ?

              • 4. Re: record thumbnails portal list view

                It's context-sensitive, you need to have a row active in your portal for it to return a value, else I think it just returns zero.


                Also, I think the function may have changed at some point in time to get(ActivePortalRowNumber), you might try that instead. Not sure if Get(PortalRowNumber) is still valid.

                • 5. Re: record thumbnails portal list view

                  I saw somehting like this done by a guy a few years ago. There is a video on YouTube showing it in use as a photo management solution. I think he may work for Filemaker now. I have never figured out how he did it, but I believe it was using portals and not list view. I have been wanting somehting like this for a while but it is not at the top of my project list.