Adding user inputs together based on Data field

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?

Lester thanks for replying! Maybe this next picture will help show what I want to do a little better.

As the user chooses a category, credit type and inputs the amount of time on the left, I want it to update the numbers on the right.

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.

does that make any more sense?

Ok, try to set it up like this. Also be sure and make sure that the input is an integer.

So that turned out

which makes sense because there’s 24 total options in the data and I asked for :count.

Should put the data in a different way? Perhaps different data types?

Could post a screenshot of ho you set it up or you could put a link to the editor then I could help better with it.

The page im trying to work on is currently on the page title “practice page 3”.

It is not letting me in. Be sure and go to setting > general and set the application rights to public

Just switched it. Thank you. I’m still a bit of a noob at this :sweat_smile:

Are you trying to update the user credits or put a new sub medic in?

I’m trying to update the user credits.

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.

Ok, that will help a lot.

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.

1 Like

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!

You should be able to do what you need with your current data structure. Try this:

1 Like

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!

1 Like

Would you mind helping me once more?

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?

i’m working on practice page 5.

Hi @christianszadyr,

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).




1 Like

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

Where yours it just updates the line

Pleased you’ve got it working.

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.

oh I see now. My computer was just lagging and not updating it in the database right away.

Thank you again for all of your help!

1 Like