Programmatically delete previous response on submit

Thanks, @john.desborough , can the Typeform have the below functionality

Let’s say there’s a stage (not UI) where the developer can define the key field(s) and date range

Multiple fields can be used to define a key such as a combination of first_name and last_name

Let’s say, I defined 

lookup_keys = @email_id

from_date = ‘2024-03-01’

to_date = ‘2024’-08-01’

lookup_date = @submit_date

Here, the lookup_keys, from_date, to_date and lookup_date are new system fields to hold values, which can be reference to user defined field names or actual values

On form ‘Submit’, the typeform engine should do the below

1. Look up all existing records where lookup_keys match the current form values and lookup_date is between from_date and to_date.

2. Delete the above matching records
3. Save the current form fields

I think the above logic would let the developer defined if they want to keep only the latest response for a user based for a day or per quarter or any date range.

The above functionality would avoid or minimize for the developer to write macros or manual post processing of generated google sheets.

Plus the above functionality would clean the data residing in the typeform tables, the SOR. If we did manual editing (or macros) on the google sheets alone, then the view on the Results page of the Typeform will not match with the cleansed google sheet.