%%[
var @email, @CCID, @SubmitDate, @Brand, @sendId, @completed, @completedcheck, @q1
SET @CCID = RequestParameter("CCID")
SET @email = RequestParameter("email")
SET @SubmitDate = now()
SET @sendId = RequestParameter("sendId")
SET @Brand = "Carnation"
SET @q1 = RequestParameter("q1")
SET @completedcheck = Lookup("NUK2657951_Carnation_June_LP_Submissions", "q3", "CCID", @CCID)
IF NOT EMPTY(@completedcheck) THEN
SET @completed = "y"
ENDIF
UpsertData("NUK2657951_Carnation_June_LP_Submissions",1,"CCID", @CCID,"email", @email, "Brand", @Brand,"SubmitDate", @SubmitDate, "sendId", @sendId, "q1", @q1)
]%%