[Doug McLean]

You can also get really creative and use Excel commands to get you a dynamic file name.
If you have O365 you can use the TEXTBEFORE and TEXTAFTER commands, or the LEFT, RIGHT and MID functions.

[Doug McLean]

You don’t have to place a markup if you don’t want to.

In the Excel cell you’re going to type =HYPERLINK(<filepath>, [friendly name]).

This will open the drawing from Excel.

[Doug McLean]

Hi Gary,

Yes.
In Excel there is a formula called Hyperlink which will allow you to do this.

What you will have to do though is first break the drawing package into individual files.

HYPERLINK requires one argument, plus an optional argument, link location, [friendly name]

The Link location is the filepath; just copy and paste it in. The friendly name is just that, an easily recognizable name

Here is a really easy tutorial to get you started https://exceljet.net/functions/hyperlink-function

[Doug McLean]

Hey Bruce

At least you found the party… lol

Never too late to start learning.

Like Troy said, we look forward to learning as much from you as you do from us

[Doug McLean]

What you might need is a dynamic stamp.

Here are two people who could help you out

@lizlarsen @isaac-harned

[Doug McLean]

Layers are something I’m just opening our team up to in Revu. With most of our people familiar with ACAD layers, this isn’t too hard to explain, its more about knowing what they can do.
With any luck, more and more people are going to start to see the benefits.

[Doug McLean]

Yesterday, I walked the PM on this project through adding a Custom Tool chest to Revu.
Just a little something I created, very similar to the Architect Review tool chest that comes stock with Revu.
At the end of this, he says to me now you’ll have to show me how to use this because this is the first time I’ve seen this tool chest thing. 🤯😱
We have far too many people here using the tool bars, and not the tool chests when they’re doing their markups.

The Project Coordinator on the job LOVED the idea, and what options it will give her.

THIS is what I’m starting with.

[Doug McLean]

Makes you wonder if many of these are the reasons that Bluebeam Cloud really hasn’t taken off like they thought it would.
People want their software to work, not be glitchy.

[Doug McLean]

I’ll have to find some time to watch this one.
The problem with this being the middle of the work day is that well, I have to work… lol

[Doug McLean]

learn the TEXTBEFORE and TEXTAFTER commands…. SO much simpler than the dreaded LEFT, MID and RIGHT…. lol

[Doug McLean]

hmmm…. that could work

[Doug McLean]

🤣🤣🤣

[Doug McLean]

One of the things I’m finding initially is to use the Tool chest tools, rather than the Tool BAR tools.
I set us specific tool chests for the various job descriptions, that are all colour coded, specific subject, and set layers… now its getting everyone to USE those instead of the generic ones that live on the tool bars.

[Doug McLean]

right now, its just in the beginning shop drawing stage.
We’re doing all the project startup stuff, finalizing schedule, finalizing scope… all that stuff.

Its going to be pretty wild when its all done.

[Doug McLean]

I like the Lunch and Learn idea. I should schedule one of those.

One thing I’m going to do is go way back to the old TWI methods.of training where you show quick, show slower with some explanations, and then show again with more explanations and more whys. That method has worked for decades, yet we abandoned it.

I used it with our previous Estimator and she was fully up to speed in 6 weeks.