Re: Filemaker: referring to a "mirror" cell value
Re: Filemaker: referring to a "mirror" cell value
- Subject: Re: Filemaker: referring to a "mirror" cell value
- From: Jay Louvion <email@hidden>
- Date: Wed, 25 Jul 2007 14:58:04 +0200
- Thread-topic: Filemaker: referring to a "mirror" cell value
Title: Re: Filemaker: referring to a "mirror" cell value
On 25.07.2007 12:31, "Peter Baxter" <email@hidden> spake thus:
This is a last resort, but if no-one else comes up with a solution, I would combine the two files into one and have only a single occurrence of the field.
How is the mirror field formatted; as a lookup, or as a new field into which the data is imported. If it is a look up, then you can use the relationship between the fields to allow you to get the data in either database.
If the two databases have a relationship, then you can insert the related (original) field into the KndStamm Database and use that to get your data.
Other than these ideas, it is hard to solve your problem without seeing what is going on the the two databases. I hope that you get some ideas that may help. Viel Glueck
Ok, here’s my last try, which works, but feels clumsy:
set everyCell to cellValue of every cell of current record of current layout of document "Offerten"
set {TelNr, FirstName, LastName, DirectNmr, AltNmr, EmailAddr, GeneralNmr} to {item 8 of everyCell, item 9 of everyCell, item 10 of everyCell, item 12 of everyCell, item 13 of everyCell, item 14 of everyCell, item 15 of everyCell}
set TelNrIsComplete to length of TelNr > 10
if TelNrIsComplete is false then
set TelNr to DirectNmr
set TelNrIsComplete to length of TelNr > 10
if TelNrIsComplete is false then
set TelNr to GeneralNmr
end if
end if
if length of AltNmr > 10 then
set TelNr to AltNmr
end if
The TelNrIsComplete conditional allows me to check if fields are empty and get the value form another field (if the client doesn’t have a cell phone, or doesn’t have a direct line, or wants me to use an alternat number for this particular job)
Best,
j.
Jay Louvion
Studio Casagrande
3, rue Müller-Brun
1208 Geneva
T+4122 840 3272
F+4122 840 3271
www.studiocasagrande.com
P Please consider the environment before printing this email.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden