0

Trigger - Update Number Field with Formula Value - en masse

Question about Triggers. Any help would be greatly appreciated!

I have a table that calculates a Price formula. This Price formula is compared to a Current Website Price number field. When there is a mismatch in these values I want to create a trigger to update the Current Website Price number field with the value of the Price formula.

I have tried a few things but none of them work very well:

I put a Trigger on Update on a Yes/No field such that when it is "yes" the trigger updates the value. HOWEVER... I have to manually change this field on EVERY record individually.... I cannot do a bulk update or a drag/copy and have it work.

Also put a trigger in an On Click formula field that compares the 2 values, which works, but I have to manually click on that formula field in Form View for it to work. Ugh!

I have >10k records, so clicking on each isn't feasible.

PLEASE HELP!!! Thanks in advance!

2 replies

null
    • szormpas
    • 2 mths ago
    • Reported - view

    Hi, do you think using Trigger after opening your database would work for you?

    • Fred
    • 2 mths ago
    • Reported - view

    a couple of suggestions were posted in FB. what do think would work for you?

Content aside

  • 2 mths agoLast active
  • 2Replies
  • 31Views
  • 3 Following