[Isaac Harned]

Thoughts and prayers man, that’s a rough one.

[Isaac Harned]

I feel like I’m going crazy, does this stuff not save to the toolset on y’alls side?

plz read video description

Custom-Column-Tool.mp4 30 MB MP4 - Click to view

Options

• Copy Download Link

[Isaac Harned]

Hmm I can add custom column info on my side without placing the markup and it seems to save. Maybe I am understanding wrong? You may have to add the custom columns to your profile before you can see them on your custom tools

[Isaac Harned]

Merry Christmas and Happy New Years to everyone!

[Isaac Harned]

If you want to play with the triggers to see if there are any convenient use cases for you the code itself would be pretty simple: “getField(“FIELDNAME”).setFocus();”

You could try to set this “on blur” so that when user click away from cell, it moves them to the desired. May be the closest you can get.

[Isaac Harned]

Sorry for the delay, just getting back from that sweet sweet PTO.

I think you are trying to move from one form field to another, which there is not easy way to do that I know of as the triggers provided for the script to activate can’t detect a specific key pressed. Best I can tell you is to set the Tab Order so you can tab to this next.

But yes also as Troy says, if it can be solved in a single form field then that would probably be the preferred route.

[Isaac Harned]

Try F9

[Isaac Harned]

Unfortunately I do not know of a way to do this programmatically yet.

Have you tried creating a scaled toolchest instead? I don’t deal with measurements that often but maybe someone might have some input here @Doug McLean @Vince

[Isaac Harned]

If looking for the quick and easy solution to QTY it would probably be counts. In the snapshot below I run a search for all SSL176 (your parameters obviously might be different) and then applying counts (stored in a pre-made tool chest with columns to show lengths perhaps?) to all the results except the descriptor. You can then activate a legend out of your custom toolchest and apply to all pages with appropriate columns displayed.

For Panel locations, one idea for this specific example could be to create “Spaces” which would have the name of the panel, and then once you have your counts applied, select all and shift to the right so they are located “in” the panel. Then activate space separation on your legend to include the info.

Screenshot-2023-12-08-141928.png 394 KB Image File - Click to view

Options

• Copy Download Link

[Isaac Harned]

Guaranteed Troy is right behind me with, “Yes! More legends!” 😂

[Isaac Harned]

I don’t think so, the form fields are dead on arrival, and there’s really no custom column to apply that would catch all the selections.

[Isaac Harned]

Is the toolchest on a network drive, and does everyone load it from the same location?

Usually I will export to local to avoid the toolset locking and being shared, but also exporting the whole profile with dependencies will isolate the toolchests to each person. Then just keep a backup so that it can be reloaded when needed.

[Isaac Harned]

🤣 This sounds like it needs to be a podcast slogan

[Isaac Harned]

Thank goodness 🤣🤣🤣

[Isaac Harned]

Oh yeah I feel that, drove me crazy for a couple days. Very frustrating that it’s one of the only shortcuts you can’t change either lol. Oh well, removing F keys from my keyboard seems to be a trend (thank you excel F1 help for starting that one)