We would like to produce a report that contains the field "Course Name (linked to course page", export the report, and have the link remain active. I have tested the CSV, Excel, ODS, and PDF exports for this report but haven't found any where the link is active.
Our partner says they can't find any way to do that but I thought I'd check in this community before giving up.
Thanks.
Carol.
Hi Carol
The exporting options for reports use plain text unfortunately - an improvement request would have to be made to implement this.
Regards
Hi Carol
It's not perfect, but when I had to do this once I exported the course report with the course ID as a column. That gives you the end of the URL you need to make your link. Then in the excel spreadsheet, you just need to bulk add the rest of the course URL [https://[site url]/course/view.php?id=] to that column before the number. To do that, add in an extra column, and in that column user the formula ="https://[site url]/course/view.php?id="&[cell where ID number is]"
Sounds a bit complex but only takes a minute or two if you know what to do. Does require admin, but when you save it as an excel sheet the link will work.
Hope that helps
- Matt
Thanks, Craig and Matt. I will try concatenating the ID # and will also make the request for the change through our partner.
Carol.