Hidden fields show as "null" on confirmation email
Is there an option to either: 1. suppress hidden fields from showing in confirmation emails or 2. show hidden fields with their value, instead of a value = "null" Currently, hidden fields are showing in User Submitted Data as follows: User submitted data Name : Ellen McGilliv Email : ellenmcgilliv@comcast.net Town : Westwood State : MA Phone : 7817628568 Comment : test thursday 10:07 PM Record created : null Record last edited : null
Report with max Date
I have a form Assign Resource, the resources are people for example programmers. A programmer can be assign to multiple projects, so the name is duplicate in the Report. I need to select the row o registry for each Resource with the last date that he will assign. For example: Resource Date Juan Perez 3/2/2014 Pedro Diaz 5/5/2014 Juan Perez 6/7/2014 Mery Combes 10/10/2014 Mery Combes 3/9/2014 When I create the Report my result should be:
job scheduling app
Hi, I'm new and have a few questions. We are a monastery. We get volunteers that come in and offer to serve doing a particular recurring job. The job stays the same the volunteers are ... volunteers, constant turn over. I want to assign volunteers to a task/job for a specific day or for a number of recurring days. I have looked at People app and it seems like overkill for our needs...that plus we would have more than 10 'employees' so that puts us into the $40/mo plan. The volunteers will not have
Field Update
How do I tell a field which references another field that the original field has changed and then to reflect those changes ? ie. Field A is a sub-total value Field B points to Field A to show the same value but further down in my form. When Field A is updated , how do I tell Field B to reflect those changes ? Or If Field C uses Field A's value in a calculation. When I change Field A, Field C's value doesn't update based on the change done to Field A. ie Field C = Field A + 99 If Field A = 1, Field
need help apply form problem?
i made a apply form for my website but the other user that is trying to apply, they see a sign in and password to get in zoho but not my apply form....how can i make them see my apply form without them signing in ? please help
Matching notes font size and style to form
Hello, Can I match font size of notes to other from elements. I cannot make note text look the same as a title of the filed. So form looks incositent, any help please. Thank you see image attached: as you can see 1. 2. looks different from the rest
Failed to submit data. Please contact application owner.
what about this error " Failed to submit data. Please contact application owner " it appear to me when i try to save my data please anyone feed me back
Use one box on another form.
First of all, I hope you understand me, because I'm from mexico and my English is very limited. I am trying to send emails through automated 3 different forms -Clientes -Ordenes - Articulos The form "Clientes" contains a box with an email and it's easy to create an automatic email., But "Orders" and "Articles" contains "Email" and would spend much time repeating 3 times the box. I wonder if Link "Email" with the other 2 forms possible. This is what I try,but I have an error: void sendnotification(Clientes1
Filter Lookup By Another Date Field
I followed the instructions listed on this post but still receving an error when I post the below code on input for date field https://help.zoho.com/portal/en/community/topic/picklist-criteria My code: z = Log_Shipping_Document [Arrival_Date== input.Arrival_Date]; Shipping_Document:ui.add(z.Shipping_Document_Number.getall());
Import Failed - unexpected Expected error
Hello, Yesterday when I first tried to import from an excel file into a Creator database I had some errors related to allowable field length. A number of records were however, imported successfully. I have fixed the maximum allowable field lengths now on the form and have tried to import from excel again. After mapping the fields correctly and clicking Import Data - it comes up with the error "Import failed - unexpected error, Please contact support@zohocreator.com". I did contact support but have
Conditional formating
This would be cool: Like feature of for instance PowerPoint, the ability to have fields or whole rows have a certain formating depending on the value of certain fields. So, for instance, have rows be printed bold if a field "priority" is set to 1. Or things like that. I think that the option to make a row/field bold and/or have a darker background would be sufficient. Maybe have a choice of some colors.
Re-inviting a user to Creator and to use my app
Hi There, I have a number of users using one of my applications in Zoho Creator, I have recently added another user, who didn't get the initial email. We de-activated that user account and then added her again as a new user but now when she tries to click the link it says there is no match for that email address but I can clearly see the user and her email address in the "Manage Users" section of Setup. Is there a way to re-send the original invite ? Appreciate any guidance. Kind Regards Matt
request to type the date
I have had several requests for the user to be able to type the date in a certain format ex. DD/MM/YR instead of having to select it from the calendar. is this possible?
How to validate a decimal field
This may be a dumb question. I have 2 decimal fields and a formula field. If you enter a , in the decimal field the formula field displays null. On the input script how can I validate the input as a decimal field (i.e. stop people entering anything but numbers?) Thanks for your help in advance.
Receiving a message that reads: Failed to submit data, please contact application owner
what does this mean? how do i fix it? their call support is only open monday thru friday which is ridiculous considering most businesses operate 7 days a week.
Zoho Creator only validates numeric fields on submit. How to validate numeric field on user input not validate!!!
Zoho Creator only validates numeric fields on submit. I have a series of numeric fields which a script calculates on user input to display the total in another field. A user can enter non numeric information into a numeric field and the on user input calc displays an error on the screen. How can you validate if the input into the numeric field is numeric before doing the calculation? Thanks.....
Sign in Issues
I get onto Zoho Creator from my home PC, office PC, and my Ipad. I also can get on through my iphone through Safari without any problems. But I tried downloading the app for my iphone and though I am signed in, it says i "don't have permission to access. Please contact Zoho support." I am the owner of the app and the administrator and I find it frustrating that I can't get in. I tried calling support but never got a response. Thanks. Paul M.
List Only Contacts relative to Customer
We have two forms, say Form A and Form B. In form A we collect basic info Account Name Contact Title Email. We also have 6 other fields for Contact2 Title2 Email2 and Contact3 Title3 Email3. Over in Form B the first field is Customer (same as Account Name in form A). What I hope to accomplish in a lookup field is once we select the Customer that in the next lookup field only the Contacts (Contact, Contact2,Contact3 ) relative to the Account Name will show and then once we select a contact their
Calendar Item Display to 25 Characters?
Hi Support, Is there a way to adjust the display of the items in calendar view to 25 characters length instead of 15? Please advise. Thanks, Egressmedia
Can not copy Url and Image field contents to a Stateless Form
@ZOHO Creator Team: I have a Sateless Form ... in its on Add on Load section I have commands like ... thisClientProfile = Client_Profile [Client_ID == input.Client_ID]; input.Business_Name = thisClientProfile.Business_Name; input.Client_Email_Address = thisClientProfile.Client_Email_Address; ... and ... input.Website = thisClientProfile.Website; input.Business_Photo_1 = thisClientProfile.Business_Photo_1; ... etc. etc. ... When I render this
Multiple Fields in One Look up Field
In form A we have a field for Contact Name and Contact Email. Also in form A (in case the customer has more than one contact person) we have fields for Contact2, Email2, Contact3, and Email3. In form B, we have a look up field that pulls from the Contact Name field only and than auto populates that persons email in from B. Is it possible that the look up field in form B could also pull the data into it from Contact2 or Contact3 if data is present there and also populate the email field? Cheers!
Custom choice for checkbox field
Hello there, I'm new to Zoho Creator so I'm sorry if my question sounds silly... Is it possible for a checkbox field to add user defined choices, in addition to pre-set choices? Like in: 1. Choice 1 2. Choice 2 3. Choice 3 4. Choice 4 - Example (specify): ................... 5. Other (specify): .............. Thank you in advance for your reply! Igino
Create, Embed, and Auto Fill a Form
Hello all, I am very new to Zoho Creator and am having some difficulties. I am trying to create a form so I can embed it and then autofill that form in correspondence with another form. I need help figuring out how to: 1. Successfully create the form (I'm trying to import it but it's not working, does it need to be a certain format?) 2. Code correctly so the form I create and embed will autofill in correspondence to another form that already exists Any and all help is greatly appreciated! Thank you
How to validate multiple fields within a form?
I have a form that has the fields "Name" "Email" "Mobile Number" and "Office Number". I wanted to validate that when they entered a Mobile Number they were entering 10 digits with no dashes so I coded this: Mobile_NumberFormat = input.Mobile_Number.toString().replaceAll("([0-9]{10})","correct"); if (Mobile_NumberFormat != "correct") { alert "Mobile Number Should Be 10 Digits, No Dashes"; cancel submit; } I want to do the same thing with the "Office Number", but I don't know how to say if
A few problems
Hello guys, I am new to zoho creator and I was wondering if it would be possible to allow a customer to enter their details via a zoho CRM lookup and make it fill in the rest of the form from this, for instance their Sales Orders, Purchase Orders etc. Thanks in advance for reading through and responding to this topic.
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!
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
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
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.
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
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!!
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?
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.
Next Page