CRM : La validation des données

CRM : La validation des données

Soyons honnête : il est difficile d'avoir un CRM parfaitement organisé. Le garder dénué d'erreur demande du temps et de l'organisation. La bonne nouvelle est qu'avec une méthode adaptée, vous pouvez arriver à tout et sans trop de difficulté.
En l'occurence, l'une des tâches les plus ardues d'un CRM est de garantir la validité des données qu'il contient.
C'est simple : ce que vous retirerez de votre CRM sera le reflet de ce que vous y mettez. Si des données de mauvaises qualités se retrouvent dans votre CRM, vous pouvez vous attendre à des résultats mitigés. La meilleure façon d'éviter cela est d'utiliser la validation des données. 
 
Qu'est-ce que la validation des données ?
 
La validation des données est tout simplement un système de processus mis en place pour garantir que toutes les informations saisies dans votre CRM sont correctes et d'actualités. Sans ces données "propres", un CRM peut devenir vulnérable aux erreurs et aux lacunes dans les informations fournies, ce qui se répercute sur votre équipe, et directement sur vos activités.
 
Zoho CRM possède justement une solution pour répondre à cette exigence : elle se nomme "Règles de validation", et vous aide à surmonter ce problème en stoppant l'insertion de mauvaises données avant même qu'elles ne puissent entrer dans le CRM.
Les données insérées par vos collaborateurs peuvent être automatiquement soumises à l'approbation d'un supérieur, en se basant sur des fonctions personnalisées.
 
Les règles de validation dans Zoho CRM vous permettent ainsi de définir l'exactitude et la validité des données qui entrent dans le système CRM.  Vous allez pouvoir définir les valeurs indésirables d'un champ : si une valeur saisie pour un enregistrement correspond aux critères définis dans la règle, le CRM lancera une alerte et stoppera l'enregistrement.
 
Prenons cet exemple, que nous allons par la suite vous démontrer à travers des captures d'écran :
- Votre entreprise désire s'introduire sur le marché français, ou y lance un nouveau produit. À cette occasion, elle décide d'offrir une offre promotionnelle de 25% à ses clients Français. Vous pouvez ainsi paramétrer une règle n'autorisant cette réduction uniquement pour le marché "France", et une seconde qui n'autorise aucun dépassement de remise.
Si quelqu'un saisi alors une remise pour un autre pays, ou une remise qui dépasse 25%, l'action sera automatiquement bloquée, et le manager du service sera automatiquement alerté. Pratique non ?
 
Voici comment appliquer la validation des données, étape par étape :

Cliquez sur le module "Prospects" :



Une fois sur l'interface "Prospects", rendez-vous sur "Règles de validation", et cliquez sur le bouton "Create New Validation Rule" :



Une fenêtre va alors s'ouvrir, à travers laquelle vous allez pouvoir choisir le champs pour lequel vous souhaitez ajouter une règle de validation. Pour cet exemple, nous allons choisir "Réduction" :



Choisissez le type de validation "Basé sur les critères" et cliquez sur "Suivant" :



Vous y êtes presque ! Vous voilà arrivé sur l'interface qui nous intéresse. Ici, vous pouvez spécifier le critère de validation. Pour rappel, pour notre exemple nous choisissons une limite de réduction de 25%. Nous allons donc sélectionner "Réduction, Supérieure >, 25."



Ensuite, nous souhaitons que cette remise ne soit applicable que pour le marché Français. Dans le bloc "Cette règle sera appliquée pour tous les enregistrements", cliquez sur modifier :



Vous pouvez ainsi sélectionner le critère "Pays, est, "France". Cliquez sur "Terminé" :



Vous pouvez ainsi constater que le critère de réduction est correctement appliqué, et qu'il s'applique bien pour la France. La prochaine et dernière étape consiste à rédiger le message qui sera affiché si l'un de vos collaborateurs dépasse ces critères :



Cliquez sur "Valider" et... Félicitations ! Vous avez créé votre première règle de validation !



Pour s'assurer qu'elle est bien valide, vous pouvez créer un nouveau prospect remplissant la condition d'appartenir au marché Français, et tenter d'appliquer une réduction supérieure à 25%. Ici, nous pouvons voir le message d'erreur s'afficher, la règle de validation est donc bien appliquée :




Pour conclure, il est important de rappeler que bien que nous ayons choisi pour cet exemple les critères "pays" et "remise", les règles de validation peuvent être paramétrées pour tout type de critères. Par exemple : numéro de téléphone, nombre d'utilisateur, origine du prospect etc.
Vous pouvez ainsi vous assurer du respect de l'intégralité de vos processus, d'une manière totalement automatisée.


    • Sticky Posts

    • CRM - Astuce #5 : Effectuer des actions en masses

      Bonjour à tous,   Au programme du jour : éviter les répétitions grâce à la fonction "en masse". Gagnez du temps sur ces actions simples pour vous concentrez sur votre entreprise. Allez dans le module concerné et cliquer sur les : (...)   Suppression en

    • Zoho CRM - Il y a du nouveau chez les modèles d'e-mails

      Bonjour à tous,   Nous sommes ravis d'annoncer que les modèles d'email dans Zoho CRM sont désormais adaptés au design pour tous les ordinateurs et mobiles. Le responsive design désigne une méthode selon laquelle les pages sont conçues pour s'afficher

    • Nouveautés Zoho CRM : la page d'accueil et le tableau de bord actualisés !

      Bonjour à tous, Nous avons apporté quelques améliorations à la page d'accueil des utilisateurs et à l'onglet Tableau de bord, en voici un aperçu. Des composants supplémentaires dans la page d'accueil pour les nouveaux inscrits : Dans l'onglet Accueil,

    • CRM Blueprint #5: Glossaire

      Bonjour à tous,  Voici le dernier volet de notre série sur les Blueprints : un glossaire pour comprendre tous les termes nécessaire à l'automatisation de votre process. État : fait référence à chaque étape de votre processus. Par exemple : qualification,

    • CRM : Ajoutez de la couleur à vos balises CRM

      Bonjour à tous, Les tags sont des identifiants uniques qui peuvent être associés à différents enregistrements ce qui permet de rechercher, trier, catégoriser, filtrer et segmenter efficacement les enregistrements. Cette nouvelle amélioration a pour but

    • Recent Topics

    • Alert for Back Navigation in Zoho Creator Widgets on Mobile Apps

      In Zoho Creator widgets, when a user navigates back on mobile devices, the data within the widget is reset. This leads to a loss of any unsaved changes or inputs, causing frustration for users. To enhance user experience, we need to implement a confirmation

    • Mapping Zoho Projects into Cliq Channels

      why arent all the Zoho Projects listed from the drop down menu when trying to Map them into Zoho Cliq Channels. The system doesnt allow me to type the name of the project but gives a drop down of a list of projects however it doesnt give me a list of

    • Input GST Reversal for damaged goods

      In our line of business, some items are damaged and we are doing inventory adjustments to remove them from stock. However, as per GST guidelines, there is a specific rule that we have to reverse Input GST availed for such items and needs to be reported

    • Develop and publish a Zoho Recruit extension on the marketplace

      Hi, I'd like to develop a new extension for Zoho Recruit. I've started to use Zoho Developers creating a Zoho CRM extension. But when I try to create a new extension here https://sigma.zoho.com/workspace/testtesttestest/apps/new I d'ont see the option of Zoho Recruit (only CRM, Desk, Projects...). I do see extensions for Zoho Recruit in the marketplace. How would I go about to create one if the option is not available in sigma ? Cheers, Rémi.

    • Canadian Anti Spam Law

      In order to be able to comply with the new Canadian Anti Spam Law, I need to send out a Confirm Subscription email to all of our existing contacts. If I use the Subscribe tag, the user gets the following message: Registration Failed. Sorry! This contact is already present in the selected list. You can check this with your update profile link. If I include an 'Update Profile' link, it then sends an email which does not arrive immediately. Can you provide a tag or URL I can put in a Campaign Email

    • How to bulk update lookup fields

      "I have a primary key named Product SKU in one form called Master SKU (which contains details like price, color, size, etc.). I also have another form called FBA, which has the same primary key, Product SKU, and contains stock quantity information for

    • Change work hours per day for employees

      Hello, Is there a way to modify the work hours per day for employees in Zoho projects? This would be helpful for resource allocation to more accurately see when an employee who works 35 hours a week vs 40 hours has a full schedule. Thanks.

    • Record GST Paid for Imported Goods

      In Australia, goods that imported from overseas needs to pay GST per invocied value. In most case, the freight forwader (logistic agent) paid this on behalf of importer (us), and invoice us in together in their freight invocie.  How do we setup a proper

    • Unable to produce monthly P&L reports for previous years

      My company just migrated to Books this year. We have 5+ years financial data and need to generate a monthly P&L for 2019 and a monthly P&L YTD for 2020. The latter is easy, but I'm VERY surprised to learn that default reports in Zoho Books cannot create

    • Bulk Editing Multiple Invoices with Overwriting at time of upload

      Hello, I would like to edit a few 100 invoices. Only the HSN needs to be updated. When I am trying to upload the excel sheet with the data updated, I get an error: The Invoices are skipped as they already exist. I know the invoices exist but I would only

    • Oauth Redirects me to sign in page

      I am developing a postman script for me to securely get my credentials via Zoho Vault. With that, I need to authorize my postman to be able to access Zoho Vault. I am currently on Step 1 in this Zoho Vault | API Reference which redirects me to this guide

    • Here's why you should refrain from using EasyShip

      This is a screen recording which shows EasyShip performance issues. Note well! While we do use the Zoho-to-Easyship integration, the problems are wholly on the EasyShip side. The actual integration of data to EasyShip, and status updates back to Inventory,

    • How can I create a billable expense.?

      Hi, I've a bill of an expenses related to printing and stationary account but it recorded in non-billable expense category. How can I record this expense in billable category. Below is the pathway I've used to record the expense. Purchases. Expenses Click

    • Introducing Sub-Accounts in Zoho Books!

      Hello Everyone, Sub-Accounts is LIVE! Yes, you read it right. The much needed and most requested feature is now live in Zoho Books. The sub-accounts feature in Zoho Books will help you to classify your accounts further which will give you a more detailed view of your accounts while running reports. You can create sub-accounts for the below Accounts: Asset Cost of Goods Sold Expense Liability Fixed Asset Other Asset Other Current Asset Long Term Liability Other Current Liability Other Liability Other

    • How can I insert and update field data of a sub-form without adding data into the main form’s mandatory fields.

      1. I have a main form that contains a sub-form. I need to update the data of the sub-form from a function, but I am unable to do so. How can I achieve this in Zoho Creator? 2. How can I insert data into a sub-form without inserting data into the mandatory

    • How to autorespond for inactive users?

      Hi, we have a few inactive users that we would like to set up an autorespond to the sender telling that the email addresses are no longer active. How can we do that?

    • Cannot view or interact with polls on IOS

      When testing with Android the user will receive a pop up message when a poll is started and be able to access polls via the more menu. This is not the case when using IOS phones, there seems to be no way to view or interact at all.

    • Calendar view not working in Zoho Projects

      Hello Zoho team! Since this morning, clicking on the "Calendar" link in the Projects Menu doesn't do anything. It seems to refresh the page, but it doesn't open the calendar view for tasks. It affects every user in my company. Closing and opening the

    • Multi Select Filter off comma separated values

      Hey friends! I have a query table for a couple of dashboards/ charts. In one of the dashboards, I'm trying to create a multi select filter for the service that is being sold. The way we look at services is by a CRM field titled, "Mail Lead Entities,"

    • Dashboard filter applied to all reports but not visible on report

      Hi, I have two reports which shows sales transactions data - one is graph and the other a pivot table. Both reports use the same base table. There are no filters on the reports so it shows all transactions for the last 6 months. I want to create a dashboard that includes the graph and the pivot table report. However, I want the dashboard to have a fixed date filter that only shows the last 30 days of data i.e. filtering the underlying graph and pivot table to show the last 30 days of order data.

    • Equipment Scheduling for Efficient Field Service Operations

      Zoho FSM helps you nail the critical aspect of field service management, i.e., scheduling the right technicians to the service appointments. Ensuring that technicians have access to the right tools and machinery for their job is also of paramount importance.

    • Chat issues

      I am having a couple problems with the zoho chat feature. When I use Chat from the App bar, not everyone is getting messages (these are to different accounts, Yahoo & Gmail). I did finally get the Users to show up correctly. However, when in an active chat with someone, I only get one sound notification. No other notifications, pop up or otherwise, come through to alert if another message was sent. Also, the bottom Chat bar that shows Active chats while I am in email does not show any online contacts

    • Problem with multiple pages record template

      Hi, I have a record template with multiple pages. When I print, it has gaps between pages. How can i fix it?

    • Field Update: can't find a custom multi-line text field in the options list

      I want to update a custom text field (large size multi-line: 32000 characters) that I have added in the Accounts module using this functionality https://help.zoho.com/portal/en/kb/crm/automate-business-processes/actions/articles/field-updates , but I

    • Ask the experts - A live Q & A discussion on Zoho Recruit

      We are delighted to come back with another edition of Ask the Experts community series. This edition, we'll be focusing on everything about Zoho Recruit. The topics will focus on the features that are used/asked by the majority of users and also based

    • Zoho One Datensicherung möglich

      Gibt es eine Zoho One Datensicherung über alle Apps mit eindeutigen Datensatz-Id´s eines Kontaktes in allen Apps und mit allen Bildern (insbesondere Artikel-Bilder)? Wir haben festgestellt, dass die Zoho Books Datensicherung keine Bilder sichert. Und

    • Note not being pulled for other modules in email template

      Hi there, Currently i am creating an email template that is able to pull the data from notes field in estimate module and email it to procurement team where they will be able to receive the email with the contents of the note, i am unable to replicate

    • Pop Up

      Hello, I want to automatically display the information of the attached data in the product module in the related list section of my data in the lead module when the current time matches the "Call Time" field of my data in the leads module. How can I achieve

    • New feature alert: Witness signing is now available in Zoho Sign

      Hello! Getting documents signed with confidence in Zoho Sign just got a major boost! We're delighted to introduce witness signing, where other individuals or entities can be designated as witnesses to observe the signing process and add their signatures

    • How to report and analyze a multi-select field entries distinctly ?

      As many of CRM users I have many multi-select fields that allows me to choose more than one chose in one cell for a specific filed Like: Field A - A;BC - A;C -B;C But when reporting the field it will handle each cell as a "String" not multiple entries

    • Get the capability to convert documents to different formats

      Hello users, In this article, we'll be exploring the Conversion API in Zoho Office Integrator to understand how it can be used to convert documents to different formats right from your web app. Before we get to the details of the Conversion API, here's

    • Issues with certain CRM, Desk & webhook blocks in Guided Conversations

      Good day I have been attempting to add a block on our guided conversations, which give our customers relavent information based on their queries. The issue is that when I attempt to use a block that fetches data I get the following error popup: Cannot

    • Use Zoho Creator as a source for merge templates in Zoho Writer

      Hello all! We're excited to share that we've enhanced Zoho Creator's integration with Zoho Writer to make this combination even more powerful. You can now use Zoho Creator as a data source for mail merge templates in Zoho Writer. Making more data from

    • Analytics Module: Can you move items from one dashboard to another?

      Is there a way to move items from one dashboard to another? I want to rearrange my dashboard now that I know what i'm doing but i don't want to remake my various widgets? Edit: Hey Zoho, This would be a good feature: to be able to move/copy widgets to

    • Can't delete/hide related lists

      Hi, Maybe I'm missing something, but I can't seem to find where I delete or hide related lists in a module. When I go to a record and click the little arrow on the right next to the related list, I only get the option to select what fields in that list

    • Make Widgets Clickable or Copiable

      Hi, I created a KPI Widget in Zoho Analytics whose content I would like the users that see my dashboard could copy or click and be redirected elsewhere. Yes, I'm aware I can create a Text Box for that instead of a Widget, but the problem is that the link

    • Custom API - Need to create a string return value, not only MAP

      @Support: When creating a Custom API it only allows a return from a function of MAP type. The service I'm using requires a string return, how can this be achieved?

    • Automate data upload process like reports

      I'll start with the end in mind.  I want to basically keep certain creator tables updated with data that are in a sql database/tables in our office (employees, active jobs, employee positions) so I can reference that data and not have to duplicate it by hand every time someone adds a new job or employee in the office desktop software.  Here are some thoughts I had about how to do this, but am unsure as to whether any of them are actually possible and how to go about it from there: Is there any way

    • Address Autofill

      Hi I'm having issues with the address autofill tutorial (https://zurl.co/rGXQ). I have followed each step in the tutorial, but when i paste the code into a workflow/function, i'm getting the following error code: Improper code format Correct format :

    • Sync custom module ID to Lead module

      Hello, I am trying to sync Contract ID (custom module) from Deal module. I have an existing function that whenever a contract is created, it will automatically creating deals based on the frequency of the contract. Now i am having problem to show the

    • Next Page