Jump to content


  • Posts

  • Joined

  • Last visited

Everything posted by kcastagnaro

  1. I was able to figure this out with some help from @CoopperBackpack in a different thread. THANK YOU!
  2. Hi! Did you ever figure out how to change the table header values? I have the same problem.
  3. This is absolutely fantastic. It's working beautifully. THANK YOU SO MUCH!
  4. Hi, Roattw! Can you share your final solution? I have the same problem that you have. I have a table with reminders that are "owned" by different users. I would like to create a task that sends a table variable to each user with only their own records. User one is emailed the table of her own records, user two is email the table with his own records, and so on.
  5. Hi, thanks for trying to help me. I'm so stuck! Yes, I did join the those two fields you mentioned. it's the section highlighted in green. CTMS_t_User.User_ID is joined with CTMS_t_Screen.Screen_User_ID.
  6. Thank you! But my files are stored in CASPIO and they are confidential, so that solution won't work since it says files have to be stored outside the database.
  7. I would love a solution to the very same problem. Would like to view rather than download pdf files that are stored in Caspio but are confidential. Datapage is authenticated.
  8. Hi. I am stumped by a problem. I have nurses who screen patients for clinical trials. Once they screen, they enter a date into a follow-up field. I would like to send a email every Monday with a list of the patients who have follow-up dates coming in the next week. I have created a task with a table variable that looks like this. I didn't include it but the WHERE portion where I set the 7 day window works fine. In the exxample below, Screening.User_ID is the Nurse and I join it with User.User_ID so that I can access the nurse's email. The email portion is also working fine. There are two nurses (Ginger & Ivana) who have patients with follow-up dates in the next 7 days. And Both Ginger and Ivana receive their own email with the table. The problem is that I want the email to Ginger to only contain Ginger's patients and the email to Ivana to only contain Ivana's patients. Any help would be so greatly appreciated! Thank you!
  9. Hi! I was actually able to figure it out. I had to customize the following in my CSS. It was 14px. Thank you so much for your help! div.numInputWrapper span { position: absolute; right: 0; width: 2px; height: 50%; line-height: 50%; cursor: pointer; -webkit-box-sizing: border-box; box-sizing: border-box; }
  10. Hi all, I have several tabular reports where I have created HTML fields to link to additional pages on my site. I would like these fields to be downloadable in PDF/Excel/CSV just like all the other fields. The online help page on this subject states that "Editable fields are converted to display only fields. If you have custom form elements in an HTML block, they will not be converted to display only elements." (https://howto.caspio.com/faq/reports-datapages/how-to-make-the-search-results-downloadable-for-my-users/) Does anyone have a workaround for this? I would love to have the study dashboard number (not the hyperlink itself) show up in my PDF and Excel spreadsheet. Any help would be GREATLY appreciated.
  11. Darn! I wish I could. But it's a medical website and we have confidential patient information in there. How else can I help you help me? (Sheepish smile). I don't think I have any other CSS that would affect this. Certainly not in the user-defined styles. But I could send the CSS?
  12. Thank you for responding. I do appreciate it. This is what I got. I wonder how to drill down to the year field.
  13. Hi all, this isn't working for me. And my calendar pop up doesn't display quite right. The up/down arrows next to the year actually cover the last digit of the year. Any help would be appreciated.
  14. Thank you, NiceDuck! Every day I'm getting a little bit better!
  15. Hi, Vitalikssssss & Alison, I have a similar situation to Alison. I imported the solution above but it doesn't seem to be working for me. I get 15 records added when the day count is 5. Any help would be greatly appreciated.
  16. Hi! New to triggers in Caspio. Thank you ahead of time for any assistance you can provide. I have a table of PARTICIPANTS (patients) and I am enrolling them into research STUDIES. Each study has EVENTS associated with it. Table 1: Participant Field 1: Participant ID Field 2: Participant Name Table 2: Study Field 1: Study ID Field 2: Study Name Table 3: PEventFinal (Events associated with each study) Field 1: PEventFinal ID Field 2: Study ID Field 3: Event Name I enroll patients onto a study through a datapage to a 4th table. Table 4: PartStudy Field 1: PartStudy ID Field 2: Participant ID Field 3: Study ID The problem I have is when I try to associate the study EVENTS with the PARTICIPANT enrolled in the STUDY. The number of events for each study varies. Some studies can have 2 events, some studies can have 30. I would like to create a trigger on the PartStudy Table that creates a record in a 5th table that list of of the study EVENTS for that PARTICPANT on that PARTICULAR study. Talbe 5: PartSTudyEvents Field 1: PartStudyEvent ID Field 2: PartStudy ID (as text) Field 3: Participant ID (as text) Field 4: Study ID (as text) Field 5: Event Name I have created a trigger (see below) that inserts the correct number of records into table 5, but inserts the first EVENT only multiple times. IN the example of Study A, there is a total of 3 events. When I enroll Particpant #1 on Study A, I want the following records to be created in Table 5. Participant #1, Study A, Tissue Sample Participant #1, Study A, Blood Draw Participant #1, Study A, Xray But what I get is this: Participant #1, Study A, Tissue Sample Participant #1, Study A, Tissue Sample Participant #1, Study A, Tissue Sample I've read every post I can find on looping and If/Then and inserting multiple records. I'm not a coder so I'm stumped. I'm sure the answer is right in front of my nose, I just haven't quite gotten there. Any help would be greatly appreciated!
  • Create New...