Show filtered table records in a view in different table
Hey there,
I have the table “Emails” and the table “Students”. In the Students table I want to implement a view where it only displays the Emails from the Student of the currently viewed record.
My Code so far:
let studentEmail := (select “Schüler”.“E-Mail”);
(select Emails)[“Absender Email” = schuelerEmail];
I understand that my approach with studentEmail is wrong. I tried to use “this”, etc. but it looks like I haven“t understood the logic behind it.
I hope that my explaination is clear. If not, please let me know.
Thanks in advance.
Joey
9 replies
-
it seems that you are using the wrong set of quotes, and two different names for the same variable.
let schuelerEmail := “E-Mail”;(select Emails)[“Absender Email” = schuelerEmail]; -
Hey Alain, your suggestion solved it. I finally understand the logic now. Thank you very much.
Regarding the quotes and different variables: Those were transcription errors. It was pretty late yesterday ;-)
-
I think Alain meant :
let schuelerEmail := “E-Mail”;
(select Emails)[“Absender Email” = schuelerEmail]; -
Ignore my post
-
Not shure why it displays Double Quotes while i put single quotes in the code....
Forum does strange.... Can“t upload images eihter....
-
Altering the quotes seems to be a new vagary here. Go figure...
-
Ahh... Ok. I was pretty suprised about my mistake too. I just didn“t want to pull the ”It wasn“t my fault”-Card... :-D
-
Ok, next problem which I can“t solve regarding the view.
In my view I have table which displays the email history (inbox and outbox). Inside the view I want to add a column which displays if the email was SENT or RECEIVED.
My approach so far:
let schuelerEmail := ”E-Mail“; // the table column can”t be found. I need the email of the current record.if “Absender Email” != schuelerEmail then “inbox” else “outbox”;How can I get the “E-Mail” field inside a View of the currently viewed record.
Regards
Joey
-
Joey, try this:
let curr := this;
let schuelerEmail := curr.”E-Mail“;
Content aside
- 4 yrs agoLast active
- 9Replies
- 643Views