I've read that but would like some more specific examples, please.
For example the Get(DocumentsPath) returns my local Mac folder and not a folder on the server, where the test db is hosted.
Get ( DocumentsPath ) will not return the local folder if run in a server context. Try this from a Perform Script on Server call:
Exit Script [ Get ( DocumentsPath ) ]
Perform Script On Server ["name of first script here"]
Show Custom Dialog [Get ( ScriptResult ) ]
If the script is Performed on the server (PSoS or scheduled), then the DocumentsPath is relatative to the Server. Server MUST have permission to read/write to any directory that may be used. Documents is one of them that by default should be allowed.
you can trap for where the script is run.