[Isaac Harned]

Definitely some good videos from Liz, but definitely let us know the:

1. Reasoning for the workflow, is this a stamp that will lock down the document?

2. Please let us know if you are trying to place a stamp with a form field in it, or whether you are trying to place a stamp IN a form field. Sounds like the former based on the last response, but maybe some detail of what purpose the text has going into the stamp.

3. Just want to verify the terminology for clarity sake, text boxes are slightly different than form fields. I assume you are looking for the ability to single click into the field and start typing, so this would be a form field.

Here is a sample from the past conference of a custom interactive stamp with some text fields if you would like to use as a base.

Submittal_Approval1.pdf 80 KB PDF - Click to view

Options

• Copy Download Link

[Isaac Harned]

Like Doug says above, there is the hyperlink function, you can place a formula in lets say column P (depends on how long your addresses are, whatever column gets it out of the way) that creates a shortened hyperlink for the addresses pasted in column A. You can then either hide cells, hide tab or copy and re-paste the links. This would be the simplest way, but there are also ways to create a PDF index based on your files as well.

The simple process would look like this, multi-select files and “Copy Full Pathnames” as shown in screenshot below. Then open Excel workbook and paste into desired column.

For the following formula to work, it assumes that there is a separator between the sheet number and name ” – “. It will look for this separator and shorten the link to only display the sheet number. If there is no data, there will be no result shown:

=IFERROR(HYPERLINK(A1,LEFT(RIGHT(A1,LEN(A1)-FIND(“*”,SUBSTITUTE(A1,”\”,”*”,LEN(A1)-LEN(SUBSTITUTE(A1,”\”,””))))),FIND(” – “,RIGHT(A1,LEN(A1)-FIND(“*”,SUBSTITUTE(A1,”\”,”*”,LEN(A1)-LEN(SUBSTITUTE(A1,”\”,””))))))-1)),””)

grabbingFullPAth.png 63 KB Image File - Click to view

Options

• Copy Download Link

[Isaac Harned]

By the way, I am no coder, if curious how I came up with this, check out my conversation with ChatGPT 😂

chatGPTFormula.png 390 KB Image File - Click to view

Options

• Copy Download Link

[Isaac Harned]

So in looking for the answers to one question, I stumbled on a possible solution for this. setAction on a button can be modified by code to “openDoc” instead of “launchURL”. Is this something that would help?

[Isaac Harned]

LOL “Kind Of?”

[Isaac Harned]

Welcome to the party, looking forward to learning some of your workflow!

[Isaac Harned]

Definitely shortens it:

=IFERROR(HYPERLINK(A1,TEXTBEFORE(RIGHT(A1,LEN(A1)-FIND(“*”,SUBSTITUTE(A1,”\”,”*”,LEN(A1)-LEN(SUBSTITUTE(A1,”\”,””))))),” – “)),””)

[Isaac Harned]

A small update to this, I tried to play with some of the trust settings to see if it could be a reason, but no luck. Added the network drive and the specific folder, but still get a security error.

[Isaac Harned]

Heck yeah, just that little spark of, “Oh, THIS is the digital age”

[Isaac Harned]

I think technically you could accomplish it through the A-word, but would be annoying to have to use that every time to update links. Hopefully that API expansion is coming soon and is not a let-down.

[Isaac Harned]

Ok getting more into the weeds of what Liz was referring to with security:

I tried to add a “File//” at the beginning in order to call file explorer if trying to go to a directory. it seems to concat just fine, but gave me a security error when I tried to execute.

It WILL however concatenate to open a specific file, i.e.:

var dataLink = this.getField(“Text1”).value + “M0-22CD Schedules Area CD.pdf”;

app.openDoc(dataLink);

This works and open up right in Revu, BUT it freezes the program for some random reason

Here is the File explorer code if anyone wants to play:

function launcher() {

var dataLink = “file://” + this.getField(“Text1”).value + “/DATA”;

app.launchURL(dataLink);

}

[Isaac Harned]

ok got the base of this working, let me know if I’m on the right track or if you need to do this a different way before I take it any further:

Global code:

function launcher() {

var link = this.getField(“Text1”).value

app.launchURL(link);

}

Button code (mouse up, javascript)

launcher()

If this is the right idea, we can take an input and concat with a set of standard relative locations.

Alternatively, we can use the openDoc method instead of launchURL if we want to open in Revu.

[Isaac Harned]

This is pretty frustrating, it looks like one way to do this would be to place a field on the page to collect the base of the address, then concatenate with a set of standard relative links. Couple of problems I am running into playing with this, and maybe you can expand Liz:

So there is no way that I can see to manipulate active hyperlinks as they are not named form fields, and as noted earlier, Revu has not made a method available to create link.

The work around that I see would be to set the action of buttons or other dashboard items. Unfortunately I am having issues getting the second half of my “setAction” command to work. I am pretty unfamiliar with the usable function calls here, but I have tried a couple, icluding this one, which seemed the most obvious:

(simplified without concatenating for now, just trying to get the base to work)

// Get the value of the form field

var fieldValue = this.getField(“Text1”).value;

// Set the action of the button to follow the hyperlink on MouseUp

this.getField(“Button1”).setAction(“MouseUp”, “this.getDoc().launchURL(\”” + fieldValue + “\”);”);

[Isaac Harned]

I have not, as we would also have to get every revision that way and at this moment, it’s not worth the constant struggle with various document departments.

Hopefully one day it’s just a standard

[Isaac Harned]

Wanted to follow up here on a part of your OP. When you say that editing a .bax is beyond your skill set, have you tried just exporting markups (not a summary), and then just opening the markup file like a PDF? you should be able to edit the markups on basically a blank space before re-importing to your file.