Get Field / Record List from Portal

[ibobo]

Hello, 

I have a list of data, extracting/looping from Webviewer to a portal.   I would like to sum last 400 record on every new record created. 

through portal it slow down too much so I try to integrate  a script step to get list and sum previous 400 records 

the fast I found is "GetFieldList ( fieldName ; recordNumStart ; recordNumEnd )" it work perfectly on the layout of the table, 

but it doesn't work on a portal & table where the Webviewer is located. 

 

Is there anyway to get it work with the portal or other way to sum 400 previous record out of a portal ? 

 

thank you  

Edited October 11, 2021 by ibobo

[Steve Martino]

Sometimes it may be easier to open a window, could even be hidden of the related records, contstrain/find the 400 you want.  A summary field will have the correct count.  Copy that value as a variable, set the field with that variable.
A Sql statement/calc may also do it to.  Someone with that experience may be able to help.

[ibobo]

Thank you Steve, as it loops sometimes every second, open and close window, or switch between windows will mess-up  the loop or conduct on error or freeze.  Already happen on other project that s why I avoid. 

I may found Custom fonction that give me list of what is in the portal, so I think I ll filter in portal 400 last record and sum the up with the CF. 

[Steve Martino]

You can Freeze Window, or open the window off screen.

[ibobo]

I did it like this, it seem s to work well, 

do you think it s the best way ? 

[comment]

I am not at all sure I understand what are you trying to do. Does the attached demo come close? 

 

SumPrevNinPortal.fmp12

[ibobo]

Thank you,

well Comment it seems to be more that close 😇 how can I change the 3 to 400 ? 

[comment]

1 minute ago, ibobo said:

how can I change the 3 to 400 ? 

3 is just the script parameter attached to the button. 

Unrelated to your question, but I would be reluctant to use a portal showing 400+ records.