Jump to content


  • Posts

  • Joined

  • Last visited

Recent Profile Visitors

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

Allison's Achievements


Newbie (1/14)



  1. Thanks for the help! This didn't quite get what I wanted from the report, but now I understand how to refer to views so that's definitely a step in the right direction. I'll keep trying.
  2. I need help figuring out how to use SELECT DISTINCT (or something similar) in a calculated field in a datapage based on a view. I am mostly unfamiliar with SQL and can't figure out how to implement the syntax. Datapage is based on a 3-table view "LocusArtifactFragment" where Locus is parent table, Artifact is child1 (one-to-many relationship with parent Locus), and Fragment is Child2 (one-to-many relationship with parent Artifact). I want to count distinct related records from Parent (Locus) in both related tables in the view (Artifact = Child1 AND Fragment = Child2). The view includes columns for LocusID, ArtifactID, and FragmentID (pk in each table) plus the foreign keys that make the relationships. I can easily count related records of fragments by counting FragmentID, but I need to count Distinct Artifact ID (because if I just count Artifact ID, I get equal numbers of fragmentID and artifactID, since artifactID appears for every related record in Fragment). This syntax from the howto site seems like it is more or less what I need, but I can't get it functional when I sub in my field and view names: "SELECT Count(Country) FROM Customers WHERE Country=’Canada’" Any thoughts on how to implement this would be very welcome. I need to verify students' data entry is correct and complete before moving forward with other parts of the project. Many thanks.
  3. Thank you! I did not actually have that fk ID field added to the results page. Now that I've put it in properly as a hidden field, it is receiving and writing accurately to the table. (duh.) I appreciate your help. Here's hoping that all my problems will be so simple to fix.
  4. There are two DataPages, both set up same way (tabular report view, inline add in results page, detail view available). One DataPage is built on a table, one built on a view. The editable side of the view is the one to which we are attempting to add the records. NEITHER DataPage will commit a new record to the table/view. The filter is to navigate to the correct related record. The workflow goes like this. Report 1: Search parent table, view/edit/update results in a detail view (no add). edit/update working as expected. On update, pass ParentID pk as external value to Child1 DataPage = report 2 Report 2: filter data for Child1 (table) based on ParentID pk, display results in tabular report with inline add and inline edit enabled. inline edit is working fine, add is non functional. On update/add, pass Child1ID pk as external value to Child2 Datapage = Report 3. Report 3: filter data for Child2 (2-table view, Child1-2, with editing enabled for Child2) based on parameter passed from Child1/Report 2; tabular report with add/edit enabled. Again edit works just fine but not add. The only thing I can think of is that perhaps something isn't passing correctly but I'm darned if I can figure out what it is. No records are being written to the tables from the "add". New records shouldn't be filtered out in the datapage because they should be created as part of the correct record in the relationship, right? ETA: there are no triggered actions on any of the tables. Same problem on multiple devices and multiple browsers.
  5. Using a filtered tabular report to view and update current records; inline edit and inline add new records are both enabled. Users are able to update records, but cannot successfully commit new record information to the table. Add button appears in results list; can input information to create a new record, but when we click "add" nothing happens; the page refreshes, information vanishes, no information is passed to the table. Please help! (Caspio rookie here, please be gentle)
  • Create New...