Hi Anthony,
Based on your description, I tried the following:
- I create a Google worksheet having a field called โCommentโ.
- AppSheet correctly inferred that โCommentโ was a โLong Textโ field.
- I created a workflow rule with an HTML template that included the โCommentโ field.
- I used the AppSheet application to enter โ9.amโ in the โCommentโ field.
- I saved my change which wrote the value to โCommentโ cell in Google Sheets.
6.The workflow rule was invoked.
- The field โCommentโ appeared in the resulting HTML document as a simple text value.
I am not sure I fully understand what you are reporting, so forgive me if I misinterpreted what you wrote.
I was surprised that in Google Sheets, the cell value โ9.amโ was treated as a hyperlink. The same was true whether I saved the value via AppSheet or if I typed the value โ9.amโ directly into the Google Sheets cell.
The cell value was treated as a hyperlink even if I preceded the value I typed into the cell with a single quote. Preceding a value with a single quote signifies to Google Sheets that the following value should be treated as text.
I was able to overcome this behavior by selecting all of the cells in the โCommentโ column, right clicking, and selecting โunlinkโ. This caused Google Sheets to display the cell values as text.
Spreadsheet products like Visicalc, Excel, and Google Sheets have a long tradition of trying to guess what type of values you enter and then formatting it automatically. That may be what is going on here.
Can you provide the exact steps to reproduce the problem?
LinkedIn
Twitter
