parsing and concatenating layout names...
I'm trying to replace several "go to layout XXX" scripts with a single script. The layout names are standardized as "Invoice List", "Invoice Details", "Client List", "Client Details", etc. I have a button on each List layout that takes the user to the Details layout for the selected record. I thought I could replace the last word of each layout name (List) with "Details" and then use Go to Layout (xxxxxx). Something like this...
Go to layout [ LeftWords ( Get (LayoutName);1))+" Details]
It ain't workin'. I've also tried Replace, Substitute, and Get as Text.
Any ideas? Any help would be greatly appreciated!