KateyN

Meaning, I want the user to not be able to input a date that is before 7/1/24 or a date that is after 7/1/25. I just want them to be able to put a date that is any day between those two dates.

Yes!

Here you go

Thank you so much for your response. I actually did figure out how to make this work, eventually.

HI! I am needing help figuring out how to make a pdf download of a tabular report so that the datapage's html header is above the table on the actual pdf, not to the left (see pic). Is this even possible? I know I could just add it to the actual PDF's header but I need it to show on the datapage prior to the pdf being downloaded, as well. Please assist at your earliest convenience. Thank you!

I have a similar question. How would I do the calculated field if I need to prevent a dates prior to 7/1/2024 and no date after 7/1/2025?

Hi! Is there any way to make it so that a footer only shows on the last page of a PDF? When I say footer, I mean the custom footer created in the PDF options window, not the actual datapage footer. Thanks!

Hi. I have a somewhat complicated trigger to send an email based on multiple criteria. The issue I am having is that the first action of "send email" with the criteria of a "true" value being untrue, along with other specific criteria like matching IDs, Pre-Survey = "Mail" and "Topic Name = "Ages and Stages, " etc works. It also works if I want to send the same topic of "Ages and Stages" and email for a POST-survey. The emails are sent only if the "Pre-Survey Sent" or "Post-Survey Sent" checkbox is unchecked in the table, which is done via a SET trigger once an email is sent. The problem is when I try to send a second Pre-Survey via email for a different topic. For instance, if I need to send a Pre Survey for "Brain Development," I think it's not working because its seeing that "Pre-Survey Sent" is already checked but for a different topic. I do have the trigger work on a unqiue ID matching a unique ID, so I am lost as to why its not working. Any help would be very much appreciated. Below is the trigger I have. The trigger is long so I had to break it up in numbered pics below.

That worked!! Thank you!!

Hi! I have a details page where I am trying to list names of participants in enrolled in a group. I have the following calculated field, but instead of only showing the names associated with the Group_ID, it's listing all of the names in the table. Can anyone point me into where I am potentially going wrong here? SELECT Participant_Name= STUFF((SELECT DISTINCT CHAR(10) + (Participant_Name) FROM FSE_Groups_Topics_Participants WHERE Group_ID = [@field:Group_ID] FOR XML PATH('')), 1, 1, '')

wow! thank you!!

I am back Can you elaborate on this "Usually with databases you use the ID/index to select the record and then fill the additional information from that." Because this is exactly what I am needing.... I think. This is complicated but I am trying to get all of the primary IDs to flow into a single joint table so that users can see multiple details on a single page AND make edits to all of the parts. I know I can use views for this as well, but the tables need to be edited so it's becoming a challenge using the views. I have several primary IDs generated in their own tables: Specialist.ID, Participant.ID, Group.ID, Topic.ID. Then I have joint tables to combine Groups and Topics (there are multiple topics per 1 group). And one for Groups and Participants (there are many participants enrolled into one group). I can get all of this work. The issues I am running into is when: A) I try to bring all of the above together to take attendance. I need a table that shows each group, the specialists assigned to each group, each topic within each group, the participants enrolled in the groups and then I need to be able to mark whether or not they attended a topic within each group. Its complicated and I cannot seem to come up with an iteration that just works without issues b) Whenever a change is made in one table, how to get the change to show up in the child tables without missing pieces and without duplicate rows. Also, same for deletions. I can more or less get this to kind of work but there are glitches and issues with it by using triggers that just seem overly complicated. And part of the main issue is the IDs - every time something is inserted or edited, it only works if all of the associated IDs are included in the form. For instance, if I want to add a topic to a group, it only shows up if the inserted data includes the group ID, specialist ID, and topic ID. Now all of my forms are full of IDs. This is long and complicated but I am getting so frustrated. Any assistance would truly be appreciated. Thanks Also - I did try swapping the IDs and Names but had issues in "hiding" fields in a table and in recalling data is instances, sometimes the ID would show and sometimes the name. And with so many IDs (this isnt even all of them) things were just getting to messy.

Hello! I have a report showing a tabular table of class sessions. The report also lists the participants in each session - each participant on its own row. I would like to better demarcate the groups of sessions by modifying the background colors of each row that belong to the same session ID. For example, all rows with a session ID of 26 would have a grey background and all rows with a sessions ID of 22 would have a blue background, etc. Is there any way to do this? Thank you for any assistance!

I figured out it was because I had a search to filter results and it was limiting what was visible when adding a new line to a table using inline update! Whoops!

Hello! I have watched every Ned video and still am stumped on how to go about what I need. I am getting rather frustrated and would really appreciate any assistance. Essentially I have a series of events that involve participants. Its organized like this: I have "Service Series" and under each series is multiple events. Each series and its subsequent event is created by a Specialist who also assigns participants to each series then tracks attendance of those participants within each event (within a series). So, essentially, I need to be able to report a Series, its specialist, the assigned participants in the series, the events in the series and then mark whether or not the participants attended the event in the series. (Very similar to a course --> classes --> enrolled students, and a teacher. However, the events in my series are not regularly-occurring so marking attendance isnt straightforward. Pretty complicated but I know Caspio can do this, I just keep running into so many roadblocks. So here is how I have currently set up: ( I think I over-complicated the set-up) I have multiple tables like this: Series Table: (used via a datapage to create a new series) Series_ID (Primary Key) Specialist_ID (foreign) Participant_ID (foreign) Events Table (used via datapage to create a new event associated with a series) Event_ID (Primary Key) Series_ID (foreign/text) Specialist_ID (foreign) Participant_ID (foreign) - for marking attendance Specialists Specialist_ID (primary) Name, etc Participants Participant_ID (primary) Name, etc Then I have a joint table which is populated via triggers whenever a new event is added to Events table and when a Series is added to the Series table. This table is called Series_Events and has all of the above IDs combined together. I am able to pull a report and it looks fine and shows all of the information I need. The issue is when update the joint Series_Events via inline add or through editable drop downs in a details page. The updates are not being added to the table. I assume this is because the IDs are associated with their own tables and not the joint tables? Any assistance would be greatly appreciated.