I want to make a forumla for a workflow rule that checks if the prior value was null (this particular field "Actual_Ship_Date" gets edited in a tracking form when the order gets shipped) and then checks if it was changed.
Basically if "Actual_Ship_Date" has changed, it will trigger a field update for another object. I just need this to validate first. I'm getting an error for this formula and I'm not sure where to go with it:
How should I be putting this to make it work properly? I've looked through the documentation - but I gotta say, Salesforce documentation has driven me nuts ever since I tried making this stupid sales order system.
Basically I want to pull the "Products" object's list and put it into a picklist...but I haven't seen anything that makes this possible (YES I do use the search to see if I can find any resource on the subject). Has anybody done this before or have a clue where to go with it? I do realize that it wouldn't make sense to make this an option for everyone because they want to track old values and all of that - but that doesn't apply to the way we're doing things.
Thanks to anyone who helps! I hate having to ask...:smileytongue:
So far from everything I've read (been searching around for quite awhile now) you can't make a field dependency for text fields. The controlling field would still be a picklist ("Products") but the dependent field would be a text field called "Other". My company has 6 standard products we sell, but once in awhile something will be ordered that is different but a rare occasion (so it doesn't make sense to add it to the perminent list) - typically it's supplemental to the product we sell, like say a box of cable ties or something. Basically if they choose "other" from the product picklist, it will enable the "Other" text field to be filled in - else it disables the field.
Can this still be done or am I just S.O.L.? I'm kind of surprised that all fields are not allowed to be selected for the dependent field, really.
I want to make a forumla for a workflow rule that checks if the prior value was null (this particular field "Actual_Ship_Date" gets edited in a tracking form when the order gets shipped) and then checks if it was changed.
Basically if "Actual_Ship_Date" has changed, it will trigger a field update for another object. I just need this to validate first. I'm getting an error for this formula and I'm not sure where to go with it:
How should I be putting this to make it work properly? I've looked through the documentation - but I gotta say, Salesforce documentation has driven me nuts ever since I tried making this stupid sales order system.
How do you predefault values on fields (example: set due date on task to current date). I tried this with a trigger, but the issue is the value does not populate as soon as new is clicked (even with before insert). It is filled in only on save.
Basically I want to pull the "Products" object's list and put it into a picklist...but I haven't seen anything that makes this possible (YES I do use the search to see if I can find any resource on the subject). Has anybody done this before or have a clue where to go with it? I do realize that it wouldn't make sense to make this an option for everyone because they want to track old values and all of that - but that doesn't apply to the way we're doing things.
Thanks to anyone who helps! I hate having to ask...:smileytongue:
