find data in database from form entry

[Guest]

I want to do a "remove from our list" page. That is, user enters email
address and submit the form, I need to find that email in the database, then
marked that record as "removed".

I don't seem to find the function to do these steps. Is it possible in FP?
please help.

 

[Jon Spivey]

Hi,

You mean delete it completely from the database? If you're using the FP
wizard you can make a form with a text box called email then have it post to
a drw with a custom query like this
delete from table where email = '::email::'

 

[Guest]

Hi,

No, actually I just want to check the field "remove" as "yes" in the
database when people submit their email address. I do not want to delete the
whole record.

I do already have a form with email textbox for people to submit. I am just
not sure -
after the form is submitted, where do I do the custom query to find the
form.email in the table?

Thank you.