RFE: UI to manually enter an out-of-band opt-in confirmation

[kgaillot]

Issue

Some email recipients have trouble clicking the confirmation link in opt-in confirmation emails. (Don't ask me why, but it's apparently a common problem in my target audience.) If I email them directly and ask whether they want to receive emails, they are generally happy to say yes via an email reply.

Expected Behavior

It would be nice if a user could manually indicate that an email recipient has confirmed opting in to emails via a direct email conversation.

Actual Behavior

I've been handling this via SQL:

UPDATE email_addresses
SET confirm_opt_in = 'confirmed-opt-in', confirm_opt_in_date = '...'
WHERE email_address='...';"

Out of convenience, I haven't been updating email_addresses_audit, but I'm not sure whether that might cause problems down the line.

Possible Fix

New item in Actions menu for Leads etc. to manually provide email opt-in confirmation.

I could imagine some installations wanting to disable the capability or limit it to certain users.

Steps to Reproduce

1. Set up opt-in confirmation.
2. Have an email recipient unable to select the confirmation link.
3. Watch helplessly.

Context

Your Environment

• SuiteCRM Version used: 8.1.2
• Browser name and version (e.g. Chrome Version 51.0.2704.63 (64-bit)): Firefox 102.4.0esr (64-bit)
• Environment name and version (e.g. MySQL, PHP 7): MariaDB 10.5.16, PHP 7.4.33
• Operating System and version (e.g Ubuntu 16.04): Fedora 36