Extracting data from cells in zoho sheets for zoho books

Extracting data from cells in zoho sheets for zoho books

I am currently uploading my bank statment in excel format to zoho workdrive.  I would like flow to extract certain data and send it to zoho books.  Would scripting in zoho flow be able to help me with this?  By this I mean should I attempt this in zoho flow or trying using zoho creator?  Thanks

    Access your files securely from anywhere

          Zoho Developer Community

              Bootcamp
              Community
              Pricing
              Webinars
              What's New
              Integrations
              Contact Support
              Contact Sales

                Zoho Survey Resources
                  Features
                  Survey Templates
                  Integrations
                  Community
                  iOS Mobile Surveys
                  Pricing
                  Android Mobile Surveys
                  Insurvey Blogs
                  Insight Blogs
                  Tips & Tricks





                                Latest Feature Updates


                                    Zoho Desk Resources

                                    • Desk Community Learning Series


                                    • Digest


                                    • Functions


                                    • Meetups


                                    • Kbase


                                    • Resources


                                    • Glossary


                                    • Desk Marketplace


                                    • MVP Corner


                                    • Word of the Day




                                        Zoho Marketing Automation
                                          Zoho SalesIQ Resources


                                                Manage your brands on social media
                                                Access Zoho Social

                                                  Zoho Pagesense Resources


                                                      Zoho TeamInbox Resources

                                                        Zoho DataPrep Resources



                                                          Zoho CRM Plus Resources

                                                            Zoho Books Resources


                                                              Zoho Subscriptions Resources

                                                                Zoho Projects Resources


                                                                  Zoho Sprints Resources


                                                                    Qntrl Resources


                                                                      Zoho Creator Resources



                                                                          Zoho Campaigns Resources


                                                                            Zoho CRM Resources

                                                                            • CRM Community Learning Series

                                                                              CRM Community Learning Series


                                                                            • Kaizen

                                                                              Kaizen

                                                                            • Functions

                                                                              Functions

                                                                            • Meetups

                                                                              Meetups

                                                                            • Kbase

                                                                              Kbase

                                                                            • Resources

                                                                              Resources

                                                                            • Digest

                                                                              Digest

                                                                            • CRM Marketplace

                                                                              CRM Marketplace

                                                                            • MVP Corner

                                                                              MVP Corner





                                                                                Design. Discuss. Deliver.

                                                                                Create visually engaging stories with Zoho Show.

                                                                                Get Started Now


                                                                                  Zoho Show Resources


                                                                                    Zoho Writer Writer

                                                                                    Get Started. Write Away!

                                                                                    Writer is a powerful online word processor, designed for collaborative work.

                                                                                      Zoho CRM コンテンツ






                                                                                        Nederlandse Hulpbronnen


                                                                                            ご検討中の方





                                                                                                  • Recent Topics

                                                                                                  • QR Code generation - native

                                                                                                    All, FYI Google have recently depreciated their QR Code API refer: https://stackoverflow.com/questions/55021765/deprecation-of-google-infographics-qr-codes Annoyingly, this has meant we needed to change our links over to another provider. Creator team:

                                                                                                  • Double Value in KPI - Zoho Analytics

                                                                                                    Hi Team, I tried to implement this in Zoho Analytics but couldn't figure it out. Here's the scenario: I want to display the total number of tickets created, along with the count of closed and in-progress tickets, all in a single KPI. How can I achieve

                                                                                                  • Rich-text fields in Zoho CRM

                                                                                                    Hello everyone, We're thrilled to announce an important enhancement that will significantly enhance the readability and formatting capabilities of your information: rich text options for multi-line fields. With this update, you can now enjoy a more versatile

                                                                                                  • Archiving Contacts

                                                                                                    How do I archive a list of contacts, or individual contacts?

                                                                                                  • Change default identifier field in custom module

                                                                                                    Hi, i have searched through several community posts and helpdesk articles but i have not been able to find a proper solution for our problem yet. We have created a new module which aims to provide similar functionality as the default "accounts" module.

                                                                                                  • Unveiling Cadences: Redefining CRM interactions with automated sequential follow-ups

                                                                                                    Last modified on 01/04/2024: Cadences is now available for all Zoho CRM users in all data centres (DCs). Note that it was previously an early access feature, available only upon request, and was also known as Cadences Studio. As of April 1, 2024, it's

                                                                                                  • Zoho Books - Branches - Can I cross-charge between branches?

                                                                                                    Hi,  We have two parts of our company, manufacturing and sales. The manufacturing side will invoice/bill the sales side for the materials and labour on each order.  I have recently discovered the Branches feature in Books and it fits well with our set

                                                                                                  • Books Custom function - Not executing..

                                                                                                    Use case : Module involved = Invoice When an Invoice is "Approved", the "current date" is more than "n" days and the "Amount" to be received is more than 0 I want a cliq message to be triggered in a channel and to be executed Daily(Scheduled) at 10:30

                                                                                                  • Delete Transactions in Zoho books

                                                                                                    Hi, Zoho books have been migrated from 01.04.2023. However, there are few transactions passed for the period 01.04.2022 to 31.03.2023. I would like to delete all the entries passed during that period. Can you please help in deleting the same.

                                                                                                  • Generate access token(Google OAuth 2.0) dynamically using deluge

                                                                                                    How to generate Google OAuth 2.0 access token dynamically using deluge to Add the zoho books invoice data in google spread sheet.

                                                                                                  • Placeholders for Multi-Level Discount

                                                                                                    I am using custom templates for Invoices and all other modules. Since i have activated multi-level discount (an early-access feature from zoho) "discount at line-item and transaction level", I need placeholders for using them in my custom templates. With

                                                                                                  • Power of Automation: Streamline status update for linked issues.

                                                                                                    Hello Everyone, A Custom Function is a user-written set of code to achieve a specific requirement. Set the required conditions needed as to when to trigger using the Workflow rules (be it Tasks / Project) and associate the custom function to it. We have

                                                                                                  • How to have two separate views for different countries

                                                                                                    Hi there, currently i have two offices i want to add to zoho crm, one office is in singapore which i have already implemented fully. The other office being malaysia which i want to implement. One issue with this is we want the malaysia office users to

                                                                                                  • Ticket View Across Departments

                                                                                                    I setup departments for the main clients I service, tickets inbound from specific emails go right to the departments. This helps with reporting for me. I would like a view of tickets assigned to agent, or unassigned, across ALL departments. Basically I am handling tickets across 3 departments, but I have to keep switching to see what tickets i have. I would like a view where I look and see ALL tickets across ALL departments.

                                                                                                  • Merging 2 tickets

                                                                                                    Hi I understand how to merge 2 tickets already but find the process quite cumbersome. It is not always simple to perform a search that causes the 2 tickets in question to show up on the Ticket Screen, and this is the only place a merge can be performed. Doing a search for the customer or contact linked to the ticket displays all of their tickets which could be hundreds to sort through, you could do a custom search that only shows open tickets but doing that every time is also time consuming. Not

                                                                                                  • Emailing a document to WorkDrive

                                                                                                    Does WorkDrive include the ability to upload a document by sending an attachment to an email address? (Books and Expenses include this functionality) If it doesn't is it under consideration? on the Road Map?

                                                                                                  • 【開催報告】 東京 ユーザー交流会 2024/11/29(金) Zoho Oneを活用した社内DX推進事例の共有

                                                                                                    皆さま、こんにちは。コミュニティチームの藤澤です。 11/29(金)に東京ユーザー交流会を開催しました。10月の開催回に引き続き、多くのユーザーさんに参加いただきました！以下に各セッションの概要と登壇資料も掲載しています。ぜひご参照ください。 Zoho活用事例セッション：Zoho Oneで決め打ちDX~導入過程からコスパ・タイパを極めて効率化~ 今回は、株式会社T h e F l o wの若林さんに登壇いただき、Zoho One を活用した社内DX推進のことや、そもそも「DXとは何か？」というようなDXの本質に迫った内容まで多岐にお話しいただきました。以下に当日の発表内容と資料を一部抜粋して記載しています。

                                                                                                  • Product Request: Send email to Secondary email

                                                                                                    Guys, we should be able to send the campaign to the secondary email too.  Is this on the plans for Zoho Campaign? It looks like I can map the secondary email from the CRM to the Campaigs, but can not send the message.  

                                                                                                  • Logic for sending to a non-primary email address

                                                                                                    Hi, I have a scenario where contacts are able to sign up for emails with 2 different email addresses (example: work, personal). I've mapped both to Campaigns from Zoho CRM, but when I go to target an email only the primary email addresses are pulling in. How can I update this to look at both of the email addresses - or specifically the secondary email address in Campaigns? Thanks, Jenny

                                                                                                  • Ticket Status Colors

                                                                                                    Can i change the colors of Ticket Status in the admin panel?  Or even change the background of the entire cell of a Critical ticket?  This way its easy for my agents to see a urgent ticket when it comes in.  Right now everything is black text. Here Right

                                                                                                  • Zoho Sites and CloudFlare DNS issue over HTTPS

                                                                                                    I have a Zoho Site with a custom domain voterprotectioncorps.org NameCheap is the registrar CloudFlare is the DNS manager, using custom Nameservers (see attached) I installed the SSL cert via Zoho Sites (the "Add SSL cert" option that installs the free

                                                                                                  • How do I do a formula to join two fields together like first name and last name into full name?

                                                                                                    Having issues with this in my custom module.  In most CRM systems you would do: FIELD1 & " " & FIELD2 But it gives an error saying I'm not supposed to use double quotations so not sure what that means.  I've tried to read the formula help guide but it's

                                                                                                  • workflow field update will Not triggering another workflow rule

                                                                                                    I have a Workflow rule that is supposed to get triggered when a field is modified to certain value. This field is actually the lead status and when the lead status changes to "Client Not Responding" . I have a series of emails that go out to re-engage

                                                                                                  • [Résolu] Liste dynamique dans Creator

                                                                                                    Bonjour, Dans Zoho Creator j'aimera pouvoir afficher une liste en fonction d'une donnée choisie dans une autre liste. Explication : J'ai un formulaire Département avec comme champ : Nom J'ai un formulaire Personnel avec comme champs : Nom et 'lookup'

                                                                                                  • PDF Document creating, editing, digital signing?

                                                                                                    Any chance you could provide PDF creating, editing,signing?  Or perhaps integrate with http://www.pdfescape.com/ ?   thanks, Linda

                                                                                                  • Pay in USD

                                                                                                    Hi, is it possible to pay in USD instead of EUR? Thanks.

                                                                                                  • Stock function not working for Brazil (Bovespa)

                                                                                                    Hi, The STOCK function in not working for the Brazil Exchange "Bovespa". This is the syntax I´m using: =STOCK("Bovespa:BBAS3";"PRICE"). Thanks for any help. Ale

                                                                                                  • Tablet Pencil + Fillable Form

                                                                                                    Hi There, I just started using Zoho Writer Forms for our team on iOS. I noticed that some functions support 'scribble' or tablet pens and some do not. Is there a function I am missing where any text field can support 'scribble' or handwriting/printing

                                                                                                  • Announcing new features in Trident for macOS (v.1.10.0)

                                                                                                    Hello everyone! Trident for macOS (v.1.10.0) is here with major features and enhancements to elevate your workplace communication and productivity. Let's take a quick look at them. Create tasks from emails. In addition to creating tasks from selected

                                                                                                  • Journey : "Added to segment" trigger doesn't work automatically

                                                                                                    Hello, I’m experiencing an issue with our Marketing Automation 2.0 integration with Zoho CRM. We have multiple segments defined in Marketing Automation, each with criteria based on field values synced from Zoho CRM. If a field value changes in Zoho CRM,

                                                                                                  • Assistance Required: Email Configuration Issues for Domain clearskyaerials.net

                                                                                                    Dear Support Team, I am experiencing issues with my email configuration after linking my domain, clearskyaerials.net, to Zoho Mail. I followed the DKIM setup guide and successfully configured it. While I can now send emails, I am unable to receive them.

                                                                                                  • How can I bulk import product images to Zoho crm.

                                                                                                    How can I import product images to Zoho crm within bulk imports. I am using an excel sheet or csv and want to include an image (via URL) for each product. This topic is the closest I have found to a solution but I need further help to implement it: https://help.zoho.com/portal/en/community/topic/import-file-upload-and-image

                                                                                                  • Can't send mail Reason:554 5.1.8 Email Outgoing Blocked.

                                                                                                    I send messages to my clients for my agency to my targeted clients last night I got (Unable to send message;Reason:554 5.1.8 Email Outgoing Blocked) this warning. Now I can't send mails. Please fix this issue.

                                                                                                  • erro 553 retransmitindo e-mails não permitidos devido ao domínio ou algo parecido

                                                                                                    Olá, não consigo enviar ou receber e-mails, pois mostra uma mensagem de erro 553 retransmitindo e-mails não permitidos devido ao domínio ou algo parecido.. Por favor, ajude-me a corrigi-lo. Obrigado.

                                                                                                  • How do I go to new form after using deluge button?

                                                                                                    I have (Form1) - [Report1] (Form2) - [Report2] I have created a button which appears on [Report1] which creates a new record for [Form2] using data from [Form1]. I have the script working well, it pulls the needed information from Form1 and builds a new

                                                                                                  • smtppro.zoho.como eror

                                                                                                    En nuestras cuentas de empresa desde hace unos dias estamos experimientando problemas con los correos IMAP outlook, generando un error en el smtppro.zoho.com 465 /SSL Todo estaba trabajando bien y sin problemas. Alguien mas con el mimo problema y/o encontró

                                                                                                  • Outgoing Email blocked

                                                                                                    Hi Support Team, My outgoing emails has been blocked, Appreciate your help to unblock it. Hartron Trade

                                                                                                  • Sheet view ignores layout rules / How to restrict fields in sheet view

                                                                                                    Hi Problem 1: When editing records in sheet view, layout rules are ignored. This is a problem, because it allows users to ignore some mandatory fields (mandatory in a Layout Rule). (Mass Update does not allow updating of fields with Layout Rules, so why

                                                                                                  • Portal users embed access

                                                                                                    So I have a page with a form, and two reports on either side. The reports are embedded as html snippets. So basically, it's set up that when I select a material from the form lookup field, it reloads the report embeds but filters the records with the

                                                                                                  • Importing Accounts with Parent Accounts

                                                                                                    I would like to import accounts that contain parent accounts.  I see a Parent Account but do not see a Parent account number in the Zoho fields and will need this to make sure the correct unique parent is imported. Can you help explain how to accomplish this?

                                                                                                  • Next Page