Positioning selected record at the middle of a portal

[Melborne]

Hi!

 

I have a 'Days' portal on my 'Sheet' layout ( which shows list of days from a particular month).

 

Requirement:

1. I want to display seven rows in the portal.

2. I want to be able to select a day from the portal and then position it in the middle ( i.e 3 days less than selected day are placed above the selected day and 3 days greater than selected day are below the selected day).

3. Allow scrolling using portal scroll bar.

 

I am able to position the selected day in the middle using a portal filter and a script, however I am not able to enable scrolling using the portal scrollbar.

Is there any other way I can achieve this such that the scroll bar will work?

 

( I have attached a sample file.)

 

 

Thank you!

Sample file.zip

[efen]

The portal will only scroll if there are more records than the number of rows in the portal

[doughemi]

Does this help?

select day_1.fmp12.zip

[Melborne]

Thanks for replying.

 

@doughemi Not exactly what I need, I want the user to select a day by clicking in portal, and then center that selected day in middle.

I think it is not possible to display a scroll bar as we are displaying filtered records.

[Brooks]

This should get you started. 

select day_jump to middle.zip

[Fran_g]

Am I missing something? This file doesn't seem to do anything other than highlight the selected record anywhere in the portal

[Brooks]

The file i uploaded will Jump the selected row to the middle unless it is at the very beginning or end. Choose anything past 4 and it will center. 

[Melborne]

@Brooks, Thats Perfect!

Thank you very much!

[ron G]

I DL'd the sample file and it does not seem to work if you select the latter records?

[Brooks]

You can't make the last row be in the middle. It will work so long as your not at selecting a row that is at the end and below the middle.