Hi, I have a question on creating an expression. The below table is called “Product”.
I have another view created from another table that require the field “GTIN”. Under the “GTIN” field, I want to create an expression that read back to the “Product” table. What I want is to filter by USEREMAIL() and select the GTIN that is the most recent added. For example, if I login in using email@example.com, the GTIN value that I want to obtain will be “9556108261009”.
For example, if I login in using firstname.lastname@example.org, the GTIN value that I want to obtain will be “931048834115”.
In short, I would like to select the latest GTIN value based solely on the useremail login.
I have created the expression but it does not work.
Can anyone advise me on how I can form my expression to achieve what I want?