Jump to content


  • Content Count

  • Joined

  • Last visited

About Allison

  • Rank

Recent Profile Visitors

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

  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 co
  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 DataPag
  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...