Hi, I created a script to send an email with some data in the subject area and data in the message area of a specific field name, My question is how can i add more specific field name in the message area,,,,,like multiple field names?
To the rt of the Message box is a menu select Specify Calculation - you can add text and field from any table (connected to the current TO)
tip: create the message calculation in the data viewer this way you see the results without have to close it and run the script. edit run the script etc.
FM 17 Turn on Use advanced tools in preferences. older versions require FM Advanced
Wow works good,,, but now all my information is in a long string of information, i would like to have it like this
John deere tractor
instead it is like this
83602014John deere tractor
Do like this in the calculation field as below, to get your output :
"field name of 8360"& "¶" &
"field name of 2014"& "¶" &
"field name of John deere tractor"
Thank you so much this works great now........now lets take it to the next level, how can i make that 8360 is the model and 2014 represents the year?
Fine! Here below...
"Model Number : "& ModelField"¶" &
"Year : "& YearField "¶" &
"Model Description : " & DescriptionField
"Model Number:"& ModelField"¶" &
"Year :"& get (CurrentYear) "¶" & //If it required to display the current year automatically
"Model Description:" & DescField
Retrieving data ...