Populate data extension according Checkbox in Cloudpage

Question

I tried to create a cloudpage in html that has a checkbox with three subjects that the customer will mark if has interest.

This is my cloudpage: https://pub.s7.exacttarget.com/u2qn0g1i5kd

I used AttributeValue to prepopulate the fields FirstName, LastName, E-mail and CPF. I have three data extensions named Bike, Car and Bus with these fields above in cloudpage (FirstName, LastName, Email and CPF) and would like that if the customer marks the checkbox with his name his data will go to the respective data extension named. Is it possible?

Answer 1

Yes it is possible. You can create if statements in the processing page where to check the checkbox and perform an insert to the respective DE. Assuming you just want to populate the DE with the 4 fields and your DE doesn't have any primary key, here is some AmpScript to get you started please update the code to fit your exact setup.

IF NOT EMPTY(RequestParameter("submitted")) THEN

SET @firstname = RequestParameter("firstname")
SET @lastname = RequestParameter("lastname")
SET @email = RequestParameter("email")
SET @cpf = RequestParameter("CPF")


SET @Bike = RequestParameter("Bike")
SET @Car = RequestParameter("Car")
SET @Bus = RequestParameter("Bus")

IF NOT EMPTY(@BIKE) THEN
InsertData('BIKE_DE','FirstName',@firstname,'LastName',@lastname,'Email',@email,'CPF',@cpf)
ENDIF


IF NOT EMPTY(@Car) THEN
InsertData('CAR_DE','FirstName',@firstname,'LastName',@lastname,'Email',@email,'CPF',@cpf)
ENDIF


IF NOT EMPTY(@Bus) THEN
InsertData('BUS_DE','FirstName',@firstname,'LastName',@lastname,'Email',@email,'CPF',@cpf)
ENDIF


ENDIF