ReportSQL - External Forms or Surveys

Most recent survey/external form completion date on a case

  • Date Formula field on Case Data
(select max(completed) from survey_response join matter on survey_response.matter_id = matter.id and matter.id = %tableAlias%.id)

External form/survey sent name

  • Text formula field on top level Survey Questions report
  • Fun fact: survey_response.dynamic_process_id identifies the survey
(select name from dynamic_process where id = %tableAlias%.dynamic_process_id)
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us