kcastagnaro

I was able to figure this out with some help from @CoopperBackpack in a different thread. THANK YOU!

Hi! Did you ever figure out how to change the table header values? I have the same problem.

This is absolutely fantastic. It's working beautifully. THANK YOU SO MUCH!

Thank you!

Hey DesiLogi, Did you ever find a solution to your problem?

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.

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.

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.

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.

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!

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; }

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.

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?

Thank you for responding. I do appreciate it. This is what I got. I wonder how to drill down to the year field.

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.