Table Name not recognized with Special Characters

Hi,
I have found the following error with the Select formula recognizing the table name with special characters.
In my case, my table name is “Sleep & Dreams”, when I use the same in suggested values field using Select command, I am getting the below error.

But, the table name is same as mentioned above.

Error with the Select command,

Help needed.

Thank you.

1 Like

I would avoid the use of special characters and spaces in table and column names. There’s likely to be other places in the app that this could cause problems, and it limits compatibility when integrating with other systems that are more strict with their naming conventions.

4 Likes

You’re going to need to remove the ampersand (&) from the table name.

I’ll bring this up with the developers.

2 Likes

Sure. I’ll do that @GreenFlux.
Thank you.

1 Like

Thank you @Steve

1 Like