I have a database that is auto serial numbering and a web site that ties into it. What I would like to do is to make it possible for the user to enter all the information including his/her e-mail address ..but obviously not the "New number" seeing as FM does that automatically.

The problem is I can't get the mail tags to work in the New page with the -new button, but it will work if I place it in the Edit page using an -edit button. I have it running right now where the user creates a new record then has to confirm the information that they entered (in an edit page, in order for them to get an email reply) ...BUT I don't want them to be able to Edit

This has really got me steaming, cause I had it working before for a very short period.

Can anyone help me with this

"...BUT I don't want them to be able to Edit "

Ok. Consider putting the -edit action in a link on a meta redirect (refresh) page as an intermediary step between the submit and the results.htm. In order to perform an innocuous edit if you need to, create a field to be edited by this automated step. Such as a blank field which is given the data "yes". That can be used as an indicator within the db file that the -edit action was taken.

http://www.vancouver-webpages.com/META/

if you dont need or want them to edit their record but would like to send them an email (and their email address comes from the email field in the database) you could put an Inline action on the response page...the inline will be executed after the record has been created.

Okay,

I have placed this into my reply page(it's accually an edit page) but it doesn't work. I am not familiar with Inline actions so it's no surprise to me, can anyone help me figure out what is wrong.

[FMP-IF: CurrentAction.eq.new]

[FMP-InlineAction: -db=My_Database.fp5, -mailto=FMP-FIELD: Send to,

[email protected], -MailSub=Part Number Request Confimation, -MailFormat=Confirmation.txt,

-MailHost=mymailhost][/FMP-InlineAction]

[/FMP-IF]

A couple of suggestions off the top of my head:

1. Specify a -Lay

2. Enclose the FMP-Field:... in {}

3. The spaces in your values may mess things up; replace them with %20

4. Specify an action, like -View.

Hope this helps!

Thanks Peter,

That works great!

The only thing is, now my Confirm.txt doesn't show my FMP fields

I have this type of thing:

Part Number: [FMP-FIELD: Part #]

Referenced Product Numbers: [FMP-FIELD: required Number1] ([FMP-FIELD: required Number2])

Comments: [FMP-FIELD: Comments]

and it shows up in the email as:

Part Number:

Referenced Product Numbers: ()

Comments:

It worked before though!

Any ideas?

In that case, instead of -View in your InlineAction, specify -RecID={CurrentRecID} and a -Find action. See if that helps.

You may also want to include the [FMP-Record] tags in your confirm.txt file, although I don't think it's absolutely necessary. Emphasis on the word think.

Thanks a pile,

It's all good!