I understand the theory and have started to apply it. However, the formula doesn't seem to work. I have as follows:
WHEN [@Virtual9]='Paid' THEN "https://c1ace471.caspio.com/dp/00118000bee75c1ed6e84ba6b6c4"
WHEN [@Virtual9]='Free' THEN (SELECT COUNT (Virtual10) WHERE DateDiff(month, date, SysDateTime())) = 0) < 10
The relevant fields are present, the pages are created, and I reference the virtual field in the destination. But nothing happens when I select submit (no error or anything, just stays on the submission form). I suspect it is the URLs. How should I be writing them to make the redirects work?