Looked all over the place there are great step by step tutorials to insert a record and upload files and save the file name in the database, but it seems there is a lack of tutorial to update that filed in the database and the image name in the database if there is file change as well not only text inputs, like if I update how ignore if there is no file selected or how to update the field with the new name and delete the old file from the system, can someone point me out if this tutorial or how-to guide exists and if not could wappler create such how to?
You can set a condition (from Core actions category in server connect actions menu) to verify if there’s a new file uploaded or not. If there is, find the old file in the database using a query, remove the file from the server (under File management category in server connect actions menu) , and update the field with the new file’s path.
As Emiel has correctly suggested, using conditions is the way to go.
You can put in multiple conditions inside the same server action to determine what all activities you need to perform.
For each condition in your rule, you can set what you want to update/upload/insert.