Error with Bot PDF Generation

[dylantabrams]

Hello,

I'm trying to use an automation to generate a PDF for SSMIRs (aka inspection forms) from the INSPECTION FORM table in our App, and the PDFs are not being created. I've done all the trouble shooting recommendations are nothing has fixed the issue. Upon further inspection in the monitor bot screen I noticed the error "Error: Task 'Generate an SSMIR PDF' Body template" because of "Expression '[Type II NC # of Defects]' is invalid due to: Unable to find column 'Type II NC # of Defects', did you mean 'Type II NC  # of Defects'?". 

Can someone help me please? I've been banging my head against a wall now for 2 weeks and I can't seem to figure it out. See snips below for additional context/detail.

[jyothis_m]

I think the problem is with the column name, its having some # symbol. Please crosscheck the column name in appsheet.

[Steve]

I wonder if the actual name of the column in Data >> Columns in the app editor has more than just a single space between Type II NC and # of defects? If so, change it to just on space.

In AppSheet, these are different:

Type II NC # of Defects
Type II NC  # of Defects