Sorting Data in a Dynamic Table - Need blank rows forced to the bottom after the sort.

Question

Hello All,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. My Designer PDF is located at the link below.https://drive.google.com/drive/folders/1Qhz-DNYM40ECzUGEl2w34egEzhKBaaoV?usp=sharingThank you in advance!

Kosta_Prokopiu1 · Accepted Answer

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.

https://documentcloud.adobe.com/link/review?uri=urn:aaid:scds:US:68787b63-a702-4977-b0c6-4968490fdfc9

Kosta_Prokopiu1 · Answer

Hi,here is a bit of a hack that seems to do what you want based on the existing logic. Try it out by replacing the sortRoutine in the script object.... the solution would not work under all circumstances - see my sample in a later post.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded