samshem

That works great. Thanks everyone for your help.

Ok, I tried it, but it will not accept it. Are all parameters correct short of the field name? I assume to remove the "Send Event" part of that calculation as FM would look for a table called Send Event. Pardon my ignorance in using this script step as I have never used it before. Thanks for all your help.

Is that supposed to go into the calculation function of Send Event?

Thanks for the reply. I do not need to have the results in a Filemaker field, only ping an IP address in a Filemaker field viewing the results in the ping window. Is there a way that can be done using the command you posted? Thanks.

I am trying to figure out a way to automatically launch the ping command built into Windows and automatically put in the address to ping from a field within the FM database. I managed to have the script launch a command prompt window by using the send event command. I think the next step would be to use the Send DDE Execute command, but I do not know what to put in the Topic field of that script step. Does anyone know if this is possible? Thanks in advance for any help you can provide.

Thank you again for your assistance, it works.

Does somebody know how I could parse a 12 digit number that starts 16 digits in and ends 4 digits before the end? For example the string of numbers 9761243631002561 724686727627 2019, the numbers that are in the middle are the ones that need to be parsed from the entire string. How would I specify that in a calculation? Thanks for the help.

Thank you! Works great.

I am trying to figure out how to get the number of characters that are in a specific field. I would like to do this in a calculation to use with a case function. I could not find anyway of simply getting a count of characters in a field. Any help would be appreciated. thanks.

Thank you, that was too easy. It works just how I wanted. Thanks.

Hi, this may be easy but I cannot figure this out. I have a field that will contain a Fedex tracking number that will be entered by scanning the barcode on the FedEx label. The barcode contains 22 digits of which the last 15 are the tracking number that needs to be parsed. How would I setup a calculation to throw out the first 7 digits and keep the last 15 in the field? I would appreciate the help, thanks.

Thank you both for your replys. Stanley, I did incorporate a that into the script somewhat. What the script does is does searches for open orders that have not shipped yet and then pastes the results for each product in a "Open Order Summary" page. The problem was, if there was a result of 0, I would get the no records found message popping up and it would then affect the rest of the script. Then, when I put the Error Capture line in the script, it was continuing like I wanted it to, however, if the result was 0, it would not copy and paste "0", instead, it would paste the last positive number it copied. I probably made it sound much more confusing that it is, but basiclly, I now have it set up as "If [Get(FoundCount)=0] Set Field [field name;"0"]. Anyway, thanks for your help.

I am using the "Perform Find" step in one of my scripts and my question is how to get it to not display the window saying that no records were found and just continue on with a result of zero. The "Perform Find" step is used multiple times in my script and if one of the find requests turns up with nothing, it messes up the rest of the script. Thanks for any help that you can provide!

That worked great, thanks so much!

I some help on how to auto format a field. I would like to be able to enter a 3 digit number such as 203 and have automatically formatted as 2.0.3 when I tab to the next field. I found a template on how to do something similar to this for a phone number field but am unable to adapt it to what I need. Any help would be greatly appreciated. Thanks!