Jump to content

Newlogiq

Members
  • Posts

    3
  • Joined

  • Last visited

Recent Profile Visitors

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

Newlogiq's Achievements

  1. Hi CopperBackpack...thank you very much for your suggestions. In my case, I need to produce a report from that data set that shows only the most recent entry in the table for an order where an associated note is more than 5 days old. If there are 10 notes all older than 5 days associated with the order, I only want to show the order 1 time with the most recent entry. Please see the attached screen shot of the notes data table. Thoughts?
  2. Hello...I need some guidance, please. I have a view of 2 tables. The first table contains customer information and an order number. The second table contains the order number plus a variety of notes associated with that order that have been date and time stamped. There are multiple notes entries for each order number. I'm trying to create a report that only shows the order number 1 time when a date from the second table matches some filtering criteria. Specifically, I want to only show those orders (again, just show order number 1 time) that do NOT have a note within XX days of today. How would you do this? I'm fairly new to Caspio...thank you.
  3. Hello...I need some guidance, please. I have a view of 2 tables. The first table contains customer information and an order number. The second table contains the order number plus a variety of notes associated with that order that have been date and time stamped. There are multiple notes entries for each order number. I'm trying to create a report that only shows the order number 1 time when a date from the second table matches some filtering criteria. Specifically, I want to only show those orders (again, just show order number 1 time) that do NOT have a note within XX days of today. How would you do this? I'm fairly new to Caspio...thank you.
×
×
  • Create New...