Thu, 17 May 2012 05:53:39 +0000 1800 This is the RSS feed of the last ten file submissions accepted into our database. This RSS feed is always up to date as it is dynamically updated. http://fmforums.com/forum/files/file/26-portal-with-0px-scrollbarfmp12/ editing the theme's CSS file or you can use a program such as Clip Manager 4 to edit these parameters via the clipboard.  Or perhaps even easier...you can download my sample file and just copy the portal style from the portal that I have already modified and apply it to your own.]]> Mon, 30 Apr 2012 00:53:25 +0000 26 http://fmforums.com/forum/files/file/25-sql-builder/

UPDATE 5/16/2012

• Misc bug fixes and UI tweaks

UPDATE 5/15/2012

• Table and Field ID's are now tracked allowing for auto repairing of table and field names after schema changes
  
• Misc bug fixes and UI tweaks

UPDATE 5/13/2012

• All new UI
  
• Support for more functions

UPDATE 5/9/2012 (v1.0?!)

• Support for FROM and Right JOIN Table Aliases
  
• Misc. bug fixes
  
• Tweaked the UI

UPDATE 5/5/2012

• You can now group by a field without displaying it in the results
  
• Added JOIN Example

UPDATE 5/4/2012

• Added a Statement Creation Wizard ( v07 )
  
• Improved Dynamic Parameters Support. ( v0601 )
  
• Support for Dynamic Parameters.

UPDATE 5/2/2012 ( Back From Vacation! )

• Starting Value navigation buttons.
  
• Output code display options can be set at the bottom of the details layout.

UPDATE 4/29/2012

• Added warning icons that show up if a field no longer exists so that schema changes can be easily tracked down.
  
• Added starting value and maximum results in the results window.

UPDATE 4/25/2012

• Fixed "AND OR" Bug
  
• Insert functions into select field lines
  
• Adding a function to a WHERE line will change it into a HAVING line
  
• Manual entry will populate when entered on SELECT and WHERE/HAVING lines

UPDATE 4/24/2012

• Fixed bug in ORDER BY
  
• Table Occurrences are now all that is needed to populate the field list.

UPDATE 4/23/2012

• Added "Get at Date or Time" Check box for SELECT lines and an example of how it works.
  
• Statements can be assigned categories
  
• Simplified the code when there is no JOIN statement
  
• Code now has formatting to make reading the code easier
  
• Dropped the use of Quote() and now use escaped quotes
  
• You can attach a sub-query when using "WHERE IN" by clicking on the icon to the right of the value field

UPDATE 4/22/2012

• More Unsafe Names
  
• UNION drop down menu and examples showing how to use it.
  
• Documentation

Thanks for the feedback so far...]]> Sun, 29 Apr 2012 17:26:41 +0000 25 http://fmforums.com/forum/files/file/22-advanceinstant-search/ Advance serach Filemaker solutions Tue, 10 Apr 2012 08:06:17 +0000 22 http://fmforums.com/forum/files/file/20-onscreen-keyboard/ Uses repeating fields and if you change the $$KEYBOARD global variable, you can use this
in spanish, russian, etc very quickly .

Hope this helps someone with their solution

-enjoy]]> Wed, 28 Mar 2012 08:18:32 +0000 20 http://fmforums.com/forum/files/file/19-context-free-record-creation/
You could us a plugin that uses SQL to create a record in a table or you can use this technique.

It's very simple.

From the Source table you export field context the primary ID field to a text file. I choose to export it to the temporary directory path.

Then you immediately import that same file in to the target table --- That is right you do not need to be on a layout that tied to the base table occurrence -- you could be on any unrelated table.

On import you adjust the field map to import the value of the text file into the foreign key field of the target table.

In this example it is a different take on a Note Log. You can type into a global field and on exit it will trigger the script to export and import that one record then clears the global field. Data entry options in the note field in the target table is defined to use the value stored in the global field.

you could choose to do things more elaborate like either exporting more columns of data by building a tab separated values to a global field and export that and import it into any table matching  field names (provided your first row includes field names - and you omit them on data entry )

OR you can set variables to the desired values and then on the target table set the data entry options to the corresponding variables.

And if you choose to include data other then the ID fields you may wish to also delete the file you can do this by un checking the Specify Field checkbox on the Export Field Contents script step.

=================

Now with all this established I realized that this technique will not work on FMGo because the exporting of the file.

So there is also another script layout and table that will in essence do the same thing and it only needs to IMPORT one
record from a temp table and doesn't need to export. I actually like this method better;  but kept both concepts in the
sample file for you to explore.

Cheers

Stephen]]> Fri, 30 Dec 2011 12:16:31 +0000 19 http://fmforums.com/forum/files/file/16-where-are-you/

No triggers.]]> Thu, 15 Sep 2011 21:21:54 +0000 16 http://fmforums.com/forum/files/file/15-navsystem/
All image and text values that are displayed on the layout for navigation are stored in an "Objects" table. The benefit of this is that any layout that has the needed global repeating fields on it will display the same navigation buttons and text. Want to add more buttons? Just go to the Objects layout (click the grey globe button at the bottom left) and import an image or input new text values. The new option will automatically be added to all layouts.

What I really like about it is that everything is controlled by two simple scripts. "Main Navigation" and "Sub Navigation". And all they do is modify one of two global fields. Of course more script steps are needed to actually perform layout navigation or other jobs. I've included the structure that would be needed to facilitate that already in the scripts as you will see.

I've seen examples of this in a limited fashion, but like I said, I wanted to see how far I could take it. Thanks for any feedback or advice that you can offer.]]> Wed, 07 Sep 2011 17:30:01 +0000 15 http://fmforums.com/forum/files/file/14-googlevoicefp7/
This file is a basic contact manager allowing its user to Dial a phone number, send SMS messages, and receive SMS messages.

There is no official API for Google Voice so this solution or Java code may need updates.

If there are any questions, please contact Angelo Luchi at angelo@foxtailtech.com.]]> Fri, 12 Aug 2011 06:06:58 +0000 14 http://fmforums.com/forum/files/file/13-avaya1416zip/ Tue, 14 Jun 2011 18:51:18 +0000 13 http://fmforums.com/forum/files/file/12-multi-column-printing-faux-down/
When using DOWN first any summary parts are only the width of the column. When it reaches the end of the page it resumes at the top of the page next column.

When using ACROSS first summary parts are the width of the page. However any alternating row colors do not alternate as you'd first expect. Since all odd rows are on the left and the even rows are on the right (if using 2 columns).

My first attempt to create a FAUX DOWN with the full width summary parts. I soon realized that the script ends up modifying each record in the found set - this change data every time you wish to print the report.

The second version does the same thing but uses the Virtual List technique to produce the printed report not requiring changes to the source table.

This example only produces 2 columns but could be adapted for more then two columns.

If you have optimization suggestions please feel free to post a comment.]]> Thu, 02 Jun 2011 17:32:06 +0000 12