I am developing a public application that allows users to submit a form without requiring a login. However, it is crucial that each user can only view their own submitted form and not those of others.
Currently, I am utilizing user-specific columns for the form submissions. Once submitted, the data is transferred to another table that is accessible only to logged-in users, ensuring privacy and security.
Is there a method that would enable a public user to save their progress and return to complete their form at a later time? Would converting the user-specific columns to standard columns and incorporating a randomly generated ID be a secure and effective solution?