Import Issue
Is anyone experiencing import issues? I exported the data to excel and when I went to import it back into the database an "Unexpected Error" occurs telling me to contact support. I have done this but have not heard anything back. Does anyone have any advice? I really need to get this figured out tonight. Thanks for any help.
Linking Zoho database to email account for bulk mailing
Hi there I am working with a non-profit organisation and I am using your fabulous Zoho Creator and wondered whether there was a way to link it to an email account for bulk mailing purposes. Many thanks Christine Bacon actors_for_refugees
Two problem with application: not run imputation to field and not run duplication and import ds
Hi, My first problem (and it is important for us) is not run imputation to field. My applications is kind of survey. I didn't check Zoho Survey, because I need integration with Zoho CRM and i want send data to my service. We have one survey but six other way. So I did one general form and seven stateless forms. One form to define way ( one of this: Women age <29,Women age 30-49,Women age >50,Men age <29,Men age 30-49,Men age >50) Every of this form have ~30 questions. We split every for 5-6 site.
Email Attachment
I have put together a purchasing application where I am uploading the vendor quote into the form. I would like to email the vendor with the purchase order information when the form is submitted successfully. I have figured out how to send the email to but have two questions. 1) I have a Contact field in the form which looks up values from the Combined Name field in the Contacts form. How do I get the email address from the Contacts form corresponding to this contact into the To: field? 2) I
Field Border Color ???
Hello all, I can see in the excellent article Style-based URLs that pretty much all parameters for a ZC form can be changed... However, I am not seeing an option to change the FIELD Border Color upon field entry. Right now, the default gray blue exists, however I need this to be a very specific green. How can this be achieved ? Thank you very much for any suggestion. Francois
Removing Reset button in the forms
Hi, I want to remove the reset button in the form I create Is there any way to achieve this?
Previous script logic no longer works with new application builder
All, in the old system the following code would ignore fields that had nothing selected, and would only perform the INSERT command for fields that had item selected in the dynamic pick-list. // If the serial number field is set to something other than -Select- then data will be inserted into the data capture form. else will be ignored. if(input.Serial_Number_One != "-Select-") { insert into Crossover_Testing [ Added_User = zoho.loginuser etc........................... this statement
Sum of values for elements from multiselect list
Hello, I have a form where you can select which parts were purchased for a service order. The parts are selected from a 'parts' form which includes fields for 'Part Name' and 'Part Cost.' The user can select multiple parts in the multiselect picklist. I would like to display the total parts cost based on the selected parts. How would I go about doing this? As an example, in form PartsList I may have Part_Name Part_Cost Part1 $10 Part2 $20 Part3 $30 If in field Service_Report.Parts_Purchased,
send email to a filtered selection of database entries
I've created a database of students. I've found it simple to filter the main list by instructor, program, age, etc and I'd like to be able to send an email to filtered selections of students. I've read the SendMail doc and experimented with the SendMail sample app, but I don't understand Zoho Creater well enough yet to implement any filtering. It seems like I'll need to create a new type of form for composing the email, and add fields for the desired filtering. I'm a professional programmer, but
Event and Attendee Subform Tracker
Hello I have an Event form with an Attendee subform within it. With the example I have below, I have Test Event with Test1 and Test2 people attending the event. How would I attach the event name to each attendee without having to select the event name over and over again for every record? Thanks!
Bug with conditional syntax in new App Builder
Hi Zoho, I was debugging some code a colleague wrote. I eventually tracked it down to this issue: He wrote if((input.Shipping_Status = "Received") which is not valid syntax. It should have been. if((input.Shipping_Status == "Received") In this situation, I would expect the compiler to throw an error. It should not be possible to write if((input.Shipping_Status = "Received")That would invariably be a syntax error. I'm pretty sure the old app-builder didn't allow this.
Zoho Creator
Hello, The views are getting deleted . Can anyone tell what went wrong ..???
Sending a value to a field in an embedded form
Hi. First of all - good job on an excellent product with a huge potential! And the support so far is amazing. A question about embedding forms: I am writing an application that manages our customers and among other things collects leads from our site. I have written a form "leads". One of the fields in it is "Industry". The leads come from different industries, and on our site we have a page for each industry. I don't want to create a lead form for each industry (becuase we have many), rather use
Can Zoho Creator be used for GoCardless integration?
Gocardless offers its own APIs that we can use for third party integration, so wondering if Zoho Creator can be used for the same? If yes, can anyone give any working sample of DELUGE? I am not able to set HEADERS for GoCardless API calls in Creator.
Approve form data for webview?
I'm building a complaint form for our association that business owners can use to file complaints against members (and non-members) of our association. I want the business owner to be able to fill out a form, and have it posted to our complaints committee. I also want to display those filed complaints embedded in our website in a searchable form, but ONLY after the compaints committee has "approved" the complaint to be visible on the website. I can build the form, and have it submit to our committee.
Additional Users in Professional Plan
Hi, We just upgraded our plan from Standard to Professional. We need another 2-3 users for our application and the add-on for users is only for Enterprise. Is there any way to add additional users without upgrading to Enterprise? Hoping for your quick response. Kiel
Moving columns
I can not figure out how to move columns in Creator in a view. When I added a new column, it went to far right, and I find no way to move it into the column order I want. In the old app builder, I just clicked on it and slide it to where I wanted it, but I cannot find any feature like that now. http://tinyurl.com/30thRoster
Re Old Fields Value for Subform
Hi When in a form with the form of Edit mode, how to know whether a subform data is updated, is there any like normal form, there is a validation of Old Fields Value? Or could you please guide me how to know the subform data has been changed. Thanks Stanley Guo
Zoho Creator Form Captcha Not Working on iPad
Hi We have had several users complaining that the following embedded form Captcha does not work an iPad: http://www.rentlondonflat.com/property-application We have tested this and can confirm the Captcha does not seem to be accepted on an iPad. But same form works on laptop or Samsung Pad. So error seems specific to an iPad. Please advise. Thanks
SubForm Fields in Email?
I am trying to populate parts of an email with fields from a subform. I am triggering the email with the subform field's On User Input action in the parent form. When in the email builder I select the desired field from the subform collection presented in the Input Fields tab. In the email it looks like this <%=SubForm.SubForm_Item%> However when I try to save the email script I get the following: Error at line :1 Variable 'SubForm' is not declared Any ideas?
Updating consecutive records
Dear Zoho Creator team, when one updates consecutive records, it's very helpful to have the screen remain in place, showing the line just updated - instead of (the current default of) going back to the 1st record on page, and wasting time trying to find where you were. on top of that, since Ctrl + Home/ Ctrl + End already brings the user to the top/ bottom of the page (respectively), it makes more sense to have the default being "stay where you are". hope to see it soon at work, thanks, Anat
Chart Based on View Request
@ejaffarian We have come up with an option to create Pivot Table & Pivot Chart based on a View like our old app builder and it is available in creator.zoho.com now. You can try this option via "Create New" -> "Report" -> "Pivot Table or Chart" -> Choose Form and its View to create one please check the same. @Others Please note this option will be enabled for certain users alone (on request basis). Thank you, Saran Please enable that for user sigroup
Bulk edit doesn't run script
Hi Zoho team, I'm trying to have the age of employees get updated once in a while w/out having to update them one by one. For some unexplained reason, when i use bulk edit to update these records, script On Edit doesn't run. Of course, i've checked that my code is working for single record updates - no problem there. is there a workaround for this issue? is the Zoho team working on fixing this bug? thanks, Anat
Add Record to a Dynamic Table Name
I have a variable set that is a table name and it can one of many tables with the same layouts. Is there a way to use a variable for the table name in an insert? insert into Variable_Table_Name [ Added_User = zoho.loginuser Customers = input.Customers Marketing_Manager = input.Marketing_Manager Project = input.Project Service = input.ID ];
How do I get a field to be required once someone enters any data into a date field?
In my form I have a "Document Date" field, when someone enters any date in that field, I want the field "Upload file" to show and be required. Here is the script I wrote for a similar one but the field Filling_State = to PA. I just want any date entered to trigger a similar action. if (input.Filing_State == "Pennsylvania") { show Date_Estimate_Filed; show Date_Estimate_Filled; show Estimated_Filing_Amount; show Proof_of_Payment_Due; show Proof_of_Payment_Filed; } else {
Julian Date?
Is the Julian Date format supported by zoho creator? I cannot find documentation on how to call it.
Dynamic Display of fields in Record Summary View
Hello, I'd like to know if it's possible, and if so how to, create a record summary view which allows for fields to be displayed dynamically based on conditionals. For example, if I have a field for Extraction= (No_Extraction), (In_Progress), or (Extraction_Complete), and a checklist of extraction-related tasks, then I'd like to do the following: (1) if Extraction == No_Extraction display "No Extraction Planned" display Service_Plan (2) if Extraction == In_Progress display a 'Removal Progress' section
Vertical Divider in 'Record Summary View' Section
Hello, Is there a way to add vertical dividers between the columns of a Section in a Record Summary View? Thanks, Elizabeth
how install date in native language?
hi in my creator's app there is date field how can i change it from "31-October-13 12:30:28" to "31-октябрь-13 12:30:28" name of month change from english to russian?
Lookup Box Dependency Filters not working.
I submitted this directly to support 3 days ago but as I've not received a response, I thought I would try the open forum. First I'm a creator newby, but none the less... I'm trying to filter a lookup field based on another lookup field on the same form and I'm trying to use the instructions found here as guidance. I have three forms which are created as a basis for each of my lookups for my final input form. However for this discussion I will only discuss two input forms and the final data collection
Embed Audio in URL Field -
I am trying to play a audio file in a zoho view -This works If I do it manually this is the final URL I need in the URL field data:text/html,<audio src="http://mysite.com/admin/recordings.php?recording_id=127" controls> I am using a CURL to add data to creator myURL = ("http://mysite.com/admin/recordings.php?recording_id=") + input.recID2; // I use this to pass recording ID in input.link = myURL; // If I post this into a single box it adds the correct URL myURL2
Can't get form to autopopulate
I need to populate a vendor form from fields in a client form. I have a dropdown field that I've populated with First Name and Last Name fields from the client form, but I'm not sure of the syntax for the, "on user input" function that will populate the rest of the vendor form. Here is what I have so far from your examples: if (Voucher_Clients[First_Name Last_Name == input.Select_Client_Name].count() > 0) { temp = Voucher_Clients [First_Name Last_Name == input.Select_Client_Name];
did not changes name of field
working app try change field name in dashboard name changes but in app it still previous how to make changing name of field?
Word Count in Multiline NOT working :(
Hello all.... I have the following script to stop a user from submitting a narration text to us that is above 125 words. However, for some reason, the submission does not get cancelled... wordsList=input.narration.toList(" "); wordsCount=wordsList.size(); if(wordsCount > 125) { alert ("Sorry. Only 125 Words or less are allowed. Please correct your narration text accordingly. Thank you."); cancel submit; } Thank you very much. Francois
Use <%=formdata%> on delete
The variable <%=formdata%> can be used in the On Edit->On Success section. It shows all the information on the form. It would be very helpful to use this On Delete. That will make it easy to email all the details of the record when it is deleted. This provides protection in case the wrong record was deleted.
ONLY DE ID...
I want a form to give me the value of an Id in a lookup field from a form wwith the structure IdX (Num) - X (Text) the "view" view. Ex: I select the value X in a lookup field (that has an Id, Ex: 1). I want the form to give me just the Id. I did a form that gives the "1-X", I want only de id...
Users cannot access shared applications on Zoho Creator
Currently none of my users can access the applications I shared with them on Zoho Creator. Can you please inform what is going on? Also, support phone lines are stating there's no representative available for Zoho Creator.
Can't set up lookup criteria using Deluge script
I've now discovered I can access Lookup fields (they appear as Forms - e.g. the Publication lookup shows up in the dropdown box with all the fields within the Publication form). Nevertheless, I prefer using Deluge script. This GUI version slows me down.
Recover Field Content Using API
I want to recover a field from an application form to use in another website as a java variable. Trying to use the REST API to GET values, but with no success. Can anybody help? If there's a simple way that I'm missing, then I apologise in advance :-)
Lookup fields display does not make sense
in my form I have several Lookup drop downs. Each one contains a code # for a part option and the purpose is to build a complete part number made up of all the individual options chosen. Each option table has 2 fields, Part# and Description, for example One of the Tables may have Part # Q36t , Q39t, G34d etc are in a part numbers Fields and Heater Option36W, Black Paint Option, and Steel Option. I appreciate the feature of being able to associate the 2 fields in the Display Fields so that when I
Next Page