Script Triggers and FileMaker Go

[lonesomejubilee]

Hey,

Now that FileMaker Go is here I want to set up a solution where workers on the floor can use an iPad but in the back office, we'd have a mac serving the solution. My question is can you write a script or script trigger that would automatically update and bring the newest record made on the iPad to the current record back in the office? Basically I want our workers to be able to make a record on the iPad, and as soon as the record is committed it appears as the current record on the mac.

Now I've tried to test it but can't get it to work. It appears, but it isn't the current record (the mac hosting doesn't automatically to the last record). I guess what I need is a way for FMP to know that a new record has been added and then go to that one.

Any ideas?

Thanks L

[bcooney]

I don't really understand your question, to be honest.

It seems to me that you have a peer-to-peer setup, "a mac serving the solution," and all that you would need is a layout that shows the records sorted by creationtimestamp.

EDIT: What version of FM are you using? You'll need the version that supported the "sustained sort," I think it's FM10.

PPS: In all your posts so far, you ask for solutions to a technique. However, I think you'd get better answers if you state the purpose of the goal and then we'll offer technique/setup suggestions. For example, I need to monitor the iPad users....

Edited September 25, 2010 by Guest

[lonesomejubilee]

Ok, sorry I wasn't very clear. Here's specifically what I want to do. I want to have a database running on an iMac that, can also be simultaneously ran on an iPad. I have people in checking in clients on an iPad. When they successfully check in a client (i.e. make a new record) that information is updated on the host machine in the back of house. Here's the fancy part though... a person isn't always monitoring the iMac in the back of house so.... I the iMac Database (host) automatically update the database to the newest record without a person actively monitoring and pressing a button to "go to the record last".

I have tried this but when I make a new record on the ipad, the imac doesn't automatically go to the last record.

I guess basically I want the activity on one device effect and update and move the activity on the other based on an event.

Does that make more sense for what I am asking?

[bcooney]

Sort of. The way I see it, you have a FMGo client on the iPad interact with the same hosted FM file that any of your regular FM clients access. This file can be shared peer-to-peer or hosted with FMS.

The FMGo user "checks" in a client by doing what exactly, setting a flag in their appointment record?

I don't understand the need to go to the last record on the iMac. What do you do once you are there? Why wouldn't a portal of clients that have been checked in work for you?

[lonesomejubilee]

I never thought of using a portal for the same reason, I wasn't sure that if the iPad user adds a record, would it automatically update the host without any user interaction. I'll try to make what you have suggested.

The reason why I wanted to do it the other is because I want to be able to perform some other things in scripts on one machine after a record had been entered on another.

[Lee Smith]

Hi lonesomejubilee,

It's obvious now that this should have been posted in the FileMaker Go Topic. I will move it in a few minutes.

Take a look at this site that I posted a link to the other day Link for a lot of good information. Take the time to download the file and watch all of the videos. I think you will find a lot of answers to your questions.

HTH

Lee

[bcooney]

The concept you have to "get" is that all users are working with the same file. They aren't doing anything on one machine that influences another machine. They are all working in the same file. Committed changes are broadcast to all.