AnsweredAssumed Answered

Changing sort order in multi-column layout for flashcards

Question asked by otto_m on Nov 18, 2016
Latest reply on Nov 18, 2016 by David Moyer

Hi everybody,

 

I have a simple vocabulary database with these fields:

Field1 (Text) = word in Arabic script

Field2 (Text) = word in Roman script

Field3 (Text) = German translation

 

To produce flashcards, I print them on labels with 4 fields across and 8 fields down in the order:

A – B – C – D

E – F – G – H

I – J – K – L

etc.

 

This works fine for the front, but I have not yet figured out a method to print the back in reverse order:

D – C – B – A

H – G – F – E

L – K – J – I

etc.

 

In Field4 (Calculation),

“Let ( R = Get ( RecordNumber ) ; Ceiling ( R / 2 ) + ( Mod ( R ; 2 ) ) /10 )”

to sort the fields in a new layout to print the back in reverse order.

 

The calculation sorts fine in two-column layouts (B – A ; D – C etc.), but I am not able to modify the calculation so that it sorts across four columns (D – C – B – A ;  H – G – F – E etc.)

 

Would you please help me out?

 

Many thanks in advance,

 

Otto

Outcomes