Linktofilteredview

I used the formula " LINKTOFILTEREDVIEW(“List of student”,AND([Student Number] = [_THISROW].[Student Number],[Date of Birth] = [_THISROW].[Date of Birth]) "

I wanted the behavior → if there is a people who student number and date of birth are matched, then show the person.

But now my situation is → No matter what data i enter, always show me all people’s data (not matched person)

How can I solve this problem?

Where did you use the LINKTOFILTEREDVIEW() expression?
How is the data entered?

Screenshots are best.

1 Like


Here you are !

So how does the Action run?

What is the 2nd screenshot showing, it seems to be completely unrelated?

1 Like

So what I am trying to do is that when student enter their Passport Number (Screen Shot 2), I want them to see the personal information that is matched with their own passport number.

However, currently, all the information is presented (e.g. Student A enter his/her own passport number → all the information of Student A, B, C, etcs. is shown).

Let me rephrase my question:

I used the formula " LINKTOFILTEREDVIEW(“List of student”,AND([Student Number] = [_THISROW].[Student Number],[Date of Birth] = [_THISROW].[Date of Birth]) "

I wanted to obtain such behavior; if the student’s number and the date of birth are match, show the data that is related to that student’s own.

However, I am currently expereince this behavior; no matter what data i enter, all the personal data is presented, NOT the specific data that is matched with the specific person.

I would be more than grateful if you could guide me on how to present such behavior that I am willing to carry out.

Thank you :slight_smile:

Yes I understand what you’re trying to do. You need to explain more about how you’re attempting to implement this so that someone can figure out where you went wrong.

1 Like