Jump to content
Server Maintenance This Week. ×

applescript set var to cell "myfield" ...


This topic is 2797 days old. Please don't post here. Open a new topic instead.

Recommended Posts

fmp 14 last release.

i put this applescript in a global field  and also all the fmp field are global.

i don't understand  wy it doesn't work, if the applescript var are set as ... "set ServerDisk to "afp://2.236.100.143/dati" ... it work.

Were i am wrong?

Many thanks.


    set ServerDisk to field ("ServerDisk_as" as text) of table ("__AS" as text)
    set ServerFolder to field ("ServerFolder_as" as text) of table ("__AS" as text)
    set VarAccount to field ("VarAccount" as text) of table ("__AS" as text)
    set VarPw to field ("VarPassWord" as text) of table ("__AS" as text)

tell application "Finder"
    display dialog ServerFolder
    if not (disk ServerDisk exists) then
        mount volume ServerFolder as text as user name VarAccount with password VarPw
    end if
end tell

Link to comment
Share on other sites

33 minutes ago, Franco Pagano said:

i don't understand  wy it doesn't work

"doesn't work" is not a useful description.

Anyway, your title says set var to cell "myfield" but you are actually using set ServerDisk to field ("ServerDisk_as"...) - which is a quite different thing.

If your field is global, then:

set ServerDisk to cell "ServerDisk_as" of table "__AS"

should do the job.

 

Edited by comment
Link to comment
Share on other sites

solved also in this way:

 

set ServerFolder to cell "_PathLocalAfp" of current record as text
set VarAccount to cell "Server account" of current record as text
set VarPw to cell "Server pw" of current record as text

tell application "Finder"
    --display dialog ServerFolder
    try
        if  not (disk ServerFolder exists) then
            mount volume ServerFolder as user name VarAccount with password VarPw
        end if
    end try
end tell


many thank for your help

Link to comment
Share on other sites

21 minutes ago, Franco Pagano said:

set ServerFolder to cell "_PathLocalAfp" of current record as text

Just as a point of good practice: the value of a global field is the same for all records in the table - so the qualification "of current record" is quite redundant. If the field is present on the current layout, and the current layout is a layout of the table where the global field is defined, you can get its value just by:

set myVar to cell "gSomeglobalfield"

I also don't see what difference the "as text" part makes.

Link to comment
Share on other sites

This topic is 2797 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.