portal based on empty field

[crazybake]

This is probably obvious but...

I have a global field so that when a user clicks on a button it filters the portal based on this global field. I am trying to create a button so that the portal will show records in which a particular filed is empty. I have a relationship between field A and the global field. when field A is empty I cannot figure out how to translate that to the global thus filtering the portal to show when the global is empty.

I have tried set filed to "" that doesn't seem to work

[BobWeaver]

Make a calculated field cField_A_Empty with the formula:

IsEmpty(Field A)

Then set up a relationship between the global field and cField_A_Empty. Put a 1 in the global and your portal will show all records with Field A empty.

[crazybake]

I don't think I was clear (or maybe I was, but can't figure it out).

I have a portal with a self join between C_global_A and Data_field_A. In a different layout, the user will click on a button to set the value of Data_Field_A. In the next layout exists the portal created using a self-join between these two fields. The user can filter the portal by clicking a button which sets the global value to Data_Field_A.

I want the user to be able to filter this portal using the same relationship and when the calue of Data_Field_A is empty and I would then create a "filter" button that sets the global value as empty...

Also, is there a way to base these results (or filter further) on the vlaue of another field through one button (i.e. only show results if Data_Field_A is empty and Date_Field_C has a valid date in it)...

and last... how do I sort these results based on another field c_Due_Date

sorry.. lots of questions...few answers

[Ugo DI LUCA]

Hi Crazybake,

I think I got the same as Bob, even with your new post. I'm sure I've seen a post somewhere for exactly the same purpose, with a detailled answer. Do a search for "empty" within the 2 past weeks. Not more....

The trick is to base your relationship using a caculation for the right side of your relationship (using a Case Statement Calc), that would return the exact match of your filter key (left side) according to the conditions defined in the calculation.

Case(IsEmpty(some field), 1, " ") for right side and a global = to 1 for left side, or

Case(IsEmpty(somefield), "a Key", " ") and a global = "a key" for left side.

Also, is there a way to base these results (or filter further) on the vlaue of another field through one button (i.e. only show results if Data_Field_A is empty and Date_Field_C has a valid date in it)...

and last... how do I sort these results based on another field c_Due_Date

The same is true for this (a calculation at right) and use a sort key in your relationship.