Filtering data in a portal

I'm trying to show a subset of the data displayed in a portal.

This is the current set up (filemaker 6.0):

I have a file called Master that contains information about clients.

I have a file called Jobs which contains, you guessed it, information
about jobs. This file is linked to the Master file by Client ID.

The Jobs file contains a text field called "type" which identifies each
record as either a "Job" or a "Quote"

I have a portal on the Master file that displays all the related Job
records for a particular client including both  "jobs" and "quotes".

I WOULD LIKE TO HAVE a set of three radio buttons above the portal that
allow me to limit the display to showing "all" records, just the
"quotes" and just the "jobs"

As a bonus I'd also like to be able to sum the field called "Amount"
from each record and get a total amount that reflects each of the three
displays.

Any help would be much appreciated

Thanks

Justin

0
justin (3)
12/11/2005 6:07:57 AM
comp.databases.filemaker 11108 articles. 0 followers. amosw01 (46) is leader. Post Follow

3 Replies
289 Views

Similar Articles

[PageSpeed] 54
justin wrote:

> I'm trying to show a subset of the data displayed in a portal.
> 
> This is the current set up (filemaker 6.0):
> 
> I have a file called Master that contains information about clients.
> 
> I have a file called Jobs which contains, you guessed it, information
> about jobs. This file is linked to the Master file by Client ID.
> 
> The Jobs file contains a text field called "type" which identifies
> each record as either a "Job" or a "Quote"
> 
> I have a portal on the Master file that displays all the related Job
> records for a particular client including both  "jobs" and "quotes".
> 
> I WOULD LIKE TO HAVE a set of three radio buttons above the portal
> that allow me to limit the display to showing "all" records, just the
> "quotes" and just the "jobs"
> 
> As a bonus I'd also like to be able to sum the field called "Amount"
> from each record and get a total amount that reflects each of the
> three displays.
> 
> Any help would be much appreciated
> 
> Thanks
> 
> Justin

If you format the field as "Jobs" and "Quotes" checkboxes instead of
radio Buttons, you'll find that the relationship will match however
many boxes are checked.

You'll have to check both Jobs and Quotes to get All, but it would be
simple to script a button to do that for you.

The idea is that when multiple checkboxes are selected, the actual text
value of the field is a return-separated list, and the realtionship
sees them all as matching values.

So, for instance, if you had both Jobs and Quotes selected, the actual
field value (if you were to simply display it as a text field) would be

Jobs
Quotes

and all would be displayed.

Matt
0
Matt
12/11/2005 12:24:35 PM
Hi Matt:

That's a great suggestions, thanks. I'm not sure though how to work the
relationships so this filters the data that's already shown in the
portal.

The relationship that currently defines the portal is based on Client
ID. How do I  get it to ALSO match a relationship with the results of
the check boxes you describe?

Thanks.

J.

0
justin
12/11/2005 5:58:39 PM
justin wrote:

> Hi Matt:
> 
> That's a great suggestions, thanks. I'm not sure though how to work
> the relationships so this filters the data that's already shown in the
> portal.
> 
> The relationship that currently defines the portal is based on Client
> ID. How do I  get it to ALSO match a relationship with the results of
> the check boxes you describe?
> 
> Thanks.
> 
> J.

First, look at what you have in the child records that identifies each
as either a Job or a Quote. You need a single field that specifically
identifies each record (e.g., Type) with a J or a Q (or, "Job" and
"Quote", it's up to you). Populate the fields accordingly.

Make a Type field in the parent (Client or Account) table. Define the
field as a checkbox set on the layout, taking its values from a value
list which you've defined as having a "J" and a "Q" (or "Job" and
"Quote") as its values.

Don't worry about the checkbox value choices displayed on the layout.
They can always be covered with something else.

Now go to your Relationship Graph, and connect the Type fields in the
two tables using the same table occurrences that define the existing
relationship.

What you've done is create a multiple criteria relationship, requiring
that the records displayed in the portal have both ClientID and Type as
matches. In Browse Mode, the portal will display that client's Jobs or
Quotes, depending on which box is checked. Bear in mind that you now
must have either or both boxes checked in the parent record, or nothing
at all will display in the portal.

For a display of all records, you can either select both boxes
manually, or do a script:

Set Field [ Clients::Type ; "JParQ" ] 
or 
Set Field [ Clients::Type ; "JobParQuote" ]

That "Par" is intended to be a Paragraph sign, otherwise known as a
"pilcrow" (or, much less commonly, "alinea") which you can select from
the symbols in the Set Field dialog. Put a button on the layout to run
the script.

Hope all that's clear enough.

Matt
0
Matt
12/11/2005 11:29:16 PM
Reply:
Similar Artilces:

Warning: Color Data is not set for Interpolated shading
Hello all: I can run the following script p = patch('Faces', faces,... 'Vertices', vertices, ... 'FaceVertexCData', rgb, 'FaceColor','flat'); K>> size(faces) ans = 17324 3 K>> size(vertices) ans = 8506 3 K>> size(rgb) ans = 17324 3 However, after I changed the 'flat' to 'interp', the Matlab reports the following errors. Warning: Color Data is not set for Interpolated shading. p = patch('Faces', faces,... 'Vertices', vertices, ... 'FaceVertexCData', rgb, 'FaceCol...

Re: Given a simple data set: Seeking tips on preparing data for #4
> From: SUBSCRIBE SAS-maru859 > Subject: Given a simple data set: Seeking tips on preparing > data for analysis > > My data analysis experience and for that matter my SAS programming > experience is limited (a few classes several years ago). I > have been given > a simple data collected from college freshmen (4000 > observations for the > variables of (sex, gpa, act score, state of residence, etc) > set on which I > will perform some basic stats .... > > I think in a nutshell I am asking for information (or links) > on how to ensure that my analysis...

filter, redirect multicast DIS PDUs
Has anybody come across software or an API that can bridge two multicast groups with filtering in between. In my case I need to receive on multicast A, filter out certain entities, send on multicast B. Then receive on B and send all on A. This is due to a limit on our sim where it chokes if it receives too many entity state PDUs. I realize a change to the sim DIS engine is MUCH easier but mgmt doesn't want to go that route :(. ...

Populating an Access combo box with large amount of data causes table lock in SQL Server
I have a combo box where users select the customer name and can either go to the customer's info or open a list of the customer's orders. The RowSource for the combo box was a simple pass-through query: SELECT DISTINCT [Customer ID], [Company Name], [contact name],City, Region FROM Customers ORDER BY Customers.[Company Name]; This was working fine until a couple of weeks ago. Now whenever someone has the form open, this statement locks the entire Customers table. I thought a pass-through query was read-only, so how does this do a table lock? I changed the code to an unbound rowsou...

problem:import csv data
This is a multi-part message in MIME format. ------=_NextPart_4E6F3B07_DF0E1368_45C61FA2 Content-Type: text/plain; charset="gbk" Content-Transfer-Encoding: base64 aW1wb3J0IHNxbGl0ZTMgDQpjb24gPSBzcWxpdGUzLmNvbm5lY3QoJy9ob21lL3N0b2NrLmRi JykNCmN1ciA9IGNvbi5jdXJzb3IoKQ0KY3VyLmV4ZWN1dGUoJycnQ1JFQVRFIFRBQkxFIHF1 b3RlICh0aWNrZXIgVEVYVCxkYXRlIFRFWFQsIHBvcGVuIFRFWFQsIGhpZ2ggVEVYVCwgbG93 IFRFWFQsdm9sIFRFWFQsYWRqY2xvc2UgVEVYVCk7JycnKQ0KaT0vdG1wL2RhdGEuY3N2DQpj dXIuZXhlY3V0ZSgnLnNlcGFyYXRvciAiLCIgJykNCmN1ci5leGVjdXRlKCcuaW1wb3J0ICAl cyAgcXVvdGUnICAlICBpKQ0KY29uLmNvbW1pdCgpDQpjdXIuY2xvc2UoKQ0...

photoshop brush filter #2
Hi, can anyone give me some hints about the mathematic algorithms behind those Photoshop brush filters? Thanks, ff On Jun 4, 8:56=A0am, finecur <fine...@yahoo.com> wrote: > Hi, can anyone give me some hints about the mathematic algorithms > behind those Photoshop brush filters? Maybe ask in a Photoshop group? Owen ...

Help: Phase Delay of Butterworth Filters
Hi All, Hoping someone can help me out. I'm working with Butterworth Filters and have some great equations for calculating the coefficients as a function of cut-off frequency: http://www.planetanalog.com/showArticle.jhtml?articleID=12802683&pgno=3 However I need a function which gives me the phase delay of the filter as a function of cut-off frequencies. For example, a second order Butterworth Filter (Low Pass) with a cut-off frequency of 0.05 has a lag (phase shift) of ??? radians. Hope someone has a formula for this. If it was genereric for N-Order that would be best. Regards...

Help on the use of the colon in a data set step
Hello, I would like to have a quick explanation of the use of the colon in the following data step: data B (drop = eff: i Dc); set A (drop = Age_End); length cum_eff: 3; by Age; array cum_eff{5}; array effectif{5} eff: ; retain cum_: 0; if first.Age then do; do i=1 to 5; cum_eff{i}=0; end; end; do i=1 to 5; cum_eff{i} = cum_eff{i} + effectif{i}; end; if last.Age; run; The question is : what do I need the colon in the line of command: retain cum_: 0; ? Indeed, if I do not put the colon, the sum is not propoerly done. Many thanks in advance for your kind help. Best regar...

US-TX-Austin: Sr. Analog IC Engineer, BiCMOS design, Design filters, Cadence; Pe (45316832403)
US-TX-Austin: Sr. Analog IC Engineer, BiCMOS design, Design filters, Cadence; Pe (45316832403) ============================================================================================== Position: Sr. Analog IC Engineer Reference: SMC01473 Location: Austin TX Duration: Perm Skills: 5+yrs of on-chip analog BiCMOS design at frequencies > 500 MHz. Skilled in the transistor-level design of high frequency analog filters, gmC filter and linear amplifiers. Cadence tool suite familiarity required. RF CMOS and SiGe Bi...

Filters Engaged
I had to "treat" my eyes to why I had so much filtering to begin with. Enough is enough. It's mostly Flatti and DuFuS talking to each other (can't say about Snot or Quack since I never lifted those anyway). Often not even new stuff, just minor rewording of the old in ways that might sound new to the cranks I put the filters back to work, and was never so happy to see so many -9999s come up all at once, Just this post ought to give Doofie 10 or 100 frothing posts as followups, with an equal number from Flatso, ageeing with whatever inanity DuFuS comes up with. At least I ...

Data Joiner and DB2 version 8
Hi Guys, We are updating an old z/OS DB2 version 7 system to version 8 compatibility mode in the near future. We have discovered an application which is currently using Data Joiner version 2.1.2 Does anyone have any experience with this combination or have any experiences to pass on? Any advice would be greatly appreciated. Cheers Paul Merrett pmerrett wrote: > Hi Guys, > > We are updating an old z/OS DB2 version 7 system to version 8 > compatibility mode in the near future. We have discovered an > application which is currently using Data Joiner version 2.1...

filtering rules
Hi list, Here's is something I don't understand from my favorite email client Pmail. When I make a filtering rule with "rules applied when folder is closed" it only works when besides the preview mode windows also the "new mailfolder solo window" is open. Is it possible to let the rule work without this extra window open? thnx Pieter ...

Eudora 6.0
I would like to either turn off the spam filters or if that can't be done, remove them. Can anyone help with this one? "P.R." ha scritto: > > I would like to either turn off the spam filters or if that can't be > done, remove them. Tools | Options | Junk Mail and Tools | Options | Junk Mail Extras You can drag the slider all the way to the right (100) and UNcheck other options that will disable the spam filters. If you want to remove the spam filters, rename or delete SpamHeaders.dll, SpamWatch.dll and StaticJunkDB.txt from the Eudora plugins fol...

US-TX-Austin: Sr. Analog IC Engineer, BiCMOS design, Design filters, Cadence; Pe (45316857604)
US-TX-Austin: Sr. Analog IC Engineer, BiCMOS design, Design filters, Cadence; Pe (45316857604) ============================================================================================== Position: Sr. Analog IC Engineer Reference: SMC01473 Location: Austin TX Duration: Perm Skills: 5+yrs of on-chip analog BiCMOS design at frequencies > 500 MHz. Skilled in the transistor-level design of high frequency analog filters, gmC filter and linear amplifiers. Cadence tool suite familiarity required. RF CMOS...

Kmail: filtering incoming IMAP messages
My server just changed from POP to IMAP. All my existing filters are set to move various kinds of messages to local folders. They still work when applied manually to the IMAP inbox but do not automatically filter incoming messages anymore, although they are set to do so. Also, the filter dialog does not give me options to move messages to different folders on the IMAP server. Does anyone have any ideas about what the issue might be? -- John John Norvell wrote: > My server just changed from POP to IMAP. All my existing filters are set > to move various kinds of messages to local fold...

Crappy Sent-items filter Eudora 5.2 PLEASE HELP
I've setup a sent-items filter for an imap user who wants their sent items left on the imap servers sent-items folder NOT the local Outbox. The filter just says take any outgoing message with any critera and transer it to the imaps sent-items folder. HERE IS THE PROBLEM THATS MAKING ME CRAZY. The sent items folder has the MAIL ACCOUNT USER under the WHO heading, not who she sent the message to (unlike all other mail software sent-items ,so it's useless basically). I cannot find any documentation explaining how to see the RECEPIENTS. I've also tried changing the toolbar...

Filter within a filter
Hy, is it possible to filter within a filter on a form? Let's say I have a button which can filter on only open cases and another button to filter on only my cases, then if I pushed both buttons, I would get only my open cases. I thought of doing such so with this code, but VBA was not impressed. Me.Filter = "tblCases.Ready = False" & "tblCases.Owner = " & LoginUser Thanks in advance. TTD wrote: > Hy, > > is it possible to filter within a filter on a form? > > Let's say I have a button which can filter on only open cases and anothe...

nslookup as filter?
Is it possible to get nslookup to return only the canonical name for an IP address? I'd like to translate dotted decimal IP addresses to canonical names in an awk script, using the system() function, to make them "people readable" but I haven't been able to figure out how. nslookup insists on returning the server name, server address, the requested address and then the canonical name. On Tue, 23 Nov 2004 13:18:03 -0500, Richard B. Gilbert wrote: > Is it possible to get nslookup to return only the canonical name for an > IP address? I'd like to translate d...

Extruding Filter
Does the GIMP contain any filter/function to obtain the following results: http://www.voidix.com/cystal.html The crucial part in that PS tutorial is the extrude filter, which apparantly even offers pyramid or block extrusion. That's one cool filter. Bart > > The crucial part in that PS tutorial is the extrude filter, which > apparantly even offers pyramid or block extrusion. That's one cool filter. > I don't know of anything similar for the GIMP. You could post the link to comp.graphics.algorithms and ask if someone knows or realizes a good (working, easy, e...

BF:V Server filters help
The BF:V manual is pretty weak... How do you filter out servers that are already full? What's the point of cluttering the display with those? BTW, I've found that I can filter ping times using "<100" "Kevin Goodman" <goodmanks@RxOxGxExRxS.com> wrote in message news:7bjgc.2092$Mzw.1571@news04.bloor.is.net.cable.rogers.com... > The BF:V manual is pretty weak... > > How do you filter out servers that are already full? > What's the point of cluttering the display with those? You can't :( > BTW, I've found that I can filter pin...

Re: Problems with 9.2
Dear Paul, thank you for your idea with the hidden formation signs. Everything was OK with the dataset. I checked it in Notepad. The entire program worked fine useing the simple editor - but useing the enhanced editor of 9.2 the program closes as soon as I pressed the run button. I changed the code of the reading procedure a little: data RawData; input Sampling Treat_ID Taxa_ID @@; do Replicate = 1 to 4; do Area = 1 to 4; input Number Biomass @@ ; output; end; end; datalines; The only difference to the faulty version was the second "@" in the line where Number and Biomass is rea...

transferring data from old Mac
I'm trying to transfer data from the hard drive of a Power Computing Power Center 120, a 1996 clone of a power Macintosh. The computer has an SCSI port and an ethernet connection, but no USB port. It doesn't have working email -- it seems to have had Eudora light at one point, but the executable file has been deleted. It has a CD-read drive, but no CD-write drive. I can always zip everything and make floppies, but I'd rather do something more efficient. Any ideas? some possibilities: Create a home network with a PC. I can do it on the PC end, but have no idea on t...

1st Order High Pass FIR-Filter
I have recorded a voice sample in matlab and now I want to apply a first order FIR filter: F(z) = 1 - k/z , k = 0.97 so the output of the FIR would be y[n] = s[n] - k*s[n-1] right? Can I simply apply this to the voice sample vector like this? k = 2; while k < size(voice_sample(),1) if (voice_sample(k) == 0) && (voice_sample(k-1) == 0) %nothing else voice_sample(k) = voice_sample(k) - 0.97*voice_sample(k-1); end k = k + 1; end I've tried it out but I'm not sure if it actually works as intended. Is there a better way...

please help me on interpolating for irregular grid data
Dear all, I have tried to interpolate the 2D data but just realized that it is not a uniform grid, my data looks like: latitude longitude data --------------------------------------- 38.82605 73.05077 74 38.89838 73.30076 56 38.96964 73.55139 54 39.03984 73.80267 59 39.06496 72.97436 91 39.13754 73.22533 86 39.20905 73.47697 82 39.27948 73.72927 79 39.30354 72.89727 124 39.37637 73.14924 113 and I need to interpolate them to, latitude=39 and longitude = 73.5. I have tried to use interp2 and griddata but MATLAB require a uniform grid, so any one is familiar with this...

Re: How to generate two data base in a single data step
I'm not sure what you'd gain by fragmenting the data. Why not populate an error coding variable instead so rather than output according to the 'if' set the variable to 1 or 0 depending on the data quality condition? HTH. On Fri, 19 Aug 2005 03:30:54 +0200, Miguel de la Hoz <miguel_hoz@YAHOO.ES> wrote: >hi List: > > > >I am trying to build a data base, but I observe so many bad observations than I am thinking to separate the whole data in two, one data with right observations and the other with data with errors. I tried this code but I am not able to cont...