crazybake Posted April 3, 2003 Share Posted April 3, 2003 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 Link to comment Share on other sites More sharing options...
BobWeaver Posted April 3, 2003 Share Posted April 3, 2003 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. Link to comment Share on other sites More sharing options...
crazybake Posted April 16, 2003 Author Share Posted April 16, 2003 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 Link to comment Share on other sites More sharing options...
Ugo DI LUCA Posted April 16, 2003 Share Posted April 16, 2003 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 7842 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 accountSign in
Already have an account? Sign in here.
Sign In Now