0

We recently started using Salesforce's Survey tool and are having trouble reporting on it.

When I look at a SurveyInvitation in Lightning, one of the fields I can see is "Participant", and I can also see that field in the Object Manager for SurveyInvitation. Here is what I see in Lightning Experience:

SurveyInvitiation

I've created a straightforward custom report type to report on SurveyInvitations. However, in the "Fields Available for Reports" section, there is no Participant field.

Why is this? Is there any way to make the field available for reporting? I have already checked in Object Manager that it is not a field-level security issue.

Thanks!

  • Go to setup, report types, edit your custom report and include the field you want for that to show up in your report – Raj Feb 26 at 20:17
  • @Raj I've already included all available fields in the custom report. The Participant field doesn't appear in the list of Survey Invitations Fields that I can select from. – James Feb 26 at 20:47
  • participant is a polymorphic field to user or contact; is there a standard report you can customize instead? – cropredy Feb 26 at 22:17
  • I'm assuming the field is a lookup field. In that case, can you please check FLS for that object, just in case. I mean if it is not a direct lookup but like a third level lookup or something. Lookup of a lookup etc.. – Raj Feb 27 at 4:07
  • @cropredy There are no standard reports for Surveys or any of the related objects, even the SF docs say to report on these you should create a custom report type – James Feb 27 at 19:59

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.