I’ve attached three pages as follows:
- This is the page that has the email server behaviour
- This is the email template page
- This is the page that I want the link in the email to re-direct to. It has a recordset that I want the desired url variable to determine.
I have also attached two screenshots of the database tables that are being queried, as follows
1 - registered_apps
2 - consented_leaseholders