Method Community

 

Basic Math In Grid

Last post 02-12-2011 7:46 AM by Caliper. 6 replies.
Page 1 of 1 (7 items)
Sort Posts: Previous Next
  • 02-09-2011 10:46 AM

    Basic Math In Grid

    How can you do basic math within a grid using columns?

  • 02-09-2011 6:17 PM In reply to

    Re: Basic Math In Grid

    Hi Caliper

    You can check out the webinar on using an advanced (sql) script.  I think its number 32.  This should get you started in the right direction.

    Mark Crews
    Cloud Consultancy
    Principal and Developer


    • 2012 MethodCRM Partner of the Year

    • 2012 MethodCRM Community Excellence Award

    • 2011 MethodCRM Community Excellence Award


    Visit our website to find out about our training, support, and customization services.
    website: cloudconsultancyllc.com
    blog: cloudconsultancyllc.com/blog/
    ph: 434.326.1601
    e: support@cloudconsultancyllc.com

    What is Method?
  • 02-09-2011 7:45 PM In reply to

    Re: Basic Math In Grid

    Just looking to do a simple calculation in estimate grid.  I would like to have a total cost collumn, which would calculate the qty multiplied by the cost in the estimate. 

     

    Thank you,

     

    Angelo

     

  • 02-09-2011 8:22 PM In reply to

    Re: Basic Math In Grid

    Within a grid - for an integer field the event has to be "lose focus." Text change does not work as an event.

    Joe Woodard
    Woodard Consulting Group
    www.woodardconsulting.com
  • 02-10-2011 9:30 AM In reply to

    Re: Basic Math In Grid

     Thank you for your response,

    All I am trying to do is: 

    Insert a column on the Estimate Screen, which will total all costs for each line item.  (Item Qty *Cost Rate)

     

    Thank you,

     

    Angelo

     

  • 02-10-2011 9:58 AM In reply to

    Re: Basic Math In Grid

    Hi Angelo

    In order to help you with this, it'd be helpful to know your experience with method.  Have you been using method for a while or are you new to it?  Maybe somewhere in between?

    Mark Crews
    Cloud Consultancy
    Principal and Developer


    • 2012 MethodCRM Partner of the Year

    • 2012 MethodCRM Community Excellence Award

    • 2011 MethodCRM Community Excellence Award


    Visit our website to find out about our training, support, and customization services.
    website: cloudconsultancyllc.com
    blog: cloudconsultancyllc.com/blog/
    ph: 434.326.1601
    e: support@cloudconsultancyllc.com

    What is Method?
  • 02-12-2011 7:46 AM In reply to

    Re: Basic Math In Grid

     Basic knowledge, 1 month user

Page 1 of 1 (7 items)