I'm very much stuck on how to approach this, so any guidance would be greatly appreciated!
Background A client wants to build a simple cloudpage from which entities will fill in their details, and submit this data into SFMC. One of the fields that needs to be submitted is policy_number.
Despite this field already existing in SFMC, entities need to manually submit this via the cloudpage because they are not being sent to the form via email - so I can't do a Lookup. This is not ideal, and I'm tempted to challenge the client on this.
Problem Once the entity has submitted this data, I need to check that the policy_number they input matches what we have in SFMC. If it doesn't, it should be overwritten with the correct policy_number. This is essential as the entity may input the wrong number.
How can I do this? I believe that if the entities were sent the cloudpage via email, I can simply pass through their details with ampscript, and do a lookup to validate their information.