I made a database that lists tasks and generates a list of summaries of them into a text field.
Users can copy the content of this field and paste it into a wordprocessor, and then apply a wordprocessor paragraph style so as to almost complete that part of their invoicing job.
But the listing in the wordprocessor needs a line break within each paragraph - usually keyboarded as Shift-Return. I have not yet been able to find a way to make the script which assembles the summary listing into the text field put a Shift-Return in the correct place. As a result, users have to manually click at the spots and press Shift-Return - nasty!
I managed to make the calculation place tab characters (by copying a tab character out of a wordprocessor and pasting it into the calculation), but this doesn't work for Shift-Return.
How can I make a FileMaker calculation insert a Shift-Return?
Many thanks, Graeme