Delete Data in Data Extension if the checkbox in CloudPage is empty

Question

I create a cloudpage with some checkboxes that reference a some Data Extension. Example image attached.

My attempted was use DeleteData in Ampscript with the syntax below:

Where Bike is my checkbox:

IF NOT EMPTY(@Bike) THEN
InsertData('Bike_DE','FirstName',@firstname,'LastName',@lastname,'Email',@email,'Telefone',@telefone,'CPF',@cpf)
ENDIF

IF EMPTY(@Bike) THEN
DeleteData('Bike_DE','FirstName',@firstname,'LastName',@lastname,'Email',@email,'Telefone',@telefone,'CPF',@cpf)
ENDIF

The fields in syntax like 'firstname' and etc. I want to delete if the checkbox was not checked.

I hope that my explanation that good. If anyone know how to help me, thanks in advance.

Answer 1

You can use the RequestParameter() AMPScript function to listen for sent values.
Assuming each CheckBox is separate (different "Name" values), you can listen for each CheckBox value and process accordingly.

HTML:

<input type="checkbox" name="Bike" value="1"> I have a bike
<input type="checkbox" name="Car" value="1"> I have a car

AMPScript:

IF EMPTY(RequestParameter('Bike')) THEN
//Do Delete Function
ELSE
//Do UpsertData Function
ENDIF

IF EMPTY(RequestParameter('Car')) THEN
//Do Delete Function
ELSE
//Do UpsertData Function
ENDIF

UpsertData() will Insert or Update depending on existing records in the data extension. This way you can update the "subscribeDate" to the last time they submitted their preferences.
If you don't want to Upsert, you could use a RowCount() check on the target preference DE to see if a row already exists, then Update or Insert accordingly.

Note that when using CheckBoxes - unchecked values are NOT submitted in the Post Payload.
Source: https://developer.mozilla.org/en-US/docs/Web/HTML/Element/input/checkbox