Sydney, thank you for the comprehensive summary - I agree with you on all points! We've been using PHQ for over a year and are mid-launch with WF so are now looking at WF Doc Approval vs PHQ Approval for our creative projects. I expect we will stick with the PHQ process since we can see the workflow...

Hi Layne, Thanks again for the above. For your consolidated notes report, are you combining them at all? I've made a few sad attempts at using sharecol to include the Note Text, Entry Date and Updated By fields (grouped by project on a note report). I wondered if you were doing something similar a...

Hi Kathy, brilliant! Confirmed with testing and will implement this weekend. Many thanks for your time and knowledge sharing!

Just came across this - very helpful!! Thank you!

Hi Kathy, So, as I was reviewing the data before I switched the field on the form last night, I noticed that the URL some users entered included search string characters at the end (ie ?sr458=q&....). Apparently it depends on how they navigate to the URL in question. I now need to account for thos...

great, thanks again! Now to see where else I can have fun with these tidbits ;)

Hi Kathy, thank you so much, that works beautifully! I'm learning expressions and intuitively I see what you did but can't put it into layman's terms. For future need, do I have this correct? It is taking the right length of the string before .com/ and subtracting it in addition to subtracting the 5...

I have a custom field that is manually entered with a URL. I am trying to make a calculated field on the same form which will return everything after the last / in the URL field. While I did get SUBSTR({field},#) to work, I would prefer to say that the starting point is what comes after the ".com/" ...

Hi Adina, same here - mind another email? Thanks!

Hi Nate, I came across this helpful thread today and wondered if you had moved the text expressions? The link you gave last year no longer works: https://communitybeta.workfront.com/p/do/si/topic=82. I checked out the Resources section but there hasn't been anything added to the Report Templates &...