How to update student grade at a certain date?
Hi, I want to update the student grade at a certain date automatically, such as 7/1 every year. So I use "trigger after update" at the "grade."
And the formula is:
if date(7, 1, 2019) < today() then
Grade + 1
else
Grade + 0
end
But it didn't work, and I want to know how to change the formula or is there another way to achieve this goal? Thank you!
4 replies
-
Hi Ariana,
As for your formula.
• First of all, the parameters order in date() function should be (year, month, day).
• Second thing to fix: to increment variable usevar := var + 1
.
• Third: you don't need use the else section here.So your formula could look like
if date(2019, 7, 1) < today() then
Grade := Grade + 1
end
But! There is a logical mistake. After Day D happened, each time you'll refresh the view your Grade will increment.
I think you should solve this like you do in real life. So you may take it as an age from the date someone became a student:
Grade := age(admissionDate) + 1
-
Hello, I'm an Adjunct Instructor of Business Administration at Heidelberg University and I have created a DB of students. How can I update student grade, if some students recieve group grades (for certain tasks)? I mean that all students from a certain group will have the same grade for a particular assignment. The students are divided into 4 groups (sometimes 5, for social projects). How do I manage that?
Ninox Database FAQ> Formula to use trigger after update for a 5 days reminder to hire essay writer
-
Need assignment help in Australia? <a href="https://www.myassignmenthelponline.com">myassignmenthelp</a>
provides the best assistance with your assignments at affordable prices. Our assignment experts are professionals in providing quality assignment writing service.
-
Need assignment help in Australia?
myassignmenthelp
provides the best assistance with your assignments at affordable prices. Our assignment experts are professionals in providing quality assignment writing service.
Content aside
- 3 yrs agoLast active
- 4Replies
- 1897Views