alanf

Comment, Beautiful. Thanks for your help!

Aussie, no it can be varying in length

Thanks and sorry guess i need to adjust my profile. Im using 18 pro advanced. Do have custom functions

I have a list such as: (B) KARR SECURITY [PS] $100 (B) PPM Gross [$1270 * 5%] = $63.5 (B) Warranty $50 Looking for suggestion and help to grab the last word in each line and calculate the total of the list. IE: $100 + $63.5 + $50 return result $213.50 Thanks

Bump on release date?? THANK YOU!

True and thanks. I started this approach of export from a sub summary report from the sales detail table because I could not figure out a way to get the results that the sub summary report produced (Running MTD sales by date of any sales on file for a salesperson) and then use the results in relation to another table by ID of sales person. So that was my approach to it.

That shows 1 record for each salesperson who hit the goal and the earliest date they hit it (in that example 2). Thanks comment. The sales table for this purpose was created via a sub summary report on a detail sales table that groups cumulative MTD sales units by Salesperson and Date for a period of start and end dates. Then that sub summary report is used to populate the table for this example via export and then imported to the sales table

Yes that is correct. Sales table would have only 1 record per salesperson per date of the month that they had a recorded sale and that shows cumulative month to date units for that date of the month. No sure which original example piece you're saying shows otherwise?

Comment, thanks for the input and outlined examples. I will avoid abstract names in the future. ( a ) I will try this with a calculation field. Thanks. ( b ) I had done some thought about using a calculated ExecuteSQL() function today as well. I am already using this method in other areas of my solution. Thanks (c ) Here is my weakness and lack of understanding of Go To Related Record. I need to get comfortable in its ability and usage. I should have pointed out that the Sales Table example were Running Totals MTD by Day. Sorry. So "not (as might be expected) for the earliest date when the total of the sales for that day has met or exceeded the goal" will work in this case. Let me play around with these examples and report back. Thank you again for the pointers and suggestions!!

Comment. Thanks for your replies and help... It will be used for display purposes within an existing portal as an additional field to that table used in the portal. If TABLE A is used for the portal and contains one record per ID i want to find ID in TABLE B with UNITS >= to a variable goal number and the earliest DATE record it was achieved. (ie: TABLE A ID 301 finding a single result in TABLE B of ID 301 with DATE 10/13/2018 using a goal of >=5 I understand how to do a scripted find on TABLE B for ID=301 and UNITS >= goal of 5, but that then returns results for all dates in TABLE B data below and not the earliest date for ID. Seems I would then have to walk through all the records with repeated finds for each ID in TABLE A and then sort the find by date ASC then grab 1st record and add that DATE to a field in TABLE A for the result??? Guess my thinking i could create a relationship BETWEEN A and B to return the Earliest date for ID with Units >= to a variable goal is not the approach?? TABLE A (used in portal) ID 301 302 360 305 TABLE B ID 301 DATE 10/15/2018 UNITS 9 301 10/14/2018 8.5 301 10/13/2018 6.5 360 10/14/2018 4.5 766 10/3/2018 3

Sorry I should have given a bigger picture. Yes there is more than 1 table. Lets call it Salespeople. Based on a relationship of Salespeople::ID, i want to determine the earliest date that a salesperson hit a given goal and grab that date and unit amount only. Thanks

I have a table named Sales with the following data: ---------- ID DATE UNITS ----------- Based on Sample data below, i am trying to query the table by creating a relationship to find the ID that achieved a specified Unit amount on the earliest date. In other words, and for example, which ID achieved a specified Unit amount first (earliest date) Specified Unit Amt of 5 = 1 Expected records returned result 301 10/13/2018 6.5 Specified Unit Amt of 2 = 2 Expected records returned result 766 10/03/2018 2 360 10/03/2018 2 I think a selfjoin may be required. Any thoughts appreciated! Thanks Alan SAMPLE DATA ID DATE UNITS 301 10/15/2018 9 301 10/14/2018 8.5 301 10/13/2018 6.5 360 10/14/2018 5.5 305 10/15/2018 5.5 301 10/12/2018 4.5 656 10/13/2018 4.5 360 10/13/2018 4.5 305 10/14/2018 4.5 611 10/14/2018 4.5 305 10/13/2018 4 15 10/13/2018 4 301 10/11/2018 3.5 360 10/12/2018 3.5 611 10/13/2018 3.5 301 10/09/2018 3 15 10/11/2018 3 656 10/12/2018 3 611 10/12/2018 3 200 10/14/2018 3 301 10/06/2018 2.5 611 10/09/2018 2.5 200 10/13/2018 2.5 766 10/03/2018 2 360 10/03/2018 2 785 10/05/2018 2 301 10/05/2018 2 611 10/05/2018 2 439 10/10/2018 2 656 10/11/2018 2 510 10/15/2018 2 360 10/01/2018 1.5 510 10/04/2018 1.5 611 10/04/2018 1.5 305 10/05/2018 1.5 200 10/08/2018 1.5 656 10/09/2018 1.5 785 10/02/2018 1 766 10/02/2018 1 305 10/03/2018 1 439 10/03/2018 1 15 10/04/2018 1 301 10/04/2018 1 200 10/07/2018 1 656 10/08/2018 1 766 10/01/2018 0.5 510 10/01/2018 0.5 611 10/01/2018 0.5 200 10/06/2018 0.5

Thank you Ryan for the reply and appreciate the focus on rolling the fix out! Alan As in my case there are 3 processes to kill. I am wondering if this may cause a problem in trying to kill the filemaker process itself this way before FM Closes. Seems like this may cause file corruption.

Have had this issue using ScriptMaster and Email plugins for many many months on Windows 7 Professional and Windows 10. Have to use a system scheduler program to look for Filemaker, java, and fmxdbc_listiner.exe process still left running and end the processes left running after quitting FM 17. A real end user pain! Sad that 360works is taking SOOOOO long to fix this!!!

Ryan, Thank you for the reply. I have tried to set that up as you directed. Script does send email and move message to "Sent Items" folder, but does not successfully mark it as read. Here is what I have. Does this look correct? Thanks! Set Field [ PluginExample::_result; EmailCreate( PluginExample::From ; $CurrentEmailAddress ; PluginExample::Subject) and EmailSetBody( PluginExample::Body ) and EmailAttachFile( $OutputFileName ) ] Set Field [ PluginExample::_result; EmailSend ( "progress=" & PluginExample::Progress Bar ; "progresslocation=" & PluginExample::Progress Location ) and EmailMoveCurrentMessage ( "Sent Items" ) ] #get message id from what was just sent Set Variable[ $messageID; EmailOutgoingMessageId ] Set Field [ PluginExample::_result; EmailReadMessages( "readonly=false"; "messageID=$messageID"; "mailbox=SENT ITEMS" ; "max=1") ] #Iterate to message Set Field [ PluginExample::_result; EmailGetNextMessage ] #Mark as read Set Field [ PluginExample::_result; EmailMessageSetFlag( "viewed";"true" ) ]