Formating a list as separate paragraphs in PDF Report

I have a list (Actions) with a separator of *

But when I want to display in a PDF report I want each item in the list to be on a separate paragraphs .

I can do the following:

<<SUBSTITUTE([Actions], “*”, “–”)>>

But I want the two dashes (–) to actually be a paragraph or line break.

I cant find a way of doing it?

Also there is not wat of making the separator a line break with AppSheet which would be better.

Any ideas

Try

With line-break in Exp editor
Or reformulate your question

1 Like

Thanks but I’m not sure what you mean?

Actions is a Ticklist and has to be.

Explain, pls

When you type text in Expression Editor [carriage return] symbol must be placed in text-constant
So
"aaa bbb" - is one line of text
but
"aaa
bbb" - two line

1 Like

Yes.

I have done that and created a new variable that has carriage return in and in the Google sheet.

However when creating a PDF report the variable does NOT honor the carriage returns!

PDF reporting is fraught with these sort of issues!

Surely most users want a EMULIST formatted properly in their reports?

Ups
I must try to emulate this for a time
//Excs me

2 Likes

I really don’t understand problem

Scrn shrt of my PDF report

1 Like

So your PDF is using a Variable (With CRLF) from an AppSheet table?

Because when I use such a variable the CRLF are not used in the output PDF.

Below is is what is in the Google Doc that is formatted as a PDF by AppSheet.

<<[Variable With CRLF]>>

And it comes out like

– Item 1 – Item 2 – Item 3

NOT

– Item 1
– Item 2
– Item 3

Wow!!!
Wich type you set to column?
Text or LongText?
Only LongText types can do that

3 Likes

Brilliant!

I was using Text. Now changed it to LongText

2 Likes

The formatting of reports and emails is a bit of a challenge.

You might want to try using MS word documents instead of google docs for templates. You can still store them on google drive. I find that word documents include more of the formatting, for example line breaks. Line breaks work with word templates even if you are not using long text columns.

Word templates also tend to result is better formatted emails, depending on which email client is used.

On the other hand, word templates tend to give you rather strange column widths and put images in the wrong place so they are not always the best choice.

3 Likes