You can set to update database table values depending on certain set conditions. To do that you need to go to Form Maker –> Forms, select the form submissions of which you want to update.
Click Settings then MySQL Map.
Now select Local or Remote (enter credentials for Remote) and click Update, then click Connect.
Select the table you want to update.
Now select the field you want to update and the data you want to update it with. For example, update “post_author” with Name.
But we want to update it depending on a certain condition. Scroll down to Query text box and set the WHERE conditions you want.
For example, you want to update only if it’s not already the Name. Put “post_author” != {2}
Once you’re done listing all the conditions, click Generate Query and then Save.