1 Reply Latest reply on Jul 25, 2017 1:56 PM by fitch

    Problem filling in portal values through script


      I have a portal that represents data from both the "Building" table and "Building_address" table
      The building table is related to the address table, which is named Building_address.


      I am trying to write a script to import data into the portal. My issue is that the portal fields contain information from 2 different tables, Building and Building_address. I'm not sure if that is my issue however.


      This is the part of the script that I'm having problems with


      Go to Object [ Object Name: "buildingPortal"]
      Go to Portal Row [Select: On; Last]

      Set Field[ Building_contact_company::Type ; $Type]
      Set Field[ Building_contact_company::RBA ; $RBA]
      Set Field[ Address_Building_contact_company ; $Address]


      For some strange reason, set field works for all the fields that are in building_contact_company but not address_building_contact_company.

      All my variables are assigned correctly and I am traversing through my portal rows correctly as well.


      Does anyone have any idea what my problem is? Or can they recommend a different approach to filling in the portal rows?