Hi @RMazzoldi,
The short answere here is that HubSpot simply does not offer that functionality, at least not to the point where it’s meeting your requirements. Web-forms are a one-way tool. They can’t look up or verify information in the CRM. (If that was possible, it would be a surface for attackers.)
For a true functionality that allows contacts to both check their information and change it, a log-in area, allowing contacts to manage their account would be needed.
That being said, let me address some of your individual points:
@RMazzoldi wrote:
The personalized email prepopulates the form page with CRM data (Not working)
This is working, I’ve explained this before, for example here: https://community.hubspot.com/t5/Tips-Tricks-Best-Practices/pre-filled-forms/m-p/815417/highlight/true#M3835
@RMazzoldi wrote:
The “Pre-populate form fields for returning visitors” setting appears to just take browser cache and so is somewhat useless for my case - I Do not want to take cache, I want data from the CRM for the submitted email. How to I get this to occur?
See above – however, as mentioned, you cannot have the form look up information in the CRM, that would be a data security nightmare. You can only pass information through the email into the browser via parameters. (Keep in mind that forwarding the email means that the recipient now has all of this information.)
@RMazzoldi wrote:
Submission that don’t update the DB still provide a successful response to the user. How to I stop this? If the update failed it should tell the user to contact someone for support
Because of the one-way-logic I described, this is expected behavior and cannot be changed. The form does not know whether it’s submitting new or existing information. The confirmation is shown because technically, it is working. Anything else would require custom development.
@RMazzoldi wrote:
How do I ensure secure access to the update/signup form? I don’t want someone updating someone else’s account by - for example - allowing them to enter whatever email they like into the update form (I have tested this and at the moment it does allow arbitary writes to other contacts. Where can I control this?
Unfortunately, this is again a limitation in HubSpot. It’s not possible to prevent someone from just sending form submissions for a list of email addresses and thus updating contact records in your system.
Other users have requested this before: https://community.hubspot.com/t5/HubSpot-Ideas/Being-able-to-disable-automatic-field-updating-from-outside/idi-p/517338
These requests submitted to the HubSpot Ideas section of the community are reviewed by the HubSpot product team, based on their popularity and the assumed demand. I’d recommend commenting and upvoting.
You can also help other HubSpot users find this request more easily (and drive traction) by accepting my reply as a solution. I’d appreciate it, too.
Have a great day!