Hello community,
I am building an app where employees can state their outage days and by submitting that form, an email will be sent to entered email addresses.
In the “Your coworker” field the user can choose their colleagues from an EnumList of all possible employee email addresses taken from a sheet. Though, next time the user signs in, their individual last entry shall be visible as initial value. At the moment, my initial value only shows their very first entry with the expression:
LOOKUP(USEREMAIL(), “SickDB”, “email_address”, “email_practice_lead”)
with “email_practice_lead” being the column to save the coworkers.
Happy about any suggestions on how to solve it.
Solved! Go to Solution.
Try:
ANY(
SELECT(
SickDB[email_practice_lead],
(
[_ROWNUMBER]
= MAX(
SELECT(
SickDB[_ROWNUMBER],
(USEREMAIL() = [email_address])
)
)
)
)
)
To add to your lookup (or equivalent select expression), you need to add maxrow expression
https://help.appsheet.com/en/articles/2357310-maxrow
to find the most latest (last) entry to pull the value from that row to set that as initial value.
Thank you for your quick response @tsuji_koichi. I tried MAXROW but have difficulties to find the correct combination to my Lookup
Try:
ANY(
SELECT(
SickDB[email_practice_lead],
(
[_ROWNUMBER]
= MAX(
SELECT(
SickDB[_ROWNUMBER],
(USEREMAIL() = [email_address])
)
)
)
)
)
Perfect! Much appreciated
User | Count |
---|---|
39 | |
32 | |
30 | |
16 | |
14 |