Jump to content

cbaker10

Members
  • Content Count

    16
  • Joined

  • Last visited

  • Days Won

    1

cbaker10 last won the day on May 1 2016

cbaker10 had the most liked content!

About cbaker10

  • Rank
    Member

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. So I am using SELECT DISTINCT([@field:Courses_Course]) FROM _v_Teacher_Courses WHERE Personnel_ID=target.[@field:Personnel_ID] which works, but it lists the name of the first course for all courses instead of each individual course. The second column is the calculated column and the last column is the actual course. I am so close....any ideas? Bob Sanders English Language Arts, Grade 7 2017-2018 3 English Language Arts, Grade 7 Bob Sanders English Language Arts, Grade 7 2017-2018
  2. I'm getting closer. Can I use a select statment on a View instead of a table? Chris
  3. I've been try to find the SQL statment you suggested. Can you supply an example? Regards, Chris
  4. Vitalik, Thanks for the response! I already have three separate tables, Teacher, Enrollment, and course tables. Still get multiple records. Chris
  5. This would be a nice feature for future releases.
  6. I have a similar issue, could you explain the solution a little more in depth? Here is my example: I have a Teacher, Enrollment, and course tables. The enrollments tie to teacher with teacher ids and courses with course ids. The teacher may have multiple enrollment for one course. I want to create a view to be used in a datapage that would list once the Teacher and Course. How would I go about this? Here is what it looks like now and want it to only have 1 record for Bob sanders, but because he has 2 enrollments in his class, it lists twice. Any Ideas? Courses_Course
  7. I have a Teacher, Enrollment, and course tables. The enrollments tie to teacher with teacher ids and courses with course ids. The teacher may have multiple enrollment for one course. I want to create a view to be used in a datapage that would list once the Teacher and Course. How would I go about this? Here is what it looks like now and want it to only have 1 record for Bob sanders, but because he has 2 enrollments in his class, it lists twice. Any Ideas? Courses_Course Personnel_Full_Name English Language Arts, Gr
  8. Kristy....that worked....thanks so much for all of your help!
  9. I tried the following however I cannot get the two fields to concatenate: function concatenate() { var FirstName = document.getElementById("EditRecordTA_First_Name").value; var LastName= document.getElementById("EditRecordTA_Last_Name").value; var FullName = FirstName+LastName; document.getElementByID("EditRecordTA_Full_Name").value = FullName; } document.getElementById("caspioform").onsubmit=concatenate; Any suggestions? Thanks, Chris
×
×
  • Create New...