Your solution is using a web viewer to view the folder contents. This means that the web viewer is expecting no spaces as this character is usually encoded as %20.
You can use function to replace the space with %20 or you might use the GetAsURLencoded function instead.
GetAsURLencoded ( FolderURLWV )
Thanks Phil for the help. I'll give both of those a try this weekend. I'm happy my question made some sense to you.
As a minor update, I've found a couple pieces of confirmation that FileMaker has a bug that "double encodes" or maybe just doesn't properly encode URLs.
In this case, FileMaker appears to see the space and then properly encodes the URL with a %20. If it stopped there, it would be fine, but it appears FileMaker then runs another encode pass over the new URL and now catches the % that's been added. Thus, it changes the space in the address to %2520 (%25 being the ascii code for %, if that makes any sense).
It seemed like I should be able to modify the URL opened by the web viewer by doing something like,
Substitute (Patients::FolderURLWV;"%2520";"%20") - if that would work better
But those substitutions have no effect.
I can, however, do Substitute (Patients::FolderURLWV;"Mary";"TEST") and, sure enough, I see the URL the web viewer trying to open a URL modified by adding "TEST" instead of Mary.
So, I feel like I'm getting closer to discovering the cause and a potential workaround. Does anyone have any additional ideas?
Thanks so much!