Jump to content
  • 0
Smashley

Counting and limiting submissions

Question

I am trying to track warnings given to company employees. It's a three-strikes-and-you're-out situation.

I originally created a field called "warning_level" in which you could select a 1, 2, or a 3.

But now I'm wondering if it's possible to automatically calculate/count how many warnings have been submitted for each employee.

And also limit submissions to three per employee.

Additionally, warnings are meant to expire after one year. Is it possible to calculate the age of a submission and automatically make it inactive, and then prevent it from being included in the count?

Thanks in advance for your help!

Share this post


Link to post
Share on other sites

1 answer to this question

Recommended Posts

  • 0
On 6/20/2017 at 6:15 PM, Smashley said:

I am trying to track warnings given to company employees. It's a three-strikes-and-you're-out situation.

I originally created a field called "warning_level" in which you could select a 1, 2, or a 3.

But now I'm wondering if it's possible to automatically calculate/count how many warnings have been submitted for each employee.

And also limit submissions to three per employee.

Additionally, warnings are meant to expire after one year. Is it possible to calculate the age of a submission and automatically make it inactive, and then prevent it from being included in the count?

Thanks in advance for your help!

I wonder who sets warning point? Is it a specific employee or you need to do that automatically after a specific action?

Where do you store warning points? In users table or you have a separate table?

Conditions which you described can be done in a view, however exact criteria depends on the current workflow.

You may also have a look at this solution which should be close to what you need

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×