November 26, 200322 yr I have 2 databases related by constant throught the relationship "donor". One is a calander type database. What I am trying to do is this. Click on a date on the calander, this copies the date into a DateField in the calander db. Then through an OK button that performs a script, this date should be set in another field in the related db. My script looks like this, and I can not figure out what is going on. If[isEmpty(gNavigator)] Show Message [buttons: "OK","";Data: "No date is selected"] Else Set Field [Donor:ScheduledTowDate, gNavigator] End if Any ideas where I have gone wrong, or how I can get this to work? Thank you
November 27, 200322 yr Hello Kristen Myself working on a german Fielmaker version, yesterday I didn't get the right english Scriptmaker terms for the call to external script. So here again, but this time in english Filemaker: If[isEmpty(gNavigator)] Show Message [buttons: "OK","";Data: "No date is selected"] Else Perform Script [sub-scripts, External:
December 1, 200322 yr The only problem I can see for this script step not working is if there is more than one record in the related file. If there is, then the Set Field step is setting the first related record in the related file, which is either the first record created in that file or the first record that would be displayed in a portal for that relationship, if the relationship definition has a sort defined. If there is only one record in the related file, then both of these possibilities would point to the same single record, and your script should work.
Create an account or sign in to comment