• Jega Deiva
  • NEWBIE
  • 130 Points
  • Member since 2018

  • Chatter
    Feed
  • 4
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 23
    Replies
Hi,

I am stuck at this challenge in Superbadge - Lightning Experience Reports & Dashboards Specialist - Challenge 5 - Create a report for the Executive team.

Please check my report and let me know what detail am I missing with the Stage? I have grouped the table with Stage. Not sure, where to look at? Assistance is appreciated.

Thanks in advance.

Regards,
Sanjay
Hello,

I am creating a reports on Contracts.
I filtered by date.

I dont see all the contracts.

is there any standard field that blocks the display of contracts in reports ?

thank you for suggestion
Hi Team,

could you please to understand why the validation rule doesn`t work:

AND
(ISCHANGED(Stage_test__c),
TEXT(Stage_test__c) != Status__c)

I want to check Account Stage and Status, and if they are not equal, display an error message.
Without part ISCHANGED(Stage_test__c) this rule works, but we should check values only in case if the Stage was changed.
Status - formula(text) in our case, and Stage - picklist.

Thank you,
Nataliia
I'm trying to set up a Validation rule to show an error if both of the below fields are filled in but not if both are blank. 

or( 
and(!isblank( Strategic_Partner__c ),!ISBLANK( Reseller__c )), 
or(!ISBLANK( Reseller__c) ,!isblank( Strategic_Partner__c )) 
)
Hi,

I am stuck at this challenge in Superbadge - Lightning Experience Reports & Dashboards Specialist - Challenge 5 - Create a report for the Executive team.

Please check my report and let me know what detail am I missing with the Stage? I have grouped the table with Stage. Not sure, where to look at? Assistance is appreciated.

Thanks in advance.

Regards,
Sanjay
Challenge Not yet complete... here's what's wrong:

The 'My Shifts Pending Approval' report does not have the correct columns. Confirm that ALL report columns are in place according to the requirements. Additionally, take note that of the two 'Volunteer Shift Worker ID' fields, make sure to include the one with the format Shift-XXXX so users can click through to the volunteer record.

I am unable to add volunteer activity as a column in the following report.User-added image
Hello,

I am creating a reports on Contracts.
I filtered by date.

I dont see all the contracts.

is there any standard field that blocks the display of contracts in reports ?

thank you for suggestion
can someone plz tell me how to make 4th report
 
We have a customized field added to opportunity about contract signing date, we want the field is auto filled by the date when the stage of the opportunities changed to "Won- Agreement Signed". as the stage is a picklist field, I cannot use If, but I also failed when I use Case.
This is my formula, it doesn't work. SF said it cannot be used for picklist field.
CASE((StageName  = "Won - AGREEMENT SIGNED & ACCEPTED"),TODAY())
can anyone help me to give a correct script?

thanks very much
Carol
Hello guys!

I've been struggling with a validation rule. There is a field called "Birthday" where the user populates his/her birthday. When the user populates this field, then it has to allow only ages higher than 17 years old.

For example:
User's birthday: 02/02/2005
Today's date: 15/05/2019
So it means that the user's age is bellow 18, hence it is not accepted. 

How can I do it? I've made it doing the following code, but it didn't work as I wanted:
(TODAY() - DadosPF_DataNascimento__c < 18*365)

I did other things, but there were incorret datas that were allowed instead of being denied. Could you guys please help me? 
 
We have created a community for end users to be able to add, update and see their own cases.
The end user is able to create their cases just fine. I have assignment rule where when case is created and it is assigned to Tech support queue. after queue is assigned as owner of the case, the end user looses visibility of it.

End user should able to atleast see cases generated by him/her.

Does anyone have experience with communities and cases visbility?
Hi All,
            I have one date field Responded_date__c. so whenever this field contain value then email alert should send to user.
i am not getting, how to set rule criteria. can anyone suggest how to check whether responded date contain value or not?

Thanks 
Which application is a beneficial simulate programme for merge and combine   Outlook PST file into a single PST file. Suggest ?
Hi Team,

could you please to understand why the validation rule doesn`t work:

AND
(ISCHANGED(Stage_test__c),
TEXT(Stage_test__c) != Status__c)

I want to check Account Stage and Status, and if they are not equal, display an error message.
Without part ISCHANGED(Stage_test__c) this rule works, but we should check values only in case if the Stage was changed.
Status - formula(text) in our case, and Stage - picklist.

Thank you,
Nataliia
I'm trying to set up a Validation rule to show an error if both of the below fields are filled in but not if both are blank. 

or( 
and(!isblank( Strategic_Partner__c ),!ISBLANK( Reseller__c )), 
or(!ISBLANK( Reseller__c) ,!isblank( Strategic_Partner__c )) 
)
Challenge not yet complete - It's a simple challenge.Create a poll post and ask any question you like. I have create the Poll post in my org but it continues to say Challenge not complete
User-added imageUser-added image
I have a three date field and one pick-list field.

Based on the Start Report Date i need to update Last Report Date Next Report Date Automatically.

Date Field
  • Start Report Date
  • Last Report Date
  • Next Report Date
Pick-List Field
  • Schedule Lkup
Formula Field Output:
 
Schedule Lkup     = "Quarterly"
Start Report Date = "12/31/2012"
Last Report Date  = "9/30/2018"
Next Report Date = "12/31/2018"
 
|---------------------+-------+-------+-------+-------+--------------|
|    Schedule Lkup    |  Q1   |  Q2   |  Q3   |  Q4   | Years to add |
|---------------------+-------+-------+-------+-------+--------------|
|                     | 03/31 | 06/30 | 09/30 | 12/31 |              |
|---------------------+-------+-------+-------+-------+--------------|
|      Quarterly      |  Q1   |  Q2   |  Q3   |  Q4   |      1       |
|---------------------+-------+-------+-------+-------+--------------|
|       Monthly       |  Q1   |  Q2   |  Q3   |  Q4   |      1       |
|---------------------+-------+-------+-------+-------+--------------|
| "March June & Sept" |  Q1   |  Q2   |  Q3   |       |      1       |
|---------------------+-------+-------+-------+-------+--------------|
| "Semi March & Sept" |  Q1   |       |  Q3   |       |      1       |
|---------------------+-------+-------+-------+-------+--------------|
|  "Semi June & Dec"  |       |  Q2   |       |  Q4   |      1       |
|---------------------+-------+-------+-------+-------+--------------|
|    Annual March     |  Q1   |       |       |       |      1       |
|---------------------+-------+-------+-------+-------+--------------|
|     Annual June     |       |  Q2   |       |       |      1       |
|---------------------+-------+-------+-------+-------+--------------|
|     Annual Sept     |       |       |  Q3   |       |      1       |
|---------------------+-------+-------+-------+-------+--------------|
|     Annual Dec      |       |       |       |  Q4   |      1       |
|---------------------+-------+-------+-------+-------+--------------|
|   Biennial March    |  Q1   |       |       |       |      2       |
|---------------------+-------+-------+-------+-------+--------------|
|    Biennial June    |       |  Q2   |       |       |      2       |
|---------------------+-------+-------+-------+-------+--------------|
|    Biennial Sept    |       |       |  Q3   |       |      2       |
|---------------------+-------+-------+-------+-------+--------------|
|    Biennial Dec     |       |       |       |  Q4   |      2       |
|---------------------+-------+-------+-------+-------+--------------|
|   Triennial March   |  Q1   |       |       |       |      3       |
|---------------------+-------+-------+-------+-------+--------------|
|   Triennial June    |       |  Q2   |       |       |      3       |
|---------------------+-------+-------+-------+-------+--------------|
|   Triennial Sept    |       |       |  Q3   |       |      3       |
|---------------------+-------+-------+-------+-------+--------------|
|    Triennial Dec    |       |       |       |  Q4   |      3       |
|---------------------+-------+-------+-------+-------+--------------|

Any help will be much appreciated.

Thanks in Advance
I am in need of setting up an integration user which needs to have access to Contact object (restricted to couple of fields only) and nothing else. When I try to create a profile, I have to select an existing profile to clone. However, all the existing profiles have some additional level of access that I need. Is there a very basic minimal security profile that I can use to clone? If not, what is the best way of approaching this?