I have a simple data entry log to track donations to our shelter, it has a workflow that sends an email with a donation receipt that is auto populated in a PDF with their information. Their Email is part of the form, but I can’t figure out how to only select the most recent row entry in the email column to send the receipt to. Is it something I would put in the equation in the workflow? or would I have to isolate that email in another table temporarily?
- right now it emails EVERY email in the column
Is this an ADDS_ONLY/ADDS_AND_UPDATES_ONLY workflow or a scheduled report?
FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() Tips & Tricks ?
How do I get a column value from the last row of this thing only? LOOKUP( MAX( SELECT( My Table[_ROWNUMBER], ([_THISROW].[Thing] = [Thing]) ) ), “My Table”, “_ROWNUMBER”, “Wanted Column” ) Replace My Table with the name of the table from which you want the column value; Thing with the name of the column containing a value that identifies the thing you want (e.g., Order ID); and Wanted Column with the name of the column whose value you want. See also: MAX()
3 Likes
Adds only.
I’ll try that here in a minute, last night I had tried something with “MAX” and it kept telling me it was returning a number value not an email value or that the “MAX” function was being used incorrectly. But I will give it another try.
FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), and SELECT()
LOOKUP( MAX( SELECT( My Table[_ROWNUMBER], ([_THISROW].[Thing] = [Thing]) ) ), “My Table”, “_ROWNUMBER”, “Wanted Column” ) Replace My Table with the name of the table from which you want the column value; Thing with the name of the column containing a value that identifies the thing you want (e.g., Order ID); and Wanted Column with the name of the column whose value you want.
AHHHH IT WORKED lol thank you so much <3
1 Like