Anyone experienced an issue where when printing a ...
# advancedpdfj
jen
09/07/2023, 11:23 PMAnyone experienced an issue where when printing a Long Text field on Advanced PDF/HTML template it cuts off everything past 1000 characters?
jen
09/07/2023, 11:23 PMUse Case: We have a list of custom records A showing on a custom record B. Transactions have a single select of type B on them. I want to show a text summary of the As on my transaction in Advanced PDF/HTML template. I know I won’t be able to directly access the sublist via Advanced PDF/HTML template, so to achieve this, I created a custom field on B of type Long Text that updates itself whenever something on the sublist changes. Then, I display this field on my transaction template.
d
David B
09/07/2023, 11:28 PMfound the same issue here , answer was 'file a support case'
David B
09/07/2023, 11:30 PMwonder if you could
<#list record.longtextfield?split('<br />') as text>${text}<br /></#list>David B
09/07/2023, 11:30 PM(if the list of custom record A's are separated by newlines in the long text field)
s
scottvonduhn
09/08/2023, 1:18 PMI seem to recall this being a known limitation.
The likely workaround would be to, create 2 or more fields, text_summary1, text_summary2,
scottvonduhn
09/08/2023, 1:19 PMand having the code updating the current text summary split it every thousand characters, and save it in the corresponding field
scottvonduhn
09/08/2023, 1:22 PMthough, perhaps formula fields returning characters 1001-2000, 2001-3000, etc. would also work, and probably worth trying first
👀 1
j
jen
09/08/2023, 4:00 PMwe can’t predict how long the text will be, so don’t have a solid way to know how many fields we’d need
n
NElliott
09/11/2023, 1:21 PMDepending on when / where you are printing this...
You could dynamically create custpage_ fields containing 1,000 characters each.
If you also dynamically added a custpage_ field with a count of how many you have and keep your field names sequentials.
In your template pick up the count and then you know how many custpage_ fields to pick up. which you could do in a loop and concat the fields.
custpage_text_1
custpage_text_2
etc etc
j
jen
09/11/2023, 4:25 PMThe problem I’ve had is that UE scripts that are supposed to execute on
printn
NElliott
09/12/2023, 1:57 PMThe context of "print" I thought was only when the user specifically pressed print, but happy to be proven wrong.
j
jen
09/12/2023, 5:48 PMthe UE doesn’t get called at all as far as I can tell when you are using the
INCLUDE TRANSACTIONjen
09/12/2023, 5:49 PMNS Support offered a workaround. Apparently it only truncates if the field is on a subrecord. So I made a non-stored version of the field on the transaction itself, and sourced it from the child record. That seems to be working. Stupid that it’s necessary.
👀 1
slack bookmark 1
d
David B
09/12/2023, 8:49 PMwonder if that's documented anywhere....
j
jen
09/12/2023, 9:53 PMlol
jen
09/12/2023, 9:54 PMunlikely
💯 1
27 Views