Member Isaac Harned
Member
Forum Replies Created
-
Points: 8,204Rank: UC2 Brainery Purple Belt III
Thank you Doug, we are about to make the switch to Sharepoint, so this is extremely useful knowledge!
-
Points: 8,204Rank: UC2 Brainery Purple Belt III
I am playing with this one, but doesn’t look like an easy fix right off the bat. Nothing obvious in coding that I can see, and I’m pretty sure the calculation script is smart enough to account for missing items, but maybe @lizlarsen might have more of an idea.
-
Points: 8,204Rank: UC2 Brainery Purple Belt III
Paste your snapshot to the page, add to toolchest. Once in toolchest, right click and select “Create Count”
-
Points: 8,204Rank: UC2 Brainery Purple Belt III
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.
-
Points: 8,204Rank: UC2 Brainery Purple Belt III
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)),””)
-
Points: 8,204Rank: UC2 Brainery Purple Belt III
By the way, I am no coder, if curious how I came up with this, check out my conversation with ChatGPT 😂
-
-
Points: 8,204Rank: UC2 Brainery Purple Belt III
Fair enough 🤣
-
Points: 8,204Rank: UC2 Brainery Purple Belt III
Yes, this is the intention, unfortunately our count tools are pretty extensive, and it is hard to distinguish without the description. Without seeing the details it makes the convenience a mute point.
-
Points: 8,204Rank: UC2 Brainery Purple Belt III
I don’t think so, the attempts I did were not writing code, but manually creating the link and opening through outlook or word. I can write the hyperlink formula to work once I know how the link needs to be formatted in the first place.
-
Points: 8,204Rank: UC2 Brainery Purple Belt III
Negative, really hoping someone out there might know more. I even pulled the doc up in Adobe to verify it recognized the named location. Makes no sense since Revu supports the location.
-
Points: 8,204Rank: UC2 Brainery Purple Belt III
Here are all the formats I tried to make it work for default open, switched my convention from single letter to “Grille” later
H:\HOU\Office\PROJECTS\2210327\DATA\Submittal\23 37 00-1 Air Inlets and Outlets – PD_SSA_CD.pdf#page=D
\\Fs01\data\HOU\Office\PROJECTS\2210327\DATA\Submittal\23 37 00-1 Air Inlets and Outlets – PD_SSA_CD.pdfpage=20&nameddest=D
H:\HOU\Office\PROJECTS\2210327\DATA\Submittal\23 37 00-1 Air Inlets and Outlets – PD_SSA_CD.pdf#page=20&nameddest=D
\\FS01\DATA\HOU\Office\PROJECTS\2210327\DATA\Submittal\23 37 00-1 Air Inlets and Outlets – PD_SSA_CD.pdf#20&nameddest=D
file://\\FS01\DATA\HOU\Office\PROJECTS\2210327\DATA\Submittal\23 37 00-1 Air Inlets and Outlets – PD_SSA_CD.pdf#page=20&nameddest=D
\\FS01\DATA\HOU\Office\PROJECTS\2210327\DATA\Submittal\23 37 00-1 Air Inlets and Outlets – PD_SSA_CD.pdf#page=20&nameddest=D
\\FS01\DATA\HOU\Office\PROJECTS\2210327\DATA\Submittal\23 37 00-1 Air Inlets and Outlets – PD_SSA_CD.pdf#page=20&nameddest=Grille
\\FS01\DATA\HOU\Office\PROJECTS\2210327\DATA\Submittal\23 37 00-1 Air Inlets and Outlets – PD_SSA_CD.pdf#Grille
\\FS01\DATA\HOU\Office\PROJECTS\2210327\DATA\Submittal\23 37 00-1 Air Inlets and Outlets – PD_SSA_CD.pdf#page=20
-
Points: 8,204Rank: UC2 Brainery Purple Belt III
As I understand it, this should be possible, but would not use bookmarks. It would use “Named Destinations”, or as Revu calls them, places. You can find these in the links tab. I can’t seem to get the feature to work though, and some forums are saying that it only works for URL links. Here is an article:
See below screenshot for description of “Places” in Revu
-
Points: 8,204Rank: UC2 Brainery Purple Belt III
Definitely shortens it:
=IFERROR(HYPERLINK(A1,TEXTBEFORE(RIGHT(A1,LEN(A1)-FIND(“*”,SUBSTITUTE(A1,”\”,”*”,LEN(A1)-LEN(SUBSTITUTE(A1,”\”,””))))),” – “)),””)
-
Points: 8,204Rank: UC2 Brainery Purple Belt III
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.
-
Points: 8,204Rank: UC2 Brainery Purple Belt III
Heck yeah, just that little spark of, “Oh, THIS is the digital age”