Dynamic HubDB value in email template
02-05-2019 05:55 - edited 02-05-2019 07:23
We have a client with a form with a large selection of options for the platform the user wishes to download - ie .NET, Java etc. Since they can select multiple values, we have some fairly complex workflows and an individual email for each platform. These emails contain links to a thrid party CDN which hosts the downloadable file.
The issue is that these download links change when a new version of a platform is released - and we cannot redirect since old versions also need to be downloadable.
We've therefore set up a HubDB table which will hold the newest release url for each platform. We have a utility already built that automatically updates the link when a new release is...released.
In the email template we've created a choice field, so .NET, Java etc to make it easy for somebody to create an email.
The problem I see is that once that email is saved, even if the HubDB row has updated for the platform that was selected in the choice field, when somebody new submits the form and gets the email, they will - I imagine - get whatever the original saved value was (ie the url of the platform).
Am I correct? Am I even making sense!?
Does anybody have any workarounds or solutions for such an issue?
Thanks in advance.