Bikur Cholim בקור חולים

Wednesday, March 15, 2017

Ask FileMaker - Part XIV

Date:  11/11/2009
RFC #  242
There is no Discount feature in the Order Form - why?
Date:  11/11/2009
RFC #  243
We need a Filed for Areas, this will help us categorise engineers and it will also help us with Marketing
Date:  11/11/2009
RFC #  244
The Bill To Copy Function doesn't work properly: It copied ID : 25407 instead of ID: 25406 in Order ID. 23256
Date:  12/11/2009
RFC #  245
The Tab Order in the Job to Engineer Tab in the Products Ordered Layout needs changing
Date:  12/11/2009
RFC #  246
The Address Type Drop Down Menu shouldn't open in the main Layout, only in the Editing Window
Date:  12/11/2009
RFC #  247
In the Quote for Job Layout, can you make a selection: "Passed ON", meaning that we gave the entire job to the engineer and we will charge a commission to him?
Date:  12/11/2009
RFC #  248
In the Quote for Job Layout, where do I put the name of the engineer that we requested a Quote from?
Date:  13/11/2009
RFC #  249
We need to log hours for workers, how much they earned and how much we owe them
Date:  15/11/2009
RFC #  250
When closing an unfinished Order, a warning comes up: You havent's enetered (notice the spelling mistake) a Customer for this job, press OK etc. The moment I press OK, it should page back to the page where I can enter the customer.
Date:  16/11/2009
RFC #  251
The Preferred Payment Method should also include: Deduct from Commission and Mixed (Cash & Cheques)
Date:  17/11/2009
RFC #  254

When entering a quote, the Job should also be tagged automtically

Ask FileMaker - Part XIII

Date:  03/11/2009
RFC #  228
Create Templates to create standard letters (Example: MPAN_Authority, CORGI Reminder etc.)
Date:  03/11/2009
RFC #  229
Can we have the Address Records expand Abbreviations like : Rd = Road, Ave = Avenue, St = Street etc.?
Date:  03/11/2009
RFC #  230
For every Job there should be a Tab for Stakeholders / third party - for those contacts that are not related to the Tenant, Property, Landlord or Engineer - only to the Job in itself (Example: Local Authority Enforcement Agency who chase the Landlord as they need to install a new boiler, Plumbin Merchant To Advise on which Boiler to buy, Neighbour to facilitate access etc.)
Date:  09/11/2009
RFC #  232
The Entries in the Quote Layout should be incorporated into the Job Diary. This means that the Fields representing Dates, Times, Notes etc. should really be the same Fields from the Job Diary, only that they are displayed inside the Quote Portal.
Date:  09/11/2009
RFC #  233
There should be Up / Down Buttons in the Company / Staff Tab, so that I can associate who is the Main COntact - if there are two companies associated with one peron (Example: David Hager)
Date:  09/11/2009
RFC #  234
The "Copy for Engineer" Button doesn't work
Date:  10/11/2009
RFC #  235
Please place a "Go To Last Record" Button on every Layout
Date:  10/11/2009
RFC #  236
Can you allocate the Ctrl+N Key Combination to open up the New Contact Window in the Contacts Layout? (I tried filemaker ctrl change "key combination" -mac -passwords -browser -ibm in Google, nothing on the first page)
Date:  10/11/2009
RFC #  237
Tip to display the symbols: Try the Font "Lucida Grande "
Date:  10/11/2009
RFC #  238
Eventually we should be able to see a diary of every engineer: what he is doing, where and what slots are free etc.
Date:  10/11/2009
RFC #  239
Please sort out the Search without Spaces in Telephone Numbers, for data entered with a Paste Command
Date:  11/11/2009
RFC #  240
There should be a Copy Engineer Details in the Products Ordered Page in the Edit Order (and New Order) Window, like Copy Job Address and Copy Landlord
Date:  11/11/2009
RFC #  241

The Date Field in the Jobs DIary is too narrow, Wed & Mon don't show the dates

Ask FileMaker - Part XII

17/07/2014
Menasche Scharf
Ask FileMaker to add one more “Mode” to the three existing ones (Browse/Find/Layout): Data Entry.  This will solve so many problems with end users ‘destroying’ the work of the Data Entry clerks etc., which has bugged FileMaker Pro users from day one.
31/07/2014
Menasche Scharf
The Associated_Companies Tab should be the default one, when the Find brings up results that include Records of people (=Associated_Persons) rather than companies (=31/07/2014
31/07/2014
Menasche Scharf
The Associated_Companies), so that the User can immediately see which company this “person” belongs to.
21/11/2014
Menasche Scharf
Ask FileMaker: What is required for FileMaker Pro v12 client, served on a FileMaker Pro Server v12 in order that it should be able to dial-to-connect via the Avaya Office Pro console on Windows?
23/03/2015
Menasche Scharf
Allow the Field Picker to be enlarged and the columns widened
28/05/2015
Menasche Scharf
Ask FileMaker: How to write a formula / function that polls all Fields in a database (NOT the individual Records - only the FIELDS), to see whether they are being used at all or not.  This will help when trying to tidy up a databse by deleting unnecessary Fields - as we have with the Main_Menu file, where the total of unused Fields reaches nearly 200(!).
23/06/2015
Menasche Scharf
FileMaker Training: FM Starting Point 4.5 - RELEASED - for FM14
10/09/2015
Menasche Scharf
Ask FileMaker: Why is it that when I save a link with an answer from FileMaker, the link doesn't work a year later?
Date:  02/11/2009
RFC #  223
The list that appears when trying to Associate a Record toi an existing one should not show the Records that are : a) The Record itself and b) The Records that are already Associated to this Record (example EDF)
Date:  02/11/2009
RFC #  224
The Ctrl+2 combination should also work in ALL other Layouts: instead of popping up the Find Tel/eMail Window, it should first switch to the Contacts Layout and then pop the Window
Date:  02/11/2009
RFC #  225
Add an "Add" Button and rename the "Add" Button to "Associate", as this will allow a new Contact to be added on the fly, when adding a new Company Record which also needs a new Employee Record and vice versa
Date:  02/11/2009
RFC #  226

When there is only one Record found in the Find Address (or Tel/eMail) Window, the Focus should automatically go onto the Close Button so that when the Enter Button on the keyboard is pressed twice (once for Find and then for Close) the Window should close and go to the singel Record

Ask FileMaker - Part XI

23/08/2013
Menasche Scharf
Ask FileMaker: 12-02-2008, 10:22 AM how can I have the cursor start in a specific field in the header as default when using find mode?  The cursor goes to the first field in the Body, even though the tab order starts with the Field in the Header, for which entry in find mode is allowed.
12/09/2013
Menasche Scharf
Ask FileMaker how to keep the database footprint small, by using the Same Field in different Tables, instead of creating new Fields with identical names?  For example, Date Entered (or Drawn) could be the same in Ingredients_Table as in Formulations_Table – unless it will disturb the sorting or other functions?
23/10/2013
Menasche Scharf
Ask FileMaker which option is better: To place the Unique_ID Filed in the Destination Table, with the data coming from the Source Table - so that the Unique_ID appears on the Destination Table, using a Relationship, or to create a new Field also called Unique_ID in the Destination Table, but then the Record will only become a Related Record when it is populated with an ID that matches the contents of a Unique_ID Record in the Source Table?
06/03/2014 17:52
Menasche Scharf
Ask FileMaker How to manage data
06/03/2014 17:52
Menasche Scharf
Ask FileMaker How to create Data tables to store data
06/03/2014 17:52
Menasche Scharf
Ask FileMaker How to create Dialogue boxes to enter data, assistance for installation, launch, reinstallation and bug reporting
06/03/2014 17:52
Menasche Scharf
Ask FileMaker How to create an alert when the developer creates a new field that already exists somewhere in the same solution although it's not in the same table.
14/05/2014
Menasche Scharf
Ask FileMaker if it is possible to have Conditional Tabbing, based on the contents of the Clipboard: If I copied text that contains the ‘@’ symbol, then when I press the Tab key it should go to the eMail address Field.  Likewise if the Clipboard contains digits (numbers, figures) it should jump to the Telephone Number Field next, instead of going to the regular Next Tabbed Field.
14/05/2014
Menasche Scharf
Ask FileMaker how to arrange the Focus to be in the Field that has the text being searched, when pressing the Ctrl+R Key Combination to change the search string.
16/05/2014
Menasche Scharf
How to deal with a situation, where a user changed the wrong record?  Roll back to previous backed up version?  This would mean losing all the new (and CORRECT!) data that was added in the interim.
30/05/2014
Menasche Scharf

Ask FileMaker to introduce the feature of sub-Folders in the Manage Database Combox, like they have done in the Layouts Combox: it allows the grouping of similar type (or similar Function) Layouts into a Folder that can be expanded or closed to hide the many Layouts.

Tuesday, March 7, 2017

Layout Questions - Part II

09/07/2015
Menasche Scharf
Would it help speed up the ysstem if I strip out any fields in tables where they aren't needed?
When a client requests a record from the server, the entire record downloads, even if only a single field is shown on the layout. 
More fields, more data, longer download time?

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

Layout Questions - Part I

15/02/2013
Menasche Scharf
Ask FileMaker How to arrange a Watermark in Layouts - See: http://fmforums.com/forum/topic/33588-watermark/


22/04/2013
Menasche Scharf

Ask FileMaker - How do I set the “Tab Distance” in a Checkbox Box, so when two boxes with Check Boxes are one on top of each other (like in the Kashrus Contacts Table), the names in the list are nicely aligned See: http://www.experts-exchange.com/Software/Apple_Software/Filemaker_Pro/Q_28096476.html

11/11/2013
Menasche Scharf
Limitations to the Map includes “Haversine distance between points - The Haversine formula will not function in FileMaker 8.5 because the 'Asin' function is not available.
This limits the ability to perform radius searches and 'route optimizations' based on distance between points” See: http://docs.proofgroup.com/fmMap/en/1.0/TechnicalSpecifications#toc4

06/03/2014 17:52
Menasche Scharf
Ask FileMaker How to Join tables to display data
See: http://michaelrocharde.me/2015/06/07/what-is-a-join-table-and-when-do-you-need-one/

24/03/2014
Menasche Scharf
Ask FileMaker how to display data from two Fields as a ToolTip (in other words: is it possible to have more than one Field in the Inspector->Position->Tooltip Field?). Try the solution shown here.
See: https://fmdev.filemaker.com/message/134529#134529

04/04/2014
Menasche Scharf
Ask FileMaker how to set up the server so that it can handle email file attachments with unlimited size restrictions
See: http://www.cnsplug-ins.com/Plug-ins/smtpit_Pro, http://forums.filemaker.com/posts/95afef1651, http://www.dacons.net/fmplugins/mailit5/  

04/04/2014
Menasche Scharf
Ask FileMaker if instead of using the Sliding Left feature in Sliding & Visibility, concentrate all these functions with Conditional Formatting instead.  Much more powerful, logical and dynamic! 
See: https://community.filemaker.com/thread/83995

24/04/2014
Menasche Scharf
How to print a Field that might contain varying number of characters See: https://fmdev.filemaker.com/message/112686#112686

Tooltips

13/12/2013
Menasche Scharf
Ask FileMaker how to allow changing Tooltips, according to the data entered. 
Example: I want the explanation of the Grades to be shown as a ToolTip, as the Grade is entered: A1 “These ingredients may be sourced from any supplier/manufacturer”.
SORTED: The ToolTips do show the Field content anyway!


09/07/2014
Menasche Scharf
Ask FileMaker why the text "type one or more words, then press enter" (that appears as a tooltip in the top right hand corner when I hover over the Quick Find tool box located in the tool bar) is not to be found anywhere on the web.
See: http://help.filemaker.com/app/answers/detail/a_id/7604

18/09/2014
Menasche Scharf
Ask FileMaker How do you lengthen the time for the ToolTip to stay displayed when the user hovers over the Notes Field in the Portal Tab “Diary” in the Kashrus_Contacts_Table, so that the whole entry can be read at once, without having to move the mouse over the Field again and again, when the text disappears after 15 seconds

Layout Themes

19/05/2015
Menasche Scharf
Ask FileMaker - how was the Field Format set in the Onyx Layout Theme, so that the text is offset from the Field border?
If the padding doesn't solve the problem, report it to FileMaker

Go to the Inspector->Appearance->Advanced Graphics->Padding and reduce from 8 points to whatever you fancy…

15/05/2015
Menasche Scharf
How to create a calendar
Try Seedcode
See: https://www.youtube.com/watch?v=hDbpwg3kAw0

15/05/2015
Menasche Scharf
How to create a calendar with a multi-day view
Try DayBack
See: https://www.youtube.com/watch?v=EVObC3oTU5M

Dashboard

Date:  02/11/2009
RFC # 222
The Dashboard should also have a space to jot down ideas / opportunities, which should stay on the designated space until it has been dealt with.

Example: Customer is prepared to pay commission for those who bring new customers to his Pest Control business. 

28/05/2015
Menasche Scharf
Ask FileMaker: Half of a Page is Displayed in Dark Gray When Viewed in Layout Mode 
Script every Layout that OnLoad it should Hide Page Margins
See: http://help.filemaker.com/app/answers/detail/a_id/5566/kw/show%20%22page%20margin%22%20%22layout%20mode%22%20-dashboard


How do I center an Object in a Layout?

06/02/2013
Menasche Scharf
[Case:130206-000183]
Ask FileMaker: How do I center an Object in a Layout? How do you align an object to the center of the page?
Answer: Lock an object exactly in the middle of the page, which will prevent it from moving along with other objects.  Possible answer: “you’ve wished you could put the thing in the middle of the window.
Unfortunately, since you don’t know how big the window will be, you can’t.  It isn’t entirely obvious at first, but with autoresize in FileMaker 9, you can.
If you turn off all the anchors, FileMaker splits the difference as a window resizes.
If it gets 100 pixels wider, the object moves 50 pixels, so that half the new space is on one side, and half is on the other. 
So an object that is centered on the layout in layout mode, and has no anchors, will be centered on any size window”.

http://help.filemaker.com/app/answers/detail/a_id/5427

http://sixfriedrice.com/wp/filemaker-9-tip3-get-the-most-from-autoresize/
https://www.google.co.uk/search?q=filemaker+How+do+you+align+an+object+to+the+center+of+the+page
Or google: "align" "graphic" in "middle" of the "screen" "filemaker" -Quick "splash screen" "Kiosk" -"FileMaker Pro"