Iโve noticed that OCRTEXT function disables when you try to EXTRACT any type of data (prices, number etcโฆ) from text field with initial value formula OCRTEXT. Did anyone encounter this as well?
@tony FYI
Hi @Nekorn_Lammayot. Can you try creating a separate column that captures the OCRTEXT output (you can mark it as hidden) and then use the formula EXTRACT([The OCR Column], ...)
instead?
My OCRTEXT ouput (with initial value OCTTEXT formulal) was already on a separate column. Thanks for looking into this bug.
Hi @tony Is this bug resolved?
I also want to use something like
SUBSTITUTE([OCRTEXT],". ",",")
But it gives no result.
(This is a bug that weโre working on fixing.)
Hi @Fabian, Iโm trying to reproduce your bug but it seems to work fine to me. Can you tell me what Iโm missing from this app? https://www.appsheet.com/Template/AppDef?appName=OCRTEXTDemo-176618-20-03-12
Using this image in the app works for me:
Sorry @tony my fault. I explained wrong. I want to do all the calculation in just ONE column.
In your sample App the column [Text] should have the expression:
SUBSTITUTE(OCRTEXT([Photo]), ". ", ",")
But this is not working.
Yes, this is a limitation of the OCR and OCTEXT functions, currently. They canโt be nested inside other formulas, so for now youโll need to make your OCRTEXT formula in its own column, and then reference that column outside of it. Weโre working on fixing this issue, but for now youโll need to use that workaround.
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
17 |