• Sadhu
  • NEWBIE
  • 10 Points
  • Member since 2011

  • Chatter
    Feed
  • 0
    Best Answers
  • 1
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 6
    Replies
Hi all,

Wish you a happy new year...

On case, I've 2 lookups. One on Product and another one on Asset. I want to add a lookup filter on Product lookup, so that I could see only those Products which have the same Group as Product family of selected Asset.

But, I'm not able to get Product family of Asset, while putting the criteria.

Can anyone help me to achive this?

Thanks in advance...
  • January 02, 2015
  • Like
  • 1
Hi all,

Wish you a happy new year...

On case, I've 2 lookups. One on Product and another one on Asset. I want to add a lookup filter on Product lookup, so that I could see only those Products which have the same Group as Product family of selected Asset.

But, I'm not able to get Product family of Asset, while putting the criteria.

Can anyone help me to achive this?

Thanks in advance...
  • January 02, 2015
  • Like
  • 1
Hi all,

Wish you a happy new year...

On case, I've 2 lookups. One on Product and another one on Asset. I want to add a lookup filter on Product lookup, so that I could see only those Products which have the same Group as Product family of selected Asset.

But, I'm not able to get Product family of Asset, while putting the criteria.

Can anyone help me to achive this?

Thanks in advance...
  • January 02, 2015
  • Like
  • 1

Based on the business requirement I have to make text as a link in trigger and then I wanna retrieve/print that value in a standard page.

 

eg. string link = '<a href=/'+ accId +'>'+accName+ '</a>'

 

Please share your thoughts.

  • April 22, 2013
  • Like
  • 0

Hi,

 

Had to spend time and think about this formula for reporting, so here you are, in case you ever need it.  It does not consider national holidays, and the calculations are based purely on days of the week.

 

Comments:

First, it takes the number of weeks betwen the two dates, and multiplies it by 5 (number of business days per week).

Then, it adds the remainder of the time period divided by 7.

Then, it subtracts 2 from the result (for Saturday and Sunday) if the time period included an extra weekend in it.

 

 

5*FLOOR((Delivery_Date__c-Ship_Date__c)/7)+MOD(Delivery_Date__c-Ship_Date__c,7)-
IF(
  CASE(MOD(Ship_Date__c-DATE(1900,1,7),7),
    1,1,
    2,2,
    3,3,
    4,4,
    5,5,
    6,6,
    0,7,
    0)
  <
  CASE(MOD(Delivery_Date__c-DATE(1900,1,7),7),
    1,1,
    2,2,
    3,3,
    4,4,
    5,5,
    6,6,
    0,7,
    0),
  0,2)

I created a custom object 'Incentive'. This custom object has got a master-detail relationship with accounts.

On the object there are 3 fields (contact 1, 2 & 3) with a lookup relationship to contacts.

 

I would like to set a lookup filter criteria on these 3 fields so that the users can only choose between contacts of the specified account.

 

Is this possible? If yes, can someone help me out with this?

 

 

Thanks in advance!

 

 

  • September 27, 2010
  • Like
  • 0
Is there a way to set a filter at developement time for a lookup that the user can't change to control the list of items displayed in the lookup