AnsweredAssumed Answered

Value from last visited record: can this be conditional?

Question asked by petermontague1 on Dec 12, 2015
Latest reply on Dec 12, 2015 by petermontague1

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.

Outcomes