I have successfully utilized the sort table function within a dynamic table using the John Brinkman Sales Report file. It works beautifully, the magic is in the Variables script. It would be amazing to take this one step further and update the code to always list any blank rows at the bottom of the table no matter if the sort is ascending or descending. John's script does not account for this so if anyone can help me tweak this code to make that happen, I would be eternally grateful.
I think I found a solution that works for different field types. If you want numeric input to be sorted numeric then your field must be Number or Decimal - otherwise it will sort as text.
Thank you so much! I appreciate your time. I replaced the sortRoutine script and realized when testing that it didn't force the blank rows to the bottom so if you have any ideas on what I can do differently I would love to hear them. Unfortunately using this updated script or my original script is crashing Designer in the HTML preview. Any advice or thoughts on how to make this work in both PDF/XDP and HTML for AEM would be appreciated.
We are in the phase of building our 2000 forms from Word and Excel into Designer PDFs. Then we will take those and produce XDP files which will then be uploaded to AEM environment for publishing. We will eventually get them into Adaptive but for now, I'm trying to get them into XDP as HTML5 keeping in mind the end goal is Adaptive forms. We are a govt agency so its the path I have to take. Does that help explain my situation?
I opened the file in Acrobat and it does not keep the blank row at the bottom of the table. I also see that if I use digits that vary in decimal placed they do not go in the proper order, i.e., 10 is a lower number than 3 in the sort. Is the sort working on your system?
Thank you for all the information with the HMTL! This is helpful. I see now that this sort works alphabetically and it even works on the dates. This is a generic table that i'm working on for my team to use in their forms if the need arises. It could include numbers such as check numbers. Is there a way to cover both basis? This is kind of a template if that makes sense.
My last post as it is late here in Germany. My trick does not work with numbers - only with strings - that is why it did not sort the empty columns for you. I guess that algorithm needs to be changed big time and we somehow need to check the field type. The table fields all seem to be interpreted as text. I have to think about it - we will talk next week.
I think I found a solution that works for different field types. If you want numeric input to be sorted numeric then your field must be Number or Decimal - otherwise it will sort as text.
