Increasing user grade by one each year

I have a data type called guest, which has a grade field.

I’m trying to figure how best to bulk edit all 1st graders to 2nd graders (and all 2nd graders to 3rd graders and so on…) at the end of each year.

Any simple solutions for this?

Thanks!

you can use the make changes to a list action.

1 Like

An esiest way is Just case ‘Make changes to a list of thing’ then search all the guest of 1 st grade and change them to 2nd one.

few ways you could do this

instead of storing a grade you could store a date and do it like age then you don’t have to update anything in bulk each year

works similar to birthdate and age
to get age just compare birthdate to current date and format as years
to get grade compare grade date to current date and format as years
if they are held down or moved up a grade then just change the years 1 or -1

could also simplify and not use date but a number and still use a comparison - store the year only 2020 and compare to current dates year ie 2024-2020 = grade 4

although date would likely be useful if they enrol at a certain date because grades probably change every year at a specific date so comparing current date to grade date would make sense there - unless grades change the same time a year changes then you could use number

of if you want to store the grade as a number you could trigger it several ways

  1. teachers could mark each student as “graduated” from the grade/could be done in bulk also - this batches the logic so it is triggered by users instead of a scheduled event
  2. you could do it based on a scheduled workflow that runs once a year for all students (but what if some are kept down or skip a grade?)

I’d probably store it as a date or have the teachers do the graduations via a button per student/class

This is brilliant. Thanks!