How Do I turn OFF "Invalid Field Name" and "database Field Name" tag in Excel

1307
1
Jump to solution
02-17-2018 04:38 AM
AaronColbran1
New Contributor III

When using the "label" column in a Survey123 excel X-form the "Invalid Field Name" dialog box pops up EVERY time an edit is made to the label field. The error states you need unique values and no spaces, none of which are true for a label field. 

This causes significant downtime with any survey editing as the subsequent dialog box defaults to no, and not yes like it used to.  The error should be removed from S123.

The second issue are the yellow help boxes that get in the way of ANY editing of the fields of interest. They show the same misinformation that the Invalid Field Name dialog box does. 

The only time either of these messages are relevant is in the 'name' column. Even there they are not needed as the generation process highlights the errors.

Please advise how to turn these "functionalities" off.

Please advise if these issues can be scheduled for removal in the next build?

1 Solution

Accepted Solutions
JohnathanHasthorpe
Esri Regular Contributor

Hi Aaron

This is the result of a data validation rule that is applied to the name field (not the note field). It looks like you may have done some copy and pasting in the form and this shifted to a different column,

To disable the error message go to Data=>Data tools=>click the data validation button

Then un-tick the the show error alert message box below

and click OK.

The error message will no longer display.

Cheers

John

View solution in original post

1 Reply
JohnathanHasthorpe
Esri Regular Contributor

Hi Aaron

This is the result of a data validation rule that is applied to the name field (not the note field). It looks like you may have done some copy and pasting in the form and this shifted to a different column,

To disable the error message go to Data=>Data tools=>click the data validation button

Then un-tick the the show error alert message box below

and click OK.

The error message will no longer display.

Cheers

John