Jump to content

Tanager

Members
  • Content Count

    4
  • Joined

  • Last visited

About Tanager

  • Rank
    Newbie

Recent Profile Visitors

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

  1. Thank you @MayMusic! I really appreciate your expertise and time. Helps me to learn what is possible to do in Caspio.
  2. Thank you BaySunshine for your response and suggested edits! That was a big help in understanding what is probably obvious to some folks but not me. J
  3. I am seeking assistance for the correct syntax to test that a record exists in a child table (table name is Evaluation) and display a "Yes" in a calculated field (Link Test calculated field in image) on a dp for the parent table. I have very little SQL knowledge. Current SQL syntax that works but is probably incorrect: SELECT 'Yes' FROM Evaluation WHERE EXISTS (SELECT ManagingArea FROM Evaluation WHERE ManagingArea = '[@authfield:Evaluators_ManagingArea]' and NTAID = [@field:NTABase_NTAID]) Use case: 800 proposals, 30+ reviewers, I am creating a dashboard that indicates t
  4. Hello, Issue: My trigger action is not processing the Having statement in the Where clause. I barely know SQL and while the 30 minute Caspio webinar on Trigger Actions was helpful, the action I am attempting was not covered. I have a parent table and a child table, their common field is NTAID. I am trying to use a trigger action on Inserted/Updated/Deleted to quantify the number of records in the child table for the NTAID and assign a category to each parent record. The purpose of the categories is I need to use the field in the parent record to create filter views of t
×
×
  • Create New...