Hi,
I can't figure out this problem. I'm using SharePoint Lists as a database for this simple Customer Register -app.
App has to filter from Gallery those customers that has assigned to signed user and also all others customers. It has 4 different searchboxes. You also need to be able to search for customers on the search box terms. Also it has 2 buttons: My Customers and All Customers. These buttons specify which customers are listed in the gallery. This is how it looks like:
Everything else works pretty nice. Only problems is this: If those customers that has assigned to user and doesn't have Person ID > MyCustomers Filter formula won't show those customers in filtered Gallery.
This is formula what I using in Gallery.Items:
If(Tab="MyCustomers"; Filter(BasicInfo; CurrentUser.Email = AssignedToMe.Email;
StartsWith(CustomerNumber; TextInput1.Text);
StartsWith(PersonId; TextInput2.Text);
StartsWith(FirstName; TextInput3.Text);
StartsWith(LastName; TextInput4.Text));
Tab="AllCustomer"; Filter(BasicInfo;
StartsWith(CustomerNumber; TextInput1.Text);
StartsWith(PersonId; TextInput2.Text);
StartsWith(FirstName; TextInput3.Text);
StartsWith(LastName; TextInput4.Text));
How should this be done?
