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
-
Hi, do you think using Trigger after opening your database would work for you?
-
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