applescript set var to cell "myfield" ...

[Franco Pagano]

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

[comment]

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 August 26, 2016 by comment

[Franco Pagano]

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

[comment]

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.

[Franco Pagano]

You have reason, it is a standard apple script, i can use it also for non global field.