Jump to content

email URL link to new record


This topic is 6688 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hey All,

Quick question. Has anyone come up with a solution or know of a solution that would allow FM to automatically email a predefined list of recipients the URl to a newly created record?

For example. I have a database called meeting minutes. When new minutes are added to the database I would like an email to be sent to all those involved with the project that would conain a link pointing to a format file that would contain those minutes. In essence, it would have to display the find criteria, similar to the email you receive if you are sent an Evite.

TIA.

Link to post
Share on other sites

Hi, an easy method is to embed a hidden mail form into the new record reply page.

If you Give the user the chance to review his submission with an 'amend' (link to record detail to revise it) and an OK button which is the mail post.

I tend to use a mail cgi instead of the filemaker mailer because it's more flexible, but the principle's just the same.

Use Filemaker fields to populate your message.

Embed a search string with either the record serial number or current record ID to let them get to that record.

Like:

<FORM ACTION="http://www.myserver.com/cgi-bin/forms.acgi" METHOD=POST enctype="x-www-form-encoded">

<P><INPUT TYPE=hidden NAME=message VALUE="[FMP-Field:meeting_stuff]" WRAP=virtual></P>

<P><INPUT TYPE=hidden NAME=link VALUE="http://myserver.com/folderpath/FMPro?-db=thedatabase&-Format=record_detail.html&-error=error.html&-lay=layout1&-op=eq&recordnumber=[FMP-Field:recordnumber]&-Find"></P>

<P><INPUT TYPE=hidden NAME="*mailto" VALUE="[FMP-Field:recipients_email]">

<INPUT TYPE=hidden NAME="*smtphost" VALUE="mailout.myserver.com">

<INPUT TYPE=hidden NAME="*header" VALUE=[FMP-Field:mail_title]>

<INPUT TYPE=hidden NAME="*mailfrom" VALUE="[FMP-Field:sentby_email]"><INPUT TYPE=submit NAME=Submit VALUE="Mail">

</FORM></P>

........You can assemble this stuff as a calculation field in FileMaker to make the html less messy

A note of warning: If you embed a long FileMaker URL into an email, some clients, like MS Outlook won't link from it if the url wraps to a second line - the recipient will have to cut and paste.

regards, Jeff

Link to post
Share on other sites

This topic is 6688 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Who Viewed the Topic

    1 member has viewed this topic:
    iking42 
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.