Here is my problem; I am new to FileMaker and I have built a solution only by the grace of God and help from forums. The database imports updates from spreadsheets on my Desktop, and it works great on one computer, but if I use it on a different computer I have to edit and map the Desktop file again. The problem is, that I need it to be able to find the file on the Desktop no matter what computer is running the solution. For example; if I gave a copy of this to a friend (assuming he had FileMaker)and he wanted to update it, he could simply click the update button and it would locate and import the UPDATE file on his desktop.

Am I asking too much or can this be done? Also, I should mention; I don't know the first thing about database relationships or how to make a script. I would certainly like to learn though. No FileMaker classes in my neck of the woods!

Use a script variable for the path. The variable can be populated using the Get (DesktopPath) function.

Use a script variable for the path. The variable can be populated using the Get (DesktopPath) function.

At risk of sounding dumb... How do I do that? As I mentioned I don't know how to do scripts. I am using FileMaker Pro 11 Advanced though if that helps.

Roughly:

Set Variable [ $path ; Value: Get (DesktopPath) & "UPDATE.xls" ]

Import Records [ "$path" ; Add ]

Do consult the help for things that aren't familiar to you.





---

It's possible that on Windows you need to be more explicit and set the variable to =

"filewin:" & Get (DesktopPath) & "UPDATE.xls"

Just to update and verify:

In Windows this will work just fine... as it's what I use.

Set Variable

Name: $FullPathToDesktop

Value: "filewin:"& Get (DesktopPath)

Yes, that did it! Thanks for all of your help. This forum is the BEST!