%%[ var @emailAddress, @CCID, @SubmitDate, @Brand, @SendId, @brand_shreddies, @brand_cheerios, @brand_shreddedwheat, @brand_gofree, @brand_curiously, @brand_nesquik, @brand_natbears, @brand_all, @topic_sustainability, @topic_recycling, @topic_farming, @topic_wholegrain, @topic_vegan, @topic_glutenfree, @topic_guthealth, @topic_breakfast, @topic_promos, @topic_comps, @topic_fitness, @topic_all SET @CCID = RequestParameter("CCID") SET @emailAddress = RequestParameter("Email") SET @SubmitDate = now() SET @SendId = RequestParameter("SendId") SET @Brand = "Cereal MB" SET @brand_shreddies = IIF(RequestParameter("brand_shreddies")=="true",'y','n') SET @brand_cheerios = IIF(RequestParameter("brand_cheerios")=="true",'y','n') SET @brand_shreddedwheat = IIF(RequestParameter("brand_shreddedwheat")=="true",'y','n') SET @brand_gofree = IIF(RequestParameter("brand_gofree")=="true",'y','n') SET @brand_curiously = IIF(RequestParameter("brand_curiously")=="true",'y','n') SET @brand_nesquik = IIF(RequestParameter("brand_nesquik")=="true",'y','n') SET @brand_natbears = IIF(RequestParameter("brand_natbears")=="true",'y','n') SET @brand_all = IIF(RequestParameter("brand_all")=="true",'y','n') SET @topic_sustainability = IIF(RequestParameter("topic_sustainability")=="true",'y','n') SET @topic_recycling = IIF(RequestParameter("topic_recycling")=="true",'y','n') SET @topic_farming = IIF(RequestParameter("topic_farming")=="true",'y','n') SET @topic_wholegrain = IIF(RequestParameter("topic_wholegrain")=="true",'y','n') SET @topic_vegan = IIF(RequestParameter("topic_vegan")=="true",'y','n') SET @topic_glutenfree = IIF(RequestParameter("topic_glutenfree")=="true",'y','n') SET @topic_guthealth = IIF(RequestParameter("topic_guthealth")=="true",'y','n') SET @topic_breakfast = IIF(RequestParameter("topic_breakfast")=="true",'y','n') SET @topic_promos = IIF(RequestParameter("topic_promos")=="true",'y','n') SET @topic_comps = IIF(RequestParameter("topic_comps")=="true",'y','n') SET @topic_fitness = IIF(RequestParameter("topic_fitness")=="true",'y','n') SET @topic_all = IIF(RequestParameter("topic_all")=="true",'y','n') UpsertData("Cereals_Pref_Centre",1,"CCID", @CCID,"EmailAddress", @emailAddress,"Brand", @Brand,"SubmitDate", @SubmitDate, "sendId", @SendId, "brand_shreddies", @brand_shreddies, "brand_cheerios", @brand_cheerios, "brand_shreddedwheat", @brand_shreddedwheat, "brand_gofree", @brand_gofree, "brand_curiously", @brand_curiously, "brand_nesquik", @brand_nesquik, "brand_natbears", @brand_natbears, "brand_all", @brand_all, "topic_sustainability", @topic_sustainability, "topic_recycling", @topic_recycling, "topic_farming", @topic_farming, "topic_wholegrain", @topic_wholegrain, "topic_vegan", @topic_vegan, "topic_glutenfree", @topic_glutenfree, "topic_guthealth", @topic_guthealth, "topic_breakfast", @topic_breakfast, "topic_promos", @topic_promos, "topic_comps", @topic_comps, "topic_fitness", @topic_fitness, "topic_all", @topic_all) ]%%