Modification in the app impact the google sheet

Hello !

I am working on an app that allows you to measure differents types of production times: with added value and without added value.

I have a problem: when I start a new measurement on the application, I fill in certain information that impacts my googlesheet. A number displays in cells which should be a text choice and this automatically removes the row from the measure in the app…

If someone can help it would be great !

Thanks you all.

I’m afraid your description of the problem is confusing me.

Often, there is a problem when the spreadsheet cell’s “number format” setting doesn’t match the data type used by the app table’s column. In general, it’s best to avoid setting the spreadsheet number format to Automatic; instead, choose Plain text or a number format that more-closely matches the data the cell is intended to contain:

image

1 Like