CONCATENATE ON THERMAL PRINTING

AppSheet AppSheet Q&A
,
1

Hello everyone,

Currently, I’m making some basic apps that function as a receipt and can print in a thermal printer.

I am able to print it using concatenate but hit some problems in terms of printing where the blank rows were using space during an actual print which is a waste of paper.

here are my simple codes:

concatenate(
"RECEIPT #: “,([RECEIPT#]),”
“,([DATE]),”
“,([NAME]),”
“,([ZONE]),”
“,([LOCATION]),”
“,”# OF ITEMS: “,([NUMBER OF ITEMS]),”
","WEIGHT: “,([WEIGHT]),”
“,([DISPATCH]),”
","CHARGES: “, ([CHARGES]),”
","TOTAL: “, ([TOTAL]),”
“,([PRICE 1]),”
“,([PRICE 2]),”
“,([PRICE 3]),”
“,([PRICE 4]),”
“,([PRICE 5]),”
",([PRICE 6]))

Now if all Prices rows from Prices 5-6 or more are not filled-in (meaning it’s blank) and it is, but that blank uses space during printing.

Is there any other way to avoid this?

Any help is highly appreciated

1 Like
2

You should be able to exclude rows with something like this

IF(ISBLANK([PRICE 5]),"",",([PRICE 5]),")
2 Likes
3

Apology for the delayed reply, I was trying it but it’s not the one am looking for because it still uses space or the result is different.

Appreciated your reply to my post.

conconate 2.jpg
conconate 2.jpg1083×834 56.3 KB

conconate.jpg
conconate.jpg422×789 20 KB

4

OK that was my mistake, the newlines inside the quotations make this difficult to read, try the following:

concatenate(
"RECEIPT #: ",([RECEIPT#]),"
",([DATE]),"
",([NAME]),"
",([ZONE]),"
",([LOCATION]),"
","# OF ITEMS: ",([NUMBER OF ITEMS]),"
","WEIGHT: ",([WEIGHT]),"
",([DISPATCH]),"
","CHARGES: ", ([CHARGES]),"
","TOTAL: ", ([TOTAL]),"
",([PRICE 1]),"
",([PRICE 2]),"
",([PRICE 3]),"
",([PRICE 4]),IF(ISBLANK([PRICE 5],"","
",([PRICE 5])),IF(ISBLANK([PRICE 6],"","
",([PRICE 6])),IF(ISBLANK([PRICE 7],"","
",([PRICE 7])),IF(ISBLANK([PRICE 8],"","
",([PRICE 8])),IF(ISBLANK([PRICE 9],"","
",([PRICE 9])))
2 Likes
5 
SUBSTITUTE(
  CONCATENATE(
    LIST(
      ("RECEIPT #: " & [RECEIPT#]),
      ("" & [DATE]),
      ("" & [NAME]),
      ("" & [ZONE]),
      ("" & [LOCATION]),
      ("# OF ITEMS: " & [NUMBER OF ITEMS]),
      ("WEIGHT: " & [WEIGHT]),
      ("" & [DISPATCH]),
      ("CHARGES: " & [CHARGES]),
      ("TOTAL: " & [TOTAL]),
      ("" & [PRICE 1]),
      ("" & [PRICE 2]),
      ("" & [PRICE 3]),
      ("" & [PRICE 4]),
      ("" & [PRICE 5]),
      ("" & [PRICE 6])
    )
    - LIST("")
  ),
  " , ",
  "
"
)

Note carefully the lack of indentation in the third argument of SUBSTITUTE().

4 Likes
6

Hi friend!

Can you share the way to print once you have ready the body to print?

7

https://youtu.be/Ishn9XmCljk

2 Likes
8

Print each label directly to a supported thermal label printer. Excellent for performance and fine-tuning thermal printing.

9

Hi @Bael Bael, i’m building a similar app, and i want to print a receipt by smartphone, can you tell me how is it possible? i didn’t found any tutorial about that.