function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
ChrisGountanisChrisGountanis 

Cases to Cases InnerJoin to Allow Survey Web to Case Reports

Right now we are using Web to Case to allow clients to post survey results back to the Case table. We separate these by using a Survey case type. In SQL this would be a super simple solution. We store the original case number in the survey as a hidden field. When the client sends the survey back it stores the answers and the original case number in custom fields. So is there a way for me to innerjoin the custom case number with the original case number so I can link the support case with corasponding survey? The concept would be something like CaseNUmber=SurveyCaseNumber both on the Case table allowing one-to-one relationship for reposrting.