Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and ListHow to link-join two forms using "forms and list" moduleHow to link-join two forms using "forms and list" module
Previous
 
Next
New Post
3/16/2015 7:31 AM
 

Hi All,

I wanted to ask couple of questions regarding "Forms and List" module.

1, I have a two forms which is called "Stage 1" and "Stage2" and i wanted to join them using "Email" as a key. How would i do that?

2, I wanted to populate some data from "Stage1" form into "Stage2" form i.e Email, Name,et.. How do I do that.

3, Can we really join two forms on DNN "Forms and List" module?

Any help would be appreciated.

Thanks,
Yogs

 
New Post
3/16/2015 7:42 AM
 
Form and List module does not support joining of records in UI.
You could perform it using reports module, however, as FnL stores data serialized in UserDefinedData table, it is a bit tricky.

Cheers from Germany,
Sebastian Leupold (Microsoft MVP)

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
4/27/2015 4:53 AM
 

Hi Sab,

 

You last post was very helpful. Tried below but with no luck.

 Any suggestions would be great.


SELECT  "Created at","Application ID","Enquirer name","Enquirer Email","Date of enquiry","How did you come to know about OCNLondon",
"Name of organisation","UKPRN (if applicable)","Website","Do you already deliver Accredited Qualifications",
"Organisation type","Created by","Changed by","Changed at"
 FROM

        ( SELECT FieldTitle,FieldValue
          FROM  UserDefinedFields F
          JOIN  UserDefinedData   D
          ON F.UserDefinedFieldId = D.UserDefinedFieldId
          WHERE ModuleId = 2042
          ) as S

          PIVOT (MAX(FieldValue)
          FOR FieldTitle IN ("Application ID","Enquirer name","Enquirer Email","Date of enquiry","How did you come to know about OCNLondon",
"Name of organisation","UKPRN (if applicable)","Website","Do you already deliver Accredited Qualifications",
"Organisation type","Created by","Created at","Changed by","Changed at")) as a


SELECT  "Created at","Application ID","Enquirer Name","Enquirer Email","Enquirer Role","Main Address Line","Address Line 2",
"Delivering OCN London qualification","Gaining OCN London accreditation for existing course(s)","
How many learners would you expect to register in twelve month period",
"Do you have funding in place to support delivery of the qualification",
"If Yes What is the source of your funding","Does your organisation have  (please select all that apply)",
"Do your tutors / assessors have qualifications in teaching & assessment",
"Do any assessors have qualifications / experience in internal verification","
DCELLS (Dept of Children / Education / Lifelong Learning and Skills)",
"ESTYN (Welsh Inspectorate)","CCEA (Council for the Curriculum / Examinations and Assessment)",
"Created by","Changed by","Changed at"
 FROM

        ( SELECT FieldTitle,FieldValue
          FROM  UserDefinedFields F
          JOIN  UserDefinedData   D
          ON F.UserDefinedFieldId = D.UserDefinedFieldId
          WHERE ModuleId = 2074
          ) as S

          PIVOT (MAX(FieldValue)
          FOR FieldTitle IN ("Application ID","Enquirer Name","Enquirer Email","Enquirer Role","Main Address Line","Address Line 2",
"Delivering OCN London qualification","Gaining OCN London accreditation for existing course(s)","
How many learners would you expect to register in twelve month period",
"Do you have funding in place to support delivery of the qualification",
"If Yes What is the source of your funding","Does your organisation have  (please select all that apply)",
"Do your tutors / assessors have qualifications in teaching & assessment",
"Do any assessors have qualifications / experience in internal verification","
DCELLS (Dept of Children / Education / Lifelong Learning and Skills)",
"ESTYN (Welsh Inspectorate)","CCEA (Council for the Curriculum / Examinations and Assessment)",
"Created by","Created at","Changed by","Changed at")) as b

Thanks,

Yogs
 

 
New Post
4/28/2015 1:46 AM
 
Yogs,
what is the issue (besides missing the join of bot result sets?

Cheers from Germany,
Sebastian Leupold (Microsoft MVP)

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
4/28/2015 4:37 AM
 

Hi Sab,

 I have join query "JOIN   On a.[Application ID]= b.[Application ID]"

 I want to join  on [Application ID] from both query "a" and "b".

Hope this make sense. Which will not work

Thanks,

Yogs

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and ListHow to link-join two forms using "forms and list" moduleHow to link-join two forms using "forms and list" module


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.

Content Layout

Subscribe to DNN Digest

DNN Digest is our monthly email newsletter. It highlights news and content from around the DNN ecosystem, such as new modules and themes, messages from leadership, blog posts and notable tweets. Keep your finger on the pulse of the ecosystem by subscribing.  


Copyright 2017 by DNN Corp Terms of Use Privacy
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out