"+" Symbol Causing Error in Spreadsheet

[Mike303]

Hello, I'm having an issue my inventory app. Users  need to be able to enter a "+" into the app, which in turn enters it into a cell in a Google Sheet. This results in a field entry error (incomplete equation).

The only work-around I've found is to add an apostrophe in front of the "+", but it's not ideal. I've also tried to format the input field to detect if a single "+" symbol is added and if so, automatically concatenate an apostrophe to the front of the "+". Furthermore, the input field is set to text, so that is not the issue.

See the screenshot below. Thanks in advance!! 

[Trevwiller]

This could be on the sheet site. The formating for the column if still Automatic can cause issues with thinking it could be an equation. Setting the column to plain text in the Google sheet can help with this. Also side note with the key system you have set up sequential keys can run into possible issues if you are using them as the key generated from the app especially if multiple users are able to add items. Could be used as a possible label or identifier but if two items are made at the same time by different users they can be given the same key value if sequential is used.  https://support.google.com/appsheet/answer/10106361?hl=en&sjid=819683376254858201-NC

[Fabian_Weller]

Hi @Mike303 this was discussed here.

---

@Trevwiller wrote:

Setting the column to plain text in the Google sheet can help with this.

---

Sadly this is not changing the behavior.

[Mike303]

I believe the only work around is to type an apostrophe before the "+" in the app. I can get it to display only the "+", but it needs the apostrophe to be entered into the spreadsheet.

[Karimmc2]

Try adding an ' at the beggining.

[Karimmc2]

Sheets will disregard the '  and stop trying to compute it as a formula

[Fabian_Weller]

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/How-do-I-store-a-text-value-beginning-with-quot...

[yasarcan]

Bunu kullan; ➕