Apex Code Development You need to sign in to do that
Don't have an account?
Karunakar Burugu Help needed regarding the Account Opportunity custom data format
Hi All,
I have a requirement to gather data using the below format from Account and opportunity. could you please help me how to achieve this format? I mean is it possible with collections?
I have a requirement to gather data using the below format from Account and opportunity. could you please help me how to achieve this format? I mean is it possible with collections?
| Account Name | Opportunity CreatedDate | Opportunity Name |
| Samsung | Jan-22 | Opp1 |
| Opp2 | ||
| Opp3 | ||
| Apple | Feb-22 | Opp1 |
| Opp2 | ||
| Opp3 | ||
| Samsung | Feb-22 | Opp4 |
| Opp5 | ||
| Opp6 |
Karunakar Burugu
,
You can use this below formula
Account.Name & " : " & Name & " : " & Text(Month(Today())) + "/" + Text(Day(Today())) + "/" + Text(Year(Today()))
Here you had Standard field if you want to use some Custom field than you should use this below formula
MM/DD/YYYY
Text(MONTH(Customfield__c))+"/"+Text(DAY(Customfield__c))+"/"+Text(YEAR(Customfield__c))
DD/MM/YYYY
Text(DAY(Customfield__c))+"/"+Text(MONTH(Customfield__c))+"/"+Text(YEAR(Customfield__c))
Hope this solve your issue if yes than mark as the best answer
Thanks,