FileMaker Scripts - Part IV

25/03/2014

Menasche Scharf

Ask FileMaker how to OnTabSwitch navigate to Tab within a tab script (See: ), so that when the Status is set as Associate, the “Associated Companies” Tab should show, instead of the default “Associated Persons” Tab (See: [cccxcvii]

See: [cccxcvii] https://fmdev.filemaker.com/servlet/JiveServlet/download/1121-3-19808/script_triggers_fmp_en.pdf and http://sixfriedrice.com/wp/tab-controls-without-the-tabs/

See: http://forums.filemaker.com/posts/4393e50209?opentoken=QXBpS2V5PTEwYzgwZjlkODliMjcwNmUmcF9jaWQ9MTQ2MzAzNCZwX2VtYWlsLmFkZHI9bWVuYXNjaGUlNDBrbGJka29zaGVyLm9yZyZwX25hbWUuZmlyc3Q9TWVuYXNjaGUmcF9uYW1lLmxhc3Q9U2NoYXJmJlNpZ25hdHVyZVZlcnNpb249MiZTaWduYXR1cmU9UmtkQUJNT0thUmh2YUdHRzJKd08wNG5Td1lNJTNEJnBfc2Vzc2lvbmlkPTF2M2xKNlFsJnBfdGltZXN0YW1wPTEzOTU3NDc5Nzk*

27/03/2014

Menasche Scharf

Sage advice from: The slide up, also shrink enclosing part feature will do what you want. 

But.... The feature will only be visible in preview mode or when you print the report. 

But... This feature is tricky. 

If you have multiple fields on your layout, changing the position of a field even 1 pixel may affect whether the fields slide and shrink correctly. 

If I have to make major use of the sliding property, I often set up a script to a) preview the report b) pause c) return to browse mode. 

While paused, the user sees what the report will look like if they print it and has the option of either printing hard copy or just continuing the script to return to browse mode. 

See: http://forums.filemaker.com/posts/97002a7b31?opentoken=QXBpS2V5PTEwYzgwZjlkODliMjcwNmUmcF9jaWQ9MTQ2MzAzNCZwX2VtYWlsLmFkZHI9bWVuYXNjaGUlNDBrbGJka29zaGVyLm9yZyZwX25hbWUuZmlyc3Q9TWVuYXNjaGUmcF9uYW1lLmxhc3Q9U2NoYXJmJlNpZ25hdHVyZVZlcnNpb249MiZTaWduYXR1cmU9UmtkQUJNT0thUmh2YUdHRzJKd08wNG5Td1lNJTNEJnBfc2Vzc2lvbmlkPUtLMWlUZ1FsJnBfdGltZXN0YW1wPTEzOTU5MTQ1MDM*

01/05/2014

Menasche Scharf

Ask FileMaker if I change the spelling of a Value List, does it ‘scramble’ the Formulations, Scripts and Functions throughout the system, wherever this Value List occurs in them?

15/05/2014

Menasche Scharf

Ask FileMaker how to arrange the Hand over a Button not to show, when the Script will not be able to execute.  

Example: A M Todd (the very first Record on the Main_Menu_Table, has no Factory Visits listed against it, so nothing happens when the FV Button is pressed.  Same for Followup Button.

20/03/2015

Menasche Scharf

Ask FileMaker -the dragging in the Script List Dialog Box should allow interrupted scrolling; at the moment, you can only drag the full heigth of the Dialog Box, which requires the User to start and stop dragging, after moving the Slider one 'page' at a time.

30/04/2015

Menasche Scharf

Remember: Either do not block user abort or include an end loop if. The latter is extremely important if you run the script on the server.

See: https://community.filemaker.com/thread/83693