duplicates
I'm sure it has been asked and answered, but I missed it. How do I find duplicates, based upon one column (name, in this case). Before I found ZOHO, I had my data in several different services, and when they proved unacceptible, had to move it. Each time I moved it, errors such as duplicates crept in. My best day in a long time was to find ZOHO. THANKS. Jim West
updating records in grid view
Hi, for 2 days now, In grid view, I only can updated six records at a time. Anything more than 6, it tries to "save records" for along time unsuccessfully. please help, i need to update 100s of records everyday. i cant do it in an increment of six. it will take the whole day thanks
Hide field from others does not work in a permalink?
Hide field from others does not work in a permalink? In a form oppened from a permalink all fields are visible? is there a way to hide a field here? Cheers Luis
How do I compare two text fields from two forms?
I have written\copied this code below, however, it isn't working. I wonder if it had to do with the fact that they are text fields. if (count (Mrs_Weaver_s_Question_of_the_Day [Question_of_the_Day == input.Question] ) == 0) alert "Question of the Day was not listed. Try again later"; cancel submit; Please advise.
Aggregate values from Multi-select field populated with query-string during function call?
I have a function that works together with a stateless form: void ReverseDeposit(Payment SelectedDepositGroup) { querystring = ""; for each Payment in SelectedDepositGroup { querystring = querystring + "recIDlist=" + Payment.ID + "&"; } openUrl("#Form:ReverseDepositValue?" + querystring, "popup window", "width=600"); } The stateless form has a Multi-select field that gathers the IDs of the selected records of the Payment form in a view. How can I aggregate the value of
reference a field value as part a field name
BACKGROUND INFO: In a form named Payment I have fields with the word Note in their names; one for each month, e.g. JanNote, FebNote, MarNote, etc. Using a function and stateless form I will have a Custom Action allowing the bulk change of a selected Month's Note field in many records. The stateless form has a dropdown field named StatelessMonth with a selection menu of the months, Jan, Feb, Mar, etc., and a single line field named StatelessNote. Upon Submit I want a selected Note field in the Payment
I have a form in zoho creator when I submit the form the data should be saved in salesforce Lead. Is it possible in zoho creator?
Hi, I have a form in zoho creator when I submit the form the data should be saved in salesforce Lead. Is it possible in zoho creator? Thank you
How to get the left x characters of a field?
I am trying to get the first 3 characters of a given field to use in a formula for a 2nd field. I do not see a formula/deluge script that allows for what in Excel would be Left(field, # characters). Can anyone point me in the right direction? For example, I have a Client Name field in a form called Clients. I want to pull the first 3 characters of the Client Name into a 2nd field called Client ID.
Problem with Free-flow script view in IE
I'm using IE 9.08 and just today have had a problem with the free-flow script view. The font used to render the script (and the numbers to the left of the script) make the script unreadable -- they are all symbols. When I view the script in script builder, all is fine. This problem arises for both views and forms. The problem just appeared today. It does not show up in Chrome. As I said, the problem doesn't appear in the ScriptBilder, just in the free-flow script. What font is being used
Please Reply this Can I use My own Domain Name
Hi Team Can I use my own Domain name for eg:- Application Link is http://creator.zoho.com/l3admin/namexYZ/ Is it possible to use my own domain eg: http://mydomain.com/xYZ/ instead of http://creator.zoho.com Please reply this Smitha
Are there dynamic functionality based URLs for ZOHO Reports?
I love the Reports feature added to Creator that integrates ZOHO Reports. I noticed that the URL parameters functionality doesn't seem to work for reports. e.g. http://<your app URL>/#View:<view name>?<field name>=<field name value> The above allows the dynamic filtering of the view based on field values. It doesn't seem to work, however, for #Report:<report name>. Which forces the creation of multiple similar reports to handle various filter criteria (e.g. Totals this Month, Totals last Month).
Zoho Creator printing
When in the Summary View, can I have a page break separating each record? So when I print the Summary View, I got one record on each page. Thanks.
Hide/Show Function Not Working
I have implemented the simple hide/show function on my form to achieve a simple outcome. I want to hide fieldA on load so I have added to the On Load Diluge Editor hide fieldA; I want to show fieldA when fieldB which is a radio box has the option "Yes" selected. I have therefore add to fieldA the following on user input script: if (input.fieldB == "Yes") { show fieldA; } else { hide fieldA; } For the life of me I can not get the simple function to work. Very frustrating. The form doesn't
Published to a client but he does not see the data
Hi, I published an application to a client but forgot to check "with data". I then republished but my client still does not see any data. I did not see an "unpublish" option. Any ideas what I need to do so my client will see the data. Thanks, Alon
View criteria for last 168 hours/week.
What is the result of the following criteria in a view? Assume today is Thursday at 8:30pm. Will it show only records added in the last 168 hours (since last Thursday at 8:30pm)? Will it show only records added since one minute past midnight last Thursday morning? Will it show only records added since one minute past midnight last Friday morning? Added_Time >= (zoho.currenttime - '1W:0D:0H:0M:0S') Herb Wexler
Need Help for PHP Return Page
Hi I have creator application stateless form, and if i submit the button in my form , then it will goes to my PHP page which was in my server, then if i enter the data in my PHP form , then the page will return back to my Creator application form. I have the below error when i redirecting the page. " An error has occured. It has been reported to Zoho Creator support. We will look into this issue . Sorry for the inconvenience caused. Go to Home " Let me know How to solve this issue. Thanks
Script Builder window can it be made taller
Hi, When working in Script Builder the height of the window makes it hard to see a complete for each loop especially if you have a lot of statements in between Any way to make this window taller ? so you can see more of the code ? thanks
Need a developer for Zoho Creator for CRM
I have a client currently using Zoho CRM with Google Apps who would like to have a custom module build with creator for use as an add-on with Zoho CRM. They would like to have a rental equipment module that would integrate with CRM and Quickbooks add-on. Anyone up for the challenge?
Last Modified Date and Version# for HTML Views
Rather than typing it manually, it would be neat to have built-in variables for HTML views that display the last modified date and version number. Cheers, John Whitney ZOHO Creator Developer
Embedded forms, weird URL
Hi, Please take a look at the two embedded codes, both for contact forms on our web site: The forms are set up identical with identical sharing permissions etc. But #2 has all kinds of extra "GHJhj;HJB;HJ" in the URL. #1 does not have that... Why is that so? Kind regards, Bo Thygesen 1: <iframe height='500px' width='100%' name='zoho-smallno' frameborder='0' allowTransparency='true' scrolling='auto' src='https://creator.zoho.com/bo.thygesen/smallno/form-embed/smallno/'></iframe> 2: <iframe height='471px'
Reminder emails to attendees
I see the exciting new ability to add events from Creator to Calendar. https://help.creator.zoho.com/Create-an-Event-in-Zoho-Calendar.html However, I'd like to create events so that attendees automatically get reminder emails at a specific period of time (perhaps 2 days) before the event occurs. How would I do that? Also, is it possible to customize the reminder emails in any way? Also, once I create an event, how would I update or delete it using Creator? And if an attendee declines her attendance,
Selection Dependant Fields
Hi, I am wondering how I can create a selection dependent field: For example: Type: if A is selected then sub-list A is shown below for further selection or if B is selected then sub-list B is shown? Thanks
placing two controls side by side is not happening
Hi, Zoho form is divided into two parts.In one part how to place two controls side by side.That is not happening. Please help me out of this.
Anyone know the standard form time out?
Hi folks Can anyone tell me how long it is before a Zoho Creator form assumes you have wandered away and logs you out? I lost a lot of data at a demo the other day because of this (mucho embarrassing!). Also, does anyone know if there's a place you can tweak this setting??
URL in Creator contact form
Hi, we are using our creator contact form extensively through out our site. (we are a real estate agent, so at every property there is a contact form). So basically the same contactform is displayed on several 100 URLs. Is there a way to include the site specific URL in the contact form, so that we can see from which part of our site the customer has contacted us? Kind regards, Bo Thygesen
multiple criteria using bidirectional lookup fields
I am trying to use set criteria to use 2 different fields in a bidirectional look up to sort my data. (Warship_Name == input.Warship_Name && Engine_Type == "Main") in my engine view I define what ships can use that engine. and also define whether the engine is a main, mjet or scram. I would think the code above would only show me engines (in my warship view) that work with the listed warship and also need to be defined as Main. However it seems to only pay attention to the first part Warship_Name
Hide Subform Field based on Group Membership
Hi Is it possible to hide the subform field of a main form conditionally based on whether the logged in user is a member of a certain group? T
Will not import data from google doc or allow me to cut and paste that data
Hi - I have successfully been able to create a new form previously by importing data from a spreadsheet. Tonight when I am trying this I select the document I want - press next and it says loading and then does nothing. Same thing when I try and cut and paste info as an alternative - select paste and no entry is made. Thanks Kendra
Custom domain
Could a Zoho guy explain what the "custom domain" marked as complete in the working on feature list, refers to? Also, when can you implement the html to pdf WITH IMAGES and PAGINATION ???? Thanks.
Record level permissions
Here is what I want to do: 1. User enters email and a password. 2. Script compares to see if email is already in database. 3. If email and password match, the user can edit ONLY their record. I can do #1 and #2 - looking for help on how to implement #3. Thanks! Julia
Access all products from PurchaseOrders module
Hi, Is there a way to access Product_Details data in PurchaseOrders module via Zoho creator? if there is, could you please guide me as to how to go about it? thanks.
Rich text editor button icon positioning
Lately in Chrome, the RTE is displaying button icons in strange places. Cheers, John Whitney ZOHO Creator Developer
Based on 1st form data need to do some changes in 2nd form
Hi, Based on 1st form data need to do some changes in 2nd form.For example,I have two forms,lets say one is company form & other is employee form.In company form i have one SingleLine control & Checkboxes.So in Employee form i need to show/Hide the data based on Company form textbox & Checkbox selection. Please help me out of this.
HOLD DATA IN A DROPDOWN MENU FROM FORM TO FORM
I have a dropdown menu that I want to hold data after submit button is hit. I want the dropdown menu to remain the same unless the value is manually changed. I cannot determine the script to accomplish this task. Thanks for your help. PZ
How do you specify two criteria in the "Set Criteria" portion of a lookup field?
How can I have my lookup field key off of both criteria I show below? It will work with a single entry, but no matter how I put the second one in, it removes the second option when I click the Done button.
Conditional X-Axis Dates in Reports
I have a report that tracks some activity on a monthly basis. Is there a way to adjust the x-axis of months to a custom range like July 2012 to July 2013? Or is there a way to only display months that have data?. Here's an example Cheers, John Whitney
Updating Related Record on Case (Case Add Comments)
I am trying to update a related record on cases. Specifically, I want to add a comment to the Add Comment area on the case. It seems like that field is in a solution record that is related to the case, and trying to pull the id out to update the Add Comment field on the associated Solution record. Any help much appreciated! if((input.ZC_Subject.contains("Case#: "))) { input.Case_ID=(input.ZC_Subject).subString(11,29); input.Case_Response=(input.ZC_Content).subString(0,(input.ZC_Content).indexOf("---------------------------"));
Ive got a csv / xls file that i want to import automatically on a schedule
is this possible? i am open to thinking outside the box. Ive got a csv file with about 700 records, that i need added to a view on a schedule. for example, i need it to import this csv on a local hard drive every night at midnight. is this possible? i need help! Thansk!
Link two forms filled one after the other by the client
Hello, in my application, I have a form called "contact" and another with "service order". The client will fill the form contact with his contact information and will be redirect to the next form (after clicking the submit button) to define which service he wants to order (let say between a transcription and a translation) and the related informations. A client (with information saved in the contact form) can later have many service orders. This is why I need two forms. Now, I need that the service
Database
Hello if i creat an app on zoho ,, can i get the database to put it on my on server
Next Page