Hi. I want to scan in column A and show the result in column B where I input a column of vlookup functions. Could I scan, let's say, A1 and show the result (of B1) on the phone?
Hi! Answering this question here in the CZcams comments would be a bit difficult, it involves a few steps including settings in the Add-On for Excel and Excel itself. I would kindly ask you to send us a quick email at support@tec-it.com. That's an easier way to find a solution for your request. Thank you!
Yes. You will need to check the "Send Timestamp" checkbox that you will find in the add-on options menu in your Google Sheet, or if you are connected to Google Drive, by editing the connection from the app. You will find more help at this link: www.tec-it.com/en/software/mobile-data-acquisition/scan-it-to-office/manual-add-in/Default.aspx#110731 If you need further help, please send us an email to support@tec-it.com and we will assist you personally. Best regards, TEC-IT.
We support two different methods for connecting to Google Sheets targets. Usually both methods send the data to the current cell (and moves to a new line). 1) When connecting using "Google Sheets (Drive)" you can transfer data to the Sheet even if it is not opened in the browser. When using "Google Sheets (Add-on)" you have more control over this process (see the "Options" tab in the Add-On). Drawback: When using the Add-On the target Sheet must be opened in the browser and the Add-On needs to be activated. Hope this help, TEC-IT (support@tec-it.com)
Hello. Within a custom form, you have the option to set the endpoint. Here, you can specify the target table name, sheet name, and the starting cell address. Here is the sample syntax: [TableName]SheetName!C4
@@TECITSoftware Can you kindly tell me the steps to reach there?If I am scanning barcode to a google sheet?I tried but failed tho find out where that option is.
Hello! Please, check that you have the latest version of the app installed. - Open the forms view (bottom right button). - Edit a custom form or create a new one. Under "Form Title" you will find the field "Endpoint". - Enter the sheet and cell name in this format: SheetName!C4 If you need further assistance, please send an email to support@tec-it.com and we will assist you personally. Best regards - TEC-IT.
Please elaborate the difficulties and let us know how we can improve the app. Provide details either here or via mail to support@tec-it.com. Many thanks, TEC-IT
Love this app. Thanks for saving my day ❤❤
We're glad Scan-IT to Office is helpful :-) Kind regards, TEC-IT
Hi. I want to scan in column A and show the result in column B where I input a column of vlookup functions. Could I scan, let's say, A1 and show the result (of B1) on the phone?
Hi! Answering this question here in the CZcams comments would be a bit difficult, it involves a few steps including settings in the Add-On for Excel and Excel itself. I would kindly ask you to send us a quick email at support@tec-it.com. That's an easier way to find a solution for your request. Thank you!
Do you have the function of date and time when scan that upload to google sheet sir?
Yes.
You will need to check the "Send Timestamp" checkbox that you will find in the add-on options menu in your Google Sheet, or if you are connected to Google Drive, by editing the connection from the app. You will find more help at this link: www.tec-it.com/en/software/mobile-data-acquisition/scan-it-to-office/manual-add-in/Default.aspx#110731
If you need further help, please send us an email to support@tec-it.com and we will assist you personally.
Best regards, TEC-IT.
Inserting image to google sheets drive its not working, it said currently not supported
Hello! Please stay tuned for a future update, we are currently working on exactly this feature. Yours, TEC-IT (support@tec-it.com)
can we decide the scan column abd row?
We support two different methods for connecting to Google Sheets targets. Usually both methods send the data to the current cell (and moves to a new line). 1) When connecting using "Google Sheets (Drive)" you can transfer data to the Sheet even if it is not opened in the browser. When using "Google Sheets (Add-on)" you have more control over this process (see the "Options" tab in the Add-On). Drawback: When using the Add-On the target Sheet must be opened in the browser and the Add-On needs to be activated. Hope this help, TEC-IT (support@tec-it.com)
Hello, it is fixed? My problem same with you
can we decide the scan column and cell?
Hello. Within a custom form, you have the option to set the endpoint. Here, you can specify the target table name, sheet name, and the starting cell address. Here is the sample syntax:
[TableName]SheetName!C4
@@TECITSoftware
Can you kindly tell me the steps to reach there?If I am scanning barcode to a google sheet?I tried but failed tho find out where that option is.
did you find something on this@@muraly3523? I'm looking for putting at the exact cell as well.
Hello!
Please, check that you have the latest version of the app installed.
- Open the forms view (bottom right button).
- Edit a custom form or create a new one.
Under "Form Title" you will find the field "Endpoint".
- Enter the sheet and cell name in this format: SheetName!C4
If you need further assistance, please send an email to support@tec-it.com and we will assist you personally.
Best regards - TEC-IT.
Experience wasn't good at all.
Please elaborate the difficulties and let us know how we can improve the app. Provide details either here or via mail to support@tec-it.com. Many thanks, TEC-IT