LinkedIn
Twitter
Hi community!
As the title indicates I am trying to use a formula as an initial value in a column that after saved in the database (google sheets) would become a script function (google app script) that will return me a reversed geocode value (that is a text address).
The problem I have is that when the data is saved from appsheet the result in the google sheet adds an aposthrophe ( ' ) in the front of the formula. I did some testing and I found out that the aposthrophe is being added whenever I try to pass a "=" text value from appsheet. So for example If my value starts with a letter the problem doesnt happen. But if the equal sign is the first character (second character after the ") then the aposthrophe is added automatically.
Here are some Images:
I have tried all the other solutions people found in this forum but nothing works for me so far. The most common solution I found was to confirm that the database and appsheet columns were matched as Text and I did that but didnt worked. Maybe it is intended by google that it happens that way but I wanted to make sure with someone more savvy since I didnt specifically found that is a program restriction. Thank you.
Solved
2 ACCEPTED SOLUTIONS
@Ion wrote:
The most common solution I found was to confirm that the database and appsheet columns were matched as Text and I did that but didnt worked.
I'm not sure what you mean by this. If you mean for the values in your Sheets column to be treated as text, confirm that the Sheets column is formatted as plain text.
If instead you are trying to populate a Sheets column with values from your app that you intend to be treated as formulas in Sheets, I doubt that's possible. It also shouldn't be necessary. Depending on what you're trying to accomplish, you should be able to either use a Spreadsheet formula or an automation to Call a script.
@Ion wrote:
The most common solution I found was to confirm that the database and appsheet columns were matched as Text and I did that but didnt worked.
I'm not sure what you mean by this. If you mean for the values in your Sheets column to be treated as text, confirm that the Sheets column is formatted as plain text.
If instead you are trying to populate a Sheets column with values from your app that you intend to be treated as formulas in Sheets, I doubt that's possible. It also shouldn't be necessary. Depending on what you're trying to accomplish, you should be able to either use a Spreadsheet formula or an automation to Call a script.
