Help with Start End troubleshooting in PDF

Quality_Assuran · 09-13-2022 11:48 PM

Good morning Community,

Hope everyone is well.

I need some help with an expression in my PDF template.

I had the system create a template with the below table

Agenda_Talking_Point
Agenda_Decision
Agenda_File
<<Start: [Related Agendas]>><<[Agenda_Talking_Point]>>
<<[Agenda_Decision]>>
<<[Agenda_File]>><<End>>

I then removed the other two columns because I don't want them in this PDF and moved the <<End>> to the end as below.

Agenda_Talking_Point
<<Start:[Related Agendas]>><<[Agenda_Talking_Point]>><<End>>

But I get an error

Task 'Make or Update File' Body template. Found 1 unmatched 'Start'. They are: <<Start: [Related Agendas]>><<[Agenda_Talking_Point]>>

I tried to copy and paste this into Notepad++ and it looks like this as I saw on this link

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Body-template-Found-1-unmatched-End-They-are-lt...

<<Start: [Related Agendas]>><<[Agenda_Talking_Point]>><<End>>

While I was writing this I thought I would 'save and verify' with a newly appsheet created template without me doing anything to it to see if I still get an error, to confirm that it wasn't the changes I was making and I still get the same error.

Then I deleted that table completely and ran 'save and verify' and I got almost the same error

New Error

Task 'Make or Update File' Body template. Found 1 unmatched 'Start'. They are: <<Start: [Related Agendas]>><<[Agenda_Talking_Point]>>

Old Error (Same as above)

Task 'Make or Update File' Body template. Found 1 unmatched 'Start'. They are: <<Start: [Related Agendas]>><<[Agenda_Talking_Point]>>

Any suggestions on what I can try to fix this?

Aurelien

Hi @Quality_Assuran

Can you make sure the whole text formatting is identical ?

Quality_Assuran

Hi @Aurelien apologies, not following, in the Template or in my Post?

Aurelien

@Quality_Assuran your template

Quality_Assuran

@Aurelien I just wanted to get back to you regarding this.

What I did was copy and paste the Agenda table to another automation I was working on, incorrectly. (With no End)

And then went back to my other automation and worked on it and forgot that I had pasted this table in there and so I kept trying to fix the problem in the wrong template.

It was only when I disabled it and ran 'Save and verify' and saw that it was still broken that I realised I needed to check the other automation.

Hope this saves someone some time in the future.

Aurelien

You eventually found the reason it kept not working.

Let's move on 🙂

Yes, I avoid using the "copy" feature with Bots because of this reason, mainly 🙂

A good tip is to name the template according to the bot that is using it (if you are using Google Docs).

This way, you don't get confused (hopefully). But with a copy...well, I did not give it a try, I don't do copy 😂

Good luck for the rest of the development !