Interestingly in forms version 9 it will be only possible to store form data in the database which if I am right translates as 'removing the ability to use custom db's to store data' https://our.umbraco.com/documentation/add-ons/umbracoforms/developer/Forms-in-the-Database/

Is my interpretation correct? It seems strange so I assume I am wrong but if I am right then there may be even more GDPR implications down the line.

Hey Tiffany,

As far as I know, it is not currently possible to store forms responses in a custom DB at the minute.

The "forms in the database" bit as I understanding it is the storing of the actual form definitions, workflows etc in the database instead of the flat files that they currently are.

However, I'm not 100% on that.

Thanks

Nik

Hey Nik,

I'm just having a dig in to this and I think setting up a scheduled task would be the most appropriate approach, but I'm still scratching my head about what to write within it.

I'm just taking a quick nosey into public methods of the DLL's and can see that the Umbraco Forms front end calls the Delete(Record record, Form form) method of the RecordService class within the Umbraco.Forms.Core.Services namespace. I just need to track down how to query the API to get the Record and Form objects.

If I happen to strike it lucky and figure this out I'll post my findings!

Regards,

Andy

Hey Andy,

In v7 I did something like this:

using (FormStorage formStorage = new FormStorage())
            foreach (var form in formStorage.GetAllForms())
            {
                if (FormsSecurity.CanCurrentUserEdit(form.Id))
                {
                    model.Form = form.Id;
                    var formRes = FormRecordSearcher.QueryDataBase(model);
                    if (formRes.TotalNumberOfResults > 0)
                    {
                    }
                }
            }

And then this for the delete:

if (FormsSecurity.CanCurrentUserEdit(model.FormId))
                {
                    using (FormStorage formStorage = new FormStorage())
                    {
                        using (RecordStorage recordStorage = new RecordStorage())
                        {
                            var form = formStorage.GetForm(model.FormId);
                            var records = recordStorage.GetRecords(model.Records, form);
                            foreach (var record in records)
                                RecordService.Instance.Delete(record, form);
                        }
                    }
                }

You could add filtering into that get aged results.

I assume the services etc would be similar/the same in v8

Thanks

Nik

Awesome cheers Nik, I'll keep this thread posted of any solutions I may find.