Need to fetch a record from another application
I understand that ZC does not support fetching records from another application. Sadly, I'm new to ZC and don't understand the nuances of building functions. I have an application called Common Lists that contains multiple forms populated with common data for an organization (e.g. Employees, Departments, Accounts, etc.). I want to build a suite of applications that share the common data in the Common Lists application. For example, the Purchase Manager application has a form called Requisitions.
creating invoices from creator
I'm not a developer but fairly technical. Is there a tutorial regarding how to do the following 1 - I have a Customer file 2 - I have a file that has all items we sell and prices related I also have ZOHO Invoices setup in a way that integrates with Authorize.net (our gateway). How do I tie this all together so something as easy as the following can be done. 1) An employee can pull up a customer, apply detail items to it, generate an invoice, and email it to the customer, who can then pay it through
Custom Actions - Field Validation & E-Mail Notification
Hello, I Would Like To Create A Custom Action For Each Records It Checks If The ALERT Field = "EXPIRED" Then Sends An E-Mail Notification. For each records with input.ALERT = "EXPIRED" { Send E-Mail Notification } ... Looking Forward To Your Help... Thank You.
Not sorting fetched records
Hi I am trying to fetch and sort a list of items before adding them to a drop-down list. Here is the code: destinations = Destination_Modifier[true] sort by Destination_code; for each destination in destinations { Destination_Code:ui.add(destination.Destination_code); } It fetches and adds successfully but only the first items are sorted and then many items are not. Any idea what am I doing wrong?
Share form/view between apps
Is it possible to share the same form/view and all data between applications? I have the same application duplicated for two different user groups, they have the same 5 forms/views but one I need all the data to be shared and editable between both apps.
App workflow overview
I'm sure I'm missing something obvious, but I have run into a brick wall on my private app... So I have several forms and views. I just created an HTML view, put my main control panel in it, started the app. Entered a couple of required items, all good! But I can't find where to go back to that item in the database and edit and fill out other pieces of information! How do I, as an application USER (not admin) edit and view information that I just entered?
HTML Reports
Hello, I am looking at write a HTML report for my Zoho program but I am not sure where I can get help from to write it. I want to have a report for each order which will have information on it such as customer order numbers, delivery dates, and then machine times and notes which are all related to the drawing number. Could someone point me in the right direction in making this report? Is there a tutorial or a template I could play around with to learn how it works? Thanks in advance
How to make the field "Name" in the "Requester Details" inactive
How to prevent make nonsense in the "Name" in the "Requester Details" and allow only the names of the Active Directory? For example, how to make this field inactive, allowing the selection of only the Active Directory ? Thank you.
Dynamic Field Color in Calendar View ?
Is it possible to have dynamic field colors in a calendar view ? For example if I have a FORM called celebrations, which contains 3 fields (Type, Date, Description) and Type is a dropdown of three choices {Birthday, Anniversary, Wedding} and I build a calendar view based on this form, I would want 'Birthday Entries' to appeare with a 'Blue' label, Anniversaries with a 'lime' label and Weddings with a 'Yellow' label. I cant see how to include this in the deluge script using [zc_LblClr] ?If this cant
Creator Form -> Potentials
Hi, I am trying to create a form when upon completion a new "potential" is created in Zoho CRM. In my implementation, the potentials tab has been renamed "Sales". When a form is submitted, nothing appears in Zoho CRM. I think the problem relates to the mandatory Closing Date field. I don't think the formatting is correct for it to link correctly into the CRM. Can someone advise me? Here is the script I'm using: leadinfo = { "Sale Name" : input.first_name + " " + input.last_name, "Closing
For Subform on user input it does not seem to update main form unless you click another field first
Hi I am updating a main form field from my subform Main form = balance each row in the subform is for payments For testing only one row in my subform If i enter a payment and click another field the balance changes and upon clicking update it is stored correctly in the main form If i enter a payment (DO NOT CLICK ANOTHER FIELD) I can see the Balance change (the on user input script is working) but when i click update the value in the main form is not updated Thanks
Form Object to Function my Form has Subform Rows
When writing the function i can see that the subform is available as a collection but how do you know which row is being acted upon example Function .... .... if (Function.SubForm_1.this_is_a_row How do you know which row is being evaluated Thanks
Dropdown autopopulation
Hi, I was wondering if it is possible for the dropdown list to be autopopulated with values from another field. For example: View 1 "Authors": Name, Books written View 2 "Books": Title, Author(dropdown) Now, I would like the Author(dropdown) in Books to automatically contain the list of records from the column Name (in Authors). Is this possible?
transfer field data from stateless form
I have two stateful forms - "Entry Form" and "Entry Detail Form" and have set up the Entry Form with Entry Details Form as a sub-form. Unfortunately the scripted calculations carried out in the sub-form, whilst they work in stand alone form, do not work in sub-form, so I thought I would try to make entries to the sub-form using a stateless form "Class Entry". However although I have set up the stateless form and it works perfectly properly, and despite reading and re-reading the advice in Developer
Too many bugs in your creator - is not reliable.
Too many bugs in your creator. is not reliable. - Often gets lost ralations of lookups; - Lookups are not shown in the subform; - If the lookups in the subform are "required field" can not be inserted into and block the registration form; - In edit mode, the lookups in the subform, the existing records are not loaded, remainnull and lose the connection; ---- in my application "Italy" - Form Regions is no longer accessible for editing, the script is there, but only those events, "Form definition" crashes.
bug in related subform
related bug in subform, If I insert a "related lookup" with the subform in other mask, the system goes in crash.
All I want is a No Results Found message when no data is found.
When no data is found in my HTML view, I want my own message that says so and explains what to do next. I know how to do this if a view is simple, but mine is not. I will explain my problem, and here is the page in question, http://www.slaafws.org/meetings : 1. My database has TWO forms for two different types of groups with BOTH form views displayed on the same HTML page. 2. The two types of groups are searched simultaneously by dropdown by country and state for US and Canada, BUT only country
Arkansas comes up in a search for Kansas, I need exact terms please
Isn't there a way to ignore all terms except the exact term being searched for? Arkansas comes up when I search for Kansas, others have said Female comes up in a search for Male. This is a big problem for me. Thanks
Support have screwed up my lookup field
I requested help with sorting values alphabetically in a lookup field. Then on the 19th Bhaskar from support informed me that he had made changes to the script. Now only one value appears in the lookup field. Can anyone from Zoho get in touch with me and tell me what is going on there?
Upload & Download File
Dear Sir / Madam I am creating a Application form in zoho creator, in which i would like to attached / Upload a file which eventually applicant will download and again upload after required data filling. Please help me at the earlist
Error message in my deluge scripting. What am I doing wrong?
I am trying to add an update script to a field, so that when the field called "Complete" is set to "YES" I will get an email saying "Send Thank You Card to <here the name from the "Contact" field should be inserted> on <here I'd like it to insert the date 5 days from now>. Thank you for choosing Atomic Disc to duplicate <here the name from the "Job_Title" field should be inserted>. Here is the script I've used: "Send Thank You Card to " + input.Contact + .addDay(5) + "Thank you for choosing Atomic
Fetch values in a Subform what is the format or is it supported
Hi Wanted to count the rows in a subform using count function but could not get that to work Then i wanted to Fetch all the rows for a subform to obtain the count Which leads me to the problem i cant see how to fetch the rows in a Subform (or at least it is not obvious using script builder) Help Thanks
How to add the duplicateCheck parameter when inserting data to CRM from Creator
This example: https://help.creator.zoho.com/Creating-a-record-in-CRM.html claims that the following: zoho.crm.create("Leads", leadinfo); is a wrapper for this: https://zohocrmapi.wiki.zoho.com/insertRecords-Method.html The insertRecords method has a request parameter: duplicateCheck=2 which allows me to update a record if it finds a duplicate. How can I use that duplicateCheck parameter when using the "wrapper" zoho.crm.create provided in Creator? Thanks, David
Creator API add to form with Dropdown or Lookup wont accept Blank or -Select-
Need an answer please, i am paying a programmer to wait ==== From testing it seems you have to pass a value, blank or -Select- both return fail I would expect -Select- to work.. maybe i am missing something is there a trick to this ?
Urgent pleae! Formula fields in a form don't work, please help!
I changed the name of my form and the links asociated to it in my whole application. After this, the functionality of formula fields appear not to be working in this fomr. Please help me out. This is the form. The application is shared for support. https://creator.zoho.com/yaxche/form/220/edit/ Thanks in advance. I would appreciate to look at it rather soon as I use this for business operation.
Subform: Quantity of Add Rows...
I have a subform, right now it seems to be like I can´t add more rows, I have 16 Rows. I put on the edit field of the Subform max rows = 30, but it seems to be that its not working. How can add more Rows for the Subform?. I will appreacite any help on this. Victor Miranda
Formula on a value in a related table?
Hi: In a formula field, can I use the value from a column in a related table? If so, how? Regards, Tom
Help with "Average" Aggregate Function
Hi all: I'm new to scripting in Deluge and have a question: How do I fetch only related records located in a sub-form (a.k.a. a related form) and then calculate the average of a specific field in that sub-form? Specifically, I need to know how to write the "criteria expression" part so it only finds those fields related to the parent form (not all records). I'm using the Fetch Records drag-n-drop function wizard. The pure Deluge Script syntax is... //to find the average of a numeric field for specific
Pass parameters to ZC form or view through the ZC html view page？
Hi In the html view page, when click on a link or an image, can I pass a parameter to the ZC and then open an existing record？ or have any suggestions? Thanks Stanley Guo 2012-1-12
problem in view for string with spaces
if in form there is a string with a lot of spaces results is trim the spaces ... example (field lormula in form that format string to fix length): "Name: " + Name + " age" + age ; result: Name: Peter age 30 Name: Augusto age 35 ---------- i like: Name: Peter age 30 Name: Augusto age 35 Ruggine from Italy
On Update on Add does it make sense
Hi just trying to get my head around this When you first add a form how can a field "On Update work", there is no reference to be updated ? maybe i am missing something and need to stop working so late
Setting CRM "Contact lookup" field value
Hi, In our CRM, we have added several custom fields in Solution entity. We have added a Contact lookup field. Then, we try to populate Solutions from a Creator Form via script, after creating, programmatically too, the Contact. We do something like this: c = map(); c.put("First Name", input.First_Name); c.put("Last Name", input.Last_Name); // other fields... i = zoho.crm.create("Contacts", c); // error treatment... s = map(); // other fields... s.put("Contact", input.First_Name + " " + input.Last_Name);
Suggestion - form template
form: optional header for SubForm fields .... or SubForm fields .... or SubForm optional footer for SubForm
ZC and GravityForms? Has anybody done this?
I'm considering buying the GravityForms wp plugin to easily make better looking and more functional forms, and I'm wondering how easy it will be to integrate this with ZC forms. Has anybody had experience using ZC and gravityforms together? I figure the GravityForm will either Post to the ZC form, or perhaps send email to ZC form. Any thoughts, suggestions, or examples of past experience would be very helpful. Thanks in Advance
OpenURL error: Passing arguments
G'day, I request assistance with an error associated with the following code. I suspect it is trivial. I send 2 parameters from a form to a HTML view using OpenURL: ((((("/" + zoho.adminuser) + "/") + zoho.appname) + "/#View:Boys_Search?searchParam=") + input.Choose_your_city + "&searchParamD=" + input.When.toDate("dd-MM-yyyy")) Possible errors: a) Syntactical error in how the two strings are being passed. b) Because 'When' is infact a Date field, toDate() function is redundant. Would greatly appreciate
View Enhancement Shared user Select box is no longer visible
I allow my shared user to add and to edit records....the select check box is no longer visible As admin i see the check box problem is in FF and Chrome Am i imagining this === Maybe i had the checkboxes there before because this view had functions..which are header based and which do act on a record
relative URL for image display in Marketplace demo?
In reference to the demo mode in Marketplace, this thread says that "the demo works only if relative urls are used and breaks when full url(starting with /<username >) is used." As documented in many places, I am using the "https://creatorexport.zoho.com/DownloadFile.do?filepath=/<%=titleImage%>&sharedBy=<%=zoho.adminuser%>&appLinkName=<%=zoho.appname%>&viewLinkName=Books_View" technique for displaying images that have been uploaded using the application I have developed. Of course, everything works
How can I display fetched records?
Seasons' Greetings! I am new here (see question). Would appreciate assistance with the following: - I have a stateless form with a 'Find' button. - On clicking 'Find', I fetch records from another form and store it in a variable. - How is it that Deluge allows me to display these fetched records? Thanking you in advance, inclininwirefree
Waiting Time on Click
Dear Sir/Madam I have assign a "Alert message" and a URL for next form in one Stateless form of my application. But once the user click, the form directly jump to next form. Waiting time for reading success message is very very less. Could somebody tell me how i can increase this waiting time after Click a stateless form Shiv
Sub form info in email
I have a simple form that has a sub form in it. I want to be able to send the information captured in sub form in an email, on submit of the parent form. But all i seem to be able to do is submit the IDs of the Subform records. Can someone please help this has taken me way to long and it seems like an easy thing to do.
Next Page