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, 20214 yr by ibobo

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.

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. 

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

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

do you think it s the best way ? 

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

 

SumPrevNinPortal.fmp12

Thank you,

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

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.