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();
How to pass url parameter value to a form's text field
Hi, I have been searching for ages but I couldn't find it. I have a stateless form (but stores record in Customer View) After filling up the form, there is Submit and Add Record so it's redirected to another HTML form (with embedded zoho form) using this url. I succeeded on this. https://creator.zoho.com/christianjoy/sample/#View:Add_Session?CustID=789456233 My Problem: In my Session Form (inside Add_Session HTML View), i have a Customer_ID text field. How do I fetch the CustID=789456233 from the
Populating fileds
My question is how do you fetch the data from the CRM by calling the recorded Then populating the a field Eg test = Test [CRM_Lookup == "8000210000000000 "]; // do i call name or the id input.my_input_box = test.field_name_from_crm ; but get the error test.field_name_from_crm dose not exist How do I know if the lookup has made a matched ? is there a simple example to get started using the scripting as i have not found anything Thanks
How can I access a particular field of a record of a List type subform, in the main form using deluge?
Need to access a field of a record added in a List type subform, in the "Action on click" of the main form.
How to get the Record ID of Zoho CRM object from one stateless form to the other, in order to update the same record in CRM from the other form in Zoho Creator?
I am having 9 stateless forms in zoho creator. In the first form, I am creating a Lead record in Zoho CRM. From the 2nd form and so on, I want to update the same Lead record with the input values. How can I do that? Is it possible to get the Lead ID in all the forms from the 1st form?
Sub Forms
Hi, I created a form to be used as a subform. In that form I have scripts to hide/show certain fields depending on selection criteria. They work fine when I test the application. However once I use the form as a subform those scripts no longer work. Is that normal? Is there anyway around this? For example I need to create a Survey for visiting bakeries. A lot of the input is about the store itself but then we need to start recording the product range and costs etc. I had hoped to create the main
CRM Integration Tasks
How do you map a recurring crm event / task? Do you set the default key "Recurring Activity" to "true" (boolean) since it is a decision box field? And what about the other recurring info needed: "Start Date", "End Date", "Repeat type", "Repeat for <field> weeks", "Monday" "Tuesday", etc (checkboxes)? Thanks Kevin
PDF export does not respect landscape mode using 'New PDF generation'?
Hi, I have an issue with PDF export of HTML views. As you can see from the below screenshots, the PDF output looks good with the "New PDF generation" disabled, but an extra page is added at the start of the document. With the new PDF generation enabled, the extra page is gone but the table looks cramped and unattractive. Is there a way to have the best of both worlds - no extra page, plus report looks nice? It looks like the new PDF generation does not respect landscape mode or otherwise it is not
DB Relationship Chart
I'm enjoying the Zoho Creator experience so far. Being an old MS Access guy, one of the things that I miss is the ability to view and print a relationship chart. The application that I'm building is eventually going to be pretty complicated and being able to use a visual aid like that would certainly help. Any thoughts on something like this?
RSS Feed into MAC OSX Widget
Hello, I have a created a RSS feed widget using the program Dashcode. The widget takes the feed from my zoho application and plugs it in to nice little display of my app info. However the widget doesn't seem to be updating whenever I make a change in my zoho application. Has anyone ever done this before and had it update? I read in the help section that the rss feed could take anywhere from 5-10 minutes to update but that didn't happen. A
Adding Users
I'm still having problems adding other users. I've added the email address of the user I want to invite, but he doesn't get an invitation. Please confirm the process required to add new users. Thanks, martynhale
long forms
Hello I need help with a very long form, that i would like to split in several small forms, but still using the same recond on the table. Thanks!!
Overcoming max # of fields on a form...
I need to create a form/set of forms to handle the collection of over 300 fields of information for a Credit application. In reading, it looks like there is a limit of 80 fields on a form, or less if you're using drop down lists. How can I overcome this? I can break the questions into groups, and put each on a different form, but I understand that each form creates it's own file/table. And I need all information to be in one record, at least ideally. Any suggestions would be appreciated.
How do I script to do something for each week between dates?
And where can I find documentation on loops? I have something like this Start_Date End_Date I need a loop like this for every week between Start_Date and End_Date { do stuff for week [ i ] ... } is there something built in? But also if I can extract n, like this n = End_Date.getWeekOfYear() - Start_Date.getWeekOfYear() and do a loop like this (I'll give it c++ style) for (int i=0; i< n; i++) { do stuff for week[ i ] }
Displaying previously defined relationships in forms / tables
Hi, Hoping someone can help me with my problem. In my database, I have Form A & Form B. In form A, I have linked a "Name" with a "Region" that person lives in. In form B, when I use the lookup function to select the person's "Name" from form A, I want it to automatically display (on form B) the "Region" the person lives in (as previously linked in form A). Can somebody help me? Thanks, Andrew
How to adjust the page margin when printing an html view?
When I print an html view, there is a 3/4 inch left margin. How can I override this so that my data prints with only a 1/4 inch margin? I have not been able to find a way to modify the default css, although I have seen reference to an "external css" capability. Can anyone point me in the right direction? ~Steve
Next Page