[rporteous]

Hi.

I’m looking for a bit of help to hide rows in a table where the row contains a subtotal in the PDF output from an advanced PDF/HTML template…

In simple terms, I use subtotal items in estimates then use a markup item to add a loading for work conducted after normal business hours. An example transaction in NS might look like this;

QTY ITEM DESCRIPTION AMOUNT TOTAL

—-+———-+———————-+———–+——–

2 | LABOUR | Business Hours Work | $100.00 | $200.00

| SUBTOTAL | | | $200.00

| MU-AH | After Hours Loading | 20% | $20.00

When I render this as an advanced PDF/HTML template, I get a blank line on the SUBTOTAL row, which I want to hide (remove completely from the PDF output), note I removed a couple of the columns to illustrate the transaction detail is different to the output I want (example only)…

QTY DESCRIPTION TOTAL

—-+———————————-+——–

2 | Business Hours Work | $200.00

| |

| After Hours Loading | $20.00

I would really appreciate any suggestions how I can do this…

I am also looking to add a custom field (checkbox) to ITEMS, the field would be a option to HIDE certain fields from the output… Any suggestions or advice on this would also be most welcome…

Thanks

Russ
This is a cached copy. Click here to see the original post.

[rporteous]

After about 10 hours, I have a part work-around for my question… Here is my code;

HTML Code:

---

${item.description}

${item.description}
${item.description}

I have been thinking that perhaps I could also add a custom checkbox field to ITEMS that I can use to SHOW some transactions and HIDE others… Any comments, feedback or advice on this approach?

Russ

[michoel]

Looks like you got the right approach, though note that this line is currently redundant:

Code:
${item.description}
You can absolutely add a custom field to the Item records, however, keep in mind that you will need to also create a corresponding Custom Transaction Column Field to source this data into the transactions. You would typically select Store Value = F, and make sure it is selected to show as a Screen Field on the Transaction Form. Even if you don’t want it to show in the UI, this needs to be selected to make sure it is visible to your template. If you don’t want it actually appearing in the UI, there is a hack to clear the the description field which hides it in the UI but keeps it available to you template code).

Shout out if you need more help.

---

rporteous replied on 01/16/2017, 03:48 PM: Thanks Michoel…

I would be interested in the UI hack you are talking about… there are so many columns on our transactions that its unwieldy for small screens!

Russ

[michoel]

Originally posted by rporteous

View Post

I would be interested in the UI hack you are talking about… there are so many columns on our transactions that its unwieldy for small screens!

It’s just to clear out all the text in the “Label” field, but to keep “Show” checked. This works for most fields, and keeps them hidden in the UI but available in the printed templates.

[Author]

Posts