Emailing Form Question
We have a questionnaire form that we send to new customers. We have been using google forms to do this, but would like to switch to zoho creator because the data seems easier to work with once it's collected. Currently (with google forms), we just find the "send form" drop-down, put the customers email address, and it's done (for free). How do we do this with our Zoho Creator form? - thanks, Brian http://www.redpelicanmusic.com
Birthday Notification
Hi All, I am setting up a client database and wanted to know if i can set something up to either automatically remind me when its a clients birthday or to automatically email them directly. any help would be greatly appreciated! thanks mel :)
Form has been customized prior to embedding - can I save these settings?
Hi, I can't see any answer to this on the help guide or forums. I have developed a form in zoho creator. I have no problems customizing and embedding this in my website. But, if I make changes to the form and need to embed again in my website .... do I need to keep customizing each time? Is there a way to save the customized settings? Thanks
How do I make my form public view?
Lookup field
hope someone can help: with the "Lookup" field in a form, how do I import unique values only (no redundent values)? thanks in advance, --Wei
Multiple sets of "and" and "or" combinations in criteria don't work
I tried to create a criteria for limiting records shown in a view, with a mix of && and ||, with parentheses used to keep the boolean logic correct. The type of criteria: (A && B) || (B && C) || D. However, the system adds other parentheses automatically when the script is saved. These added parentheses mess up the logic totally. I found a work around, by creating variables combining A-B and B-C; however, this seems unnecessarily circuitous.
Cycle 4: RESULTS
Cycle #4 voting is over. 1st Place: Rich-text editor CYCLE-4-41296882 2nd Place: These all had 5 votes each Date/Time field format adjustment and Google Checkout or Paypal Integration Programmatic Access to the Platform Share Module View the voting application here: http://creator.zoho.com/niskypto/cycle4/ Thanks, John M. Whitney (niskypto)
Urgent: Form Schedules do not time correctly (GUI time != Free-flow Scripting time)
I have a Form Schedule entitled "Confirmation". Under the "When to do?" section I use the form field "EmailTime" to set the schedule. My saved schedule has different appearances when viewing it in "GUI mode" or "Free-Flow Scripting", or in IE8 or google chrome. I have done the scripting and saved it using google chrome. The emails are not sending. Here are the different views. Google Chrome Free-flow Scripting: Confirmation { Execute on 20 hours before of Spring2010.EmailTime
Can't Delete Function (again)
I encountered another case where I cannot delete a function. When I try to delete the function, it says: Function cannot be deleted. This function is referred in the following places. Please remove the reference,then try deleting the function. In action script--> Notice, there is no name after: "In action script-->" The name of the function is: GetPledgePayment The name of my application is: MyDB I have given support access to the application. Please access my application and delete the function
Sript Tag Error
I cannot access the script tab. Getting the following error: [ServletException in:/jsp/edit/script/sbuilderedit.jsp] null'
Creating app from .csv file, there is no 'finish button'
Whenever I want to create an application from a .csv file, I copy the information on the file, but when I click on the "create now button " it says: "We have identified 'Field Type' based on your data. You can change the 'Field Type' and the 'Label Name' if you wish to. Click 'Finish' when you are done. " But there is no 'Finish' button anywhere. Can you please take a look? Thank you info
Need Help Formatting Printout of Student Directory
Hi: I have a seres of Zoho tables for a small school. I need to printout a Student Directory in which the student's name is listed once on the left and the parents are each listed (one per row) underneath. The look needs to somewhat resemble an Excel pivot table where the student names are grouped. Can this be done when setting up a view? Thanks- Charlie Epes
Counting checkbox responses - is there a way to limit these?
I am constructing a form giving parents the chance to sign up their children for various school clubs. What I would like to do is limit the amount of people ticking in the DECISION BOX to, say 20. I have tried a script for this, but I cannot get it to work, as it continually throws back errors at me. This is the script I use: if(count(input.Drop_in_Computers_Y3_8_Monday_lunch_1250_1315_ICT_Suite_01)>= 20) { alert("This club is full. Please untick and resubmit your form.");
Does Zoho Creator support Soundex (phonetic) algorithms that will display similar sounding values?
E.g., when adding a new company into a database, if the company name is similar, though not exact, to a company already in the database it would be recognized as a potential match and permit a notification message (such as "Did you mean this company?").
Problem importing data into Zoho Creator database
I have a very simple form and am trying to import data into it. I have successfully done this in the past, but this time it silently fails every single time and gives no feedback about what is causing it to fail. I have tested all the obvious things, like data types and field names, and have found no issues. Any ideas for how to test further or how to get explicit feedback about what is killing it? Thanks!
tipo de campo imagen
que se indica en source de un campo tipo imagen?
Extending Objects/maps
Just a tip... You can extend maps much like you extend an object in javascript. Deluge Script does a great job of overwriting map members when you redeclare a put! Old pairs stay the same new pairs get added. Thanks DS dev team for making this an overwrite method rather than having to remove the key first. :) map private.editRecordMap(map recordMap, map editMap) { editKeys = editMap.keys(); for each key in editKeys { recordMap.put(key,editMap.get(key)); } return recordMap;
Google Apps& ZoHo Creator Helpdesk User Mismatch
I've tried twice so far with this and still no dice. As an Administrator I created a user Requester account for myself on ZoHo Creator Helpdesk. Once the email was received I proceeded to set up a ZoHo account (using Google Apps to sign in with) - however both times I end up with the following message: You have logged in as ChosenUsername. You are not allowed to access this application. Contact the administrator of this application to add you as Requester / Technician. Please click here to login
Save those precious 5000 statements and use xpath!
In the past I used to loop over XML using the toXmlList() function combined with some if statements... PROBLEM: Each iteration adds to your # of statements used and it's slow. There's a better way! Use xpath to it's fullest and let xpath do the heavy lifting.. Here's a function that let's you pass a "filter" map to your xml. It iterates over a map's keys and then builds up an xpath statement. Once the xpath statement string is built up it filters ALL your xml nodes (based on your xpath prefix change
How do you sort on a hidden column in a view?
I need to sort on a column in a view, but I don't want the column showing. When I edit the view and hide the column, I no longer have the option to select it for sorting. Does anyone know how to sort on a hidden field, or know some work-around? Thanks.
Report does not display calculated result
I created three fields: A, B and C. A - B = C. So C is the result of a calculation of entered data A and B. When I view the table in Data View, I see A and B, as well as C correctly calculated. However, when I create a Pivot table C is displayed as no value. It is not being calculated. In the columns that are dragged into the Pivot table fields, there are two options for data: Dimension and Range. If it is range, the report shows a range and the value is not calculated. If it is Dimension (treated
allow other user to edit my application
how do i allow another user to edit my ZoHo creator application?
Hope Zoho Creator team could improve the way of showing error message when debuging
I create a HTML page and write some script in it. When I click "Save Script", then ZC check Deluge Script and report error. There is no problem for this flow. But the error message looks unfriendly. eg. there is a simple error, however ZC tell me the following error message: Encountered "<" at line 30, column 21. Was expecting one of: "Workflow" ... "output" ... "bool" ... ... "float" ... "list" ... "map" ... "xml" ... "var" ... "htmlpage" ... "string" ... "date" ... "void" ... "this" ... "input"
"atleast" typo error in required multiple-select finput warning
I have a check box required in a form, and if submitted without a check, the warning states: "Provide atleast one value for..." That should read with a break between the words, "...at least..." You want Zoho to look fully professional, right? Might put all your alerts through a spell and grammar checker. If you can download them--I assume they're in a database--it would be easy to do.
Do ZOHO Documents communicate?
I need the Data (Contacts) from Creator to be "auto-filled" into Writer (Response Letter). Please, Please and Thank you.
Dashboard and Employee Self Service not working.
Info not showing on Dashboard or Employee Self Service.
Linking Separate Forms To Share Data
It seems that when we try to link forms with similar data, it will allow us to do so only on one field but not multiples. Is this the case or is there a procedure we are missing?
Won't let me share!!!
I don't seem to be able to share my application. It keeps saying... "To share more users Upgrade your user plan" However I don't have any shared users, it won't let me share it. For a free user it says I can have 2 users! Regards, Mark
errors/bugs
3 records i created aren't deleting and I can't view the forms. Also in the CRM app, I added a form and I'm able to set values for leads with the exception of phone and mobile numbers
Another Update ... Another case of breaking existing functionality !!!!
Looks like the ZOHO Creator Team decided to update the platform ... ... right in the middle of the day (Eastern Time) ... without any advance notice ... and in keeping with past practices, broke existing functionality !!! When trying to Edit an Application ... free-flow mode ... when you right click on a Form field and then ask to Edit Actions on user Input ... the resulting display goes into a never ending "loading" state. However, when you click on the Share Tab and then choose the event from the
Error when chaining functions
Hello ZC Support, Take a look at the following variable declaration.... created_time = row_map.get("Created Time").toDate(); The error I receive when I try to save this is...... Encountered "." at line 16, column 51. I understand why I'm getting the error BUT there isn't really a great solution.. 1. If I do this..... created_time = (row_map.get("Created Time")).toDate(); I can save my script. BUT, almost always the two parentheses before the declaration and after the first function WILL BE REMOVED!
Store current google user along with data
I need my form to store among other things the current Google user, entering the data, as an hidden or read only field. Is this possible? thanks, gabo
I can't DUPLICATE my Application
Hi ! I have this issue, in Home page i select my application to duplicate, the process start, but at the end i can't find my copy :( I have try with other application, ant the copy work well. Can i know why ? Thank you...
how to increase the usage limit in my application.
how to increase the usage limit in my application. for delug script there is one for each loop that does execition. and displays error like this Error details: Error occured while on Load script. The execution is stopped since the number of deluge statements that can be executed in an action has exceeded the maximum limit. You can view your usage limits here. what is the proper solution? my email: bhaveshgodhaniya@gmail.com
Views <-- passing params to hidden view fields...
Hi, Could you have a ZC platform developer explain to us why we can pass params to hidden form fields but not to views with fields not being shown? This functionality would reeeeally be helpful. Also, I wouldn't have to explain to my clients why they have to leave this "long number" in their view. LOL PS... Do you think we will ever be able use POST not just GET on an html view? Wow that would be awesome! -Stephen @srhyne
set email alerts?
im very new to this zoho creator this is what im trying to do: Contract management system. I am specifying when the contract ends and I want it to send an email alert before the date that was specified in the ENDING DATE comes.
Conditional statement based on uploaded file
I would like to make an IF-ELSE conditional statement based on if a user of my form has used the UPLOAD FILE field. If they have I want my email confirmation to include the link to the upload. If not, then I do not want the link. How can I do this?
Formatting
Please provide a few more formatting tools, like header alignment, and at the very least let us format formulas... For example if I take a dataset that is type USD with no decimals, it appears as such, with commas, even. But the formulas derived from this are plain (no commas) and I cannot drop the decimals. Thanks
Report builder freezes on "Loading Editor" page
I am trying to build a report. Here's the sequence of events: 1) Click "Reports" tab 2) Click "Create Report" (button or link) 3) Enter Report title, etc. 4) Click "Next" The browser then sticks on the Loading Editor graphic. I've tried this on Safari and Firefox. No luck. I have a pretty fast connection (DSL). I'd very much appreciate any help or suggestions
Creator is hanging on the "Loading Editor" window when I try to create a report
Creator is hanging on the "Loading Editor" window when I try to create a report. Here's the sequence of events. 1) Click "Reports tab" 2) Click "Create Report" link or button 3) Select "Pivot Table" 4) Provide/Select approporiate information 5) Window hangs with "Loading Editor" I've tried this on Safari and Firefox (Mac OS X). Same problem. Any suggestions would be much appreciated.
Next Page