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.
Solved! Go to Solution.
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.
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.
Sure. Iโll do that @GreenFlux.
Thank you.
Youโre going to need to remove the ampersand (&
) from the table name.
Iโll bring this up with the developers.
Thank you @Steve
I have just came across this very same problem. While it may seem simple to just remove the & and move on itโs really not because when you change a table name this is what happens.
Please someone just not allow us to put special characters in our table names if this is the issue itโs going to cause.
Thanks
Josh
If you change the table name(s), for sure you need to edit all the expressions associated with that table name. Regenerating or refreshing the editor does not auto-provide that re-association.
Iโm aware of this. Which is exactly why I posted what I did. It would be great if appsheet didnโt allow you to put characters that it doesnโt recognize in the table name. Otherwise later down the road you will come across the issue described by Khanapmoffice and have to change your table name which then can cause all sorts of problems as shown in my post above.
Ditto. However, provided Iโm not mistaken, neither one the RDMS have some sort of a name check for the column/header names. Besides, itโs a big rule of thumb not using/avoid using non-ASCII chars and/or operands (i.e. the amperstand) - even the space char in general - with the column/header/parameter/variable names in coding and/or RDMS development.
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |