Forums

create alert if field and value of database sum are more 40...

mlosito 29 Nov, 2016
Hi my friends,

i have a question
I created a form with more field. Ok
in the form there is
cliente
materiale
week_of_finish
qta
ecc....

now i know that every the week of the year We can producer only 40 pieces.
Then when the user will write a number in qta, if this qta sum the other qta in the same week in more 40 i must do create a allert

it is possible?

thanks?
mlosito 29 Nov, 2016
the week_of_finish is simple a number
GreyHead 10 Dec, 2016
Hi mlosito,

Sorry not to have replied earlier.

You can do this using Custom Code to check the database records to find the number committed in each week and check if that is greater than 40.

One way to do that would be to show a drop-down or Radio Button group for the weeks and to disable the weeks where the quota is full.

Bob
This topic is locked and no more replies can be posted.