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?
Adding text as part of the form page
I am creating a form. I want the form to look like this: Already registered? SIGN IN below User Name Password Forgot password? (this would link to a different page) Question. I know how to create the user name and password fields. how do you just add text as part of the form? How would add a hyperlink to the text?
how to add logic within a field
Reuben: Rob thought you might be able to help. I am new to Zoho...and am trying to understand a couple of things. I am creating a form. I want to add logic to a drop down box....or a check box. The first check box choice: Add a new customer in the data base. OR Edit an existing customer record If they select the "add a new entry"....the form should then display the fields they need to complete for a new customer. If they select the "edit an existing customer" they should see a list of
are there any videos showing us how to use zoho?
Are there any training videos that show how zoho creator works? thanks
creating an application from an excel spreadsheet
Has anyone built an application where the original code/logic was stored in an Excel spreadsheet. Is there a way we can view the results? Does it work if you have multiple worksheets in your existing Excel logic? thanks
Formula result not showing in View
I created a very simple formula ((Revenue_Amount * Revenue_Percentage / 100 - Deposit_Received), but it is not showing up in the Application View (I know it's not supposed to show up in the Form, but it won't show up in View, either). No error message is returned. Any ideas? Julia
Lookup with two keys
Hello I have created two forms, form 2 needs to reference form one by a combination of two fields (i.e. a composite key). How can I do this ? Thanks
Can only the administrator edit applications
Hi, I am currently using zoho creator whereby my colleague is the administrator. She has shared the application with me and set me up as a developer with the permissions of editing adding and deleting files. However the administrator has the option to edit applications (on her home page she has edit, duplicate... buttons I don't) and has a whole range of other tools that I don't have e.g setting up relationships and the ability to change fields. My question is can only the administrator have these
Need help with figuring out putting an HTML view's PDF file into another form
Hello. Thanks for reading this post. I need help or ideas on how to put an HTML view's PDF file into another form without having to save the file and then upload it to the other form. Is this even possible in Zoho creator? Scenario: I have an HTML view that generates preset letters with the Print & PDF capabilities. I have a function/script that allows me to select various letters to generate based on the contact info and uses the HTML view mentioned above to make these letters. I would like to be
number of lookups depending on another dropbox
I have a max number of students in a class, and it all depends on how it is set by the tutor. The number can range from 1 - 10, however, because if the number is only 4, then i want only 4 lookups to be added(or enabled, if not possible to make the rest disappear) The lookups are used to look for student names and add it to the class. Thanks for the time!
Empty upload field is no longer empty after record duplication
I check whether or not an upload field in my form is empty with the following code: if ((searchProfile.File_Upload != null) && (searchProfile.File_Upload != "")) This works fine if I created the record from scratch. If I duplicate a record with an empty upload field in it, the code above no longer works. Checking if the field is empty with searchProfile.File_Upload.isEmpty() is not supported. Adding the code input.File_Upload = "" in the On Add / On Load event does not work either. Please advise.
Calculating time
Hello, I'm creating a web application to manage information from an Online Racing League and am currently having an issue tracking time. I'd like to have lap time data of the various races then be able make calculations against that data to get "Top 5 Lap Times" or position the grid based on lap times etc. I currently have the time entered in a single text field in the format of M:SS.SS so for example 2:12.234 (2 minutes and 12.234 seconds). THis works fine for sorting but I cannot use it in calculations
Multiple dynamic drop down
Hi -- I have three fileds : ARTISTE_projet ; ARTISTE_date ; ARTISTE_seq I'm trying to populate _date from selection in _projet, then _seq based on selection in _date (like cascading). Based on this tutorial, I tried this: In ARTISTE_projet on user input I have this: if (count(JOURNEES_Form[JOURNEE_projet == input.ARTISTE_projet]) == 0) { clear ARTISTES_date; } else { datelist = JOURNEES_Form [JOURNEE_projet == input.ARTISTE_projet] sort by JOURNEE_DATE ; ARTISTES_date:ui.add(datelist.JOURNEE_DATE.getall());
Creating form to search dbase?
Hello. I'm not a dbase programmer, just a guy trying to use Zoho to help out a worthy cause (supporting organic farming in Nepal) I've set up a database application, with a form and a few views. -- http://creator.zoho.com/nepsan I'd like to create a form or view (not sure which!) which would be, essentially "Look up my Listing" -- allowing a user to quickly and easily search by first and/or last name (or whatever fields), and then - if no results, have the option to enter their data (via the form
Any reports (chart) for showing the trend of using Zoho Creator.
Is there any report that shows the trend of how many people start to use zoho creator? Just curious. I am getting more inquiries from my clients to build zoho creator application. Thanks.
Next Page