Dragging Numbers:
Type "0" into the top line (the one that doesn't move/the Overall Title line)
On the next line down, type =, then click on the box above.
You should see =02
Drag down
To Add in a Colon
Do action 2
In the column next to your first number after 0, type =CONCAT(":",O2)
The O is the column of the number from action 2. Change accordingly.
To Skip Count
Complete action 2, but add a +3 (or whatever you want to skip count by) onto the end
Ex. =O1+3
SQL Queries
Field Map:
SELECT FIELD AS FieldName, TRIM(SUBSTRING(FIELD.TYPE FROM 1 FOR 2)) AS Typ,TRIM(SUBSTRING(FIELD.TYPE FROM 3)) AS Nbr , FORMAT, FUNC, F3 AS OutputFmt, SM, ASSOC.NAME FROM DICT xxxxxx ORDER BY FIELD.TYPE, FIELD;
Books Query:
SELECT PARENT, BOOK, TITLE, SUBTITLE, COMMENTARY, REFERENCES FROM BOOKS WHERE AUTHOR = 'F.B. Hole' ORDER BY WEB.ARTICLES.SORT;
Author Query:
SELECT AID, NAME, FULL.NAME, NAME.INVERTED, VARIANTS, WEB.OK, NOTES FROM AUTHORS WHERE NAME.INVERTED LIKE 'A%' ORDER BY NAME.INVERTED;