Hi,
I have a png image that has dates in the format of YYYY-MM-DD, and my google sheet [where the four sample documents are] also has the format of YYYY-MM-DD, but appsheetโs OCR is reading and returning MM/DD/YYYY. The return of this incorrect format is setting off warnings and saying that a few documents have failed. Is there a way that I can change, either by formula or in UX or wherever, how this is read from OCR so that YYYY-MM-DD can be returned instead of MM/DD/YYYY?
Thanks
I have no experience with the OCR functionality, so I can only speculate.
I would expect the OCR to return the data in whatever order it appears in the original, unless the target column is of an appropriate data type. Make sure your appโs locale is set suitably for the data being scanned.
If the original format is variable, you may need to scan it into a Text
column and build some logic into the app to interpret it and convert it to the desired format.
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |