Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have details of a sheet based on a given value and I want to copy the resulting URL to clipboard, either via script or UI, using a button object.
Example URL which changes based on the highlighted value (in red) the user selects from another sheet:
http://server/abcd/opendoc.htm?document=Dashboard.qvw&select=LB01,20460&sheet=SH04
Can you elaborate a little with some example data? What is that red value where is that value coming from? Where is the URL stored?
Hi Vishwarath,
From Sheet 01, for example, we have the following data....
Project Name Project Number Leader Workstream
==========================================
ProjectA 12344 Leader1 WS1
ProjectB 12345 Leader2 WS2
ProjectC 20460 Leader3 WS3
When the user clicks on the Project Number (ie, 20460), a new sheet opens (SH04) with just the details for that project number (Name, Leader, Workstream). That sheet has it's own URL (as indicated in the original post). The user is asking for a way to simply copy that URL to clipboard. I know that they can simply highlight the URL from the browser and copy, but they want a button that can do that.
Thanks for any help!
Read this if this could be of any help?
URL Composer = compute an Access-Point link and pass selection values, open sheets etc.