I'm building a URL in a Set Values event handler that links to M3 Experience Designer, injecting a customer number from my tile form's collection.
Let's say the customer number is 123456.
URL expression I'm using:
"https://mingle-portal.inforcloudsuite.com/v2/<TENANT-NAME>/<GUID>?favoriteContext=%3FLogicalId%3Dlid%3A%2F%2Finfor.m3.m3%26program%3Dmp%3A%2F%2F<EDA-SHORTNAME>%3FLogicalId%3Dlid%3A%2F%2Finfor.m3.m3%26title%3DName%20Of%20EDA%26IndexList_Customers.CUNO%3D" + P(CustomerNumber) + "%26SiteLogicalId%3Dlid%3A%2F%2Finfor.m3.m3%26name%3DName%20Of%20EDA&LogicalId=lid%3A%2F%2Finfor.m3.m3"
Resolves to:
...IndexList_Customers.CUNO%3D%22%20%20%20123456%20%20%20%22%26SiteLogicalId...
CustomerNumber is coming through space-padded (and wrapped in quotes) — the CUNO value ends up as " 123456 " instead of 123456. This results in the EDA opening, but not to any customer record.
How do I strip the whitespace from P(CustomerNumber) or from the URL itself so only the number lands in the URL? Trim functions I've tried inline aren't executing. What's the correct approach in this build?
