[web2py] Creating a validator to limit the number of table entries

I am trying to create a short validator that limits the number of children that can be listed under one parent but I'm having a problem with the highlighted line because I cant use *parent.id *to specify the selected parent when the parent variable is referenced outside the validator function.

[web2py] Re: Creating a validator to limit the number of table entries

Hello! Your are not referencing the parent table. I think, what you want to address, is as follows: if db((db.*parent*.id>0) & (db.children.parent==parent.id)).count() >=10: ... Then the error should not occur and you are get all parents with more than 10 children. Regards Clemens On Su

[web2py] Re: Creating a validator to limit the number of table entries

What I want is to prevent more than 10 entries of children per selected parent On Sunday, December 12, 2021 at 1:45:31 PM UTC+2 Clemens wrote: > Hello! > > Your are not referencing the parent table. I think, what you want to > address, is as follows: > if db((db.*parent*.id>0) & (db.children.p

[web2py] Re: Creating a validator to limit the number of table entries

So i decided to do this & seems to be working, I hope it fall apart, please advice if i'm wrong. I added the validator function inside the registration function & called it from the process() function, its working, i hope it wont fall apart. def registration(): parent=db.parent(request.args

[web2py] Re: Creating a validator to limit the number of table entries

Now parent is a valid row object, that can be referenced by parent.id. If it delivers what you want to, it's fine! Best regards Clemens On Sunday, December 12, 2021 at 2:42:31 PM UTC+1 mostwanted wrote: > So i decided to do this & seems to be working, I hope it fall apart, > please advice if i

[web2py] Re: Creating a validator to limit the number of table entries

Thank you, really. On Sunday, December 12, 2021 at 3:46:40 PM UTC+2 Clemens wrote: > Now parent is a valid row object, that can be referenced by parent.id. If > it delivers what you want to, it's fine! > > Best regards > Clemens > > On Sunday, December 12, 2021 at 2:42:31 PM UTC+1 mostwanted wro

[web2py] Keeping track of database entires

Is there a way of keeping track of table entries? I have to create a function that shows a pop-up warning when a client has not made payments in 3 months ,i dont know where to begin, any ideas? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py