Hi everyone, I want to use LINKTOFORM, but f...

(SKETCHwade) #1

Hi everyone,

I want to use LINKTOFORM, but filling the form with data of a specific row (the row is the last entry from USEREMAIL()). I looked at using LINKTOROW but I cant find a way to nest it that works. Any ideas?

(Steven Coile) #2

You don’t need LINKTOROW() at all.

LINKTOFORM() has access to the row from which it is used. So, for instance, if it’s used from that “specific row”’ (“the row is the last entry from USEREMAIL()”), you can reference that row’s columns to provide values for the form:

LINKTOFORM(“MyTable_Form”, “Referred By”, [_THISROW], “Referrer Email”, USEREMAIL())