11 Replies Latest reply on Dec 12, 2015 8:15 AM by petermontague1

    Value from last visited record: can this be conditional?


      I have a transactions table. When I enter new stock I want to automatically enter the box number where it is located as the value from the previous record so I don't have to repeatedly enter the box number. Checking the value from last visited record box makes this work well for me.

      But when I am making sales I use the transactions tables too. In this case I don't want to auto enter the box number. I use a different layout for sales.

      So maybe I could use a script trigger related to the layout. I tried a trigger which sets the field to "" when the record loads. But this deleted location numbers when I looked at previously entered records. Is there a way of conditionally setting the trigger to fire only when the record is new.

      Looking forward to hearing back.