I'm trying to input a field into a smart capture form using the code below for the first content block. I've tried to get this working a number of times and searched here also, similar to the following post, but can't find a solution yet.
I'm unable to comment on the post above just yet (account is to new).
My script in the content block looks like this:
%%[ var @key, @email, @rowset, @row set @key = QueryParameter("key") set @rowset = LookupRows("DE Name","ContactKey",@key) set @row = Row(@rowset,1) set @email = Field(@row,"EmailAddress") ]%%
Once I click "Schedule/Publish" the page doesn't load in preview, I change the last line of code to this and it works:
set @email = "1"
My DE does have the column named "EmailAddress" and there is a record there, any help would be greatly appreciated. I've tried other columns and also get the same result.