Uploading large Excel File
I have an excel worksheet that contains 90 fields that I would like to upload to an existing application in order to create a new form and view within that application. I rec an error message from the ZOHO migration tool stating that there are too many columns. Can you help?
Field no empty
Hi, I have a script to return that this field inline it's not empty (have a value) if (input.Codice_di_conferma != "") { hide Data_pagamento; hide Codice_di_conferma; hide plain1; show plain2; } But this code return wrong information. Anyone can help me? Thanks Mic
Workaround for loops to add records to a database
I am working on a database for a pet-sitting service. Clients make bookings for pets to be visited and walked and these bookings can range from one day upwards. I have a form to enter all the booking information and I am trying to write a script to add each visit (up to three a day for a varying number of days) to another form in the database called Visits. This form will eventually be displayed as a calendar and form the basis of reports e-mailed to clients etc. I have read many of the comments
Replacing a record with another record
I am new to zoho. I am trying to build a database to keep records on a task list that needs to be duplicated for each client we have. As soon as we accomplish another task for a client, how do I update the records? Right now, it is making a new record for the client. I want it to write over the old record.
Help linking forms
Zoho newbie. No scripting experience. And now my questions: How do I create my app such that completion of formA directs the user to either formB, formC, ... formN based on inputs on formA? Also, are Zoho Creator apps (forms, views) intended to function 'as is' or are they supposed to be embedded in one's pre-existing website (via HTML or whatever)? Thanks, Steve
Linking forms based on inputs
How do I create an application that launches a form based on input from a previous form? For instance, launch formB, formC or formD as based on answers (input) submitted in formA. Thanks
How to add multiple data in one form?
I need to create a simple application that has the following information: (it's a letters database) The user create a new "Received letter". He chooses from a list of senders, just ONE name. Then he chooses date, subject, etc. And he chooses, from the same list of senders, the "RECIPIENTS", that could be MORE than one. How to associate more than one recipients in just one form? If I use Multi-Select box, I cannot search for a name (have more than 20.000 names in a list). Suggestions?
Update field value in another form
Help with syntax please. I have a form [tasks] that records tasks and links them to the Jobs form [jobs] using a job number. I've created script in the Task form that counts the number of active tasks against a job number and assigns the value to a variable called active_task_count. What I want to do is update a field in the Jobs form called active_tasks with the value of the variable active_task_count against the specific job_number. Martyn
Error Uploading a Database to Zoho Creator
I was about to upload a database to zoho creator, but my user name and password is incorrect. I am signing in through my yahoo account. I believe I have the right username and password. I don't know what is the problem with the migration tool.
Upgrade the Zoho Creator
Hello Respected Members, I am an active user in your Group, and after seen many other services for database creation, i am thinking that the ZOHO creator is best one of them, but now there is also a competitor there. and you know that this time of Competition and every one want to get height. If Zoho includes following features, then it can be safe his position in the USERS. 1. Address Field 2. Paypal payment integration 3. Other Payment integration 4. Editable label width and height See the
Wufoo integration
I'd love it if you guys were able to work with Wufoo and get some integration going there — they have an email-out notification system of submitted forms. All it'd take is them to use your email template to send field info out. Just a thought.
Can a field be conditionally required?
For instance, I have a 3 fields: Allergy---- Dropdown- Yes/No- REQUIRED Severity--- Dropdown- Mild, Moderate, Fatal- Not required on form load Allergen--- Dropdown- Pollen, Bee, etc.- Not required on form load Here's what I want: IF Allergy is Yes, THEN require the Severity and Allergen fields IF Allergy is No, then no change needed This is necessary because if you make the Severity and Allergen fields required on form load and the Allergy is NO, then you don't need to fill them in. But if the Allergy
Name field string manipulation
Hi -- I saw several threads here giving string manipulation script bits using toUppercaser and such, but I tried various ways to implement them, and failed so far. If a very kind soul could bear with me and explain step by step where and how I put the script code, I'd be VERY grateful. I need to : 1/change to upper case Last_name field on Success, i.e.: lastname to LASTNAME last-name to LAST-NAME last name to LAST-NAME if there is one word : all uppercase ; if there are two words, all upper case
Create a custom field in a view?
I have a view that shows records in a summary view. These records contain client names, in the format saluation, first name, last name. Can I change the view definition to show these three fields as one and if so, what is the correct syntax? Many thanks Mark
Invalid email address when updating form and sending mail
I have an app that sends an email when a form is submitted and edited. The email address is provided by the user when they submit their info. When they submit their info, no error is given and the email is sent just fine. However, when they edit the form and re-submit, an error is given about an "Invalid email address". The specific email address is in the form: fname.lname@gmail.com It seems to be the . (dot) that is causing the problems.
How to get rid of the view heading?
Hello, I have a very simple table with one column to use as news feed. I need only one heading above it such as 'new'. There is a heading for both the column and the view. Is there a way to get rid of the view heading while embedding it to my website? Thanks a lot. Vera
Missing or Don't Find?
I am looking for some common functions and SQL like command but failed after serching help, blogs and formus. Are those not included yet OR I am not finding as a newbie to Zoho? a. Absolute Number, e.g Abs() b. Convert a date string('e.g "01-May-2003") to date. I resolved by writing a function myself c. Convert decimal to integer & vice versa d. Date difference between dates ( solved alternatively) e. SQL command like MAX(.eg Salary), MIN(eg Marks), AVG (Salary) and many like these. But many
Set an auto reminder for a due date
I have created an action item management tool in zoho creator and need to have automatic e-mails sent out before the due date. Is there a simple way to do this?
Restricting fields from viewing on public embed
First, let me say how much I'm enjoying Creator. I had no idea it existed until very recently. I have built a simple CRM-like system to track speaking engagements that I book. The main form has about 25 fields — client name, speech title, hotel name, flight info, fee expected, and so on. I'd like to embed that form on my web site (for prospects to fill out) BUT only let certain fields be visible on the web form. Is there a way to make it so that the web-based embed only displays certain fields but
How to define decision box value in email template
I want to add data to my form via email and one of my lines in the email template is a decision box that I want to appear in the database as false (unchecked). However, it always appears as true even if I type 'false' in the email template. What am I supposed to type in the email template to get it appear as unchecked in the database? Thanks for your help.
Syntax for email data address?
userx-449@forms.zohocreator.com Every form in an app has a unique email address to add a new record, right? How does this work for an app that is sold in the Marketplace? For instance what is the syntax of the email address then? zoho-loginusername-formnumber@forms... Does the form number change with each instance or does it remain the same?
Simple question about Multiplication
Hi to everyone. I have a problem that i cannot solve. First form: load up products on my warehouse. I have 3 fields: Product name - Quantity - Price Second Form: this is the sell form. I have set up a look up field for the product name (related to the first form). On the view side i can also show the related price correctly. There is another field called quantity. What kind of script i need to make a simple multiplication between the price of the first form and the quantity of second form. I need
Likert Scale Field Type in Creator?
A Likert scale would be an excellent field type for Zoho Creator. It's my #1 feature choice for Creator. An example:
Different auto responders for the same form
Hi, We have several different forms in Zoho creator to be used in different Web sites. All these forms have have the same fields, but the reason for using different forms in different Web sites is because we want to send different auto responders when the form is submitted from different Web sites. Is there a way to use a single form instead of several different forms and send different auto responders depending on from which Web site that form is submitted? In essence, is there a way to find from
Can you edit form data via email or only add new records?
If I have a record created already via a form. Can I email an update to that record to change a field? Or can the email form data capability only be used to create a new record?
Pdf link in sendmail
Hi, anyone know if it's possible to send the form data in a link as downloadable pdf as sendmail command when I complete the form in Actions on success? (For example as proforma invoice or receipt). Thanks MIc
Different Auto responders for the same form depending on from which Web site the form is submitted
Hi, We have several different forms in Zoho creator to be used in different Web sites. All these forms have have the same fields, but the reason for using different forms in different Web sites is because we want to send different auto responders when the form is submitted from different Web sites. Is there a way to use a single form instead of several different forms and send different auto responders depending on from which Web site that form is submitted? In essence, is there a way to find from
Is it possible to embed a Creator view with search boxes already visible?
It is possible to embed a Creator view with the search link already pre-clicked so the search boxes are visible? Sometimes readers don't realize that a list is interactive and searchable when they see it on an external Web page and they're not familiar with Zoho. Thanks.
Connect to Zoho CRM
I am a new developer creating my first database. I have not found any step-by-step tutorials on Creator so I'm glad to find this forum. I am a big fan of the CRM app. It meets almost all my needs. There are a few things missing for me which is why I am trying to create my own database. My question is, is it possible to relate a custom database to Zoho CRM? I can create a database to manage client and contractors and the services that bring them together, but I don't want to reinvent the invoicing
Import data field - two field in one line data list
Hi, anyone have idea if it's possible to do this: I have form A and B. In form A I have two field formA Date (field1) | Title (field2) 01.12.2009 Economy in 20th century 02.12.2009 Immigrated entrepeneurs ... ... In form B I have one multiple field that import data from form A as field1+field2 as 1 line data, as 1 single option. formB Field1= options (01.12.2009 - Economy in 20th century 02.12.2009 - Immigrated entrepeneurs
'Missing return Statement' error - what am I doing wrong?
Here is a very simple function I am writing. I cannot save it due to a 'missing return statement' error. There is a return statement there. What is still missing? string mjw.Secs2Time(int Secs) { if(Secs < 10) { return "TEST"; } } I have been working on this DB for about a week now and and getting a bit fed up with my lack of progress at learning it. Grr!!
SAVE SEARCHES
Is it possible to save the different searches I make? dennis.skouboe
creating view with dropdown field when form doesn't have a dropdown field
I'm sure there's a quick easy answer to this question, but I've searched and cannot find it. My main form in my database is a company information form. I set up the field Company_Name as a dropdown field and when I created my view, I was able to scroll down, pick the company and view/edit it's details. This was perfect. Unfortunately, I cannot add any new records as I cannot add to the Company_Name field because it's a dropdown field. It's important to be able to scroll and pick the Company name
Working with Time
Hi I am trying to build a DB to record my runs. As there is not a 'time' data type that can cope with durations, rather than time of day, I have resorted to a text field to accept my times in the format hh:mm:ss. This data sorts ok in a form, but I cannot produce a pivot report to show me the minimum time for a run - presumably because zoho can't return the min of a string data type. I already have a function to convert my hh:mm:ss into a numerical value in seconds, so I could use this in the
It is possible to create a bug tracking system in Zoho Creator?
Our Sales team is looking into using Zoho for CRM. It would be really nice if our Development Team could use Zoho for Bug Tracking too. I emailed Zoho asking if it was possible to create such an application and was told No, but I wanted to throw out the question to the community to see if anyone had done this....
Send Mail and Chrome
Cannot edit the content of "send mail" emails in script builder using Google Chrome.
Can you upload files/ photos via the API?
Can you use the API to upload a photo or file to a form?
Can I add a photo to a record by emailing it?
I need to attach a photo to a record/ form sent from an iPhone. Is it possible to email the attachment somewhere to attach it to the record? I am struggling to figure out how to attach an iPhone photo to a Creator record/ form. Please help. Will anything work? This should also work for a Blackberry and Android. You can do this with many photo sites by emailing a certain address with your user email for validation. Thoughts on an easy way to attach photos to a record? I do not want to make a user
How do I repeat questions based on answers
Hi, I want someone to enter how many tests they have graded. Based on that number, I want a question about the grade to come up that many times. I'm trying to avoid submitting every time. Also, can you do loop functions in Zoho? Thanks
How to change type of a variable to int?
How to change type of a variable to int?
Next Page