So I’m trying to create an app that allows medical professionals to keep track of their medical licenses, as well as track their Continuing Medical Education Credits (CME’s) that they need to renew their license. What I’ve been able to figure out so far is how to keep track of the total amount of credits achieved so far. What I can’t figure out is how to display the users credits completed based on the category it belongs too.
This is sort of how the page will look, and the user can choose the Category, whether it’s a Lecture or Practical credit, and then enter how many hours they received. If I want, at the bottom I can display the total amount of credits the user has logged, but I can’t figure out how to display or add up the total amount of credits completed for each Category.
I want the user to be able to track total credits in each category (sub totals) as well as total credits overall (total).
I could do this easily on an excel spreadsheet so I can’t see why it will be too difficult here.
Any ideas?
I guess I’m not quite sure what you are trying to.
Are you trying to display the total credits on the page in the picture that it shows the amount based on what they choose when they are entering in new credits?
So if someone chose a “Pediatrtic Airway” category from the dropdown, then chose “Lecture” on the radio buttons and input “1” for the credits, on the right, it would display that for the user.
I’ll give you some background and maybe it will help you see what i’m trying to achieve. For paramedics to renew their license, they have requirements on the types of credits they need to have. Practical credits are “hands on” type of learning and Lecture credits are achieved from lectures/classroom learning.
in the picture, highlighted in red, are the requirements for renewing a license. I want to create this spreadsheet, but with the numbers starting at 0, and every time a user submits a new CE, it updates the number in the appropriate cell.
I think it would work better if you redo the data a little and remove credit type field and have 2 number fields, one for lecture credits and another for practical credits and then have this show in the repeating group.
Then to make changes to the credits you need to display the current cells data in a group and then make changes to that cells credit.
Thank you so much for all your help with this! I’m still new so this will take me a little while to look up and get it done, but I’m going to work on it over the weekend and hopefully figure it out. Thanks again!
Thank you so much this is exactly what I was hoping to do! I can’t work on my app until later tonight or tomorrow so I hope you don’t mind leaving that solution up for a little bit so I can look into how to do it myself later. Thank you!
I tried to copy your page exactly as you had it but it’s still not quite working the way yours does. I even changed all the names to match yours exactly so there’s no confusion on my end, but i’m not sure what i’m missing. The only issue is when I add a new credit, it updates both the lecture and practical columns, and it adds a new piece of data in the data fields, instead of updating like it does on your app. any idea?
Yes, I see the problem. You’re missing a constraint in the second search for the credits text elements. Easier to show with some screenshots. Your app is read-only for me so I can’t make the change for you. The two screenshots below are from your app, the third is from my example. The constraint highlighted in yellow is what you need to add to yours (shown here for the Lecture field but you also do the same for Practical).
Wow. You’re really good at this. I didn’t know you could add a constraint within a constraint. It works now! The only difference is with mine it creates a new line of data for each credit submitted-------->
I’m not sure I follow. Do you mean in the database, or in the repeating group? When a new credit is submitted, it does add a new line to the medical_credits table in the database.
