5 Replies Latest reply on Mar 13, 2014 12:26 PM by willrollo

    calculated set field in a portal

      Title

      calculated set field in a portal

      Post

           I have a portal to my table InvoiceDetails_INVOICEITEMS. It contains the lines for an invoice.

           I have a script trigger set up that detects what sort of product has been added to the portal, which then alters other related fields.

           I am having trouble though with one of these set fields. The fields I have in the portal are description, price, item. 

           If Item is "E" then I want to add a percentage of the price of another item in the portal/invoice. This item has a category field that is "Master". There is only one Master record in each invoice. 

           SO at the moment my ST records the price of the master record ( if created) and saves this price as a variable. When the record that has Item=E is created, this variable is not replacing the the price field on this line. 

           How to I fix this?

           Thank you