• Diego Moreno
  • NEWBIE
  • 20 Points
  • Member since 2014

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 3
    Questions
  • 3
    Replies
hello

i am trying to make a validation rule for a currency field with 2 decimal values so that it only enables the user to put .00 .25 .50 and .75, with any other value in the decimals i need it to trigger the erro message.
this is what i've got so far:

NOT(REGEX(TEXT( Gross_Pay__c ), "[0-9]+[.]{1}[25,50]{2}")) it works for 25 and other values but not for 50

it has to be a validation rule with REGEX.
hello

i am trying to make a validation rule for a currency field with 2 decimal values so that it only enables the user to put .00 .25 .50 and .75, with any other value in the decimals i need it to trigger the erro message.
this is what i've got so far:

NOT(REGEX(TEXT( Gross_Pay__c ), "[0-9]+[.]{1}[25,50]{2}")) it works for 25 and other values but not for 50 
Hello,

i am trying to create a formula that doesn't allow usesr to edit certain fields once a record is save with a checkbox clicked, so i need the formulla to depend on whether or not the check box is clicked.

this is what i've got so far: 

AND(PRIORVALUE( Is_approved__c ), TRUE, 
ISCHANGED( Is_approved__c )) ||  ISCHANGED( Gross_Pay__c ) ||  ISCHANGED( End_Date_del__c ) ||  ISCHANGED( Has_dental_vision_insurance__c ) ||  ISCHANGED( Has_Medical_Insurance__c ) ||  ISCHANGED( Start_Date__c ) ||  ISCHANGED( Name ) ||  ISCHANGED( Net_Pay__c )
hello

i am trying to make a validation rule for a currency field with 2 decimal values so that it only enables the user to put .00 .25 .50 and .75, with any other value in the decimals i need it to trigger the erro message.
this is what i've got so far:

NOT(REGEX(TEXT( Gross_Pay__c ), "[0-9]+[.]{1}[25,50]{2}")) it works for 25 and other values but not for 50

it has to be a validation rule with REGEX.
hello

i am trying to make a validation rule for a currency field with 2 decimal values so that it only enables the user to put .00 .25 .50 and .75, with any other value in the decimals i need it to trigger the erro message.
this is what i've got so far:

NOT(REGEX(TEXT( Gross_Pay__c ), "[0-9]+[.]{1}[25,50]{2}")) it works for 25 and other values but not for 50 
Hello,

i am trying to create a formula that doesn't allow usesr to edit certain fields once a record is save with a checkbox clicked, so i need the formulla to depend on whether or not the check box is clicked.

this is what i've got so far: 

AND(PRIORVALUE( Is_approved__c ), TRUE, 
ISCHANGED( Is_approved__c )) ||  ISCHANGED( Gross_Pay__c ) ||  ISCHANGED( End_Date_del__c ) ||  ISCHANGED( Has_dental_vision_insurance__c ) ||  ISCHANGED( Has_Medical_Insurance__c ) ||  ISCHANGED( Start_Date__c ) ||  ISCHANGED( Name ) ||  ISCHANGED( Net_Pay__c )