Can 2 fields compute into a third field

All Replies

• Friday, November 06, 2009 4:44 PMAhmed ElNoby

   
  

  1

  Sign In to Vote
  Hi Shannon,
  
  There is the onChange Event for each field in the CRM Form fields using this you can use javascript code to calculate and put the total in the third field
  
  and you can access the fileds by crmForm.all.<FieldName>
  
  i.e. crmForm.all.<Field3>.value = crmForm.all.<Field1>.value + crmForm.all.<Field2>.value;
  
  Hope this helps.
  
  Thanks,
  • Reply
  • Quote

   
• Friday, November 06, 2009 4:53 PMMayankP

   
  

  1

  Sign In to Vote

  You can do this using Java script as follows...put this onSave of Form

  var iristotal = 0;
  
  if(crmForm.all.<<product total field>>.DataValue != null  &&  crmForm.all.<<maintenance total field>>.DataValue != null )
  { 
    iristotal = crmForm.all.<<product total field>>.DataValue + crmForm.all.<<maintenance total field>>.DataValue;
  
  crmForm.all.<<total field>>.DataValue = iristotal;
  
  }		<br/><br/><br/>
  

  Please have a look at this article for more details on this.

  • Marked As Answer byDonna EdwardsMVP, ModeratorFriday, November 06, 2009 9:06 PM
  •  
  • Reply
  • Quote

   
• Friday, November 06, 2009 4:58 PMShannonBarrett

   
  

  0

  Sign In to Vote

  Thank you both very muc for your answers, I will be working on this today!  Have a great day/weekend.

   

  Shannon

  • Reply
  • Quote

   
• Friday, November 06, 2009 6:44 PMDonna EdwardsMVP, Moderator

   
  

  0

  Sign In to Vote
  If you need some additional information, you can have a look at this article

  ---

  Best Regards, Donna
  • Reply
  • Quote