AppleScript definitely from the client. The "Perform AppleScript" script step is not server-compatible but you can use an FMS script sequence schedule there: run a shell script to produce the output in the FMS docs folder, followed by a FM script call to import it.
Wim many Thanks
Shell scripting is still on my bucket list - so if you have time to suggest the shell script steps it would be a great help to me
Create a text field called "dig_results"
In your script, add the step for Perform Applescript with this calculation:
"set cell \"dig_result\" of current record to do shell script \"dig\""
You could even add two fields, dig_server and dig_type, which would allow you to specify the parameters dynamically. Just change your calc to
"set cell \"dig_results\" of current record to do shell script \"dig " & yourfile::dig_server & " " & yourfile::dig_type & "\""
Note that you can use man dig in Terminal to learn more about the dig command and its parameters.
This works for your non-server case.
Requires the target field to be on the current layout
Applescript can use the "do shell script" command, it does not need to lauch terminal
Assumes target field is named Result
property targetCell: "Result"
do shell script "dig"
copy result to cell targetCell of current record