MikeMc

Greetings! I have built a small utility that uses a complex formula to calculate the distance in meters between two points based on their respective Latitude, Longitude and Altitudes as reported by a GPS tracking unit. The utility appears to work but the values that it returns are way off. The reason that I know they are way off is that I have runt the same numbers/formulas, etc. through excel and know what the correct answers should be. I set up the formulas in Calculation fields and copied the formulas directly from Excel. My guess is that there is something going on with the conversion of Radians/Degrees that is done differently between FileMaker and Excel, but for the life of me I can't figure it out! I tried to attach the FM file but it wouldn't let me. If you think you can help, email me at mike_mcgeoy@yahoo.com and I can email you the file to look at. I would appreciate any help that can be offered. Mike

I'm writing a simple script to Find, Sort and Export data in HTML file format. The export file needs to stick with a naming convention that is a concatenation of a few of the fields in the database For example: the file name would look like this: Name_Company_Date My question is: How do I get the script to paste the string I create into the File name dialog in the "Exports Records to File" window?