Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

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

Avatar

Avatar
Validate 1
Level 1
nowackem
Level 1

Like

1 like

Total Posts

27 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
nowackem
Level 1

Like

1 like

Total Posts

27 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
nowackem
Level 1

18-12-2020

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=sharing

Thank you in advance!

 

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Establish
Employee
Kosta_Prokopiu1
Employee

Likes

132 likes

Total Posts

310 posts

Correct Reply

87 solutions
Top badges earned
Establish
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile

Avatar
Establish
Employee
Kosta_Prokopiu1
Employee

Likes

132 likes

Total Posts

310 posts

Correct Reply

87 solutions
Top badges earned
Establish
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile
Kosta_Prokopiu1
Employee

22-01-2021

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-4968490fdfc...

Answers (1)

Answers (1)

Avatar

Avatar
Establish
Employee
Kosta_Prokopiu1
Employee

Likes

132 likes

Total Posts

310 posts

Correct Reply

87 solutions
Top badges earned
Establish
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile

Avatar
Establish
Employee
Kosta_Prokopiu1
Employee

Likes

132 likes

Total Posts

310 posts

Correct Reply

87 solutions
Top badges earned
Establish
Give Back 5
Give Back 3
Give Back 25
Give Back 10
View profile
Kosta_Prokopiu1
Employee

21-01-2021

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.