Jump to content

Returning a Global Variable for a Find

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

Recommended Posts

  • Newbies

I have an intermediate level of experience with Filemaker pro and am working on Filemaker Pro 13.

I am trying to fix an automated script for removing a series of records based on a common identifier field.  During this process I pass the identifier field of the existing record to a global variable, but can not pass it back after initiating the find.  Below is this script:

<<-- Beginning of Script -->>

Show Custom Dialog ["Message"; "Do you really want to delete this series?"]

If [Get(LastMessageChoice) = 1]

   Exit Script []

End If

Go to Layout [""Schedule Visit" (Scheduling)]

Set Field ["Scheduling::record_place_holder; Scheduling::Appoint_Set_Record]

Set Error Capture [On]

Enter Find Mode []

Set Field [Scheduling::Appoint_Set_Record; Scheduling;;record_place_holder]

set Field [Scheduling;;Date_Start; Get(CurrentDate)]

Inser Text[Scheduling;;Date_Start; "...12/31/2222"]

Perform Find[]

Go to Layout [Delete Appointment Set"( Scheduling)]

Sort Records [Restore; No dialog]

Go to Record/Request/Page [First]

Set Error Capture [Off]

<<-- ! End of Script -->>

If I Echo the values for the record_place_holder and Appoint_Set_Record before the line:

Enter Find Mode[]

The values are the same, but after

Set Field [Scheduling::Appoint_Set_Record; Scheduling;;record_place_holder]

The Appoint_Set_Record is blank.


I am not sure if this is syntax or Filemaker Logic that is preventing the record_place_holder value from being passed to Appoint_Set_Record during the Find process.

Any direction or Enlightenment on this topic would be welcome.


Link to comment
Share on other sites

Can you please print your script to PDF, then open it and copy the contents out of it then paste in here as "code" (<>)? Then we could see what you actually have in the script.


I cannot see you setting a variable. 

And why do you need a record placeholder? What does that do?

Link to comment
Share on other sites

It's hard to follow the logic of your script, because we don't have the context. Here's a guess:

When you enter Find mode, only global fields have values. So when you do:

Set Field [Scheduling::Appoint_Set_Record; Scheduling;;record_place_holder]

it can only work if Scheduling::record_place_holder is a global field.

Link to comment
Share on other sites

This topic is 3114 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.