function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Formula field for finding date

Hi , 
We have  Member__c obj and MemberState__C objects..MemberState__C  has look up field for Member__c obj. I need to create formula field in Member__c obj. In  MemberState__C obj , we having field state__c and date__c  When the member is active very first time(since we many active state) ,
i need to popolate the formula field called startdate__c  in Member__c using  date__c  in  MemberState__C when state__c is active.. But we can have many active states in  MemberState__C obj per member 
Steven NsubugaSteven Nsubuga
Cannot use a formula field for this. Formulas are typically used on child objects. Consider changing look up to a Master Detail and then use Rollup Summary field to find earliest date.
If you cannot change the look up to master details, consider a process, maybe Flow or Apex trigger.
Thanks Steven 
But actually we created look up field called memberState  in Member__c to look  up  MemberState__C 
So the issue  is that  Member__c has many member states(registered , member , active , inactive  then again active ). the lookup fied on Member obj  refrer the most resent state. But i need to populate the date field with date that member is active veryfirst time 
Steven NsubugaSteven Nsubuga
Is there a lookup field to Member__c on MemberState__C ?  If so, I suggest you change it to a Master Detail.
If you do that, you will be able to create a Rollup Summary field on Member__c, that will enable you to view the earliest date__c  in  MemberState__C