Bikur Cholim בקור חולים

Friday, January 27, 2017

Save a Record by Print to PDF

27/01/2017
MS
Ask FileMaker

How do I Save a Record by Print to PDF?
I want to create a separate PDF of each record in the current Find.

How do I set as Default the setting "Save: Current Record" in the Save Records As PDF Dialogue Box?


Thursday, January 19, 2017

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

FileMaker Scripts - Part III

13/02/2013
Menasche Scharf
Ask FileMaker how to do this: New Drop Down Menu in the Certificate_Table: KC Layout List. 
First create a hidden field, connect to this Value list and Script it OnFieldExit goto the identical Value=Layout name? 
See: https://www.google.co.uk/webhp?sourceid=chrome-instant&ion=1&ie=UTF-8#hl=en&q=%22filemaker%22+%22value+list%22+%22pop-up%22+%22button%22+%22layouts%22+-Papillon+-portal+-%22Show+Values+Only+From+Second+Field%22+-keyboard+-radio+-iwp+-%22Type+ahead%22+-drop+-nih+-odbc+-FERO+&safe=active
See: http://www.experts-exchange.com/Software/Apple_Software/Filemaker_Pro/Q_28270887.html

15/02/2013
Menasche Scharf
Ask FileMaker why there is no Enter Layout Mode Script Step? Possibly because there are Scripts Steps that allow you to do many Layout Functions, which will enter and exit Layout Mode for you, obviating the need to Enter Layout Mode(?) 
See: https://pauseonerror.pbworks.com/w/page/14902736/Parameter%20Pandamonium, for a list of Custom Functions, which may also help in other areas of FileMaker Development
See: https://pauseonerror.pbworks.com/w/page/21109112/Typed%20Dictionnary

25/02/2013
Menasche Scharf
How can you see on a Script, which Objects/Fields it is connected to? Like you can see on a Field which Script is tethered to it, we also need to reverse.

24/04/2013
Menasche Scharf
Ask FileMaker - As the FileMaker Layout workspace is so large, perhaps we should have all main Layouts in one Layout and the Navigation Buttons should lead the user to another point in the same Layout?  
Scripts can be written to navigate around the various Tables, by bringing them in focus of the screen, as and when required.

12/12/2013
Menasche Scharf
Ask FileMaker how to see the last results of the last action in the database. 
Say I pressed the Delete Button that invokes the DeletePortalRow Script but nothing happens in the Layout or Portal where it is placed. 
Maybe this Script deleted a Record elsewhere in the Database? 
It would therefore be nice to be able to see somewhere what are the last changes to the database (Check TimeWyze how the delete Button works in the diary portal).

16/01/2014
Menasche Scharf
Ask FileMaker ("filemaker" -php -calcul* -dates -tool -script -find* -license -relat* -butt* -index -ical -prin* -data -searc* -remote –key)

Monday, January 16, 2017

How to Record a Macro in FileMaker

See: https://www.google.co.uk/search?safe=active&q=%22filemaker%22%20%22create%22%20%22record%20a%20macro%22%20-newbie%20-access%20-security%20-hotfrog%20-AppleWorks%20-twiname&rct=j

Saved Finds

How to Scrip the Saved Finds
Need to find out how to capture the strings that appear in the FileMaker Saved Finds Menu Item, which will help when doing repetitive Searches.
There should be a Script that allows the user to select from a list of Saved Finds in a Drop Down Menu inside the Layout, unlike the regular list that appears under Records->Saved Finds->Recent Finds

See: https://www.google.co.uk/search?q=%22script%22+%22saved+finds%22+%22recent+finds%22+%22filemaker%22&ie=&oe=

20/01/2017
MS
Saved Finds only saves successful searches.
Request from FileMaker that they add unsuccessful searches to the Saved Finds List

Wednesday, January 4, 2017

How to run a Script before the File launches

04/02/2013

Menasche Scharf

Ask FileMaker: How to run a Script before the File opens up? 

For example, I want to enter Username and Password automatically, so the User doesn’t have to do this every time they open a file. 

As soon as you set password(s), FMP starts up with a password dialog. 

To prevent this you can automatically fill in (populate) a specified password in the document settings.

No dialog box appears.

If you want to log in with the non-standard password, you have to hold SHIFT (Win) or ALT (MAC) during opening the file.

The password-dialog-box will appear.