Order table by hidden column

This forum is for all Flare issues not related to any of the other categories.
Post Reply
ceriwilliams
Propeller Head
Posts: 13
Joined: Tue May 22, 2018 3:01 am

Order table by hidden column

Post by ceriwilliams »

Our release notes contain a table which we update with new information in each release. The rows in the order the customers want to view them, so kind of a random order rather than alphabetically or anything.

Meanwhile, we receive the info to put in the table from another team in a table with the same rows but in a different order. Copying and pasting the cells one at a time is a pain, so I thought the least I could do was have the rows in the same order in the editor, and re-order them the way the customers like in the output.

My solution was this:
1. Order the rows in the topic so they're convenient for editing.
2. Add a new column with numbers that correspond to the row order in the output.
3. In Advanced Sorting, sort the table by the new column ascending, but sort the column on build (so the table remains the same in the editor).
4. Condition the new column so I can exclude it from the output.

I thought I was being clever, but of course Flare excludes the column and then applies the sorting, so actually my solution does nothing.

Is there another way I can apply the row sorting without having this random new column visible in the PDF?
Post Reply