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?
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
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.
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
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.
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
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?
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 ] }
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
Calling a view or form in a Function
So I have a view that I have setup and a custom action that calls a function and works (function is just some simple test code) What I need to be able to do is two things: 1. I need the syntax for calling a view from the Function 2. I need the syntax for calling a form from the function. Help
How to convert javascript to deluge script
Hi, How to convert javascript to deluge script. Eg Code : <div id="vm"></div> <script type="text/javascript" src="https://www.swarminteractive.com/js/vm.js" ></script> <script type="text/javascript">client="4740"; width=580; secure=true; vm_open();</script> Please help me out of this.
Re use Formula field
Hi Can I add bellow code to Formula field? r = formkhzl[xsdm == input.xsdm]; openUrl("https://creator.baihui.com/lg8888b/jk/formkhzl/record-edit/view17/" + r.ID + "/","Popup window","height=600,width=600"); Thanks Stanley Guo
Platform update may have effected dates?
An application that was working perfectly for months stopped working today around 9:30 am NY time. At this same time, the app started to experience a very long duration upon submit actions. After spending hours diagnosing things (the logs did not show any errors), I decided to remove this bit of code (submit action) if((input.DELIVERY == zoho.currentdate) && (input.REMINDER == null)) { // some code that sends an email } to //some code that sends an email and observed two things: 1) The code
General Creator Question
Working on my first Creator project. I have a credit application I want to add to a Lead record in CRM. There's too many fields to just add these to the Leads file. So, I think the best solution is to use creator. But I'm concerned that even in creator, there are too many fields to have on a single form, so I want to divide up the questions into logical groups and then be able to navigate between these groups easily to collect the required data from an application. But it look each form and view
if you do a lot of deluge script
... is there a better app to code with? I hate the scripting editor. Is there something for mac?
tooltips do not like "
Tooltips are getting truncated if there is a " character. Are there other characters that should not be used in a a tooltip? If you put he following in a tooltip it will truncated after the a This is a "tooltip" Herb Wexler
using checkboxes in script
In my form I have checkboxes for days, Sunday through Saturday, field name is Days I'm trying to check if day was selected then do something for that day ... lets say set day to number of the week it is, as I try to do here. for each selectedValue in input.Days { if (selectedValue == "Sunday") { day = 1; } if (selectedValue == "Monday") { day = 2; } // ... Tuesday ... Wednesday ... Thursday .... Friday ... Saturday ... alert
Implementation of right join within Zoho Creator
I need to implement the equivalent of a right join in a View in Creator and then display with grouping. Here is an example. Imagine two tables, Supervisor and Employee. Each has a primary key and a Name. There is a one to many relationship such that an employee may have only one supervisor, but a supervisor may have many employees. This is implemented in forms in Creator my adding a lookup table in the Employee form in order to choose the Supervisor. Now imagine that some Supervisors have no
referencing a multiply linked field in Deluge script - how many link levels can I go?
I am working in a stateless form. I am trying to reference a field that has been linked through regular forms via 'lookup fields'. This is what I have done and I believe I got this code from an earlier inquiry of public example app: Here is only an example to illustrate what I want to do. The user enters a unique customer ID (not the record ID) in a stateless form field. And suppose the customer has earlier selected one Product in a lookup table on the Customer form. And there is a Product
Merging rows of multiple data - similar to mail merge Help :)
I want to create a form that resembles a 14 labels per page form, I will print on to labels paper. I have the following script which only produces a page of the same data(address) I cannot find a Next record command or similar to add to next block of data - what do I need to add/do htmlpage dALEMAILHTML() print = true content <%{ fetch = Prospects [Email.contains("@")];%> <div class="WordSection1"> <table class="MsoTableGrid" border="0" cellspacing="0" cellpadding="0" style="border-collapse:collapse;border:none;mso-padding-top-alt:0cm;
Anyone else having problems with saving scripts tonight?
Steps to recreate: 1. Views > Select a view to modify 2. More Actions > View Definition > Save Script Green message area just spins saying "Updating script..." -Jeff
Date list variable returning as a string
I have created a date list and I am trying to use the dates stored in the list to fetch records from a form. I use "for each element" and create an Instance variable called tempDate. I then try to use tempDate in "fetch records" but it shows that tempDate is now a string variable. How can I pull records that match the dates stored in my list? Thanks, Walter
Referencing a record with a lookup field
Hi Everyone.. I have been getting a lot of great feedback from the forums and its been a good response time so I thought id put this issue forwards, maybe its a limitation or maybe i'm just doing something wrong; okay so the following is my setup Regions Form Region - Single line for each region (Europe, ME, Africa) Customers Form Customer Name - Single Line Region - Lookup field for Region in Regions (Works Fine) Project Form Has Lookup Field for Customers Customer Name (Works Fine) Region - Lookup
Really struggling to set up a domain account in Creator
Hi Team I am really struggling to set up a domain account in creator. I have edited the CNAME field with my domain provider to the value requested and have left it for several days but verification still returns the error message "CNAME Verification failed for the domain itmooti.com.au". My domain provider is www.crazydomains.com.au - do I need to contact them? My domain is www.itmooti.com.au I have sent several emails to support but am not having much luck with responses. I am desperate to get this
Simple Excel formulas
Hi, I have uploaded my excel file into creating and it created a form to add new data automatically. However, it didn't import the formulas as well. For example, Number of items: 5 Price :10$ Total Amount:50$ I got the total amount result automatically in excel however, I couldn't get it in the creator. How can i use the simple math formulas in the creator? I couldn't find a satisfied documents which are giving brief information about these issues. By the way, I extremely suggest a guide which is
what makes fields unique in a form?
I am adding records, by using script in FormX On Add/On Success script block I am duplicating records of FormX but modifying a few fields weeklist = {0, 1, 2, 3, 4}; for each week in weeklist { var = insert into FormX [ EmployeeID = input.EmployeeID someField = input.SomeField +1 ]; } New records are not created and I get the error "Some of the fields are unique" I did not intentionally make any fields unique. I don't understand why I am getting this error
Formula Field not Updating with Large Data Sets
Hi, I have a data set that is about 2300 entries. I have added a simple formula field to this form. Unfortunately the formula field does not update for any of the entries. The same formula field works fine with smaller data sets. How do I get around this? Thanks! Mike
Pull Multiple Fields from One Form to New Form based on Lookup Field Selection
I have two forms - an Event form and a Volunteer form Event form has Event Name, and includes Coordinator Email Address . My Volunteer form has lookup to Event form. I want to create a field so when the Event is selected I also pull in the Coordinator Email Address so I can send an email notification to the Coordinator when a volunteer signs up What is the best way to do that?
Can I enable real time column Filtering in Views for Related Fields
Filtering the data in Zoho Views is a convenient feature to allow the user in Acess mode to customize the display. I have just recently added some Related Fields to Views, which allows one to view related data in a 'lookup' field. However when I choose 'Set Filters', I see no options to enable filters on the related fields and in access mode, there are no filters for the related fields. Is there any way to enable filters on Related Fields? DJ
Grouped items get broken up for no apparent reason
I have a problem with a view https://creator.zoho.com/ecgnet/ecg-work-programs/#View:Sector_Thematic_Evaluations I am displaying items by group (specifically, Sector/Thematic Subclass as designated in my database). I am not sorting the items by any other means. As you can see, some items that should be under one subclass (in the screenshot, it is Climate Change) are listed apart. Another group, Climate Change, Social Development, cuts into the list. Am I doing something wrong or is this a bug? Thank
Next Page