Unable to Fetch data from form
any idea? We are unable to fetch this data, sorry! Please note that your data is SAFE.Report this problem to support@zohocreator.com
Creating a Form which can call data from another form
Hi, I have created a database which is essentially, like an excel spreadsheet, with columns defining variables, and rows of data. I was wondering if it were possible to create a stateless form, which when a user selects a certain record e.g. title, the form then calls data from that record for certain fields. To explain further, incase I am not doing it well. I want a user to be able to go onto the form, select a title, from a dropdown box (the titles are stored on the database), and then when they
Is there a way to add a custom action to the predefined all contacts view???
Hello, I need to synchronize data selected by the user (single or multiple) in the contacts view to my database using a web service. So i need to add a custom action or a button if possible.Is it possible to add a custom action to a predefined view(e.g. Contacts view) ??? If not please suggest me some workaround for it... Thanks
Our Scheduler Doesn't Seem to Work
We have a couple of nice, simple email functions whose scripts execute flawlessly, but we can't seem to get them scheduled using the Scheduler. As "When" we set the date and time with a "daily" frequency, then set "What" as a call to our email function - thisapp.emailoverduereminder.EMailOverdueReminder(); Never happens. Never occurs. First of all, why does this fail? Secondly, can we set the date for some day in the past; meaning the schedule will automatically occur today at the determined time?
Subform and form relationships
Hi Everyone, I have am working on an order tracking app. This is for tracking orders for items which require custom production (not just items off the shelf). I have an Orders form, which generates an order ID for each entry, and within it a sub-form for Items. As each one of these is a custom job within the order, I have been trying to import the order ID from the parent form into the subform, but if I do a standard lookup, it makes a dropdown of all the IDs in the Orders table. Is there any way
Create CRM Event from Creator
I am trying to create a CRM Event from Zoho using the following function: crmEvent = zoho.crm.create("Events", { "Subject" : input.Name_of_Patient, "Start DateTime" : input.Time_of_Appointment, "End DateTime" : input.Time_of_Appointment, "Type" : input.Type_of_Appointment, "Project
Setting values and display when creating a drop down
Hi, The script below runs when a JobID is selected on an invoice form. It creates a dropdown of all the customers associated with the job. The dropdown is of names only, which are the keys in the "contacts_map". What I really want is to display the contact names as display only, but have the ContactID as the value held to the form. <select> <option value="ContactID">ContactName</option> <option value="ContactID">ContactName</option> <option value="ContactID">ContactName</option> <option
Can I embed a zoho report to Add Notes field？
Hi Akash I don't want to jump to open a html view for display a report, like embed in a picture to Add Notes field , embedded in a report to Add Notes field, I tried the following code, but it can't work： plain ="<iframe height='500px' width='900px' name='zoho-report' frameborder='0' scrolling='auto' src='http://creator.baihui.com/stanleyguo/theone/report-embed/report/'></iframe>"Hope get your help.. by the way the Add Notes field extremely useful. Thanks Stanley Guo
Can't insert user in Zoho Creator with API
I have a custom app built in zoho creator where 1 field is an accounts field in Zoho CRM. I can insert into every field using xml and cURL but I can't seem to get the user right.. I get this error when trying to insert in the field "User" Failure, Invalid column value "Test" specified Where Test is an EXISTING account. The strange thing is that there are 2 actual fields but 1 visible field. User is visible but User_ID is invisible.. not sure if that has to do with anything. But that's my problem..
Help passing a parameter to an HTML view with a view embedded
I want to pass a paramater to a view that is embedded in a HTML view. Below is the code for the "on submit" action from the form in which I wish to pass the paramater from. form_link = input.Form + "_HTML"; if (input.Search_Options = "Yesterdays Records") { openUrl("https://creator.zoho.com/jpiajr/food-safety/view-perma/" + form_link + "/todays_date=" + input.Start_Date + "&Added_Time_op=58", "same window"); } if (input.Search_Options = "Date Range") { openUrl("https://creator.zoho.com/jpiajr/food-safety/view-perma/"
A question regarding subforms
Hi. I am building a simple project management application and have run into a problem. Background: My application consists of 4 "objects". These objects are: Projects, Activities, Employees and Roles. Every project consists of several activities and every activity has several roles. Each role is connected to a employee. I want the application to have 2 "tabs", "Projects" and "Employees". The problem: The activities are created within the "project form" in a subform. I want to create the roles while
Problems with Custom Themes
When I change the theme choosing to create my own (Custom theme), the chosen properties are not applied and I get a sort of text+hyperlink version of the UI (see attachment). Sometimes saving the application, after changes to the custom theme, takes a very long time (3-4 minutes and the changes are applied but then if I logout and in again I get back the bizarre UI. I use Firefox.
Conditional field labels?
I have two fields on my form: Country and State/Province. If user selects "Canada" I want the field label for State to say "Province". I the form definition I added the following code but when I go to save the script, it never stops saving. Am I doing something wrong? Thanks, Jeff
Create CRM Event from Creator
I am trying to create a CRM Event from Zoho using the following function: response = zoho.crm.create("Events", { "Owner" : "carlgifford", "Subject" : "Test", "StartDateTime" : "08/01/2012 10:00:00", "EndDateTime" : "08/01/2012 10:30:00", "WhoID" : input.CRM_ID }, 2); It does not seem to be working, I am thinking that the date formats are incorrect. How do the dates need
About toDate(), why the "15:00:00"?
I've put a Formula field which converts a time (which holds date and time like "May 5, 2011 18:08:01") to a date ("May5,2011"). I used "Deadline.toDate()" to achieve so, but it always gives a time like "May 5, 2011 15:00:00". Why the "15:00:00"? Shouldn't it be just "May 5, 2011"? Please help. Thanks very much!
can HTML be added to related list for contacts using custom functions??
Hello, I need to display some data associated to each contact on the contacts page. So,is it possible to use an iframe in a related list or load html into the related list directly?? I didn't find detailed information regarding custom functions for adding new related lists. Please suggest some examples regarding the same or some workaround if its not possible... Thanks
Looking for a ZOHO Creator developer in Amsterdam area
We are looking for a ZOHO creator developer in the (greater) Amsterdam area NL who could develop a relatively simple Assignment Tracker System for Master Students fo a University department. Please respond to this message if possible.
Xml rpc update on a field in a form with subforms failed
Hi i am trying to update field in a form with couple of subforms. When i try to update the field after payment i get weird errors that are not related with the form i am trying to update, but instead it is related with subform in this form. I tried removing this subform but then it gives me same error with the next subform in the form. My question is, does zoho suports update on a form with subforms ?? Or this is some other issue. I checked the code multiple times and there are no errors in it. This
webhook keeps firing
My webhook keeps firing every 10 minutes, instead of just once. It is configured with a workflow action on create/edit that checks the existence of a (custom) field, and fires if it is true. The webhook service returns an empty response with status 200 OK. It completes in 10 seconds or less -- btw, what is the timeout on webhooks? It has fired 15 times now in the 2.5 hours since I "tested" it by saving a record, firing every 10 minutes with the same data. There is nothing listed in the errors tab.
How to sum up pre-added field?
Please see photo, i need to total every amount that is added on the subform. Hope you guys can help me asap. Thanks.
Separate out a comma separated list
Hi, I have a comma separated list of emails in a single field. I want to send 1 email to each email address summarising the information in the form. Eg Row Num Email recepients 1 test@test.com, bob@test.com 2 bob@test.com 3 Test@test.com 4 test@test.com I want Test to receive 1 email with 3 entries and Bob to receive 1 email with 2 entries. Constructing the email content is fine but I am having issues Extracting the emails from the comma separated field I don't think Zoho has an explode type function
Can't use dropdown form fields as display fields
Hi, I have a SERVICE subform that has a SITE look up field. I want the SITE lookup to display the site name and site address. However, when I go to Edit Field ->Advanced Options -> Display As, I do not see all the SITE fields. The ones that are missing are the dropdown fields so I cannot select site address. Note, site address is a dropdown in the SITE form. Is there a way that I can use the site address field as a display field in the SERVICE form without making the site address a textfield in the
Sending notification from one app using email ID of another
I need to send notification when data is entered in one application to the email ID of registered users of a different application.
Convert string to numeric?
Is it possible to convert a string or portion of a string to a numeric variable that can be acted upon in a function? E.g. I want to take a string like "5 - High", extract just the "5" substring and create a function to multiple that by a separate numeric value. Currently failing because the substring is still a string. Thoughts?
How can display pic in a Note Field
Hi Latha My application scenario is as follows： 1，I have a File Upload field in formsc 2,The pic can show in view 3,I now want to the image displayed in a plain field and put the code as bellow plain=("<img width='100' src='http://creator.baihui.com/DownloadFile.do?filepath=/" + r.zpct + "&sharedBy=" + zoho.adminuser) + "'/>" but I try many times it's dons't work,I don't know where is wrong, please help Thanks Stanley Guo 2013-3-14
How to edit a record in htmlview?
Hey - I know how to edit a record using standard Form/View URL, e.g.: /#Form:<formlinkname>?recLinkID=<recordID>&viewLinkName=<viewlinkname> It works great while the <viewlinkname> is a standard view. It fails to work when I use htmlview as the <viewlinkname>. Any idea how can I do this properly using alike: <div elName='zc-component' formLinkName='newXYZForm' params='XYZType=<%=openFormAs%>&zc_Header=true&zc_SuccMsg=Data Added Sucessfully!&zc_SubmitVal=Submit&zc_ResetVal=Reset'>Loading
Changes to the behaviour of the ZOHO Creator platform as a result of platform upgrades.
It has been brought to my attention that there have been one or two changes to the behaviour of the ZOHO Creator platform as a result of platform upgrades. 1) Incorrect indication of change to the Deluge commands. When editing an Application (in Free-Flow mode), any time a user types Ctrl+A (to select all Deluge commands) or Ctrl+C (to copy selected Deluge commands), the red star (asterisk) next to the 'Application+Event Description' in the title appears. This red star is supposed to appear
Separate out a comma separated list
Hi, I have a comma separated list of emails in a single field. I want to send 1 email to each email address summarising the information in the form. Eg Row Num Email recepients 1 test@test.com, bob@test.com 2 bob@test.com 3 Test@test.com 4 test@test.com I want Test to receive 1 email with 3 entries and Bob to receive 1 email with 2 entries. Constructing the email content is fine but I am having issues Extracting the emails from the comma separated field Getting the distinct emails from the list
Considering Creator for Application Development
Greetings all: I have used Creator off and on through the years for smaller, personal projects but am considering it for an online application to sell to end users. I like the scripting capability as well as the deep feature set, but I have a couple of questions what I hope a few of you can weigh in on. 1) How problematic has the updates from the Zoho team been in the sense of application stability? In other words, how often have your apps been broken by new updates that were rolled out without
Getting stonewalled on variable call
Hey, Is there any reason why my function would say my variable is "not declared" even when it's clearly in the script? If I try to save the following script it states just that for 'maxweek1': void schedule_teams.mhl_scheduling_module.toString() { for each r in MHL_Scheduling_Module [(Season == "Winter 2013" && (Team_1 is null))] sort by Team_1 { scheduleteam15 = MHL_Team_Contact_Info_Entry [((((Current_Last_Season_New == r.Season && Nights_Playing == r.Day) && Team_Name !=
Dynamically summing a field of a subform
Hi, I have a subform of invoice items held in a main form of invoices. When the form is loaded, all of the items (ItemCosts) are added up and the figure is loaded in the SubTotal field of the main form using: input.SubTotal = Invoice_Items[InvoiceID == input.ID].sum(ItemCost); This code will not help with any changes made to the open form using 'InvoiceItems > ItemCost > On User Input' as the code is working on the main database and not the open form. How do I access (and sum) all the items in
Want to create a second form to enter data for the same table (duplicate form)
This sounds like I want to create a duplicate form . . . but . . . I have read that thread about copying the script and pasting into a new form and that is not what I want. I want to be able to edit the same table information with two different forms. One will enter all the data fields and one with be a 'quick entry' to enter just a few of the fields which will later be edited on a view in order to enter all the data. Thus the two forms will be working on the same table, not two identical forms
Total a check box field
I have a form called Register It has a checkbox field called Events_Open and a Net_Amount field for the total. The data for the checkbox field comes from a form called Events with field names of Event_Name and Event_Price. Event_Name is a calculated field holding the value of a dropdown called Event_Product. In the On User Input of the Events_Open field is the following code: //Set the initial value of Net Amount input.Net_Amount = 0; //Fetch the amount for the selected items and calculate the Net
Need help scripting toString Function - Pretty stumped
Hi, I'm working on an automated scheduler function to fill out teams into game slots in an ice hockey league season. I want to have one game per team, per week, based on the criteria supplied in the team lookup field that "Team 1" is based on in the code below: void schedule_teams.mhl_scheduling_module.toString() { for each r in MHL_Scheduling_Module [(((Season == "Winter 2013" && Reverse_Record == false) && (Team_1 is null)) && (Team_2 is null))] sort by Team_1 { scheduleteam15
PayPal Usage Question
Can the PayPal payment data be queried just like any other table? If I wanted to find all payments where payer_email=zoho.loginuserid, would this work? Thanks, Jeff
Can't hide field with Form -> On Edit -> On Load Deluge script
I am using the 'hide' statement to hide a field from anyone other than one particular user. I am referencing the zoho.loginuser variable to decide whether to hide or not. Here is my form called 'case' as viewed by the administrator in application execution mode where the field called 'approved' is not hidden (as expected): Here is the same form as viewed by another user. Note that the checkbox field 'approved' is no longer visible. Here is the code that I have in the two events in the script
Recursive Function Work
I have a need for a recursive function and don't know where to start. In the form shown below, I have a sub form for Unit Entry. I need to create a way so that every time someone enters a line item in the Unit Entry sub form the system will generate a list of those items with the same unit number, sales order number, and work order number but for each individual part, it will generate a new serial number. In other words, In the example shown, my user enters quantity 34 of the unit number 1234123.
Add contact email and phone number information on quote
Hi all, I would like to know how to add contact email and contact phone number information on the quote model inventory. Could please someone help me? Tks a lot. Felipe
Multi Select returns values in a different order than I selected them
Hi, anyone has an idea for my issue? I have a two multi select boxes, multi select 1 multi select 2 choice 1 choice 1 choice 2 choice 2 choice 3 choice 3 etc... etc... I select the following, in this particular order multi select 1 multi select 2 choice 3 choice 2 choice 1 choice 3 choice 2 choice 1 etc... etc... in my view when I go to analyse the info i entered, i should see multi select 1 choice
Show record data in form - but not allow edit
I have a function which brings up a stateless form and populates it with the current record information. The user then will edit some fields and click submit to update the record. I would like to make certain fields like redord ID, Name, etc, show up as plain text rather than in a editable textbox -- in order to show the user which record they are working on, but not be able to edit the information. Is this possible?
Next Page