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
Adding a Download field to a form
I want to set up a form on my website so that people can download a pdf file once they have submitted their email details. It has been really easy to set up the template but I cannot locate a field with the function. I can see file upload, but not download. This is the main task I want to add to my website as part of the "sales funnel" so hope there is the option.Campaign Edit - Vertical Align Text to Center
I have a layout in one of my campaigns that is using the split box with a picture on the left and text on the right. I can't find where I can vertically align the content of these boxes. It's forcing my text to be at the top vs centered. Am I missingIntroducing Dark Mode / Light Mode : A New Look For Your CRM
Hello Users, We are excited to announce a highly anticipated feature - the launch of Day, Night and Auto Mode implementation in Zoho CRM's NextGen user interface! This feature is designed to provide a visually appealing and comfortable experience foris it possible to pull the landing page and email campaign from Zoho app to Zoho marketing? Can I get all the benefits that exclusive app that offers in ZMA?
There is a exclusive Zoho apps for landing page design, email campaign, and same features are there within ZMA as well for to setup landing page and email campaign. can ZMA offer all or limited features of those apps? I request please provide demo andEnable 2FA / MFA in Bigin
Hi, Our company started using Bigin. I (sysadmin) want to require MFA for Bigin as some users also have integrated their calender and mailbox into Bigin and regardless of that, in general, MFA logins are preferred in our company as it strengthens ourForwarding Zoho Desk Support Email to a different e- mail
Hello, I am using ZohoDesk and I have a Zoho Desk Support e-mail setup. I would like to know if there is a way to forward the e- mail inbound to this Zoho Desk Support e- mail to a different e- mail? Thanks!We are being overbilled by Zoho and they refuse to correct it
We are being overbilled for CRM Ultimate Add-on. Zoho has acknowledged that they know this, but refuses to address and issue billing credits for the amounts we have been overpaying. Our company has been downsizing (unfortunately) and in the past 3 monthsis there a better way to routinely export my project timesheets?
Hi there, I am somewhat happy with how Zoho books handles time. One thing that is missing is more user driven control over my data. I have a workflow where I constantly need to give customers feeds of work done. So I pick a project, and would ideallyDoes the ability exist to make tax on the customer profile mandatory?
I am reaching out to inquire about the possibility of making the "Customer Tax" field mandatory when creating a new customer in Zoho. We want to ensure that all customers have their tax information recorded to maintain compliance with our internal processes.Triggering rules on lead conversion
There is no field on the Rule list for rule conversion to trigger an alert on liead conversion to a potential. I assigned a rule to file on any creation or update of a lead. The lead was changed a lead to a potential but no rule was fired. Rajesh BhadraHow do you remove a user from SalesIQ?
I have a user in Sales IQ who needs to be removed (she's no longer involved with sales and chat) but I can't find any way to remove her. How do I do that?Integrate SalesIQ with tiendanube.com
Tiendanube.com is the leading e-commerce platform designed to help businesses create and manage online stores. It provides tools for entrepreneurs and companies to set up, customize, and operate their online shops with ease. Tiendanube is particularlyHow to reset Zoho Commerce
Hi, we are preparing a new onlineshop connected to commerce and books for going live in the next days. Now we want to delete all tests and transactions we made within the development process. And also add a new tax rule which is not possible at the momentFree webinar: Zoho Vault in 2024—A live Q&A with our experts
Hi everyone! 2024 has been a pivotal year for us, taking our journey from a basic team password manager in 2013 to a full-featured security platform offering password management, single sign-on (SSO), and soon, passkey management. Our team has been tirelesslyKaizen #167 - Configuration and Initialization of Zoho CRM Python SDK (V7) for different client types
Hello everyone! Welcome back to another week of Kaizen! Zoho CRM Python SDK allows developers to integrate Python applications with Zoho CRM. In today's Kaizen post, we will explore how to initialize and configure the SDK for both self-clients and server-basedZoho Forms - Dynamic Prefill Setup Question
Hello, I'm very excited about this feature. So much I'm learning about webhooks. However, it seems that the webhooks I can obtain from Zoho Flow and Zoho CRM come with already parts in the URL that are put as invalid by the GET Webhook URL. Do I needHow to get a list of Team Folders associated to a Project from the API?
I've tried the below, based on another article and was unsuccessful. response = invokeurl [ url :"https://projectsapi.zoho.com/api/v3/portal/" + _portalID + "/projects/" + _projectResID + "/folders" type :GET connection:"zohoprojects" ]; info response;Email Alert attachments unavailable for Vendor Payments
I have several vendors with country specific compliance requirements to support the payment of their invoices. I've created Vendor Payment templates to meet their requirements and I setup an automation workflow that gets triggered when the invoice isHow to create Sepa Direct Debit XML file: solution and code
Even though Books provides a payment integration for Stripe and Gocardless (in Europe) there are customers that want to use the Sepa services of their own bank. Mainly because Stripe and Gocardless are quite expensive. In that case they would need a SepaExporting Project Tasks
I can export the gantt chart to a nice PDF in colour, but we want just the task list in a nice colour layout. Is there a way to export it to PDF without the gantt? It would be perfect to give to clients.bug reporting with the count of linked Desk tickets
I am aware that when viewing an individual bug, you are able to see a count of the Desk tickets that are linked to the bug on the right hand side. However, I cannot see a way of reporting this figure from a list of bugs. Our use case is that we wouldUnable to send e-mails to an specific address
Hello. I'm having problems sending e-mails to my shipping company. user@shippingcompanydomain.com INVALID_ADDRESS, ERROR_CODE :550, ERROR_CODE :5.1.1 <user@shippingcompanydomain.com>: Recipient address rejected: User unknown in virtual mailbox table Reporting-MTA:Blueprint transition help needed
I have 5 approvers. For a stage to be passed to the next stage, I require any 3 out of these 5 approvers to make the approval. There is no particular sequence of approval, at any one time, any one can approve. As long as 3 approvers approve, the stageYear-End Wrap: Out-of-Office Made Easy with Zoho Mail
As we wrap up 2024, now is the perfect moment to take control of your email routine and gear up yourself for a productive and successful new year. We have curated a series of weekly tips to help you master your email management starting today. Watch outCreator Simplified #9: Automatically Sending Uploaded Files as Email Attachments
Hey Creators, Welcome back to the Creator Simplified series! Today, we’ll explore how to automate file uploads as email attachments in Zoho Creator—a handy feature that saves time and reduces manual effort in your business processes. Use Case: In a typicalZoho Books Community Meetup: Learn, Grow, Network!
Hello users! We are excited to announce a series of upcoming Zoho User Group meetups and would love for you to join us! This is a great opportunity for you to connect with other users, share experiences, and learn more about how to make the most of ourBar chart from Deal Stage Snapshot table not showing right amounts
Hi, since we needed to track the changes of our deal pipeline over time, I added a new data source and selected 'Snapshots' to start the sync. At first I thought it was working just fine, after a few days I realized that something was wrong with the amountsHow to Display Territory Field on Deal Object
I am assigning Territories to Deals. I am able to use the Territory field as a column in my list view but cannot figure out how to enable it to be visible when viewing a Deal record directly. Can you advise on how to display the territory assignment asPower of Automation::Automate the process of creating Tasks from Task template on project status update.
Hello Everyone, Here we are again to share another requirement that has been accomplished through the implementation of custom functions. A Custom function is a user-written set of code to achieve a specific requirement. Set the required conditions neededIm Stuck in an EDIT ONLY WITH WIZARD issue
So I found Wizards to be a really helpful tool in minimizing the exposure of redundant, superfluous fields to staff that would never otherwise have to edit those fields. My issue is, that when the record (in this case a lead) is created with a wizard,Mass Update in Zoho CRM
Hello, I want to update my past update records by using deluge on some conditions. anyone can please tell me how can I do it.LinkedIn Followers not correct
It looks like Zoho Analytics only counts followers from the day it was connected to our LinkedIn-page. The Total Followers Count in Analytics only displays 549 followers, while in reality we have 1,036 followers. The information is correct in Zoho Social,[API] How to get Contact's funnel?
Hi everyone! I am trying to use the API to get a Contact funnel's (step, name.. anything). Can anyone help me? This information is not available in the API response... I need to retrieve and change my Contacts between funnels dynamically according toTask created from Email Alias
When forwarding multiple emails to project email alias, it will create a task as internal which makes a lot of "General" Task List as I've created automation to set the flag as external. Is there any way to set up the task list created from email aliasAutomation#24: Auto-Update custom field from Accounts to Tickets
Hello Everyone! Welcome back to the Community Learning Series! This episode dives into how Zylker Techfix streamlines account-related ticket references. Previously, employees had to manually check account details to retrieve specific customer information,How do I add an email to tasks in Trident?
Hi, I'm trialling Trident to see if it works better for me than the browser version. It's a nice idea and looks quite refined, so I'd like to be able to use it. My first question is: how can I add and email to a task? I can't find any obvious way, butProject template after project creation
How can I apply a project template AFTER the project has been created?Creating Email template that attaches file uploaded in specific field.
If there's a way to do this using Zoho CRM's built-in features, then this has eluded me! I'm looking to create a workflow that automatically sends an email upon execution, and that email includes an attachment uploaded in a specific field. Email templatesHow to create a Field with answers as Yes, No> Further if no is selected a new field to be visible to give details
Dear All, I am creating a feedback form in HR Letter. The question is were you satisfied with the work allotted. Expected answer to this is Yes, No. Further if the response is no, then a field to be give to fill more details as to why no was selected.Filter Tabs in a Dashboard
I have multiple tabs in a dashboard one of which is aimed at a different audience, is it possible to filter out this tab for a group of users?Next Page