I'd love to help but your upload of the files did not work. You have to use the online interface not standard email.
I am familiar with the Contacts.fmp12 starter file as I did a recent set of modifications for a new client.
1. Your <missing field> is most likely caused by a broken relationship.
2. Your change to the FIlters should work... so long as there is data in the fields with the same matching values.
I hope that helps...
I'll keep an eye out for the files.
1 of 1 people found this helpful
Thanks Lyndsay - I’ll try uploading the files again. Cheers, Herby
Hello again Lyndsay - I seem to recall using the 'Attach Files' option in my original message. Now I can't find that option so how do I upload the files? - Herby
Here I am back againn Lyndsay - this time I editedthe orgiginal post and seem to have successfully added the files. Please let me know if you can see them. Cheers - Herby
I have had a quick look at the two files you have posted and can offer the following:
1. The field that is missing is <<Initial>> (NOTE: this is not a relationship issue, as suggested by Lyndsay, because there are none in this file)
2. The script that runs from the Status Filter button in the original file depends upon matching values in the Contact List Filter list with values in the Group field. However, you appear to have deleted this field and so there is no way the script can run as it cannot perform the finds that are in the script. You will need to reinstate this field and populate it with the values you have in your new version of the list (Financial and Unfinancial).
I note that you are using FMAdvanced, so you have tools at your disposal which you may not be using. In the Tools menu turn on:
1. Script Debugger—this will enable you to step through scripts one step at a time so that you can see what the script is actually doing and perhaps discover which steps are not doing what you expect
2. Data Viewer—if you make sure Current is selected you can see the values of any variables that your scripts create, which will help you also understand how these variables are set and how they are used
Hope that's of some help.
PS. I'm an old fart too, or as you put it "a somewhat old guy".
Many thanks from one old fart to another. I much appreciate the help that guys on the forum can provide I’ll reinstate the field Group and see how I get on. Cheers, Herby
Herby, delete the merge field <<<field missing>>> in the subsummary part and reinsert the merge field "Initial" .....
Herby, if you use the Script Debugger to walk through the script trigger that runs when you pull down the filter "All - Financial - Unfinancial"... you see you have accidently added a script step that puts you on the incorrect layout.
Set Error Caputre [On]
Set Field [Members::QuickFind; ""]
If [Members::Status Filter = "All"]
Show All Records
Set Variable [$$Script_Trigger; Value:"Off"]
Set Variable [ $$FILTER; Value:Members::Status Filter]
Perfore Find [Restore]
// Perform Find [Restored] // this is your problem script step ... disable and run Script Debugger to see script work with "All" chosen.... then delete this script step
Perform Script [ Trigger | Sort Member List [Ge Script Paramter]"; Parameter : $$PLATFORM]
Go to Record/Request /Page [First]
Your script will now work ... at least when you choose "All" ... you need to add field "Group" back to the Contact Detail Layout ... so you can set whether Member is Financial or not......
Good pick up!
I'm glad you figured it. Unfortunately I have had quite a day and only just got back to this.
Looks like you have had some help from other 'old farts' so I hope you have been able to go forward.
PS. Women don't fart in Australia... they 'glow and men thunder' according to the 1980s classic "Land Downunder". I suppose the fact that I know that and remember that when I was a small kid people actually said those words, that I too am an old fart... a term in much more common use today.
I’m so sure that ‘thunder’ would apply at my age (I’m not far off 80) however, women still glow in Oz.
Yes, I’ve had some more help but I’m still not out of the woods so if you come across another post from this 'old fart’ I hope to hear from you again.
Cheers - Herby
Also old enough to remember when the song came out. I wouldve never guessed in a million years that '...women glow and men thunder' meant what it did. I never knew you were from Australia...you type so American.....lol
My understanding is that the expression "women glow" refers to perspiration, not the other.