Hi Alex, I wonder if can you help?

Here is what I am trying to do

Form 1 (Contacts) is a simple contact form. When completed, the client is added to a Callback list (confirmed submissions only).

Form 2 (CallBack) is another simple form embedded into the submissions details page for Form 1.

A new client completes Form 1 asking for a call back. Once we have called the client we need to set rsform_submissions.confirmed="0" via the mapping utility so that the client no longer appears in Form 1 submissions.

In Form 1 submissions view, I can see the SubmissionId for the current record in the address bar but I don't know the correct syntax to use to update the matching SubmissionId in rsform_submissions

For example, put crudely -

UPDATE jos_rsform_submission SET FieldValue='0' WHERE SubmissionId= ( the SubmissionId of the record I'm viewing in Form 1 submissions)

Hope that makes sense

Regards

Just as an aside to this

I have tried updating rsform_submissions table using mapping function (update) but it will not allow me to place a zero in the 'confirmed' collumn !