Method Community

 

Advanced Grid Control

Last post 02-18-2014 9:20 AM by Method_Greg. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 02-14-2014 1:55 PM

    Advanced Grid Control

    How do I make it so limited info shows up one a grid column (Contact/Lead/Company) when the Rep logged in does not own the lead?

    If the rep that is logged in, it should show everything on the grid column.  This is obviously the shared active lead contacts view.

    I want to show this if the rep logged in owns the lead

    '<b>' + ISNULL(viewContacts.Name,'') + '</b><br />' + '<i>'  + viewContacts.FullName + '</i><br />' + ISNULL(viewContacts.CompanyName,'')

    when the does not

    '<b>' + ISNULL(viewContacts.CompanyName,'') + '</b><br />'


    Thanks in advance

  • 02-14-2014 4:25 PM In reply to

    Re: Advanced Grid Control

    Hello,

        It is possible, but is a very involved process to do.  This is what I came up with.

    CASE WHEN viewContacts.SalesRep = session.user  
         THEN '<b>' + ISNULL(viewContacts.Name,'') + '</b><br />' + '<i>'  + viewContacts.FullName + '</i><br />' + ISNULL(viewContacts.CompanyName,'')
         ELSE '<b>' + ISNULL(viewContacts.CompanyName,'') + '</b><br />'.

    I'm not seeing how to find the User's Sales Rep for the equation. In the above equation, I put in 'session.user' for the placeholder.  The key may be to somehow get the Sales Rep name/initials onto the screen so you can access the value.  You could try a textbox object that gets the Sales Rep initials through an Action Result.  You can use the generator and go through the steps to find field values.

    I can look into it a little more next week and see if I can help out anymore.

    Greg Bilous
    Community Support Specialist
    Method Integration
    g.bilous@method.me
    Toll Free: 1.888.925.6238
    Local and overseas: 416.847.0400 ex.756
    Fax: 416.640.6027
  • 02-14-2014 4:54 PM In reply to

    Re: Advanced Grid Control

    That's fine not in a big hurry.  I would appreciate more direction on accessing the value via action results.

  • 02-18-2014 9:20 AM In reply to

    Re: Advanced Grid Control

    Hello,
       The action is called 'Assigned value to action result'.  You can find information on it in our Help Center.  It's straight forward to set-up.  When you have the Action Properties screen up, you give the Action Result a name, choose Value From Screen and select User - Sales Rep Initial.  This is basically what you are looking for here.  The Action Result will now be available for other actions.  
       You can use Assigned value to shared result as well.  This is the same, but the value is carried over to other screens.

    - Greg

    Greg Bilous
    Community Support Specialist
    Method Integration
    g.bilous@method.me
    Toll Free: 1.888.925.6238
    Local and overseas: 416.847.0400 ex.756
    Fax: 416.640.6027
Page 1 of 1 (4 items)