Another question:
Will I be able to generate invoices using Pages and import fields from Tap Forms to the invoices?
Thanks,
Sal
Hello Sal,
I don’t think this would work. There’s no merge capability in Pages as far as I know. Even if there was, there’s no facility in Tap Forms to transmit a record over to Pages.
Thanks,
Brendan
Well, other than maybe exporting your records as a CSV file and somehow importing that into Pages. Maybe it’s possible, but I’m not sure. I know you could import a CSV file generated from Tap Forms into Numbers or Excel though. And from there you may be able to do what you want.
Thanks,
Brendan
FWIW, should you know LaTeX, you can import the CSV file and create a report in any format using the datatool package …
Suppose you have exported your TapForms invoice database as myinvoiceDB.csv. It contains the fields paid (checkmark) and lastname (text). Here is how you can prepare a list of clients, sorted first by paid status and then by lastname.
\documentclass{article}
\usepackage{datatool}
\DTLloaddb{invoices}{myinvoiceDB.csv}
\begin{document}
\DTLsort*{paid?=descending,lastname}{invoices}
\DTLdisplay{mylist}
\bigskip
Paid status as of \today
\end{document}
—
JJW