topic Re: Error message assistance request in App Development

Error message assistance request

Fri, 26 Sep 2014 11:13:23 GMT

I'm getting an error message when trying to create an expression. The expression has been directly copied over from the input Excel file, so there are no spelling errors, additional spaces etc.

Desired expression is:

Count([GAS SERVICING ONLY Q11. If the appointment was inconvenient how satisfied were you with options to change it?])

Error message is:

Bad field name(s): [GAS SERVICING ONLY Q11. If the appointment was inconvenient how satisfied were you with options to change it?]

Any ideas on how to resolve?

Regards

Mike Hack

Re: Error message assistance request

Anonymous — Fri, 26 Sep 2014 11:25:37 GMT

i think GAS SERVICING FILEDS NAME IS NO IN PROPER MANNER PLS CHECK IN DATA BASE ONCE

Re: Error message assistance request

flipside — Fri, 26 Sep 2014 11:49:37 GMT

Do you mean you are building an expression in a front end object? If so, I would recommend renaming long field names to something more manageable and preferably containing no spaces. Excel column headers can have hidden characters if it comes from cells that have been merged.

Re: Error message assistance request

ToniKautto — Fri, 26 Sep 2014 11:49:54 GMT

The error message indicates that you do not have a field with the name in your application's data model.

A Reason for this can be that you have loaded the Excel file without embedded labels. Please attach a copy of your load script and it will be easier to determine how you can address the issue.

Re: Error message assistance request

Anonymous — Fri, 26 Sep 2014 11:54:32 GMT

when u have gap between fields u should use [ ] or '' ''