Jump to content
Sign in to follow this  
sojahseh

Listing multiple field contents in a field

Recommended Posts

Hello all,

I have a layout in my database that I am trying to use as an order entry form. When the form is complete, I'd like the database to send out an email with the body of the email being a list of field names and contents of the record displayed as a list. Like this:

Entry Date: January 20, 2009

Customer Name: 3M etc.

I've been trying this using the FM email feature, but it only lets you include the contents of one field. So I was thinking if there is a calculation that I could use to list the info as formatted above, in one field and then include that in the body of the email, that would solve the problem. Does this sound logical? Is there a better way that people normally use to achieve this?

I look forward to hearing from you.

MVC

Share this post


Link to post
Share on other sites

create a calc field, eMailBody, and use the concatenate features to create the text block you want. For example,

eMailBody (result text) =

"Entry Date:" & TO::EntryDateField & "¶"

& "Customer Name:" & TO::CustomerNameField

...where TO is the table occurrence.

Edited by Guest

Share this post


Link to post
Share on other sites

Forgive my naïveté, calculations have not been my thing. Here's what I have in the calculation dialog:

"Entry Date: " & Date & "¶"

"Customer Name: " & Customer Name "¶"

But I get the alert that an operator is expected here: and have the second line highlighted.

What am I missing?

Share this post


Link to post
Share on other sites

As it says, you are missing a few & operators:

"Entry Date: " & Date & "¶" [color:red]&

"Customer Name: " & Customer Name [color:red]& "¶"

BTW, although as a rule literal text needs to be enclosed in quotes, there is an exception for a single carriage return, so you can safely make it:

"Entry Date: " & Date & ¶ &

"Customer Name: " & Customer Name & ¶

Share this post


Link to post
Share on other sites

hi - i am wanting to do basically the same thing - but a LISTING of only ONE field - like student names... in the email - any help very much appreciated.. :-)

Share this post


Link to post
Share on other sites

As comment asks, where are you starting-- what table? and where are the student names? another related table?

Share this post


Link to post
Share on other sites

I think what is being ask, since this is the solution I am trying to find, is this.

I want to make a list separated by ";" that includes email addresses from two different tables - one is a general company email (only one email address in a single field) and the other are all the emails from the related contacts (as many as 10 or more). The company and contacts are related through a member id number.

Is there a script I can use?

Thanks

Share this post


Link to post
Share on other sites

You don't need a script, you need a calc.

All_eMails = Substitute (CompanyEmail & ¶ & List (related::emails); "¶", ",")

result text.

Share this post


Link to post
Share on other sites

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
Sign in to follow this  

×

Important Information

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