# mdeevers

Members

9

## Recent Profile Visitors

553 profile views

0

1. ## Failed CASE WHEN formula in a table

Thank you for looking into this. My solution to this issue has been to remove students who have NO SchoolYearDaysAttended (i.e., a blank field). I can't explain why, but that fixed the problem. And the more I thought of it, if that field is blank, the school would have never seen the student anyhow - so the data aren't necessary. Thanks again for looking into this.
2. ## Failed CASE WHEN formula in a table

That didn't work, Nuke. Any other thoughts?
3. ## Failed CASE WHEN formula in a table

Thanks. I will give it a try!
4. ## Failed CASE WHEN formula in a table

Sorry if this question seems tedious. I am having a real time with this one. I am trying to use a formula in a table to categorize attendance rates. I have three number fields in my table (excused absences, unexcused absences and days present). Mathematically, I can calculate attendance rate with days present/(excused absences + unexcused absences + days present). That is, a student's attendance rate is the percent of days attended compared with all possible days. I am trying to categorize attendance rates into four groups, which then has me doing a CASE WHEN statement. I am trying just one group for starters, like this: CASE WHEN IsNull([@field:SchoolYearDaysAttended],0)/(IsNull([@field:EXC_ABS_CUR],0)+IsNull([@field:UXC_ABS_CUR],0)+IsNull([@field:SchoolYearDaysAttended],1))> 0.95 THEN 'Excellent' ELSE 'Not Excellent' END When I check, the formula editor says the formula is valid. But when I try to save the table, I get an error saying I have incompatible data. My plan is to have things get even more complicated, since I will have to do some greater than and less than work to create the four categories (i.e., WHEN ....>X AND WHEN...<Y THEN). But I would at least like to know I'm on the right path before I put all that in. Any suggestions are appreciated.
5. ## Email notifications - 30 days, 60 days and 90 days

Caspio will custom build this for you, for a fee. And then there will be a monthly fee to keep it up and running. We had them build something like this for us where I work. I hated paying to have the script written, and then seeing the monthly costs added in. However, the solution was well done, quickly implemented, and it's supported through all Caspio updates. If you see this as vital to your app, I recommend working with the Caspio team to get it built. They are great to work with.
6. ## Taking Attendance / Gradebook Function

Does anyone have thoughts on how I could create a system for taking attendance or operating a gradebook with Caspio? I've been thinking about this for over a year, but I haven't come up with anything that isn't too crude. Here is what I would like to see: A table has student names and IDs, along with several events (e.g., the date a group met, or the title of an assignment). A user (teacher/coach/group leader) can take attendance for the event by marking students "present" or "absent" in a submission form. This is the challenge I see: Users don't always know the "events" when the table is created, and they are not Caspio developers who can modify table structures. So...creating a new "event" would actually require me to edit the table with a new field, which I do NOT want to do every time a user creates an event. I'm thinking there must be a way to do this with multiple tables, and perhaps views or relationships. But then there comes the challenge of marking multiple students "present" or "absent" at the same time. Any thoughts or insights would be appreciated.
7. ## Looking For Examples Of Mobile Kits

I'm a relatively experienced Caspio user who is looking to try the caspio mobile kit. Has anyone used the kit with any success? Would you be willing to share an example of it? Any insight would be appreciated. We deploy a lot of apps to mobile responsive pages, which creates the feel of a smart device app, but I'm looking for something more.
8. ## Allow Users To Convert Details Page Into Pdf Reports

I'm relatively new to caspio, but I'm using it for darn near every aspect of my work lately. I think I can get to a point where I have a nice HHTML data page that looks like a report, with set headers and such. What I REALLY want is to give users the option of converting a data page into PDF document they can easily print. Is this going to be a third party kind of thing? Or can I convert HTML into PDF if it's in java script? Full disclosure: I am NOT a programmer AT ALL! Caspio sure makes me look a lot more clever than I am, but I think this "print as pdf" option would really help me with my last piece. Any insight would be appreciated.
9. ## Formatting Data Page Tabular Report Headers

I've been shrinking the results table (data page) by creating different Styles and reducing the table from 100% to a smaller proportion. Creating or modifying the styles may also have some of the other options you are looking for, but it doesn't seem to let me format individual columns. I think we're looking for the same thing, so I'll follow this topic and wait for someone more skilled to reply
×