Planet FileMaker, Forums
... helping to feed the FileMakers ...
Contact | Random URL | FM Help Daily | Home
July 30, 2010
FileMaker Café
Would like opinion using instant web publishing vs remote open
Forum: FileMaker Pro 11
Posted By: ScottJ
Post Time: 07-30-2010 at 11:47 AM
Email Marketing
Forum: FileMaker and E-mail
Posted By: comfish
Post Time: 07-30-2010 at 10:54 AM
Trash: "Recovered files" folder
Forum: FileMaker Pro Versions 5 & 6
Posted By: mfggt
Post Time: 07-30-2010 at 10:23 AM
Need to validate whether a person has certifcations to perfom a task
Forum: FileMaker Pro 11
Posted By: ScottJ
Post Time: 07-30-2010 at 05:01 AM
Google Groups: FileMaker
Re: Displaying related tables.
I think portals works great for printing invoices. If you know that
you sometimes have more line items that fits in the portal, you can
have a script that switches to a long version of line items on a
second page. If you have extremely many line items that you want to
invoice then you should go for the non portal solution, in my opinion.
you sometimes have more line items that fits in the portal, you can
have a script that switches to a long version of line items on a
second page. If you have extremely many line items that you want to
invoice then you should go for the non portal solution, in my opinion.
by Nicolay (nicolay.flaa...@gmail.com) at July 30, 2010 09:30 AM
FileMaker Café
MaxLength ( field, foundCnt )
Forum: FileMaker Custom Functions
Posted By: barry
Post Time: 07-29-2010 at 06:51 PM
July 29, 2010
SeedCode Support Forums
SeedCode Calendar :: RE: Complete: How to go about planning my imports?
Author: jimrecht
Posted: Thu Jul 29, 2010 10:34 am (GMT -9)
Topic Replies: 2
Thank you John: your reply is super-helpful as usual!
Posted: Thu Jul 29, 2010 10:34 am (GMT -9)
Topic Replies: 2
Thank you John: your reply is super-helpful as usual!
General Support :: RE: Need a New Forum for Complete
Author: John Sindelar
Posted: Thu Jul 29, 2010 10:02 am (GMT -9)
Topic Replies: 1
I'm still on the fence about a new forum; but I hear you. As for the Quick Find, there is no way for a developer to add or remove that for you, sadly. If you don't see it, just tight-click on the tool bar and select "Customize Toolbar..."
_________________
John Sindelar
SeedCode LLC
Posted: Thu Jul 29, 2010 10:02 am (GMT -9)
Topic Replies: 1
I'm still on the fence about a new forum; but I hear you. As for the Quick Find, there is no way for a developer to add or remove that for you, sadly. If you don't see it, just tight-click on the tool bar and select "Customize Toolbar..."
_________________
John Sindelar
SeedCode LLC
SeedCode Calendar :: RE: Speed up month to month
Author: kaostika
Posted: Thu Jul 29, 2010 7:16 am (GMT -9)
Topic Replies: 5
HI, it took 19 seconds to switch months. There are no index fields. There are about 3000 records it is looking thru. Does it prefilter before it goes to each month?
Oreste
Posted: Thu Jul 29, 2010 7:16 am (GMT -9)
Topic Replies: 5
HI, it took 19 seconds to switch months. There are no index fields. There are about 3000 records it is looking thru. Does it prefilter before it goes to each month?
Oreste
SeedCode Calendar :: RE: Complete: How to go about planning my imports?
Author: John Sindelar
Posted: Thu Jul 29, 2010 6:55 am (GMT -9)
Topic Replies: 2
Hey Jim,
We have some notes about importing your contacts here: http://www.seedcode.com/pmwiki/pmwiki.php?n=SeedCodeComplete2.ImportingContacts
But since your solution is specific to what you've build, I don't think you'll find much in our docs about how to add your existing features, layouts etc to Complete. You just have a lot of work ahead of you.
I can give you some guidelines though that we use when moving big features from one solution to another. It's all about the order you do things. So let's say you have a layout or part of a layout you want to move from one file to another...
- Begin by adding the layout's table to the new file if it isn't there already. Most of your big tables will already be in Complete (Contacts, Invoices) but they'll have different fields.
- Then relate that tables to others on the graph and clean up and calcs that were commented out when you imported the table in (or pasted fields in)
- Then add any value lists the layout or its scripts may need. Same with custom functions.
- Now create a new blank layout for this layout, giving it the correct name and basing it on the right table.
- Paste or import any scripts the layout uses into the new file (everything you've done so far is to make sure that script find everything it needs when it arrives and does so without error).
- Finally you paste the layout contents into the new layout: again, those fields and buttons should find the fields and scripts they're looking for. The whole trick is to first create the objects subsequently imported objects will want to find when they arrive.
As you can tell, it is more of an art than a science and we do offer consulting if you'd like to know more.
Hope that helps,
John
_________________
John Sindelar
SeedCode LLC
Posted: Thu Jul 29, 2010 6:55 am (GMT -9)
Topic Replies: 2
Hey Jim,
We have some notes about importing your contacts here: http://www.seedcode.com/pmwiki/pmwiki.php?n=SeedCodeComplete2.ImportingContacts
But since your solution is specific to what you've build, I don't think you'll find much in our docs about how to add your existing features, layouts etc to Complete. You just have a lot of work ahead of you.
I can give you some guidelines though that we use when moving big features from one solution to another. It's all about the order you do things. So let's say you have a layout or part of a layout you want to move from one file to another...
- Begin by adding the layout's table to the new file if it isn't there already. Most of your big tables will already be in Complete (Contacts, Invoices) but they'll have different fields.
- Then relate that tables to others on the graph and clean up and calcs that were commented out when you imported the table in (or pasted fields in)
- Then add any value lists the layout or its scripts may need. Same with custom functions.
- Now create a new blank layout for this layout, giving it the correct name and basing it on the right table.
- Paste or import any scripts the layout uses into the new file (everything you've done so far is to make sure that script find everything it needs when it arrives and does so without error).
- Finally you paste the layout contents into the new layout: again, those fields and buttons should find the fields and scripts they're looking for. The whole trick is to first create the objects subsequently imported objects will want to find when they arrive.
As you can tell, it is more of an art than a science and we do offer consulting if you'd like to know more.
Hope that helps,
John
_________________
John Sindelar
SeedCode LLC
SeedCode Calendar :: RE: Calendar Complete Upgrade
Author: John Sindelar
Posted: Thu Jul 29, 2010 6:32 am (GMT -9)
Topic Replies: 1
It is $119 and you can find that link here: http://www.seedcode.com/cp-app/ste_cat/upgradetocomplete11
_________________
John Sindelar
SeedCode LLC
Posted: Thu Jul 29, 2010 6:32 am (GMT -9)
Topic Replies: 1
It is $119 and you can find that link here: http://www.seedcode.com/cp-app/ste_cat/upgradetocomplete11
_________________
John Sindelar
SeedCode LLC
FileMaker Wikipedia Revision History
Ida Shaw: External links, caps
External links, caps
| ← Previous revision | Revision as of 12:10, 29 July 2010 | ||
| Line 36: | Line 36: | ||
| url = http://www.dancing-data.com/filemakerhist.html |
| url = http://www.dancing-data.com/filemakerhist.html |
||
| date = 2 April 2004 |
| date = 2 April 2004 |
||
| - |
| accessdate = 2007-10-05}}</ref> <ref>http://www.briandunning.com/browse/browse0399.shtml Nashoba Systems and the Early Days of FileMaker Pro</ref>
|
+ |
| accessdate = 2007-10-05}}</ref><ref>[http://www.briandunning.com/browse/browse0399.shtml Nashoba Systems and the Early Days of FileMaker Pro]</ref>
|
With the introduction of the Macintosh, Nashoba combined the basic data engine with a new forms-based [[graphical user interface]] (GUI), creating a program that was dramatically easier to use. Leading Edge was not interested in newer versions, preferring to remain a DOS-only vendor, and kept the Nutshell name. Nashoba found another distributor, [[Forethought (company)|Forethought Inc.]], and introduced the program on the Macintosh platform as FileMaker. When the [[Macintosh Plus]] was introduced, the next version of FileMaker was named FileMaker Plus to reflect the new model's name. |
With the introduction of the Macintosh, Nashoba combined the basic data engine with a new forms-based [[graphical user interface]] (GUI), creating a program that was dramatically easier to use. Leading Edge was not interested in newer versions, preferring to remain a DOS-only vendor, and kept the Nutshell name. Nashoba found another distributor, [[Forethought (company)|Forethought Inc.]], and introduced the program on the Macintosh platform as FileMaker. When the [[Macintosh Plus]] was introduced, the next version of FileMaker was named FileMaker Plus to reflect the new model's name. |
||
| Line 75: | Line 75: | ||
{| class="wikitable" style="margin: 1em auto 1em auto" |
{| class="wikitable" style="margin: 1em auto 1em auto" |
||
|+ FileMaker Versions |
|+ FileMaker Versions |
||
| - |
! Date !! Version (1-6) !! Published by !! Comment <ref>http://lowendmac.com/software/f/filemaker.html Mike Weber, The Low End Mac, FileMaker History</ref>
|
+ |
! Date !! Version (1-6) !! Published by !! Comment <ref>[http://lowendmac.com/software/f/filemaker.html Mike Weber, The Low End Mac, FileMaker History]</ref>
|
|- |
|- |
||
| 1985-04 || FileMaker, v1.0 || rowspan="2" | Forethought Inc. || rowspan="8" | |
| 1985-04 || FileMaker, v1.0 || rowspan="2" | Forethought Inc. || rowspan="8" | |
||
| Line 129: | Line 129: | ||
| 1998-05 || FileMaker Pro 4 Developer Edition || Aimed at expert/professional FileMaker user |
| 1998-05 || FileMaker Pro 4 Developer Edition || Aimed at expert/professional FileMaker user |
||
|- |
|- |
||
| - |
| 1999-06 || * FileMaker Pro 4.1v2 || rowspan="6" | FileMaker, Inc. <ref>http://filemaker.custhelp.com/app/answers/detail/a_id/5584/~/filemaker-pro-version-history</ref>|| rowspan="3" |
|
+ |
| 1999-06 || * FileMaker Pro 4.1v2 || rowspan="6" | FileMaker, Inc. <ref>[http://filemaker.custhelp.com/app/answers/detail/a_id/5584/~/filemaker-pro-version-history Custhelp.com]</ref>|| rowspan="3" |
|
|- |
|- |
||
| <b>1999-09</b> || <b>FileMaker Pro 5</b> |
| <b>1999-09</b> || <b>FileMaker Pro 5</b> |
||
| Line 141: | Line 141: | ||
| <b>2002-09</b> || <b>FileMaker Pro 6*</b> || Version 6 is the last to support Mac OS 9 and 8 |
| <b>2002-09</b> || <b>FileMaker Pro 6*</b> || Version 6 is the last to support Mac OS 9 and 8 |
||
|- |
|- |
||
| - |
! Date !! Version (7+) !! Published by !! Comment <ref>http://www.filemaker.com/downloads/pdf/filemaker_versions.pdf Retrieved 4/14/2010</ref>
|
+ |
! Date !! Version (7+) !! Published by !! Comment <ref>[http://www.filemaker.com/downloads/pdf/filemaker_versions.pdf Filemaker.com] Retrieved 4/14/2010</ref>
|
|- |
|- |
||
| <b>2004-03</b> || <b>FileMaker Pro 7</b> || rowspan="28" | FileMaker, Inc. || Multiple tables/file architecture introduced;<br /> multiple windows;<br /> entity relationship diagrams;<br /> calc variables. Mac version requires OS X. |
| <b>2004-03</b> || <b>FileMaker Pro 7</b> || rowspan="28" | FileMaker, Inc. || Multiple tables/file architecture introduced;<br /> multiple windows;<br /> entity relationship diagrams;<br /> calc variables. Mac version requires OS X. |
||
| Line 230: | Line 230: | ||
===Versions for Central Europe, Middle East and India=== |
===Versions for Central Europe, Middle East and India=== |
||
| - |
There are specific versions of FileMaker for Central European, Middle Eastern and Indian users. These versions are available from [[WinSoft International]] <ref>[http://www.winsoft-international.com/en/products/database.html WinSoft<!-- Bot generated title -->]</ref>, FileMaker’s [[Internationalization and localization]] partner<ref>[http://www.winsoft-international.com/en/company/press/new-filemaker-9-product-line-available-for-middle-eastern-users.html FileMaker available for Middle Eastern Users]</ref><ref>[http://www.winsoft-international.com/en/company/press/new-filemaker-9-product-line-now-available-for-central-european-users.html FileMaker available for Central European Users]</ref><ref>[http://www.winsoft-international.com/en/company/press/filemaker-9-pro-now-available-in-india.html FileMaker available for Indian Users]</ref>.
|
+ |
There are specific versions of FileMaker for Central European, Middle Eastern and Indian users. These versions are available from [[WinSoft International]],<ref>[http://www.winsoft-international.com/en/products/database.html WinSoft<!-- Bot generated title -->]</ref> FileMaker’s [[Internationalization and localization]] partner<ref>[http://www.winsoft-international.com/en/company/press/new-filemaker-9-product-line-available-for-middle-eastern-users.html FileMaker available for Middle Eastern Users]</ref><ref>[http://www.winsoft-international.com/en/company/press/new-filemaker-9-product-line-now-available-for-central-european-users.html FileMaker available for Central European Users]</ref><ref>[http://www.winsoft-international.com/en/company/press/filemaker-9-pro-now-available-in-india.html FileMaker available for Indian Users]</ref>.
|
The [[Central European]] version includes an [[English language|English]], [[Polish language|Polish]], [[Czech language|Czech]] and [[Turkish language|Turkish]] interface; the Middle Eastern version is available in English and [[French language|French]] and the "Indian" version in English. The custom versions offer spell checking, data entry, sorting and printing options for languages of the respective region. They also contain localized templates and a localized Instant Web Publishing. |
The [[Central European]] version includes an [[English language|English]], [[Polish language|Polish]], [[Czech language|Czech]] and [[Turkish language|Turkish]] interface; the Middle Eastern version is available in English and [[French language|French]] and the "Indian" version in English. The custom versions offer spell checking, data entry, sorting and printing options for languages of the respective region. They also contain localized templates and a localized Instant Web Publishing. |
||
| Line 261: | Line 261: | ||
* [http://www.fmforums.com/ FileMaker active free user forums] |
* [http://www.fmforums.com/ FileMaker active free user forums] |
||
* [http://filemaker-plugins.com/ Directory of Plugins for FileMaker] |
* [http://filemaker-plugins.com/ Directory of Plugins for FileMaker] |
||
| - |
* [http://filemaker-magazin.de/ bi-monthly FileMaker magazine]
|
+ |
* [http://filemaker-magazin.de/ Bi-monthly FileMaker magazine]
|
* [http://filemakerx.com/ Filemaker Source Web Site in Turkish] |
* [http://filemakerx.com/ Filemaker Source Web Site in Turkish] |
||
* [http://developer.filemaker.com/search/ FileMaker independent consultants] |
* [http://developer.filemaker.com/search/ FileMaker independent consultants] |
||
Google Groups: FileMaker
Re: Displaying related tables.
On Thu, 29 Jul 2010 14:05:49 +1200, your.n...@isp.com (Your Name)
wrote:
Thanks, even normal printing gets confused sometimes and prints only
the top or bottom of a line.
Thanks for that I won't be looking for something that doesn't exist.
John G.
wrote:
Thanks, even normal printing gets confused sometimes and prints only
the top or bottom of a line.
Thanks for that I won't be looking for something that doesn't exist.
John G.
by John G (greent...@ozemail.com.au) at July 29, 2010 03:27 AM
Re: Displaying related tables.
In article <9kg156h34dtj0gdrgouhcru49j7cb qu...@4ax.com>, John G
Portals weren't designed for printing and can, but not always, cause
strange problems with the printout (for example sliding not working
properly).
It's a little like using Repeating Fields instead of a Related Table ...
it can be done, but is usually best to do it the proper way.
Portals weren't designed for printing and can, but not always, cause
strange problems with the printout (for example sliding not working
properly).
It's a little like using Repeating Fields instead of a Related Table ...
it can be done, but is usually best to do it the proper way.
Displaying related tables.
Helpfull Harry advises not to print portals, I'd be interested to know
why.
If I have 2 tables, one Customers and one Items. Related by unique
customer number.
I can display and enter related records in a portal and even print the
portal to look like an invoice or whatever.
How do I display/print the same thing without a portal?
why.
If I have 2 tables, one Customers and one Items. Related by unique
customer number.
I can display and enter related records in a portal and even print the
portal to look like an invoice or whatever.
How do I display/print the same thing without a portal?
by John G (greent...@ozemail.com.au) at July 29, 2010 12:02 AM
July 28, 2010
Google Groups: FileMaker
Re: master details print
On Tue, 27 Jul 2010 09:06:52 +1200, "Your Name" <your.n...@isp.com>
wrote:
... snip
...
Thank you for your answer. The problem was indeed the sorting. Now
everything works fine.
The address table contains a lot of data about families. I wanted to
describe the problem as easy as possible, therefor I initially left
wrote:
... snip
...
Thank you for your answer. The problem was indeed the sorting. Now
everything works fine.
The address table contains a lot of data about families. I wanted to
describe the problem as easy as possible, therefor I initially left
July 23, 2010
FileMaker Wikipedia Revision History
211.30.207.40: Added Filemaker Go to "current versions" in introduction
Added Filemaker Go to "current versions" in introduction
| ← Previous revision | Revision as of 11:10, 23 July 2010 | ||
| Line 25: | Line 25: | ||
'''[[FileMaker Inc.]]''' is a computer software company formed in 1998 from the vestiges of [[Claris]] as a wholly owned subsidiary of '''[[Apple Inc.]]''' |
'''[[FileMaker Inc.]]''' is a computer software company formed in 1998 from the vestiges of [[Claris]] as a wholly owned subsidiary of '''[[Apple Inc.]]''' |
||
| - |
'''FileMaker Pro''' is a cross-platform [[relational database]] application from [[FileMaker Inc.]], formerly [[Claris]], (a [[subsidiary]] of [[Apple Inc.|Apple]]). It integrates a [[database engine]] with a [[GUI]]-based interface, allowing users to modify the database by dragging new elements into layouts, screens, or forms. Current versions are: FileMaker Pro 11, FileMaker Pro 11 Advanced, FileMaker Pro 11 Server and FileMaker Pro 11 Server Advanced.
|
+ |
'''FileMaker Pro''' is a cross-platform [[relational database]] application from [[FileMaker Inc.]], formerly [[Claris]], (a [[subsidiary]] of [[Apple Inc.|Apple]]). It integrates a [[database engine]] with a [[GUI]]-based interface, allowing users to modify the database by dragging new elements into layouts, screens, or forms. Current versions are: FileMaker Pro 11, FileMaker Pro 11 Advanced, FileMaker Pro 11 Server, FileMaker Pro 11 Server Advanced and Filemaker Go.
|
FileMaker evolved from a [[DOS]] application, but was then developed primarily for the [[Apple Macintosh]]. Since 1992 it has been available for [[Microsoft Windows]] as well as [[Mac OS]], and can be used in a heterogeneous environment. It is available in desktop, server, and web-delivery configurations. |
FileMaker evolved from a [[DOS]] application, but was then developed primarily for the [[Apple Macintosh]]. Since 1992 it has been available for [[Microsoft Windows]] as well as [[Mac OS]], and can be used in a heterogeneous environment. It is available in desktop, server, and web-delivery configurations. |
||
July 20, 2010
FileMaker Wikipedia Revision History
WikiKiwi: /* See also */ bento
See also: bento
| ← Previous revision | Revision as of 13:51, 20 July 2010 | ||
| Line 249: | Line 249: | ||
== See also == |
== See also == |
||
| + | * [[Bento (database)|Bento]], a simplified personal database application from FileMaker Inc. |
||
| + | * [[CDML]], CDML, FDML, html like mark up language for rapid deployment of FileMaker to the web |
||
* [[FileMaker Dynamic Markup Language]] - for displaying FileMaker data on the web |
* [[FileMaker Dynamic Markup Language]] - for displaying FileMaker data on the web |
||
| - | * [[CDML]], CDML, FDML, html like mark up language for rapid deployment of FileMaker to the web. |
||
* [[FileMaker Inc.]], the company developing the FileMaker software |
* [[FileMaker Inc.]], the company developing the FileMaker software |
||
Dbalieiro at 10:57, 20 July 2010
| ← Previous revision | Revision as of 10:57, 20 July 2010 | ||
| Line 23: | Line 23: | ||
| website = [http://www.filemaker.com/ FileMaker Inc.] |
| website = [http://www.filemaker.com/ FileMaker Inc.] |
||
}} |
}} |
||
| + | '''[[FileMaker Inc.]]''' is a computer software company formed in 1998 from the vestiges of [[Claris]] as a wholly owned subsidiary of '''[[Apple Inc.]]''' |
||
'''FileMaker Pro''' is a cross-platform [[relational database]] application from [[FileMaker Inc.]], formerly [[Claris]], (a [[subsidiary]] of [[Apple Inc.|Apple]]). It integrates a [[database engine]] with a [[GUI]]-based interface, allowing users to modify the database by dragging new elements into layouts, screens, or forms. Current versions are: FileMaker Pro 11, FileMaker Pro 11 Advanced, FileMaker Pro 11 Server and FileMaker Pro 11 Server Advanced. |
'''FileMaker Pro''' is a cross-platform [[relational database]] application from [[FileMaker Inc.]], formerly [[Claris]], (a [[subsidiary]] of [[Apple Inc.|Apple]]). It integrates a [[database engine]] with a [[GUI]]-based interface, allowing users to modify the database by dragging new elements into layouts, screens, or forms. Current versions are: FileMaker Pro 11, FileMaker Pro 11 Advanced, FileMaker Pro 11 Server and FileMaker Pro 11 Server Advanced. |
||
July 19, 2010
FileMaker Wikipedia Revision History
75.105.57.80: /* History */
History
| ← Previous revision | Revision as of 00:44, 19 July 2010 | ||
| Line 60: | Line 60: | ||
FileMaker 10 was released on January 5, 2009, before the [[Macworld Conference & Expo]]. This version offers scripts to be triggered by user actions and a redesigned user interface that is similar to many applications on [[Mac OS X Leopard]]. |
FileMaker 10 was released on January 5, 2009, before the [[Macworld Conference & Expo]]. This version offers scripts to be triggered by user actions and a redesigned user interface that is similar to many applications on [[Mac OS X Leopard]]. |
||
| - | + | ||
| - |
FileMaker 11 was released on March 9, 2010.
|
+ |
FileMaker 11 was released on March 9, 2010. This version offers charting.
|
== Description == |
== Description == |
||