Troubleshooting in Creator #1 Tracing Missing Records
Tracing missing records in your database
In large applications that handle data across departments, vendors, staff, and many similar stakeholders, it's important to have a clear mapping of the data, its owners, and users with access to modify them. A common issue customers face is tracing data that's been lost to a particular action.
In this article we explore a few use cases that have led to data being lost or misplaced. We explain how to trace your records, assess the possible scenarios, and restore your data. All of these use cases are derived from our experience in real-world technical support.
Case 1: Data missing in some reports but present in others
In Zoho Creator, data is collected through forms, and it can be displayed in required formats as different reports.
Since we have confirmation that data is present in one of the reports, we can access the Report Settings of the associated report in which the data is not shown or found missing, and then check if there are any filter criteria.
Case 2: Data is missing in all reports and Case 1 has been ruled out
Check for recent record deletion by using the Record Audit tool. In most cases, you will either find details of the record deletion, or the deleted records won't be found.
Sometimes a record won't be found if it was deleted via a Deluge script (Delete Record task) executed in an application workflow.
If this is the case, check for deleted record scripts in workflows and disable them momentarily to avoid further record deletion. Then reach out to support for further assistance.
Suggestions to restore deleted data:
- If the number of deleted records found in the Audit Trail deletion log is less, the best way is to manually import them back to the database one by one.
- If there are too many records found in the Audit Trail deletion log, or if the data is deleted via script, it's recommended that you restore a recent backup file.
- If you wish to import only the specific form's data back into the database, you can download the backup file, search for the specific csv file, and import them back into the database.
We hope this helps you to find and restore your missing data in Zoho Creator. If you hit any road blocks, feel free to drop us an email to support[at]zohocreator[dot]com. We will be analyse and assist you further.
We appreciate requests or suggestions for articles. Do follow the series and post your feedback in the comment section.
Access your files securely from anywhere
Zoho Developer Community
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
Dev Anand
Sticky Posts
ANZ In-Person Zoho User Group Meetups: Focusing on Zoho Creator & Zoho Flow (September 2024)
Hello, Zoho Community! Calling all Zoho users in Australia! We're thrilled to announce the next series of Zoho User Group (ZUG) Meetups, continuing the success of our previous sessions. These meetups are a great opportunity to learn, network, and engage[SESSION ENDED] Ask the Experts #07| Live Q&A: Building workflows with Blueprint in Zoho Creator |
Hello, Post the release of Zoho Creator Blueprint last month, we're happy to tell you that we'll be launching a new 'Ask the Experts' session on 16th September (Thursday) this month focussing on creating blueprints in Zoho Creator. The session will beZoho Creator Community Webinars | October - November 2020 [Completed]
Hello everyone, I’m happy to announce that Zoho Creator is hosting a new Community Webinar Series starting this October. This series is a learning initiative aimed at our developer community, where every session will take spotlight use cases focused onCommunity Learning Webinar - Zoho Creator Blueprint & other release updates | July 29, 2021
Dear developers, This June, the Creator team unveiled a slew of updates including UI enhancements to the Detail View of reports, an new capabilities in Data Import and Connections, and most important of all, the release of Blueprint in Creator. CustomizeCommunity Learning Webinar: Delve deep into the core concepts of Zoho Creator | 17th June, 2021
Dear developers, Every customer has unique business needs and unique problems to solve. To be able to give solutions to these problems, to get over any stumbling blocks and to be able to build applications expeditiously that tailor to specific needs,
New to Zoho TeamInbox?
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
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー
その他のサービス コンテンツ
Nederlandse Hulpbronnen
ご検討中の方
Recent Topics
ADDDATE formula using 2 calculations
Hello, I want to create an ADDDATE formula using 2 calculations, add 1 month and deduct 1 day. the formula that I need should look like this: ADDDATE(due_date, 1, "Months")+ ADDDATE(due_date, -1, "Days") Each row itself works fine, but when I'm tryingHow to pass dynamic parameters in an iframe inside Webtab
Hello, I have a custom url like htts://www.test.com?zoho_id= 123456789. I know that if a have a custom button and using a custom function (openurl) I can open the above link by passing dynamically the Zoho ID (lets say the record ID in the Contacts Module).Zoho Creator Embedding a Zoho Form in a Creator App
Hi I've created multiple Zoho Forms for my company for internal use by myself, I am trying to find a way I can either create an app using creator that when I open it then I'll have all my forms listed on the left hand side, so each one will have it'sAgrément Norme Française Européenne Zoho Books, Zoho CRM, Zoho Invoice
Bonjour, Je fais partie des nombreux Fan de Zoho depuis 10 ans ! Les logiciels zoho (permettant la facturation) sont super mais non agrée depuis 2018 ! J'ai tout capitalisé sur zoho et fait confiance depuis des années et me retrouve dans une impasse.Zoho Books - agrément français ?
Bonjour, J'utilise Zoho Books pour ma facturation. Je vais bientôt changer de régime de TVA et essaye donc de vérifier si je suis en conformité pour mon logiciel de facturation. Est ce que Zoho Books est agrémenté (selon l'article 286-I-3° bis du CGI)Factur-X la norme pour la facturation électronique
Hello la team Zoho France, J'espère que vous allez bien. J'écris ce post car j'aimerais que Zoho rende conforme les factures émises depuis les apps Zoho Finance (Zoho Books, Zoho Invoice, Zoho Subscriptions) avec le format Factur-X qui devient la normeConvert invoice from zoho to xml with all details
How to convert an Invoice to XML format with all detailsCannot reorder fields in Page Layout in Expenses and Purchase Requests
It is very inconvenient that the custom fields in Page Layout cannot be re-ordered. The only way is to remove the fields and re-create them; however, it is impractical. This would affect the reports and dashboards we are having. Not able to re-order theTrigger a Workflow Function if an Attachment (Related List) has been added
Hello, I have a Case Module with a related list which is Attachment. I want to trigger a workflow if I added an attachment. I've seen some topics about this in zoho community that was posted few months ago and based on the answers, there is no triggerBillable Entries Not Syncing Between Zoho People and Zoho Books
Hello Zoho Support Team, I’m experiencing an issue with the integration between Zoho People and Zoho Books. Here are the details: I created a project in Zoho People and linked it to a customer in Zoho CRM. The project successfully synced to Zoho Books.[Free Webinar] Learning Table Series - Creator for the Finance Industry
Hello Everyone! The Learning Table Series is a free monthly webinar that runs for around 45 minutes. It's offered to our Community users and aims to provide a dynamic learning experience by demonstrating how Creator can be used as a solution for variousNew UI of zoho people
I recently switched to the new Zoho People UI, and I’m not happy with it. It’s confusing, and the navigation isn’t easy to use. In the old UI, I could easily view all leave applications for the whole organization. But now, I can only see leave requestsIssues with email signature not showing up correctly
I've recently set up my Zoho mail account, and I've noticed some issues with my signature doing funny things such as the logo image getting blown up really large or showing up as an attachment or as text. The text next to which has my name and title isUnable to fetch SaleOrders
We are trying access SalesOrders on the new API, but we keep receiving the following error. We are using Postman to test. Error: URL: https://www.zohoapis.com/crm/v2/SalesOrders { "code": "INVALID_MODULE", "details": {}, "message": "the module name givenAutomatic archive sent emails
Hi, for compliance reasons we need to archive automatically sent emails, even when an email is deleted from the "Sent" folder. How to achieve that? ThxZero Support For A Paying Customer
I opened a support ticket to get absolutely no responses. My support request is being 100% ignored. What am I paying for exactly?Enable and disable modules within the Zoho Projects mobile app
Hello, everyone! In the latest Android (v3.9.14) and iOS (v3.9.2) versions of the Zoho Projects app, we have introduced an option to enable and disable the modules within the app. Now, when an user signs up on the app, they can choose modules of theirEmails "To" showing Subject
When I send an email template from a custom module, the To section is showing the Subject instead of the recipient email. When I click on it it still shows the email and sends, but it confuses people using it. Anyone know why this is showing this way?NodeJS version for CRM custom functions
It's been possible to write custom CRM functions in JavaScript: The NodeJS version seems to be quite old, according to the scripting functions docs though: The NodeJS editor uses the NodeJS 8.11. Is that version correctly documented? That is obviouslyZia Suggestions Bug
Please fix this issue it's annoying (check video attached).The email address you have entered belongs to a different deployment/region.
Hi, I am trying to create the user - mprust@crombiecomputers.co.uk but keep getting the message below - The email address you have entered belongs to a different deployment/region. Please contact support@zohoaccounts.com for assistance. Look forwardUpdate quote information without having to edit or force an edit function
Hopefully I can explain this correctly!! Our quotes are created in a 3rd party system and then integrated into Zoho CRM Quotes module via the API. In Zoho quote I have some formula fields such as discount % and some aggregate fields for sub total andIntroducing Screen Share with Audio
Share your entire screen or just the chrome tab with audio for more engaging presentations. Your audience will hear sound just like you do, whether it's a video, demo or any other content. This is ideal for training sessions, team meetings, and clientBlueprint automatic transition based on a field in the module
I've made a Blueprint for sales orders. At some point, we have to ask a subcontractor to contact the customer to agree on an inspection date. If the desired delivery date is less than 21 days from today (Urgent), we want to sent the subcontractor an automaticZoho People in Nederland?
Goedemiddag allen, Zijn er bedrijven in Nederland die naar tevredenheid gebruik maken van Zoho People? Wij zitten in de transitie naar Zoho One en vanuit de 'beste of suite' gedachte zou Zoho People dan ook een mogelijkheid zijn voor de HR administratie.Access extensions while performing task blueprint transition - Zoho Projects iOS app update
Hello, everyone! In the recent iOS version of the Zoho Projects app update, we have brought in support to access the extensions while performing the blueprint transition on the tasks. Please update the app directly from the App Store or using the link2nd and 3rd Email in Workflow fails to send
I'm having trouble sending a 2nd and 3rd email in a Workflow. Here's a screenshot of the workflow. Again...like the last topic I posted...it's VERY SIMPLE and it still will not work. This is incredibly frustrating.How to Perform Global Search
Hi everyone, I am working on an integration project using the Zoho CRM JavaScript SDK. I’ve implemented functionality to create and open entity records, but I am stuck on a specific requirement: I need to implement a global search feature where givenSubscription warning makes no sense -- no response from support so far...
I have a warning message on my Mail that reads: "Your Zoho Mail Subscription has expired and your account will be suspended on Nov 23, 2024. Renew immediately to continue services." I can see the invoice was paid on Nov 23rd and I'm confused as to whyZoho Mail
My domain and email hosting is Ionos, I'd like to switch to ZOHO, I purchased 1 user to do the test, I don't know how to set up. I have the following issue: 1. I tried to only transfer 1 mail account to test, once I set up as the suggestion, all otherOption to start the whatsapp conversation with a lead or deal from within crm
Currently in zoho crm there is no option to start a conversation with a lead. However we can send templates to contacts or leads in Zoho CRM through approved templates using workflows. But Users are not permitted to initiate conversations with leads orError while setting up IMAP configuration
Hi. We're getting the following error when we try to set up the IMAP configuration. How can we solve this problem?Identify if fields used in function
We're doing a lot of tidy up on our Zoho CRM modules but have 100s of functions. We need a way of identifying if these fields are used in any functions before deleting them. Is there a way to do this? Is there a way to search Deluge scripts on mass forExport blueprint as a high-resolution PDF or image file
This would be a good feature for organizations that want to share the blueprint process with their employees but don't want them to have access to the blueprint in the system settings. At the moment all that users can do is screenshot the blueprint orI am not receving emails but MX records shows my domain is pointed to Zoho
I am not receving emails but MX records shows my domain is pointed to Zoho I have added my TXT to my domain DNS and MXtoollookup shows it is working. my domain is cashbull.ca Please help meDigest Novembre - Un résumé de ce qui s'est passé le mois dernier sur Community
Bonjour chers utilisateurs, L'année 2024 s'achève doucement, mais les actualités continuent ! Découvrez un résumé! Le mois dernier, nous avons organisé deux Meetup Community à Lyon et à Paris. Au nom de toute l’équipe, je tiens à vous remercier chaleureusementcorreo saliente bloqueado
Tengo bloqueado mi correo saliente error 554.5.18 marcado como SPAMMER. Alguien entro en mi cuenta y logre recuperarla pero no me deja mandar correos y lo necesito urgente. No consigo desbloquearlo y no me contestáis por ningún lado. NECESITO AYUDA porPayment
Hi! I don't want to renew my mail. Will I be automatically charged the renewal amount? I don't understand how to cancel my subscription.Missing Application Salesinbox
We got some issues in Zoho CRM tools which is CRM application is known as Salesinbox. please add this application in our account best regards Shunyatax Global Fintech Solutions LLPError when sending out email via SMTP
Hi, I recently started encountering an error when using my Zohomail account to send out emails. The error message was : sendEmail.exe[16528]: ERROR => ERROR => SMTP-AUTH: Authentication to smtppro.zoho.com:587 failed. rmtree failed: Directory not emptyNext Page