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?
Search and Auto Complete
We are experiencing a problem with the Search and Auto Complete feature on some pick list fields. Our users love that the forms load faster in the case of very long lists and love that the search feature in addition to 'starts with' handles 'contains'. But, the pick list does not always populate with all the available selections. We understand that with the Search and Auto Complete option selected, by design the pick list only partially populates until the user requests additional items via search
Has JSON Changed?
The url for viewing JSON data https://creatorexport.zoho.com/adminname/appname/json/viewname/ Used to display the feed data in the browser. Now it wants to download it as a file. I think this may have messed-up my application. Cheers, John Whitney
Invoking user input within a custom action
Hi, I'm a newbie and am struggling with how to approach this. I have two custom actions in a view - Pass and Fail. An example of pass is as follows: void test.PassTest(int id) { rec = Testing [ID == input.id]; rec.Outcome = "Pass"; } What I would like to do is when this button is pressed in the view the function prompts the user for one or more additional fields. I have created a stateless form but cannot see how to invoke it or pass the values from the form back. Is anyone able to provide
Free Flow Script - Chrome visibility
The problem occurs in the Chrome browser. When I view script via "Free Flow Script", I do not see and cannot edit anything. When I change to "Script Builder", I can see and edit the code. It was working fine yesterday but I cannot edit my views, forms or functions using the free flow script editors. Can someone please investigate? I have tested it with IE and Safari and it appears fine.
SQL statements in Zoho
I am now beginning to understand Zoho a little better. Obviously there is some sort of database in the background that is at work when we use a Zoho app we have created. 1) Is there any way to have access to the database for my app through SQL statements either to execute some sort of transactional statement or statements? Ex. "Update mytable join mytable2 on . . . set myfield=1, myfield2 = 2 . . . where . . ." "Create table . . . " Etc. In some of these cases we would need to know to to access
I need a piece of code to clear certain fields on user edit.
Alright, Basically, I have a form (current form). Once I add/update a certain field, the records of that row of that field is copied to archives. So I need it to clear certain fields (on the current form and not the archive form) once I update this certain piece of information. For example, (This is a bike application) Customer checks out bike 1, once the customer brings the bike back (actual check in date), that row of records will be moved to archives. i need it to where i can clear certain records
openURL - popup window works but same window and parent window do not
I have multiple stateless forms embedded in my website. When the first form is completed the user presses a button which is supposed to load the next form. I am using - openUrl("#Form:Client_Information_SL?Client=" + input.Client_search, "same window"); behind the button. When I click the button which runs the openURL command nothing happens. If I change "same window" to "popup window", the correct form is loaded as a popup and overlays the previous form. In other words, the "popup window" parameter
Criteria in a view of a form with a subform
Hi all I have a form (treatments) with a subform (payment cards). In the subform I store each card payment. One of the fields is the due date of this card payment. I want to show in a view treatments that have their overdue payment last letter (dated before today). The problem is that it shows all the treatments that have some payment card with the date before today, instead of displaying only those with the date of last treatment before today.
Bug: Red line covering on-click
This is under my other account: sigroup/si-ni-chemical-inventory using IE 9.0.8112.16421 The red line prevents me form editing the code. Also this form is not working. Shared with support.... Cheers, John Whitney
Any tips to show embedded slideshows?
I'm looking for a way to build a small knowledge base that will include Zoho Presentations. 1. User opens the KB view to see all the articles. 2. User clicks a custom action (button) on one of the rows to display the record. 3. The record pops up in VIEW mode and has some descriptive text along with an embeded Zoho Presentation. Is something like this possible? Thanks, Jeff
Subform Edit Bug: Can't add a new record through subform link
Greetings! I have three forms: 1. Enter Class/Event/Task (parent form) 2. Attendance (subform) 3. Add Clients Attendance has a lookup field that pulls from Add Clients, and "show a link to add entries to Add Clients" is checked. For the parent form, everything works smoothly when adding new records. However, when I go to edit that parent form, and I click on the link in the subform that is supposed to let me "add entries to Add Clients", the LOADING indicator appears and never stops. It keeps spinning
Missing field names
I have a form that loads data using several lookup fields. This works fine until in another form I use a lookup field over the first table of data. When I go to the display options to choose the data the fields in the table that were lookup fields in the original form are not in the list even though they appear in the table view of the first form. Why can't I access these fields?
Disappearing data
I have a form that has several lookup fields. When I enter data into the form and execute the dropdowns to choose the data for these fields all goes well until I look at the view for that table. In two of the lookup fields the data only appears in one record of the several records in the table. Then if I create a new record the data in the record that shows data in the two lookup fields actually moves to the new record and leaves the other record blank in those two fields. What is going on?
Next Page