Button Script

I'm new to FileMaker and this group, and hope it's okay to post a
beginner's question.

I run a small consulting business and am setting up a database to keep
track of our jobs. I've gotten most of it set up, but am a little
stumped on how to script one button.

We typically have 5 to 10 jobs active at a time, so I'd like to put a
popup button on the layout that, when clicked, displays a list of
active jobs and lets me jump directly to any of them. (An active job
would be any job in which the "Job Completed" checkbox is not
checked.)

I have version 9.0. Any help would be appreciated.

James

Re: Button Script

wrote:

> I'd like to put a
> popup button on the layout that, when clicked, displays a list of
> active jobs and lets me jump directly to any of them. (An active job
> would be any job in which the "Job Completed" checkbox is not
> checked.)

In short: write a script that does the search, go to layout mode, design
the button and connect it to the script.

The script may look like this:

Go to layout xy
Enter find mode
set Field (JobCompleted;"=")
Find

Good luck.

--
http://clk.ch

Re: Button Script

In article <1190491348.479789.223570@50g2000hsm.googlegroups.com>,
JamesStep@gmail.com wrote:

> I'm new to FileMaker and this group, and hope it's okay to post a
> beginner's question.
>
> I run a small consulting business and am setting up a database to keep
> track of our jobs. I've gotten most of it set up, but am a little
> stumped on how to script one button.
>
> We typically have 5 to 10 jobs active at a time, so I'd like to put a
> popup button on the layout that, when clicked, displays a list of
> active jobs and lets me jump directly to any of them. (An active job
> would be any job in which the "Job Completed" checkbox is not
> checked.)
>
> I have version 9.0. Any help would be appreciated.
>
> James

Write a script that will do what you want.

Then in the Layout mode, double-click on the button and assign that
script to it.

--
For email, change to
Bill Collins

Re: Button Script

schreef in bericht
news:1190491348.479789.223570@50g2000hsm.googlegroups.com...
> I'm new to FileMaker and this group, and hope it's okay to post a
> beginner's question.
>
> I run a small consulting business and am setting up a database to keep
> track of our jobs. I've gotten most of it set up, but am a little
> stumped on how to script one button.
>
> We typically have 5 to 10 jobs active at a time, so I'd like to put a
> popup button on the layout that, when clicked, displays a list of
> active jobs and lets me jump directly to any of them. (An active job
> would be any job in which the "Job Completed" checkbox is not
> checked.)
>
> I have version 9.0. Any help would be appreciated.
>
> James
>

I think a relationship might come in handy.
Create one new field
REL < text , Auto-enter value , "Active">
Create a second new field, a calculation
cActive < text , IF ( MyField <> "Job Completed" ; "Active" ; "" ) >
Create a relation between REL and cActive, I call the TableOccurence

Create a ne layout for the ActiveJobs TableOccurance
On this layout create a portal
Put one field in the first row, best is a job title or job desciption.
UNcheck the fieldcontrol > Behavior > Allow field to be entered in browse
mode.
Give the portal as many rows as you need. (Maximum number of jobs that are
active OR just set it to five and activate the scroll bar)
When you are now in browse mode you will see all current active jobs.
Now go into scripts and create a script
it holds only one script step. Goto related record.
Under Specify you select the ActiveJobs TableOccurence
And under layout you the layout where you normaly work from. The one that
holds the Job details.
Now go back into layout mode and select the field that is inside the portal
right click and select Button setup > In the left column select Perform
Script and under Specify selct the GoTo Rel script.
Now when you are working and you want to see which jobs are currently active
you just go to the ActiveJobs layout. then if you want to go to any of them
you just have to click on the correct portal row and it will take you to
that record and layout.

All this completely untested, but you should get a long way.

Keep well, Ursus

Re: Button Script

Thanks for the suggestions, especially to Ursus for your detailed
suggestions!

Years ago I did a lot of scripting with a Mac program called HyperCard
(which had some similarities to FileMaker). This would have been a
breeze for me to script in HyperCard, but it's gonna take me a while
to get up to speed scripting in FileMaker, as there are many
significant differences. But FileMaker seems like a powerful program,
and I'm sure I'll get it all figured out eventually.

Once again, I appreciate your help!

James