4 Replies Latest reply on Oct 22, 2015 4:30 PM by AccordMetal

    Script: Retrieving and entering Field values in Portal views of records

    AccordMetal

      I am attempting to insert a value into a specific field of a specific record after evaluating user input from the ActiveField of the same record shown in the portal view of the records. I successfully captured the initial ActiveFieldContents and ActivePortalRowNumber.

      But I am unable to capture a field data from a field I created for tracing all entries within the Estimate Data table, a simple numbered index.  See line 3.

      The user is in Estimate Data::ItemType of the applicable portal row, which I capture in line 1.

      Nul data is the result of line 3.

       

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

      2 Set Variable [ $$PRow ; Value: Get ( ActivePortalRowNumber ) ]

      3 Set Variable [ $temp1 ; Value: GetField ( Estimate Data::EntryTrace ) ]

       

      I also tried to Go to Field ( Estimate Data::EntryTrace ) and then Get (ActiveFieldContents) without luck.

       

      Eventually I want to input the result of user input concatenated to some text into a third field of the same portal row.

       

      Any advice out there?

      The concept is to use a popover as a mini calculator /spreadsheet for Length x Width x Thickness = Result. Concatenate it all together and place into a text field Estimate Data::Description. Everything except transferring the data into the correct fields seems to be working.