[Liz Larsen]

It was something they sent you if you signed up for it at the kiosk in the Interactive Zone at XCON2022. Otherwise, if you have Bluebeam 20 or below, you have to pay for access.

Bluebeam University is included with Bluebeam 21, though (I’m pretty sure).

[Liz Larsen]

Dude, where did you get that hat???

[Liz Larsen]

I’m not sure how to do it with a Studio Project, though.

Maybe someone else here knows?

[Liz Larsen]

If it’s a Studio Session, whoever created the session needs to log into studio.bluebeam.com and select the Session. Then change the Status to Active. Then click Update Data.

See attached screenshot.

[Liz Larsen]

So I fiddled with this, doing all the things you did. I even renamed it various names that should work, like “test”. Still returned undefined.

Then I decided maybe that particular textbox was glitchy and I’d remake it. I copied it, deleted it, then CTRL+SHIFT+V, named it back to the original “FreefillAct1-1” and it worked ¯\_(ツ)_/¯

Who tf knows?

[Liz Larsen]

I’m looking into this. I have a secret resource that can probably shed some light on this.

I’ll report back when I know more.

[Liz Larsen]

@isaac-harned Mitch says:

Quickest way [to bring data into a PDF] is to create a FDF with Excel and then to open it with Bluebeam. How I deal with a large amount of the same forms are to copy and rename the PDF form template with Excel and create all of the FDF files in the same folder. I then open all of the FDF files then close Bluebeam and save on close. The whole process takes about 2 min to do for 150 or so PDFs. Best way I’ve found to go from Bluebeam to Excel is CSV, and FDF is the best way to go from Excel to Bluebeam.

I hope this helps!

[Liz Larsen]

Actually, I’m being silly. @isaac-harned , my resource is your resource.

I’m reaching out to Mitch. Hopefully you didn’t already try that avenue.

[Liz Larsen]

I haven’t checked in to UChapter2 in a couple weeks and boy oh boy am I excited to see some more coding questions. It’s like Christmas Part 2! You have the best questions, @isaac-harned 🙂

I will take a closer look at this probably tomorrow and over the weekend.

[Liz Larsen]

In the spreadsheet, you can see there are different groups of data. For example, 113, 113.01, 113.02, 113.03 are grouped together as 113.fdf. The VBA macro goes through this spreadsheet and separates the different groups, then takes all their respective information and creates an FDF file based on a template PDF file.

Each FDF file is a separate group of data that tells the PDF what data to put in which form field. One FDF file for each PDF form.

I hope that answered your question.

This is a highly customized VBA macro doing all the heavy lifting. This macro only works with this specific spreadsheet. To modify it to work with another spreadsheet would basically require rewriting the whole thing. It’d probably only be worth it if you’re doing this a lot, like in Mitch’s case where he’s creating 150 all at once.

[Liz Larsen]

I know you all think I know this sh*t really well, but I always feel like an idiot child next to @mitchyoungs . He’s so frickin smart and I just stand back in awe like I’m sure everyone else is right now.

And I’d like to thank @isaac-harned for literally asking the perfect question to get Mitch to join the Brainery 😂

[Liz Larsen]

Hey, no guarantee it’ll work for Isaac. I’m interested to see what his results are.

[Liz Larsen]

Ah, ok. Out of my depth here 😅

[Liz Larsen]

@isaac-harned It’s under Tools –> Form –> Export Data

[Liz Larsen]

I’ve always used the middle mouse button to pan while mid-markup.

But I did not know the spacebar trick. That is a Grade A pro tip right there, sir.