Jump to content

Filtering Portals


This topic is 6520 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I have a portal that links to our main DB. It will list all of the jobs in house for a specific customer. It works great. But I want it to only show jobs that have not shipped. I need to "filter" out everything whose status field ≠ shipped. Any ideas how to do this?

Link to comment
Share on other sites

In your Interface table, create a calculation field with the value "Shipped" as the formula. You could use a global field but since it global values are removed when you save a clone and can be different on each guest in a multi-user scenario, I think a calculation works best. Then, create a relationship from your Interface table to the Jobs table using the calculation field and the shipping field. Set the relationship operator as not equal (≠). This will display all jobs that haven't shipped.

Link to comment
Share on other sites

  • 3 weeks later...

What if you have a similar problem but want to omit all dates not listed in the original Find criteria?

If I'm searching Jan 06, that would mean month field != Feb Mar Apr May Jun etc. and year field != 07 08 09 etc.

Right now my Find criteria only filters a related table (geography, so all records are listed per filtered geography, but I want to omit records from different dates).

Edited by Guest
Link to comment
Share on other sites

This topic is 6520 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.