FileMaker Pro Resources: June 2015

Tuesday, June 23, 2015

Generate / Create a Captcha image

How to: Captcha

Date: 02/06/2015

Problem: Is there a way to create, monitor and handle captcha in FileMaker?

Is this possible with FileMaker?

=== Connect FileMaker to external Information Sources ===

Requirements for external / Remote Access: LogMeIn, PCAnywhere, Skype (See: [ccxlv] for an AppleScript(?!) based solution) and TeamViewer, MySQL - http://softuninstall.com/uninstall-filemaker-skype-plug-in.html

The Calendar should be able to export a range of dates – say to provide a Mashgiach with his monthly schedule – to an external application, ideally .ics format. http://hbase.net/2014/05/16/exporting-calendar-files-ics-from-filemaker-pro-13/

Request to receive authorisation for the developer (or myself) to talk directly to Sage (and eventually PS Financials) and to KID and UKD, with the purpose of obtaining from them guidance how to create a live feed to/from FileMaker Pro v12.

http://www.mbsplugins.eu/component_CURL.shtml

====== New Field Management System in FileMaker Pro ======

====== New Field Management System in FileMaker Pro ======
Developer: Write your name at the bottom of every page that you have finished implementing into the new FM System, so that we can concentrate on the ones that haven't been finished yet.

Location / Mapping / Routing / Directions

=== Connect FileMaker to external Information Sources ===
GPS / Sat-nav, Traffic Updates, GIS / Mapping, Geo-Location Based Data or GeoData, Proximity, Location, Directions, Nearest, Camera Data, SIM Data, Wi-Fi, Formz, Pen Input, Wap, eMail http://www.google.com/gwt/n?u=http%3A%2F%2Fwww.highways.gov.uk%2Fbusiness%2F13596.aspx

Every Record in the Contact Management Module should have a Location Map

For advanced mapping try gmap3, however this shouldn’t be confused with Google Map Maker – a tool for cartographers. Although, on reflection this may help us when planning trips for Mashgichim or in marketing to demonstrate the spread of our clients across the globe

Geocoding and Mapping Module for FileMaker Pro: http://msnmedia.com/blog/2015/04/10/geocoding-and-mapping-module-filemaker-pro

Add a Latitude and a Longitude Field so that the Mapping Function should be controllable (i.e."&ll=26.004184,-80.185776").

See also: http://msnmedia.com/blog/2015/04/10/geocoding-and-mapping-module-filemaker-pro

====== Geographic ======

(see: Latitude/longitude FileMaker Pro plug-in. LatitudeZERO brings the geographical world of latitude and longitude coordinates into FileMaker Pro with our LatitudeZERO plug-in. Use LatitudeZERO to: Calculate the distance between two ZIP codes Calculate the distance between coordinates Return results in miles, kilometers or nautical miles Determine whether coordinates are within our outside a specified radius Convert distances from one unit of measure to another Allocate Sales Reps / Agents that live within a certain radius Sort records by distance ... and more LatitudeZERO was named after latitude zero degrees, the alternative name for the equator.

Mapping, Geographics, Route Planning: http://www.hi-voltage.com.au/latitudezero.php

====== Trigger system ======

Design the workflow based on a TRIGGER system: every action is TRIGGERED by a Customer Request, which TRIGGERS a job creation which TRIGGERS a follow up which TRIGGERS a check up by [[Quality Control Department|quality control]] to make sure the case is closed ASAP

===== Maps, Plans and Drawings, Directions, Positioning =====

Needed for #Metering Advice #Our Location - Directions

All aspects of location related issues (Maps, Directions, Postcodes etc.) should also be implemented in the contacts file (we need to know how to get to a meeting with Customers, Suppliers etc. - just as the engineers for Tenants)

We need someone to help us build a description of what we want, need, or don't want, need.

The person should help us:

- set up on-line collaboration

- bounce off ideas

- suggest technologies / tools

===== Conditions for Call-management System =====

===== 6. Conditions for Call-management System =====

Call-management System manages incoming and outgoing telephone calls:

1. Should be ODBC etc. compliant

2. Web and Cloud compatible

3. Skills-Based routing

4. Unified Messaging

5. Agent / Salesperson tagging - to see who is succeeding / lagging behind

6. Centrex compatible

7. Three month trial - if we are not happy with it we’ll arrange a rental payment

8. Mobile, Palm, WAP etc

9. Contacts should be able to be linked to other contacts - i.e. if our customer deals with a Housing Association, we should be able to see this contact on their address details screen.

10. Compatibility with Linux, Mac

11. Manage and Supervise the various Teams: Pre-Sales, Post-Sales, Complaints etc.

12. The system should have ’’Context-sensitive smart tags" like MSWord 2000/InfoPoint/MapPoint, where a postcode entered becomes a hotlink to the Internet-based mapping system - a directions map can be generated at the click of the link.
Idea: Move the Directions Field to the Jobs File, place it next to the Map URL Field and delete all Maps that we pasted in from Royal Mail's Postcode Finder.

13. The Database should have a web based customer satisfaction survey similar to Customer Satisfaction Survey - See: http://www.surveymonkey.com/Home_Videos.aspx

14. TxT from within ordering system directly to engineer’s mobile

15. Enable users to follow progress of calls / cases history online

16. Screen popping when someone calls in, with ID so that the Shadchan knows who’s calling

17.

18.

19.

20.

21.

22.

23.

24.

25.

===== To keep track of Properties =====

===== 5. To keep track of Properties =====

===== To keep track of Time =====

===== 4. To keep track of Time =====

===== To keep track of Engineers =====

===== 3. To keep track of Engineers =====
* Need Report with a listing of jobs for each engineer
* If an engineer no longer works with us, his name should not appear in the available engineers list although his details should still be in the system for history.

===== To keep track of Queries =====

Feature:

If a reminder is snoozed more than three times, escalate it to a higher priority level, increase the fornt size and change the colour intensity with each reoccurrence then show alert message like: "It seems you need to do this but cannot find the time, why not delegate this to a colleague or find overtime?"

Instead of tackling a project head on for as long as it takes, allocate time-slots of an hour or less so that you know that for the next couple of days you're going to work on it in piecemeal fashion
This way you have time for smaller things or things that have been waiting a long time.
If operator fails to react, escalate it automatically to line manager/s.
Organiser

Calendar

PIM (=Personal Information Manager)

Date: 24/09/2009
RFC #:168
Does the reminder feature in the Job Diary on the Products Ordered Layout work already?

====== IT Capital Development Programme ======

Operations Management
- Accounting- legislation
- Decision Making
- Marketing
- Prospecting
- Drill-down reporting
- Individual and Team performance
- KPI (=Key Performance Indicators)

- intuitive user interface
- point-and-click configuration
- Easy creation of forms, reports and alerts
- Add a Notice, Add a Diary Event, Add an Item, Add an Person, Add an Property, Add an Job,
- Content Management Systems (CMS) - online survey - marketing strategy Some of the features we are looking for

====== Order forms ======

Order forms to be kept free of pricing details Order form should state whether it’s a Housing Association property - in which case a Servicing MUST be carried out -

===== FileMaker Developer Tools =====

http://filemaker.co.uk/technet/dev_license.html‎

http://www.eweek.com/c/a/Database/FileMaker-9-Bulks-Up-without-Adding-Complexity/

http://www.seedcode.com/cp-app/splash/1?gclid=COzX79H_7p0CFZoU4wodpkn0Lg - integrate sophisticated functions

http://www.clevelandconsulting.com/ - Offering FileMaker Pro based calendars, gantt charts and templates.

http://www.x2max.com/en/home/home.php - Offering FileMaker Pro based calendars, gantt charts and templates.

http://www.datadesigns.com/ - Makers of software that allows faxing from FileMaker and emailing of FileMaker Pro layouts.

http://www.mtn-db.com/ - Offering address book templates for FileMaker Pro.

Free Download of SQL Kit, when downloading a Demo version of FileMaker Pro - the same for Microsoft Office Optimiser Kit from FileMaker and Excel Kit

Sample application http://www.mmconnection.com/

http://simoncpage.co.uk/blog/category/software/filemaker/

http://www.data4life.net/

http://pastebin.com/search?cx=partner-pub-3281640380846080%3Arwgn88wz7bt&cof=FORID%3A10&ie=ISO-8859-1&q=filemaker&siteurl=pastebin.com%2Fm1f2c3d73#1041
http://www.dwaynewright.com/solutions.html - InBizness Money Layouts, Solutions, Templates, etc.

===== Download Utilities etc. =====

===== Download Utilities etc. =====
[http://www.top4download.com/software-search.html?keywords=%22flip%22+vertical+filemaker+-scroll+-scrolling http://www.top4download.com/software-search.html?keywords=%22flip%22+vertical+filemaker+-scroll+-scrolling]

===== Cimbura =====

[http://www.cimbura.com/tech/developmentprocess.php http://www.cimbura.com/tech/developmentprocess.php] [http://www.cimbura.com/tech/wordpresstech/index.php/category/database-consultant/ http://www.cimbura.com/tech/wordpresstech/index.php/category/database-consultant/]

[http://www.cimbura.com/tech/fmIgnite.php http://www.cimbura.com/tech/fmIgnite.php] - Package TimeWyze like theirs

FileMaker Related Links I

===== More FileMaker related links =====

FileMaker External Links

2empowerFM Developer Assistant

Custom Web Publishing - FileMaker Filemaker - Best people known for Filemaker on Wefollow Interview Questions and Multiple Choice Questions and Answers FileMaker | LinkedIn Filemaker News - Timeline | Facebook Clarify • Portaal Dracoventions Products Exchange Manipulator 3.0.0.9 FileMaker Business Software, FileMaker CRM Software, FileMaker PRO Database design for Mac and Windows FileMaker Calendar on Android « SeedCode: Next FileMaker developers for hire | Decent Business Systems FileMaker Development Company | Filemaker Developer (314) 353-4300 ‎| Application and Software Development | FileMaker Developers | FileMaker Training | IT and Filemaker Consulting Services | Skeleton Key Filemaker Info | Scoop.it filemaker israel Contractors, Freelancers | Elance FileMaker Resources - Applications, Plug-ins, Custom Functions filemakerhacks | About FindFileMakerDevelopers.com - Your first stop to finding and being found! FMDiff compares FileMaker Files, Clones, and Backups FMDroid - FileMaker Access from an Android app FrameReady Features - Choose a Version Home | Proof HomeBase Software | Downloads Kevin Frank and Associates - Demo Files - FileMaker 8-9 Matthew Leering | CoreSolutions Software Inc. Monkeybread Software - MBS Filemaker Plugin 3.2 Planning a FileMaker Solution | Building FileMaker Solutions | InformIT PLUGINS Downloads | ZDNet Sign-Up For FindFileMakerDevelopers.com and Begin To Be Found Choose your plan ! | BH-A FileMaker Hosting SUI Solutions. FileMaker Templates. Professional Software Development for FileMaker. The FileMakers Troi File Plugin - File Manipulation - FileMaker Plugins Watch the Online Video Course FileMaker Pro 12 in Depth Welcome to Ditronic The Database Specialists. - UK FileMaker Consultancy and FileMaker Developers Welcome to Eikonsys www.bitterendsystems.com/7v5releasenotes.pdf www.longtermsolutions.com/pricing.php WordPress, 4th dimension and FileMaker http://www.christensendesign.net/

===== User Groups =====

===== Google Groups =====
Google Groups: comp.databases.filemaker - techniques for deleting records? *http://groups.google.com/group/comp.databases.filemaker/browse_frm/thread/46d8a9da1ae4010b/9307c9e6c5d832cc?hl=en&lnk=gst&q=%22techniques+for%22+%22deleting+records%22#9307c9e6c5d832cc.

agisllc.com *agis products : FileMaker business management software + web calendar

http://my.safaribooksonline.com/9780596800604 FileMaker Pro 9: The Missing Manual, 1st Edition

http://www.magentocommerce.com/search/results/?q=filemaker FileMaker and Magento:

22/06/2015

Menasche Scharf

Training

See: https://youtu.be/m65YtvS9ydA

22/06/2015

Menasche Scharf

FileMaker Google Group

See: https://groups.google.com/forum/#!forum/fmstandards

10/07/2015

Menasche Scharf

Chat with FileMaker Technical Support

See: http://help.filemaker.com/app/chat/chat_launch

10/07/2015

Menasche Scharf

FileMaker TechNet: Here at Customer Support we offer unlimited telephone and email, sample software, white papers and many other resources, search for a local consultant specializing in training or development on our website. If you have any questions, please contact Customer Support on: 0845 603 9100 (United Kingdom) Monday-Friday 9:00 a.m. – 5:00 p.m. (excluding holidays).

See: https://community.filemaker.com/welcome

10/07/2015

Menasche Scharf

How FileMaker

See: https://community.filemaker.com/community/resources

===== FileMaker Knowledge Base‎ =====

===== FileMaker Knowledge Base:‎ =====

*http://www.linearblue.com/theclick.php

Email Directly From FileMaker Pro 6.0 Without Plug-ins

*Support for Sending Mail via an SMTP Server vs. an Email Client

*White Paper: How to take advantage of new server model and capabilities

*http://www.filemaker.com/ten/resources/index.html#0

*[http://www.filemaker.com/support/downloads/

For additional answers, we invite you to search the FileMaker Knowledge Base

http://filemaker.custhelp.com/>

or you may also visit our Forums

http://www.filemaker.com/support/forums.html

where you may search for an ‎answer, post a question, share information or provide answers for other users ‎in the FileMaker Community. ‎

FileMaker Scripts - Part I

====== Scripts ======

http://fmpscripting.blogspot.com/search?q=ontimer OnTimer Script

http://filemakerdesign.com/expression

FmPro Script Diff 1.38

- http://www.download3k.com/Software-Development/Editors-Tools/Download-FmPro-Script-Diff.html

- http://fmdiff.com/fm/cleantext.html

http://www.runaware.com/launch/run?c_app_id=7384&refid=3501&width=1024&height=738&scrb=no

Copy ideas from this runtime into the Field Maintenance Management System (or POM (=Peace Of Mind)) http://www.filemakertrial.com/nskto/form/entry.aspx?ovmkt=O5M3PJVLTCEPR8MHDMOA1AN1TC

http://filemakertoday.com/com/showthread.php?4536-Deny-Record-Access/page3‎

Would it be possible to set FileMaker up so that when it starts up it opens up our file directly?

Would it be possible to set FileMaker up to start up differently for every user? Create a Script "Startup_Routine_Personalised_01" to achieve this.

26/11/2013

Menasche Scharf

Ask FileMaker How do you Script the ScripTrigger OnTabEntry to Find only those Records that are ticked off as “Prospective_Client”?

14/09/2016

Did you know about the function “GetNthRecord”?‎

https://books.google.co.uk/books?id=L3qfayrqJ1oC&pg=PA430&lpg=PA430#v=onepage&q&f=false

12/03/2013

Menasche Scharf

All “Go To Layout” Scripts should be replaced with a Script that includes a “Enter Browse Mode”, which will ensure the User is taken to the database and not to the Find Layout in the destination Layout.

====== Books & Training on FileMaker Pro ======

====== Books and Training on FileMaker Pro ======
*Safari Books publish quote a selection of FileMaker related books, you can even read excerpts

http://my.safaribooksonline.com/search?searchtextbox=filemaker&searchmode=simple&searchview=summary&searchfor=SearchForAllBooks&searchlistbox=&isbn= HERE].

* http://www.amazon.com/FileMaker-Pro-Bible-Ray-Cologon/dp/0470429003

*html
http://www.vtc.com/products/FileMaker-Pro-10-Advanced-Tutorials.htm

* http://www.vtccanada.com/can/titles/filemaker-pro-10-beginner.]

* Jens Rasmussen : FileMaker 9 Certified Developer

====== Setting up a Hierarchical tree ======

A Hierarchical tree is sort of a springboard for making an interface that lets users zip through their work.

Other definitions for the above: “tree-like structure” or "tree view" or intuitive 'drill-down' interface for your hierarchical tree of values or Accordion like fold-out list or

See: https://www.google.co.uk/search?sclient=psy-ab&safe=active&biw=1280&bih=895&noj=1&q=%22fileMaker%22+%22Hierarchical+tree%22+-Oracle+-Netscape+-asp+-ODBC+-activex+-menasche+-Android+-object+-McAfee&oq=%22fileMaker%22+%22Hierarchical+tree%22+-Oracle+-Netscape+-asp+-ODBC+-activex+-menasche+-Android+-object+-McAfee&gs_l=serp.3...6792.7287.1.7751.3.3.0.0.0.0.0.0..0.0....0...1c.1.64.serp..3.0.0.1W6HKL65BHQ

====== Have Vertical List (as in List View) of Contacts inside a Form View ======

====== Have Vertical List (as in List View) of Contacts inside a Form View ====== *[http://fmforums.com/forum/showtopic.php?tid/192492/post/277990/#277990‎ http://fmforums.com/forum/showtopic.php?tid/192492/post/277990/#277990‎]

===== Managing Relationships in Tables etc. =====

===== Managing Relationships in Tables etc. =====
http://filemakerterm.blogspot.com/

Relationships between Records / Record Sets:

Q. Should a Landlord/Company be given a absolute Company-Type value only, or should you be able to give it a Company-Type in relation to it’s association to another company.

In short: should a company be able to be one type in relation to one company and another type in relation to another company?

A. Any Record should have be able to associate to many Relationships.

Example: A Letting Agent Record is associated with a:
- Property Record (Letting Agent->Property), whilst also being associated with a
- Managing Agent (Letting Agent->Managing Agent), at the same time as being associated with a
- Owner (Letting Agent->Owner),
- Housing Association (Letting Agent->Housing Association) and
- Local Authority (Letting Agent->Local Authority) or even
- another Letting Agent (Letting Agent->Letting Agent).

====== Redirect eMails ======

====== Redirect eMails ======
Redirect all eMails arriving from eShop into info@propertysafety.co.uk *CORGI to david.h *NICEIC to merlin.n *EPC / HIP to hip *POM to pom *

Bikur Cholim בקור חולים

Tuesday, June 23, 2015

FileMaker External Links