Cannot duplicate an application
I have submitted a support ticket and sent an email to support and there's no resolution yet after a week of waiting. When I try to duplicate an app, the screen message says "duplicating" yet nothing happens. I have also downloaded the .ds script file and then import the script, and nothing happens. Some of my other apps also suffer from this, but not all This is under account sigroup Fix this today! John M. Whitney a.k.a. buzzap
Populate a CRM (Products) field in Creator App
I am trying to achieve exactly what is in this SAMPLE APP from Zoho, minus the input.Quantity_Available. I am having issues with this and am a new Creator user so any suggestions will be greatly appreciated. Thanks!
Summary and paper size
How/where can I specify that, using the summary report, I'd like to print 2 records per page? Or 4 (2 across, and 2 up and down)? Is any of that possible?
URL for viewing details based on drop down
Hi Currently have 3 forms. 1. Company 2. Contact 3. JobDetails In the job details I have a lookup for Company_Name and Contact_Name from the corresponding forms. I need to create a link for users to be able to view details of each of the companies and contacts. I need a link for users to click on to view the details of the selected company from the drop down. So the users selects the Company from the company_name lookup and it shows them the details of that company. I tried a note field with a
Show / hide fields in stateless form depending on value chosen in lookup field
Hi What code do I use to show or hide selected fields on a stateless form depending on a value that is chosen from a lookup field in the same form? Thanks
can not copy/duplicate sample applications
Hi all, I recently started to use Zoho and am hoping to use sample application to learn faster. However, I could not successfully copy/duplicate the sample applications at https://creator.zoho.com/sampleapps/. The error message always shows me You have logged in as xxxxx@gmail.com. You are not allowed to access this application. I have tried to duplicate dozens of sample applications, none of them worked, but I can install free applications in Zoho market place. Is this due to the plan I have is
user dedfined choice on checkbox
Hello there, I'm new to Zoho Creator so sorry if my question sounds silly... Is it possible to have a checkbox field where, in addition to some pre-set choices, the final user is able to add extra choices not originally provided? Like in : 1. Choice 1 2. Choice 2 3. Choice 3 4. Choice 4 - Example (specify): ............ 4. Other (specify): .................... Looks like it would be a useful addition to the checkbox field but I'm not sure if this is possible to set at all. Thank you in advance for
Show/Hide fields on subform based on selection from dropdown on same sub form
Hello. I need to know how to hide/show a dropdown picklist on a subform based on user input on another dropdown on the same subform Thanks in advance! Arlan
URL links for forms and pages for an application going to the Marketplace
I have a new application (my first to go to the marketplace) and need to know what format should links be so they continue to work when run by someone who buys the application. Are there placeholders for the top URL segments so they always resolve properly. I'm not sure at this point what part of the URL changes once someone is running their version of the application. Thanks. Regards... Rick Davey
count rows in subform
What am I doing wrong? I just want to count the total number of records in the subform that meet a certain criteria and input that count into a field on the main form. input.fieldinmainform = count(Subform[fieldinsubform == "LBR"]);
Sub Items And More users!
Hello, I just signed up for the free account but am very excited about using Soho for all my invoicing needs for my company. There are two huge questions remaining before I would be able to move forward. 1) How close are you to adding sub items? I have hundreds of products and need to be able to break them down into categories to make adding items to an invoice user friendly. 2) Is there the possibility of adding more users? I would like to be able to have 12-16 users. Please let me know.
Pivot table based on multiple forms.
Hi, I want to create pivot table based on multiple forms. I have three tables as describe below. 1. Trainer: This contains details of all trainers e.g. trainer name and age. 2. Trainer's target: This contains planned work for trainer. So each trainer will have multiple entries month wise. e.g. Trainer1 - Jan 2014 - 5 trainings and so on. This form has lookup field for trainer from Trainer form. 3. Students: This contains student details, trainer name and training date. (Student data gets entered
Move value from subform to main form
Hi what's the syntax to take a value from a field in a subform and apply it to a field in the main form? thanks Kevin
Reports in Zoho Creator vs Zoho Reports?
What is the difference between the two (if any)? Is there an advantage of getting Zoho Reports if I already have Creator?
How can i open a published form in edit mode?
I have published a form. I need to display the form in edit mode.
Best Way to Archive Data?
My team has currently hit a dead end. We are trying to figure out the most efficient way to archive our data. Currently, the only way I know how to do this, is to have two separate forms. One is the “Current Bike Form” and the other is “Archived Bike Form”. On the “Current Bike Form”, once a certain criteria is met and when the submit button is pressed, it will add that record to the “Archived Bike Form”. While this method archives data, the data can get very redundant under the “Archived Bike
integrations: updating an event created from CRM calendar with new guests
Hello, I created an event from zoho CRM --> little plus sign --> new event. Currently it has no guests. I understand zoho.crm.updateRecord for updating titles and such, but how do I update that event from zoho Creator to add new guests to it? Thank you, Joseph
Bulk Edit - excludes one of my lookup fields
I have a form with lots of fields, some are lookups and some aren't. When I use the Bulk Edit, one of my lookup fields is not included as a field that I can update. Any idea why that one field is excluded???
Image Preview for linked file
I have created submission form for advertising. Due to the file size restrictions I have not been using the file upload instead of the photo field. I can not figure out a script that would link the file upload URL to the photo field. I have created a summary report that would would show the preview of the image. I apologize if this topics has been covered before. I may not be searching the correct terminology. Any suggestions? Thank you!!
How to Add Criteria to a API Request Using Form Method GET
I'm following the API directions to fetch a single record from a view using the form Get Method. I'm not a programmer and the documentation says you can add criteria to your request, but I don't know how to add the criteria. I can successfully access the view. The request returns the entire record set, I just want a single record returned. Can anyone help me with adding criteria to my API Get Request Here is my request with an attempt to add criteria as a parameter. Not working of course. <form
Attachment via subform
How can I send an email notification via a sub form attachment? Any assistance in this matter would be greatly appreciated.
Pull multiple fields from Form A into lookup field in Form B
In Form A I have 3 different fields, Contact, Contact 2, and Contact 3, plus Email, Email 2, and Email 3. In form B, I have a lookup field that currently will only lookup the value of Contact and auto-populate the associated email. In the lookup field of Form B I need to pull the values of Contact 2 and Contact 3 also (if value is present) into the lookup field. Is this possible?
Skip weekends formula
Hello, I am building a database that will allow a user to set a target delivery date and choose a shipping zone. Based off of this information the program will auto populate the "needs to ship on date." My issue is i can not find a formula to add in the extra two days for the weekend if there is a weekend in the middle. This is what I have so far. Thanks in advance for any help. if (input.Shipping_Zone != "-Select-") { days = ((input.Shipping_Zone).subString(0,1)).toLong(); if (days >
Time field and average calculation
Hi, I have submit several tickets since almost 2 weeks, we did not had any reply back?? I hope someone an help me here, here are my questions : 1- I'm trying to create a simple form for my employees to fill the working hours. - Is there another way to have Date and Time separately? We found really hard to fill the time into the Date/Time field. - Also we need a field that will deduct the lunch break, Here is the formula used into the total field : (((((((Finnish - Start) / (1000
Problem with condition for disable subform
Good day, I have a subform in which I want a radio or checkbox type field by selecting an option from the list in the same place two fields subformularia DISABLED. and trying to do it this way. if (sfrmSubActividades.chkSubnivel3 == "Si") { disable sfrmSubActividades.txtValorSubcUE; disable sfrmSubActividades.txtValorSubcGN; } InvalidTaskInSubForm get error, can in some way?
Bi-Directional Relationship
FormA has a multi-lookup to FormB, with ability to "add new" FormB has an "existing relationship" lookup to FormA. My expectation is that, from Form A, I can add new values in FormB - the problem I'm having is that: I think FormB should automatically KNOW the value of the linking field, without my having to enter it, and it doesn't. Should FormB be able to automatically know the value of the linking field, because of the bi-directionality? Or is it really necessary to add the value manually????
How can I save a photo to an app with an iPhone or other mobile device?
I have an app that requires photo documentation in the field. I want to be able to enter text data into a form and then take a picture to be attached to the form in a field. I want this to be done with a Blackberry, iPhone and Android phone. Can this be done? Snap a picture and then attach/ upload? If not directly, does anyone have any recommendations on how to do?
no reply from support
I sent an issue by email 2 days ago and have had no reply. The subject line is "automation not working" I have logged this again via the support request form today. I am not receiving any auto-reply from support that even indicates that my email or form submission was even received at your end. Please advise.
ZC and ipad - date picker
Odd, but.... from the ipad, when I select a date using ZC's datepicker, the date that gets populated into the field is one day earlier than what I selected. Any ideas how to isolate what's going on here?
Custom Scheduler not working for add record
I have a script that adds records to a table. I had created a custom schedule on 27th July with following settings to see if it works: Start Date: 28th July, 2014 Time: 00:00 EST Repeat: Frequency: Monthly, Day of Month: 28th. I expected the script to run and add records on the 28th July but it did not. (When I click on 'Execute Now' in the scrip builder for this script does not give any errors and the records get added successfully). Am I missing something here? Any pointers will be helpful. Thanks!
PHP form sends data to Creator
Hello everyone! I have a problem that I can't solved. I have a PHP form on my website and I want to add a record by this form to Zoho creator. Now the action for this form is to send an email (by mail() function) and I need some additional function which will send all information from form to zoho creator. I was searching on the Web but I didn't find any idea - maybe because Im a beginner in API and I dont know what exactly I need.
"Failed to submit data. Please contact application owner."
I'm using the free version of zoho creater and have created an extremely simple form. However I cannot add any date to my database. When I try to submit the form I get the error message "Failed to submit data. Please contact the application owner" There are no fancy validations or anything on the form, it's simply a zohocrm look up (I'm using the enterprise edition of zoho crm) and 3 date fields. Grateful for any help and advice.
HTTP JSON request - return no such view error
Hi I am trying to fetch data in JSON format from one of my views The below fetch call returns There is no such view in Zoho Creator http://creator.zoho.com/api/json/<application_name>/view/PriceSheet_Report/apikey=XXXX I like the above url to return the data in JSON format. Can please help me? Cheers -Jag
Script error when evaluating old field value
Becoming frustrated with ZOHO Support Found that you can't apply an IF or SET statement against any old values (any old code still works) For example if you create a new form say ZOHO TEST and create a single line field called TEST In the Workflow Script, On Edit Validate if you create an IF statement to look at the old content of the field TEST this error occurs Error at line number : 1 Variable 'old' is already defined of datatype '1013228000006314713' but trying to update 'zoho_test' datatype
Cannot duplicate applications
Hi, I'm trying to duplicate an application, but every time I click duplicate it says "duplicating" and then nothing happens. How can I fix this?
REST API response speed
Hi ! I think that something wrong going with REST API. I testing 2 different way of fetching data from Creator. 1. REST API GET https://creator.zoho.com/api/json/<application name>/view/<view name> (with credentials) response time - 390ms 2. GET https://creatorexport.zoho.com/showJson.do?sharedBy=<zc_ownername>&appLinkName=<application name>&viewLinkName=<view name>&privatelink=<privat key> (privat key is part of url for public link) response time - 160ms note 2-nd way is undocumented ... but more
can you key data into a date field?
can you key data into a date field? I have several employees who find it easier to key a date than select it from a date box. is it possible to key the date?
Assigning "Numeric Value" to Radio Buttons
This is a two part question (I will take one answer at a time if not one person can answer both LOL) Q1: Is it possible to assign a value to each individual option on a radio button? e.g. Radio Button Field 1: Was the Main Objective completed? Options: Yes = 50 No = 25 Radio Button Field 2: Was the minor Objective completed? Options: Yes = 50
importing apps
Have imported the Apache OpenOffice app for my linux documents, but while it seemed to install properly [even has own icon], when try to access it, all get is message that have lost contact with the page -- again and again and again. Anyone have a solution?
Support Issues
What is the best way to get Zoho support? I submitted two different support requests (and left voice messages) last week that were critical to not only the usability of my application but the roll out of the application (which has now been delayed by a week with no solution or timeline in sight). All I get are "we're working on it" emails but no solutions? These issues are still not resolved. Is this typical of Zoho support? It doesn't seem like they place much of a priority on their customer
Next Page