Latha ：Urgent need of help..
ZC team: I have a business application needs: 4s in China's auto shop to read specific data in their databases, ZC have a way with their database docking? Have any suggestions or solutions? The means is ZC is there a way to get data from external databases? Thanks and waiting your reply Stanley Guo 2012-01-31
Similar script produces error
The application in question sends an email "on success" to the end user. Subsequent follow up emails are sent over the next few weeks using an "on load" script. I have been trying to add a script which continues to produce an "on load" error. This is the script just before the new lines I am attempting to add. It works fine, as do the scripts above it. (NOTE: I have removed the email content so that this post doesn't exceed character limit). else if ((lead.Added_Time.addDay(30) < zoho.currentdate)
On Load View - Check Fields & Input Value
Hello Zoho Community, On Load View I Would Like To Check Fields & Input Value. FOR EXAMPLE: When I Click On The View. It Will Auto Check Each Record If Current Date Before 1 Month > Membership Expiry Date Then On Input.Status Show "*" On Load View For Each Record If zoho.currentdate (BEFORE 1 MONTH) > input.Membership_Expiry_Date { Input.Status = "*" } Looking Forward To Your Help. Thank You.
Custom Action - E-Mail Notification + Input Current Date
Hello Zoho Community, Custom Action To Send E-Mail Notification + Input Current Date. void email.EmailNotification(int toaddress) { sendmail ( To : zoho.adminuserid From : zoho.adminuserid Subject : "Subject of the email" Message : "Your message" ) input.Sent_Date = zoho.currentdate; } Looking Forward To Your Help. Thank You.
Sub Form Field Validation ?
I have a subform where I have set a script for converting the contents of a field to 'Upper Case' input.Product_Description = input.Product_Description.toUpperCase(); And when I access the form directly, it works really well - and I can add the script to On Add, On Edit, Validate etc..doenst seem to matter... But when I enter data through a master form, that has the first form embedded as a subform, the field criteria are not inherrited, so the data entered does not get converted to Uppercase....
see only selected records (updated)
I have 3 forms the first form is called "Car " single line "Automobile Make", single line"Model", single line"colour" single line"unique ID" (database driven) Each Automobile has 5 wheels and tyres hence 2nd form is called "wheels" Lookup Form "Car" for "unique ID" Advanced display options shows "Automobile Make" single line" Wheel1, single line" tyre 1, single line"wheel2, single line"tyre 2, etc etc Form 3 is called "emissions" Lookup Form "Car" for "unique ID" Advanced display options shows "Automobile
No hyperlink for underlying data in ZOHO creator report / chart
Hello i am a ZOHO creator enterprise edition user i have created some reports / charts for my colleague but only the Admin user can use the hyperlink to see the underlying data could any one show me how to share charts with underlying data enabled thanks regards, Matthew
Custom Action showing on clicking on view
I love the new feature of being able to put a custom action in any location on a View. However when I click on the view button to the left of the record the custom action shows as a field label. Apparently it pushes the other field names down on the list so the data associated with the field label is offset by one. If the view is: Field1 Field2 Custom Action Field3 Field 4 Field 5 Data1 Data2 Button Data3 Data4 Data 5 Then the view is Field1 Data1 Field2 Data2 Custom Action Data3
will the ical feed work with 30 boxes?
Unfortunately, Zoho doesn't have a robust calendar for scheduling, so it has referred developers to Google Calendar. I (and a number of others) am very unhappy with the Google Calendar and am trying to find an acceptable alternative. I have heard 30 boxes is a much better calendar that google, but I can't seem to get the Zoho generates iCal url to work in 30 boxes. Do you know if it will work with 30 boxes or not? If so do you have any tips on how to make it work with the zoho generated ical feed.
ZC there any way to get SQL or ORACLE data in these databases?
Hi ZC there any way to get SQL or ORACLE data in these databases? Thanks Stanley Guo 2012-01-29
Stateless buttons not wrapping in IE 8 & 9
When I embed a stateless form in a website Internet Explorer does not wrap the form to fit in the space. Firefox & Chrome will wrap to fit in the space on the website. In IE 8 & 9 the buttons do not wrap and the form is truncated. I attached a document with screen shots. Is this an IE bug or is there some code I can add to get the form to wrap to fit the space? Herb Wexler
Lookup Forms Issue
I'm on my trial and I have an issue that is a kicker to determine going forward. I'm setting up a business process that each form will build on a previous form's submitted data. Form 1 - initial input to start process Form 2 - management form, to be used to accept what is in Form 1 - this form uses a lookup field to get "Name" from Form 1 Form 3 - is the next set of criteria that "Name" will need to go through. (HERE IS THE PROBLEM - see below) Form 4 - another management form to determine going
Adding links to Edit Form and Pass Value
I have a relatively simple DB schema. I am building an application for a charity auction. There are multiple bidders, each of whom will likely bid on and win a number of different items. We won't know the price they will pay for an item until the auction is over. At end of the auction, we need to list all of the items that each bidder won and total up how much they owe. There are 3 tables: (1) Bidders. While there is information here like name and contact info, we are concerned with 3 fields:
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
Next Page