Overwrite previously submitted entry

Hello,
Is there anyway to make each entry overwrite previous submission instead of adding new entry for each list choice?
To be more clear, I have a form contains a list of 3 choices (Choice 1, Choice 2, Choice 3) and also some other fields as well. So when someone selects one of these choices (Say Choice 1 for example), their entry should overwrite the previously submitted entry in which they also selected Choice 1 instead of creating a new entry. So that in the end, the exported CSV file contains only one entry for each choice which reflect values from the latest submission. Hopefully that makes sense.

Kind regards,
Mohammed Kadhim

Hi Mohammed. You can use the gform_entry_id_pre_save_lead filter to change the entry ID before a new entry is written:

Thanks Chris. Sorry but I’m still unable to associate that filter with a particular list item. I’ll elaborate further with some images to help you understand what I’m trying to achieve.

Take a look at this simple form which contains a list and a field: (Refer to IMAGE 1)

Assume that users made four submissions in which they submitted a value for “Choice 1” two times. Then the entry list would normally look like this: (Refer to IMAGE 2)

What I want to do, is to overwrite the previous value submitted along with “Choice 1” so that it always show the latest submitted number. The entry list should look like this: (Refer to IMAGE 3)

The same applies for the other choices in that list (Choice 2, Choice 3) entry should always and only shows the latest submitted value for each choice.

BTW, the “No Duplicates” option ALMOST does what I want. Except it completely stops duplicate entry for each list choice instead of overwrite the previous submission.

Hopefully now it makes more sense. I’d really appreciate if you could help me with this.

How about if you used the No Duplicates setting as a check for this, and then use this filter to change the entry ID you want updated, somehow :slight_smile:

You can use the gform_is_duplicate filter maybe:

Not sure how that would all fit together, but maybe that filter gives you some ideas (like the filter determines that the entry is a duplicate, so then you use the gform_entry_id_pre_save_lead filter to update the existing entry?

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.