AnsweredAssumed Answered

Update records from subsummary

Question asked by ndveitch on Jun 19, 2017
Latest reply on Jun 19, 2017 by philmodjunk

Hi there,

 

How do I update records in a Subsummary report? I have a subsummary report with no body and the users need to update the records if they change the value in the drop down field in the subsummary. I have a GTRR script that updates the records, but I was wondering if there is a way to do it without scripting.

 

The script is fairly basic,

 

Set Variable [ $fieldName ; Value: Get ( ActiveFieldName ) ]

Set Variable [ $fieldTable ; Value: Get ( ActiveFieldTableName ) ]

Set Variable [ $fieldContents ; Value: Get ( ActiveFieldContents ) ]

Go to Related Record [ Show only related records ; From table: “Work_in_progress” ; Using layout: “All Fields WIP” (Work_in_progress) ; New window ]

Go to Record/Request/Page [ First ]

Loop

  Set Field By Name [ $fieldTable & "::" & $fieldName ; $fieldContents ]

  Go to Record/Request/Page [ Next ; Exit after last ]

End Loop

Close Window [ Current Window ]

 

I have had to replace the GTRR with a find request as I am updating records in the same table and the GTRR kept going to all the records, not the one in the subsummary report. But other than that the script is working fine, I was just wondering if maybe there was a way of placing a field from another TO on the subsummary which might be able to update all the records at once.

Outcomes