AnsweredAssumed Answered

getting field data from a filtered portal

Question asked by bank247 on Nov 29, 2018
Latest reply on Nov 29, 2018 by bank247

I have data in a filtered / sorted portal.  The filter on the portal takes an average of the "filtered" data and gives me what I need.  I need that number which is an average to be inserted into a field into the database. 

 

Currently doing an on record load script

Go to Portal Row [Select On ; First]

to get what I need because just calling the field gives me an average of the ENTIRE database.  This is kind of workload intensive it seems because my records take a bit to load when changing records I have 50k+.  

 

Is there a way to simplify this or offload it onto the server?   I tried doing that however the field would not populate seems I have to do the Go to Portal Row. 

Outcomes