don't allow duplicates in db with form builder

[Peter Troeger]

Hi

I'm using form builder pro and saving email-adresses to the databse.

I only want people to be able to sign up once.

Is there a way to check if an email-adress is already in the database and send an error?
 

Thanks for any help!
Peter

[LostKobrakai]

There is, but it's not recommended, because you'd need to load all submitted entries into memory, which does not scale well. FormBuilder (and it's storage method) is not particularly well suited for such needs. You'd want to use pages for that use case as pages can be searched in db for particular field values.

[Peter Troeger]

36 minutes ago, LostKobrakai said:

There is, but it's not recommended, because you'd need to load all submitted entries into memory, which does not scale well. FormBuilder (and it's storage method) is not particularly well suited for such needs. You'd want to use pages for that use case as pages can be searched in db for particular field values.

Could you explain how I can do that or point me in the right direction? It'd be for a maximum of 500 entries, so it would be ok if it doesn't scale

Thanks!
Peter

[LimeWub]

@LostKobrakai

Out of curiosity, and I have never used formbuilder, but wouldn't something similar to this be possible?

$a = $people_who_have_signed_up->findOne("email_field=email_adrress_posted");
if($a->count){
	//you have submitted this form before.
}

And if so, wouldn't that be decently efficient as it's a 'findOne'?

[Robin S]

9 hours ago, Peter Troeger said:

I'm using form builder pro and saving email-adresses to the databse.

I only want people to be able to sign up once.

There is a dedicated "VIP support" subforum for questions relating to Form Builder.

See this thread for limiting entries based on email address:

 

[Peter Troeger]

Thank you, here as well