Skip to main content
C
cpounds217
Participant
May 29, 2018
Question

Move and Sort in PDF

  • May 29, 2018
  • 1 reply
  • 1047 views

Hello All!

I am working on a project at work where I allow the user to assess some hazards to their location. The result is that the hazards are given a value and a qualitative ranking. I now need to be able to move those hazards to a ranking list, but have them sorted, highest to lowest, based on their output value.

For example:

HazardValueQualitative Ranking

Tornado

50High
Hurricane45High
Earthquake38Mod. High
Terrorist25Med. Low
Flood11Low

Before that they would be in order based on the user's initial input: Hurricane, Terrorist, Flood, Earthquake, Tornado.

My thoughts are this: The values of the hazards would be assessed, maybe into an array, then placed in highest to lowest order into the next page (where the ranking occurs), and then the corresponding hazard is found and moved to the hazard text field, next to the value text field.

If this isn't possible, then I will need to investigate other ways to potentially produce this output, as it is a necessity of this project.

I currently have this tool built in Excel, but it is very laggy, especially compared to the user-end of the current PDF tool.

Any help you can provide will be greatly appreciated!

Thanks,
Christopher Pounds

This topic has been closed for replies.

1 reply

J
joelg68944244
Participating Frequently
May 29, 2018

Is there a maximum number of hazards? How are the hazards selected? (checkboxes? a drop down? something else?)

If there is a maximum number, this will be pretty easy but you'll need to respond to the above before I can advise more. If not, don't bother trying this with a PDF form unless you want to get into developing a Dynamic Form using Adobe LiveCycle which is... let's call it... "challenging".

    C
    cpounds217Author
    Participant
    May 29, 2018

    So there is currently a "maximum number of hazards". This would apply to another section which also has a maximum number of values as well.

    The current maximum hazards is 20, but will most likely increase (if I can move forward with the sort process) to 25-30.


    The other values currently max out at 60, but may (if the need is present) be moved to 100.

    The form is not dynamic in its allowance of inputs, and while that might be handy to do, it is not a function I have the capability to build (no LiveCycle at work - to my knowledge), nor do I want.

    I hope this helps you help me!

    Thanks

    J
    joelg68944244
    Participating Frequently
    May 29, 2018

    Ok - With a maximum number of hazards, the "list" of field values will end up being generated based on the user selections. Is the user selecting checkboxes? That would be the most efficient. Will any two hazards have the same value? If so, what would be the secondary sort criteria?

    Essentially what will happen is as the user selects (checks) hazards, a script will look at the chacked boxes and fill the list values. The list will actually be all read-only fields. You won't be "moving" any fields, they'll just repopulate with every check/uncheck.

      Terms & ConditionsAccessibility statement
      Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices