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?
Friday, January 27, 2017
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
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.
Subscribe to:
Posts (Atom)