How can I display a BOOL checkbox field as 'YES/NO' rather than 'TRUE/FALSE'?
KNIG02 - Jacqueline - Knight - 1 - 0 02-02-10 0 false Toothpaste KNIG02 - Jacqueline - Knight - 1 - 0 02-09-10 0 1 false
Reports security
Can I set certain users (non-developers) to be able to create their own custom reports while other users can only view? How is is done?
Need help with a very long form
Hello We are creating a form to be able to capture all the educational history of a few children we take care of, but the form is getting to long and hard to complete. Is there a way for us to create different forms to update the same table and the forms should be launching one after the last one is complete. For example we have inside the form the following sections: General information, Parents information, Education, Psychology results, Etc. Can we separate all this forms and at the end be able
How to create a view filter for a field that is populated from zoho.currentdate.getYear()
I have an income-expense form with a field called "Year" that is populated by On Add -> On Load -> "input.Year = zoho.currentdate.getYear()" I created a view that will print and serve as a report. The view contains the Year field. I need to be able to filter this Income vs Expense view based on the record in the year field but not a STATIC year (ie Year == "2013"). The user will not be able to edit the view and so will not be able to create a new static filter each time the year changes. What
zoho calender events created in zoho creator
so using zoho.calendar.createEvent to create events, but what if I need application to be able to modify or delete events? is this updated? https://www.zoho.com/creator/help/script/create-an-event-in-zoho-calendar.html
I dont understand or fail to cURL to postUrl
Hi, I have this [PayPal] example of cURL: curl https://api.sandbox.paypal.com/v1/oauth2/token \ -H "Accept: application/json" \ -H "Accept-Language: en_US" \ -u "EOJ2S-Z6OoN_le_KS1d75wsZ6y0SFdVsY9183IvxFyZp:EClusMEUk8e9ihI7ZdVLF5cZ6y0SFdVsY9183IvxFyZp" \ -d "grant_type=client_credentials" I want to use postUrl and did the following: headersMap = map(); headersMap.put("Accept-Language", "en_US"); headersMap.put("Accept", "application/json"); detailsString = "grant_type=client_credentials"; responseMap
Script New Views ?
Can we script a way to create new views when we add record or contact. As I add new customers I would like to have their view and share set automatically . Form A has data in column x is customers name. I am currently making all customers zoho users but I only allow them to view and edit records that pertain to them . When I add new customer in Form B is there a way to automatically create their personal view and add them as a user or do I need to do that manually every time . I have 125 to add
Password or access code fields in forms
Are you allowed to use password fields in your forms using zoho creator now? I had an expert creating forms for me on zoho creator and he was turned down for trying to use password fields. My competitor also uses zoho and has password fields. I let Zoho support know about this one month ago and they said they would look into it. Now they are using access codes instead of a password field. Is that allowed? This same website also has a backend login on www.tootir.com and has a username and password
How do I change the checkbox BOOL field from 'TRUE/FALSE' to display 'YES/NO'?
KNIG02 - Jacqueline - Knight - 1 - 0 02-02-10 0 false Toothpaste KNIG02 - Jacqueline - Knight - 1 - 0 02-09-10 0 1 false
Dropdown and filter
I have the following problem: I have a database shared with different users that have the option of editing and adding contacts. I have many entries with dorpdown entries just because we need to filter the information. My problem is that the information in those dropdown field may vary according to the needs. For example, add a new name of a company that is new for us. The problem is that when the users want to add this new information and have to add it in a dropdown entry, they can not do it (it
Dropdown and Filter
I have the following problem: I have a database shared with different users that have the option of editing and adding contacts. I have many entries with dorpdown entries just because we need to filter the information. My problem is that the information in those dropdown field may vary according to the needs. For example, add a new name of a company that is new for us. The problem is that when the users want to add this new information and have to add it in a dropdown entry, they can not do it (it
'like' operator in query
Is it possible to use 'like' operator in a query? If not, is there any plan to add it, when? Thanks!
Import Data By Email
When importing data by email is there a way to import more than one record from the mail e.g. I want to import all orders for the previous day so my email looks like Customer:ABC Product:123 Qty:1 Customer:XYZ Product:456 Qty:2 The only record that gets imported is the last on
Add record to other app after record is updated through XML-RPC
Hi Guys, I have two Applications created with Creator. Application A (App_A) and Application B (App_B) I'm using PHP and XML-RPC to add records to Application A. Now I want 2 things to happen: 1. When record in App_A is added with XML-RPC I want another record to be created in App_B 2. When record is updated in App_A I want another record to be updated in App_B My question is how can I access other Apps using deluge? Is it possible at all? I cannot use different forms in the same app since this
The new application builder is missing the Payment option
Hi, I couldn't see this functionality http://www.zoho.com/creator/help/forms/accept-payments-through-forms.html#Creating_a_Payment_Form available when using the new builder. Where is it located please? Cheers,
Writing an entire application with Deluge script
How can I write an entire application using Deluge Script? The advice given here does not seem to work: http://www.zoho.com/creator/help/script/app-builder-deluge-scripting.html#writescript I cannot seem to find this option. Does anyone know where I can access this mode?
How to display images in HTML views?
Hi there! I am creating a list of items with images. The "summary" view is inadequate, so I am working on creating an HTML view that will nicely list the image and a few other fields for each entry. How would you go about displaying images within HTML? Here is my HTML/Deluge code: htmlpage testpage() <%{%> <%totrec = Illustrations.count(); for each r in Illustrations {%> <%=r.Name%> <%=r.Image%><br/> <%} }%> Resulting in displaying the content of the "name" field correctly but
ZC app new builder interface
Hey, I couldn't find any public discussion on this matter. Please leave your comments here or re-link it to the older thread if exists. My first comment is that I find it too difficult to pop over between my forms and views. e.g. I have about 40 views and 25 forms. With the current builder I really need to -left-click twice. click on "views" or "form" and click on the element im after. With the new builder I either need to scroll down the list [limited] or do a search and click. Much more tedious.
Lost Data- Creating Stateless Form
Ok so I'm a newbie. I was creating a stateless form for one of my apps. I deleted a couple of items on my app and lost my data. Can I turn back the clock and set my apps to a day earlier? Also what is the best way to backup you apps/data? I see there is a backup function is the main menu. Thanks,
Does zoho support SHA1 encryption
Hi, Is there a way to convert a string into SHA1 in zoho ??? If yes then provide me with the information regarding the same... Thanks
Adding values of formula fields from two different applications
i have three forms. 2 of them are used to insert some data the third one is for summarizing the two forms. How am i going to add the values of two formula fields (values coming from the 2 forms) to be shown in the third form. See attached photo. Thanks much!
getURL fails using detailed response
Since a couple of days ago, I have been getting a failure with a getURL function that has been working for months. When I use detailed response as an option it throws an "unable to produce MAP" type error. When I remove detailed and set response to simple, the getURL works fine. I have changed nothing on my end but I noticed that you guys are rolling out new code. Has anyone else reported this bug?
Invalid email address when loading from variable
Hello all, When I am loading the variable "mailtolist" into the carbon copy field of the sendmail function it appears to work fine as long as there was only ONE email address in the Contact_E_Mail field. However if I have multiple email addresses in the Contact_E_Mail field then I receive an an error when I try to submit my form. mailtolist = Districts[District_Name == input.District].Contact_E_Mail; sendmail ( To : input.Operators_Email_Address From : zoho.adminuserid CC
view comments in contact email
I receive the submitted contacts via email... is there a way to view their comments in the same email as well instead of logging into zoho?
Mixing up Forms and Applications
Hi, I just started using ZOHO today and missed the concept of the "Application" - that this was the "Main Database". I created a couple of forms under separate (individual) applications that should have been forms under one application. Is there a way to copy these forms to the one application? Thanks
Error in duplicate application
Hi I have duplicated an application and accessed the duplicate application. With the same code in the duplicate application, it shows error while navigating from one page to the other(Error occurred please contact the application owner). Whereas in the real application, it works smoothly.
Help and Issue buttons for FORMS and VIEWS
It will be great to have ability to add help button or link to forms and views. this link can follow to wiki-page where developer can place user guide or video instruction Also, I think, It's very usefull to have issue button for each Form and View. If something goes wrong (error in deluge scripts, displaying of fields e.t.c, user click issue and describe wat is wrong. Developer will see the link to the view or form, with filled by user fields (at the moment of clicking issue link, to simulate the
How do you integrate Zoho Creator and Zoho CRM? What does it look like?
Hello, I am the administrator for our company and we currently use Zoho CRM to collect and manage our data. We need to create different custom account types for parent accounts, manufactures and etc that can be looked up with in our standard customer ACCOUNT or by the "TABS" in Zoho CRM. I was told you can create custom "TABS" in Zoho creator and have the TAB be shown in CRM. I need to know what this look likes and how it really connects so I can present it in order to get the OK to purchase this
HTML Views and Facebook Like button
Hello, any idea how I can integrate a Like Button from Facebook in an HTML view? I have been following the instructions from Facebook (http://developers.facebook.com/docs/reference/plugins/like/) with no luck... Any help will be appreciated...
how do update a child record, when parent record references it?
For instance: I have a Child Form with fields First_Name, Last_Name and a lookup to a Form Home Form Home has a multiple select field for Children. When children are added to the Home form, is there a way to update the Child Form with Home? (without script)
Is there a way to automatically populate a zoho creator form, from data entered to a zoho calendar?
Client really wants color coded calendar ... trying to find a way.
Image default value
Hi, The Image field has no default value available in its settings. I've tried to set it in the validate and success sections so it points to another URL with no good results. Did anyone try this or similar already? This can be used when setting a profile picture and need a placeHolder in case it is empty. Any offers? Thanks,
commented out code being deleted
As of today, lines of code in user defined functions that have been commented out using "/*" and "*/" are being DELETED when the script is saved and then reopened for editing (or window refreshed). Anton
HELP... form lost all color and notes fields
Hello, Just launched this to 100 of volunteers and the form lost all formatting with color and notes (headings) It is just a plain form with 80 fields now. We need the form to be colored with heading in order for our volunteers to be able to use. Can anyone tell me what I must have shut off or how to get around this? If I edit the form, everything is there. It is also there if I add a record. Only when I click edit on a record from the data sheet do I not see anything but a plain form. Anything
Changing the "from" field in the email response
Hello, My company is using ZoHo Creator as an intake form for potential clients, in a sense. I have it set up so when they submit the form, they get a thank-you/confirmation email. However, the from field in the email comes through as "info." The admin email address we signed up with is info@[companyname.com], so I understand where the "info" comes from, but I'd like to be slightly more professional in the confirmation email to our clients. Ideally, it would be "Company Name" and not "info."
how to setup a scheduled email of view that uses added.user criteria
I would like to create a scheduled report/view that is sent to each of users in zoho creator every 6 months. I would like the use a view they have access to that has a criteria to only shows records they have created (added.user) How can I set zoho to email this view to each of the users and maintain this criteria so it only shows their records? Each record they submit also has a field that contains their email address
Event OnValidate gives no result after pressing on the submit button
Hi I made a function that returns a string: string amount.getValue(int value) { errText = ""; if (input.value > 5) { errText = "unsufficient laptops"; } else { errText = "sufficient laptops"; } return errText; } I also have a form with a textbox When I press on the submit button it needs to call the function that i gave above with the value of the textbox as paramter. I put this code on the event "OnValidate" amnt = input.Number_of_laptops.toLong();
Starting Count From pre-defined number
How do I start counting records from a predefined number I don't want to get a record count of the total records, but rather than +1 of the certain field Example: Helpdesk Ticket # 1002 is submitted Next Ticket will be Helpdesk ticket #1003 I need a way on load (or validate) to reference the helpdesk ticket number of th last submitted ticket, and then add +1 to the value Any help would be great. Thank you.
API Response
I'm testing the ZC api to add a record. It's working, but the response is always "Resource id #1" Here's the php code (with items chenged to hide actuals). How can I echo the actual json response? <?php { $PETS="Cat, Dog, Bird"; $url = 'https://creator.zoho.com/api/buzzap/json/xxxyyy/form/zzzz/record/add/'; $fields .= '&authtoken=yaddayaddayadda123456'; $fields .= '&scope=creatorapi'; $fields .= '&PETS='.$PETS; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $url); curl_setopt($ch, CURLOPT_POST,
Gloabal variables in ZOHO CRM/Creator ?
Hi, I'm making a form which needs to use a global variable. I search on the web how to declare a global variable and I found the following link : https://kbase.creator.zoho.com/application/define-global-variables But I didn't find how to declare them... I have a form with a textbox where I can change the value and if I press on submit it needs to be saved in a global variabele. At this moment I made this both in ZOHO CRM and in ZOHO Creator. My form: My code: amntlaptop = input.Number_of_Laptops.toLong();
Next Page