Backup Issue
I can't backup my DB of creator with my enterprise account backend 07-Sep-2015 04:28 Onetime backup failed Error occured backend 07-Sep-2015 04:28 Onetime backup started
MS Word Plugin
Hi there I have installed the MS Word Plugin, and can sign in and setup my document with relevant merge fields - no problems there. When I select the records to merge, and then click merge, nothing happens. Does anyone have any suggestions? Cheers Aaron
BIGINT bug?
This is a part of my code : context is on add row row.Four=2938232000000091051; (this is BIGINT) it's WORK BUT WITH THIS Variable1 = input.Choix; (this is BIGINT) row.Four=Variable1; (this is BIGINT) THERE IS A BUG ? Thank you^^
API call
Hi, I'm new to Zoho and I'm a little confused. I have been asked to implement something that selects data out of our DB and adds record into Zoho. I am looking at the documentation and I'm just not getting it. I was wondering if someone could explain something to me. As I said, I am writing my script in Perl that will be cron'd that will submit records in real time. The documentation states I create a form using <form method="POST" action="the url" etc <input type="text" name="colname" value ="Me">
How to track changes in report / summary data over time?
Hello, Zoho Creator Forum, Consider the following: Let us say I have an application that tracks my inventory of tasty fruit. I have a Data Form called Fruits, which has a Type field (Apples, Oranges), and a Status field (Unripe, Ripe, Rotten). Each individual fruit is a row in the table created by this Data Form. I would like to see at a glance how many of each type of fruit I have, and what proportion of them are in what status. To this end, I have created a PIVOTCHART, which displays a stacked
Zoho Creator Portal App
Has anyone been able to use the Zoho Creator Portal mobile app? I had come to two types of error. Invalid_Request and Network Error. I had tried with different active customer portal users and different devices but sadly it happens the same. Im really looking forward to use this great functionality. Thanks in advance
Subform too large for main form
My Sub form is very large 30+ fields and my problem is that this is unusable in the horizontal sub form view and would ideally need to be opened in a popup window so that it can be worked on via an ipad etc. Has anyone else had and/or solved this problem?
filtering a subform lookup with a mainform field
Hi! :) I have a Products form with a lookup field on Factory form. I have an Order form with a lookup field on Factory form The Order form has a OrderItems subform with a lookup on Products form. At the subform OrderItems I want the lookup on Products form to show only the records that match the Factory chosen at the Order mainform. Is this possible? Thanks :)
Diferent layouts for diferent sections of a form
Hi! :) Is it possible to have diferent layouts for diferent sections of a form? I would like to have a form with two columns and a subform that would fill all the form. Thanks! :)
[Solved ]sendmail from NON zoho.adminuserid / zoho.loginuserid
Hi, I used to use a simple form from built in features on the Sites app. Not knowing the Creator app can allow me to do much more. So i bought a subscription for a standard plan with Creator, and built an app with forms that i am very happy with, with some help from support already. Thanks for that. But now there's one last thing I wish to do, but it seems like a bit of a road block now. I hoped to do something like this: sendmail [ from: input.Sales_Email to:"helpdesk@company.com" cc:input.Sales_Email
How do I get a custom app in to CRM
So, I created an application in Zoho Creator, and can't get it in to my Zoho CRM. I have only created a form at this point. The goal is to have a related list on my accounts. Support said that it would appear in the list of Extensions for my Zoho CRM's CEO (Setup > Extensions & APIS > Zoho > Build Custom Apps > Manage) But it does not, I shared it with her and it still doesn't appear there. Not a big surprise that support was wrong (I have contacted them 5 times, and they have had a correct answer
clarification in Sandbox
Hai 1.When we create a sand box It duplicates our application but I can't get all the reports that I have in the original app.Is there any way to get it? 2.In sandbox if I publish with new changes it will change in original app after doing it more than 2 time if in case I need the previous edit can I get it?
Is there an alternative to customer portal with Creator?
Is there a less expensive alternative to using the $99/month customer portal for allowing customers to update their own information in Creator?
Fetch data from related form not working in a mainform/subform scenario
I have three forms: Orders (mainform) Order Items (subform) and Products. When i input the product ID at Order Item, a script trigered on user input fetches data from the related form Products to populate all the other fields of the Order Items. It works fine if i enter the Order Item form the Order Item form, but if i enter the Order Item at the mainform Order where there is the subform Order Item, it doesn't work... Please advise. The script: x = Products [ID == input.ProductID]; input.Price =
For each record - hitting deluge statement execution limit - to only update 730 records across 2 forms???
Hello, I have trying to update 730 records across 2 forms as follows: - Create booking = 365 records - My availability form = 365 records These are daily recurring events for a period of 1 year, which are set up in "My availability form" then inserted in "create booking" form. Both form are linked via lookup field through their ID Create booking has lookup field My availaibility_form_ID My availability form has lookup field create_booking_ID For each series (across both form) there is a unique reference
Unable to download files.
Hi Guys, I am unable to download the file from the below link https://www.zoho.com/creator/help/script/for-each-record-in-form.html (.ds file) can anyone help me to download this file. Regards Prashanth K
What is Add record in Deluge Task?
Hi Guys.. Can any one tell me, what is "Add Record / Delete Record" -- Deluge Task ? Any real time example... I am newbie , trying to learn these concepts.. Kindly help please Regards Prashanth K
How do I verify an email address to be used as the "sender" address in a form?
I´ve seen a previous post which tell me to select "add email address" when in the "from" field....however this option doesn´t seem to be available anymore, please help me!
Populate Lookup Field
I have a form which is filled out by email - it is a Twilio SMS response. I would like to link the form's From field (single line text or number; either works) with a lookup field which contains a list of mobile phone numbers from my Worker Information form. The phone number from the From field will not be an exact match as Twilio responds with "+1 NPA NXX xxxx and I only store NPA NXX xxxx. The goal is to ultimately fill in other fields based on the Worker Information Lookup so I can generate further
what is the field type for "Drop down Box
Hi...Guys.. By using "Drop down Box" field and the values in the field are "Numbers" , then Is it possible to perform "Calculation - Task" or If I put it another way , what is the field type for "Drop down Box" ?? Here, Scenario, Live Form Window is Guest Book - Room Booking. So, when user select the Guest Name ---> Booking type ----->> Rooms Available ---->> No.of Persons. Base on the --->> No. of Persons, Rate should be shown Then Room Charges , Calculation Task has to be Perform. Instead
Set up a record summary as a live template?
How do you set up a record summary as a live template? The Status field seems to have disappeared. I want to make sure when I print a record that it uses a particular record summary.
Restrict Visibility on a Report
I know you can restrict visibility on a report for your users. However, when restrict certain actions like "Eport, Import etc., the actions still appear when I access the application. Is this because the user does not see what I see when the application opened? If so, is there a way to see exactly what the user sees? Thanks
Dynamic Lookup Field
Hi I am trying to overcome a mismatch of field type error with a dynamic lookup field I have an organisation and a people form. The organisation name field in the organisation form is a strong type. In the people form I have a lookup to the organisation name field. This is what determines which people are employees of different organisations. This lookup field in Bigint. In the organisation form I have a mulilookup field to look up and record people that are employees of organisations. The set filter
Creating a record in zoho CRM Custom Module - 4401 error
I'm trying to create a record in a Zoho CRM custom module. Code was working perfectly but all of a sudden stopped. I've stripped the code down to basics and still get an error. equipMap = map(); equipMap.put("CustomModule2 Name", "test"); resp = zoho.crm.create("CustomModule2", equipMap); This code is run onClick. I get the following error each time: {"message":"Unable to populate data, please check if mandatory value is entered correctly","code",4401"} The CRM mandatory value is "CustomModue2
Custom record summary
All, I am trying to create a record summary from a form which contains subforms as well, but I am stumbling across some issues with 1) Alignment of text in subform - although I have clicked left-alignment on several occasions, the text remains centered both vertically and horisontally. Is it possible to change this default behaviour? 2) Colors of labels. In the data from the main form, I can change the colors of the labels, however for the subform this seems not possible - is this correct?
How to fetch two collective data from another form, when using Lookup - MultiSelect type
Hi , If the Look-up field type is Multi select , then how to fetch the records from another form Say for example Employee Table ( Emp ID, Emp Name, Salary,Email id) with 5 records I have another Project table (Project Name, Emp Name,Email, Proj Description) Here - Project Live Form, My Email is Multi-line & Emp Name is Lookup - Multi select values.So, if I choose two Employees from the Emp Name field, then it has to display two Emails from Employee Live form. So, How to fetch two collective data
How to fit an old database form into a double layout format?
Have an old database form in triple layout, which I would like to recreate using Zoho Creator, but since Zoho only has a double layout, I'm trying to find ways to make it fit. I've enclosed an image of my old form and under the word 'TEST' under each column, there are construction codes with boxes next to it to insert the amount (numbers). Can you guys help suggest a way to fit all that into a double layout form?
How to create a Page
Can anyone provide a simple explanation as to how to insert individual field from a Report into a Page? I just want to create a Page similar to a Word document's merge function.
Fetching Contact IDs from CRM to Creator
I want to create and make updates to Contacts in Zoho CRM through Creator forms. So that if the form is filled out and submitted they are added to our Contacts in Zoho CRM or updates a Contact already present. For updates, I need the Contact ID from CRM. How can I fetch the Contact ID from Zoho CRM to Creator and provide it in the update Deluge? Or can another identifier be used to verify if it is a new contact, i.e. email address? The fetch record instructions seem to only give me help with fetching
How to give update Email Notification in Zoho Creator Application.
Hi dear friends, I need to know, how to give update Email Notification in Zoho Creator Application. Exact Scenario: I have Agenda Live Form and Agenda Live Report form In my Agenda Live Form, I have "Enable E-mail Notify". And I am getting Email Notification perfectly. But, when I am "Updating" the records via Agenda Report Live form on "Edit" mode. Update is successfully happend in Agenda Report Live form. But I am not getting update Email Notification . I have already given command "Enable
Insufficient permissions when exporting on Windows 10
In Chrome (as well as other browsers) I am unable to export data. I get an error message. It works fine in Mac/Windows7 with same user account. I am able to download other formats like pdf. I am an admin on my local machine. I can also download from other services like dropbox. Here's the header information for both Request and Response: POST /downloadExportData.do?filterVal=FY%3A2016%3B HTTP/1.1 Host: creatorexport.zoho.com Connection: keep-alive Content-Length: 164 Cache-Control: max-age=0 Origin:
Update CRM Qty in Stock based on ZCreator subform
Hi, I went through the CRM update record tutorial, but wasn't successful in creating what I need. I created a form "Store_Records", and a subform "Store_Items", in the subform there is a CRM field related to products to select a product from CRM and a number field "Issued_Qty". I need to update the "Qty in Stock" under CRM module "Products" based on the issued qty for each selected product. Example: If I select 3 items type A, I need to subtract 3 from the current Qty in Stock in CRM. Need to do
Translate ZC using Google Translate
Hello ZC Team Here is something that may help in translate interface problem. Is it possible to use in a html view this script code made available by Google Transpator?: <div id="google_translate_element"></div><script> function googleTranslateElementInit() { new google.translate.TranslateElement({ pageLanguage: 'en', includedLanguages: 'pt' }, 'google_translate_element'); } </script><script src="http://translate.google.com/translate_a/element.js?cb=googleTranslateElementInit"></script>
3rd Level Relationshiip
Hi there I have a "Course Instance" form. I have a "Booking Header" form. I have a "Booking Details" subform on the "Booking Header" form. On the Booking Details subform, there is a lookup to the "Course Instance Form". My question is, can I display the "Booking Details" records on the Course Instance form, linked by the Course Instance ID? Thanks Aaron
ADD NOTES FIELD IN ZOHO CREATOR
Good morning,In add notes field of zoho creator,I am unable align the text centre even I click the align centre icon.Kindly help me.
Change of email address
How do I change my email address michael.macmullen
Importing Zoho Spreadsheet to Zoho Creator
I'm trying to create an app from data in a Zoho Doc spreadsheet. When I go to import it I get this message: But my Zoho Spreadsheet is not more than 70 columns, it is only 35 columns wide. Any idea why this won't work?
Record Fetching question
Hello, I have tried looking at examples \ videos etc... I am just still not getting on how to accomplish what i am trying to do I tried looking at: https://www.zoho.com/creator/help/script/fetch-a-value.html#Example_1 Maybe someone can be kind enough to set me in the right direction. My Example: I have a form with products and price, I have another form which fetches my products - this part I got working now my problem is that i want to also pull price onto the same form based on what product was
Zoho creator crashes
While reporting in Inspections, I have the following concerns: Most important, the app randomly crashes during use @ any given time, I could be waiting for a score to calculate, or go out of app to look at some notes I want to add to the report & come back to the app resetting itself. I can only add 2 emails under client at a time, when I may have to send it to 4 at a time, so I have to forward it as a PDF & cc the 2 clients listed in the app so they know I forwarded it to everyone else. I can not
Update a Lead record by specifying it's id
Hello, I tried to create the same App given in Example 1 But using the given code return the following Error: Error at line number : 4 Mismatch data type for function zoho.crm.updateRecord at argument index 2 expected data type STRING found dataType BIGINT
Next Page