0

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

null
    • Alain_Fontaine
    • 3 yrs ago
    • Reported - view

    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];

    • Massageausbildung BNS
    • Joey_Sandner
    • 3 yrs ago
    • Reported - view

    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 ;-)

    • Ninox partner
    • RoSoft_Steven.1
    • 3 yrs ago
    • Reported - view

    I think Alain meant : 
    let schuelerEmail := “E-Mail”;
    (select Emails)[“Absender Email” = schuelerEmail]; 

    • Ninox partner
    • RoSoft_Steven.1
    • 3 yrs ago
    • Reported - view

    Ignore my post

    • Ninox partner
    • RoSoft_Steven.1
    • 3 yrs ago
    • Reported - view

    Not shure why it displays Double Quotes while i put single quotes in the code....

    Forum does strange.... Can“t upload images eihter....

    • Alain_Fontaine
    • 3 yrs ago
    • Reported - view

    Altering the quotes seems to be a new vagary here. Go figure...

    • Massageausbildung BNS
    • Joey_Sandner
    • 3 yrs ago
    • Reported - view

    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

    • Massageausbildung BNS
    • Joey_Sandner
    • 3 yrs ago
    • Reported - view

    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

    • Chris.4
    • 3 yrs ago
    • Reported - view

    Joey, try this:

    let curr := this;

    let schuelerEmail := curr.”E-Mail“;

Content aside

  • 3 yrs agoLast active
  • 9Replies
  • 636Views