headers
David Kachel | 16 Jun 2013 22:22

[ANN] LAST DAY - Summer Price Reduction - AutoNavigator 2.0 for FileMaker Pro $99

FOR IMMEDIATE RELEASE ­ JUNE  16, 2013
__________

AUTONAVIGATOR FOR FILEMAKER PRO - VERSION 2.0v1 SUMMER PRICE REDUCTION ‹ $99
(regular price, $150)
__________

ALPINE, TEXAS‹JUNE 16, 2013--David Kachel/Foundation Database Systems --
publishers of AutoNavigator for FileMaker Pro --Today announced the LAST DAY
of their annual summer price reduction for AutoNavigator for FileMaker Pro
2.0v1, their popular tool for FileMaker Pro developers; this special price
ends today, Monday, June 17, 2013 at midnight.
__________

Description:
__________

AutoNavigator is a tremendous time saver for FileMaker developers, amateur
and professional alike.
No more hours or days spent building a tab and navigation system for your
solutions. Just duplicate an existing layout, rename it and run one
script... you're done!
AutoNavigator adds your layout to its built-in navigation system and
displays the appropriate tab graphics and labels on every relevant layout.
Never again worry that you or your users will get lost in a maze of layouts.
AutoNavigator knows where every user layout is, how to get there and back
and what tab grapics to display when it gets there. Never write another line
of code to move between layouts or hierarchies. Build as complicated a tab
and navigation system as you need with no coding and no effort.
(Continue reading)

Permalink | Reply | 0 comments |
headers
Jeffrey R Gorman | 16 Jun 2013 22:21
Favicon

Re: Ipad Models and FMGO

Hi,
It'll work fine.

Also, I am an Apple Specialist.  I'll give any of you a discount on any Apple or FileMaker products you need (no
credit card for discounts).
Thank You,
Jeff

--
v: 609-683-3622, f: 609-683-3612
Thank you for using Creative Computing
<http://www.creativecomputing.com>

On Jun 16, 2013, at 4:03 PM, fmpexperts-request@... wrote:

> Message: 1
> Date: Sun, 16 Jun 2013 12:05:40 -0500
> From: Jorge Biquez <jbiquez@...>
> To: fmpexperts@...
> Subject: Ipad Models and FMGO.
> Message-ID: <20130616171241.46E86FFC6@...>
> Content-Type: text/plain; charset="us-ascii"; format=flowed
> 
> Hello all.
> 
> I was offered to do some work in exchange of an old refurbished Ipad, 
> the smallest one of the first model.
> 
> I was wondering if you that have worked with FMGO and Ipad can 
> comment if model 1 of Ipad can work fine with actual version of FMGO
(Continue reading)

Permalink | Reply | 0 comments |
headers
Jorge Biquez | 16 Jun 2013 19:05
Favicon

Ipad Models and FMGO.

Hello all.

I was offered to do some work in exchange of an old refurbished Ipad, 
the smallest one of the first model.

I was wondering if you that have worked with FMGO and Ipad can 
comment if model 1 of Ipad can work fine with actual version of FMGO 
and interact with FM server 12 without problems?

Or it is better to have a more recent model of Ipad?

I know speed and resolution are some of the differences but I do not 
know if there are some others issues to consider. If so, maybe it is 
better to wait until be able have one of the latest models?

What I need and want to do is to create a working prototype of a 
solution that works with a FM server hosted, some desktop machines 
accessing directly using FMpro, a few users accessing very simple 
forms with PHP/FM pages and some users working with Ipads. For 
accessing and consulting information, receiving some data to and from 
the ipad but the most important is to be able to interact with the 
GPS and other Ipad ports to be able to upload images, videos and 
update information to the server, using WIFI or 3G.

Thanks in advance for your help and comments.

Jorge Biquez

_______________________________________________
FMPexperts mailing list
(Continue reading)

Permalink | Reply | 4 comments |
headers
Hans Gunnarsson | 16 Jun 2013 12:13
Picon

How to run scripts on FM server?

Sorry for the perhaps daft question…
But so far I have been stuck in creating applications where the user has Filemaker Pro and runs the solution
from the server.

When reading material on PHP and other issues I repeatedly stumble on people talking about running scripts
on the server versus running scrips on the client.

How do I make a script run on the server?
For testing, custom web publishing etc?

If not for web publishing - What would be the purpose of running a script on the server?

TIA
Hans
_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Permalink | Reply | 1 comment |
headers
Hans Gunnarsson | 15 Jun 2013 11:29
Picon

[Off-ish] OS X server, Wiki, PHP and Filemaker

I'm wondering if it would make sense to use an OSX server Wiki page as a starting point for a PHP page fetching
data from an FM server using the PHP API?
Or should I rather look at creating the PHP pages from scratch and then link to them from the Wiki pages?

TIA
Hans
_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Permalink | Reply | 3 comments |
headers
Hemant Patel | 15 Jun 2013 06:05
Picon
Gravatar

Trigger a script on Filemaker server from iPAD

Hello,

I am developing a solution which will be hosted on FMS 12 Advanced.
And then have local copies of same database on several iPADs.
These local copies will be synced back to server by some syncing plugin
(eg.360 work's MirrorSync).
Now what I want to do is- 'To invoke a script in server database from local
database(i.e on iPAD) (probably on a button click)'.

--

-- 

**Warmest  Regards**
Hemant Kumar Patel
Business Analyst
Preemptive Engineers <http://www.preempteng.com>
_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Permalink | Reply | 5 comments |
headers
Jonathan Fletcher | 14 Jun 2013 22:44

Can you spot the...

This has got me stymied. I wrote this to set a variable. It returns a question mark.

I ran the script up to this point and tested each field and variable with Developer Assistant. They all have
the correct data in them at the right time in the right place in the script.

When I evaluate the whole calculation with DA, I get error 8310, which is supposed to be a syntax error
(according to Google). I don't get any FileMaker errors when I close the dialog, but when I test the result I
get the SQL error.

> Let ( [
> 	~sqlQuery = "SELECT a.ID 
> 				FROM host_Person AS a 
> 				WHERE a.password = ?
> 				AND a.userName = ?" ; 
> 	~fieldSeparator = "" ;
> 	~rowSeparator = "" ;
> 	~arg1 = $userPW ;
> 	~arg2 = $userNm ;
> 	~result = ExecuteSQL ( ~sqlQuery ; ~fieldSeparator ; ~rowSeparator ; ~arg1 ; ~arg2 )
> ] ;
> 	~result
> )

Can anyone spot the syntax error? 

Thanks all!

-johnno
(Continue reading)

Permalink | Reply | 15 comments |
headers
Josh Makowski | 14 Jun 2013 20:57
Picon

inserting custom google map

I am trying to insert a custom private google map into my FileMaker
project.  Is there a way to do this?
_______________________________________________
FMPexperts mailing list
FMPexperts@...
http://lists.ironclad.net.au/listinfo.cgi/fmpexperts-ironclad.net.au
Permalink | Reply | 5 comments |
headers
Bob Patin | 13 Jun 2013 22:39
Favicon

Hover action on grouped fields

I have a line of fields in a portal; I'd love it if the entire line of 6 fields would change colors when I hover
over them.

I tried grouping the fields and then applying a HOVER format to the grouped fields; while all 6 did retain the
hover format, only one field changes its format when I hover over it.

To test further, I put a block of 4 fields on a new database, on a layout; I grouped them and set a script to show
me a simple dialog.

I then set the HOVER format to reverse the colors of the field when I hover; it only acts on the field in which my
cursor resides, even though all 4 fields are part of a group, all sharing the same script.

Is there a way to force FileMaker to act upon these at once, without having to put a field behind the 6, like we
used to do in the old days to change the color of a selected row?

Thanks,

Bob Patin
Longterm Solutions LLC
bob@...
615-333-6858
http://www.longtermsolutions.com
FileMaker 9, 10 & 11 Certified Developer
Member of FileMaker Business Alliance and FileMaker TechNet
--
Twitter: bobpatin
AIM: longterm1954
iChat: bobpatin
Permalink | Reply | 4 comments |
headers
Damian Kelly | 13 Jun 2013 12:06
Picon

Robust SQL

Something I meant to bring up at PoE[X] Berlin but didn't get the time was this approach to making SQL robust:

Let([
~d_Stored_Field = GetFieldNameOnly ( GetFieldName(Attribute::d_Stored_Field) );
~ID_AttributeCategory = GetFieldNameOnly ( GetFieldName(Attribute::ID_AttributeCategory) );
~Attribute = GetTONameOnly ( GetFieldName(Attribute::ID_Attribute) )
]
ExecuteSQL ( 
"SELECT COUNT(*) 
FROM " & ~Attribute & " 
WHERE " & ~ID_AttributeCategory & " = ? and " & ~d_Stored_Field & " = ?" ; 
"" ; 
""; 
Attribute::ID_AttributeCategory; Attribute::d_Stored_Field)
)
)

GetFieldNameOnly() and GetTONameOnly() are custom functions that do what it says on the tin. And are
probably overly verbose in name but nevermind.

Do you think using ~ to distinguish a variable containing a field or table name is a good idea? I am thinking
using variables that match the field name when I create the SQL so it reads ok. Subsequent changes to field
or TO names will change the values in the variables but the sense of the SQL ought to help??

The biggest issue with this for me at the moment is that the context has to be respected within custom
functions. So the above works as long as I have a relationship to the Attribute table.
This negates one of the key advantages of ExecuteSQL() though.  Dirty hack one is to temporarily connect the
TOs together required in a given custom function then delete these relationships. Of that I am not a fan.

I am wondering if Fabrice Nordmann's awesome abstraction custom function might come to the rescue?
(Continue reading)

Permalink | Reply | 3 comments |
headers
Eric Wright | 13 Jun 2013 01:10
Picon

RE : FRG to OmniGraffle?

Hi Rick,

I have an Omnigraffle stencil I use but it doesn't anything other than provide different coloured TOs and attributes

Happy to post it if its any use.

Kind Regards
Eric

On 13/06/2013, at 6:05 AM, fmpexperts-request@... wrote:

> From: rpdwyer@...
> Subject: FRG to OmniGraffle?
> Date: 12 June 2013 11:31:32 PM AEST
> To: fmpexperts@...
> Reply-To: rpdwyer@..., fmpexperts@...
> 
> 
> Hello all.
> Can anyone supply the directions needed to get a complex relationships graph emulated in Visio or
OmniGraffle?  I've heard it can be done with Applescript/OmniGraffle via the XML generated from a DDR, but
wanted to see if others had hands on knowledge.
> 
> Thanks,
> --Rick
> 
> 

_______________________________________________
FMPexperts mailing list
(Continue reading)

Permalink | Reply | 0 comments |

Gmane