Is there a way to activate a script when a user submits a form to a database?

for example if someone fills in a form and i want to make sure that it isn't duplicated anywhere?

Help!!

You will need the a hidden field:

<input type="hidden" name="-Script" value="YourScriptName">

And it should work fine!

Good Luck

Anita

Can i ask something, where do you put this line of code, or anyother one

Webugarit

Yes... the above code goes in a form submission that makes a CDML web call.

I would suggest that if you can help it, don't call script from the web. While script is processing, it refuses new web connection. If you have traffic, it could crawl along. The inline tag in FMP5 Web Companion Could help you out...

Duplicate records could be solved using field-level validation, in which case FMP will refuse the new record and return the specified error html format file.