Can I have Disable the Submit/Update button in my form
if the record id is not found in the tabel,can I have disable the button in my form
Dynamically populated checkbox
I have 2 related forms. I have a checkbox in form 'A' which is dynamically populated with records from form 'B' to a given search criteria. The user then selects the applicable records shown in this checkbox. This bit works OK but I now want to write a script to automatically update these selected records back in form B. Thanks in advance - A
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 :)
How do I make my form public view?
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.
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.");
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;
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.
"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.
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
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
How to check the authenticity of email
I added a EMail field in a form, I want the Application only store the valid data (email id) provided by user. That is, if user enter a invalid email id (like: abc@abc.abc, in this case, Creator will not alert for it), the submit should be cancel, is it possible? if yes, could you tell me how to do this?
Filtering filters for user specific values
I want to set up a filter in a view, but the values listed on this filter must be dynamically adjusted to only be those created by the user. As an example, if there are two users, each with items: User Item David A David D John B John C I want the filter in the view to only show A and D for David, but to only show B and C to John. Now both would see all four items. I've created a lookup value in the relevant form that has the criteria Added_User == zoho.loginuser;
Change current time reference to local time
Hi. Im making a service database for cars. I am able to create an email notification based on date. however, my local time is GMT+8. But zoho creator based the time on its system time, which i believe is US time. Can this be changed?
Bug on Meeting Tracker Application example
Hello, Even if you delete a member on View Attendance, it will still show on the Pick Attendees list in the Add Meeting Attendance. How can we permanently remove it? Thanks, Duarte.
Settings Page Redundant Validation
In Settings Page when I type/edit an application name but forget to give a link name I am thrown back the following message Please specify Link Name which I feel is redundant. When you blur out of the application name, can you prefill the same value as in the application name for the link name? ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Extensible form logic based on lookup record...
Just a tip on creating user input logic.... I often see deluge script in forms where people are trying to do a lot of dynamic show/hides based on a lookup record.. You know something like this... if(field1 == "David Palmer" || field1 == "Wayne Palmer") { show good; } else if(field1 == "Charles Logan") { show bad; } OR a little better if they have a lot of || statements they'll make a list goodGuys = {"David Palmer","Wayne Palmer"}; if(field1 in goodGuys) { show good; } BUT..
Addition of fields when number is selected
Hello, I am just creating a form and realised it would be really useful if I could have a number field that adds fields relating to the number entered. . . i.e. Number Interested In: "1" Dropdown 1: Checkbox 1: Multiline 1: --------------------------------------------- Number Interested in: "3" Dropdown 1: Checkbox 1: Multiline 1: Dropdown 2: Checkbox 2: Multiline 2: Dropdown 3: Checkbox 3: Multiline 3: --------------------------------------------- Is this do-able? I've had a quick play in script
Alert - PDF from html function stop running
Hi, I've an application that, linked to an html view, produce a PDF with the record inserted from the form. Today, are not running, and produce a blank pdf. Until this time I've been print 2700 pdf, with the same application. And I've do any chagne in the script yesterday and today. Thanks Mic
How to code edit updates?
As my application progresses, there are always changes to be made in the underlying forms. A simple example: suppose I have First_Name which includes an initial and Last_Name. Assume also that I have a field Full_Name which is First_Name + " " + Last_Name. Lastly, suppose the users now don't want the middle initial. I can write code that eliminates the initial during the Edit:Validate phase, but it appears I have to click Edit/Submit on each record. Is there some way I can automate the system to
Possible security vulnerability in Zoho Creator
Zoho Team, Whilst posting about a scripting error in Zoho Creator, I just observed that apikey is passed naked in querystring. I believe this might be a security vulnerability. You may kindly resubstitute with an alternative risk mitigation strategy like forms or sessions. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Scripting Errors on Form Page of Zoho Creator
No sooner did I start using the Zoho Creator form than I started my Web Development Error Console started to fill with a lot of error messages in the script as in the attachment. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Application delete confirmation can come before the attempted server roundtrip!
When I click the delete icon for an application in Zoho Creator, it first does some travel to server then throws a JavaScript confirmation and again goes to server. I think the delete confirmation can come instantly and then if needed the server roundtrips can be resorted to which would be more friendly and economical too. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Disallow 'add as developer' to my own account
Disallow 'add as developer' to my own account. When I do that intentionally or inadvertently I get the email confirmation and when I logon the 'Add as developer' button just confuses me and/or does nothing. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Multiple Clicks of Delete image for an application wipes out the Grid!
I inadvertently ran into an issue of broken mouse resulting in superfluous clicks of the delete icon multiple times. The confirmation message appeared several times but then the entire grid (including good applications) got wiped out. When I refreshed the page I realized that the good applications were in place but the wiping of the grid was because of a server error. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
A number of countries are missing in the 'Upgrade Plan' list
Zoho Creator Team, I observe in the page (https://creator.zoho.com/upgradeplan/#) that a number of Asian countries are missing. 'Iran', 'Iraq', 'Afghanistan' are a few to mention. If you are following US list of embargoed countries as outlined here, the list seems to have changed as per Oracle's URL but Zoho does not seem to have updated the list yet. Why is the step-motherly treatment for the countries even when the global administrations have taken another stand. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Wrong details in Creator Profile
ZC Team, I see the following message in ZC Profile: Developer Since <mm dd yy hh mm ss> and has published XXXX Applications. I believe this is an incorrect date. I have been having the Zoho account from this date but actually started using Zoho Creator only a few months back. You can just pull the account creation date from Zoho Single Signon adhoc. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
What are the allowed values and limit of 'Instructions' textarea of a control's property tabsheet?
In Zoho Creator, what are the allowed values and limit of 'Instructions' textarea of a control's property tabsheet? As our test case when I view-sourced and clipped the entire content into the instructions textarea and clicked the OK button the control did not appear at all. Also the 'Edit Field' and similar context menu failed to appear too. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Can client fill up a form without signing in?
I am new to Zoho. I just created a client survey but when I send it to myself to test it I need to sign in in order to fill up the form. I want the client to be able to fill it out w/o signing in. Is there such option? Thanks.
Checkbox to select multiple applications
ZC Team, Is there a way to allow for selecting multiple applications and clicking a single delete button to expunge all? ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Zoho Creator is accepting and saving an application with blank names
Zoho Creator is accepting and saving an application with blank names. I gave a name with Tamil symbols and it saved with blank names as in the attachment. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Can not delete the application which Zoho created with blank names!
Zoho Team, I am not able to delete the application which Zoho created without names. It threw me back an error message regretting for inconvenience. Please see and help... ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Mysterious Error whilst editing an application with blank names
I am getting a mysterious error message whilst editing an application name which got saved with blank names. The message returned is: There is no such application in Zoho Creator Besides this the URL of the error page also has weird multiple forward slashes before the required requested action ("edit") as below: https://creator.zoho.com/deepak.vasudevan//edit/ Also see attachment for more details. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
Scripting Errors in Zoho Creator
Zoho Creator Settings Page throws the following scripting errors in 'Error Console': Error: not well-formed Source File: https://creator.zoho.com/api/json/messages/view/Inbox/Status=Unread&zc_ownername=zohospace&apikey=dfdfdfdf&raw=true&ticket=60fe2f685b816c8c8dfdfdf7f222848302e72a Line: 1, Column: 1 Source Code: {"Compose":[]} ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
import picklist - import from two forms
Hi, I have one form A containing a certain type of students. Unique registration numbers are given I have another form B containing a different set of students. unique registration numbers are given I want to be able to import the registration field values from both into a single field in a third form How can I do this? Thanks
Modify a dropbox - affect records in the view
Hi, I need modify a dropobox field that have 7000 choice option, because IE have no condition to run the form. I have 2700 records in the view that it´s related with this form. If I change the dropbox with a ISingle Line Field. My fear it´s about this modification, if affect the record in the view. If I cancel the choices in the dropobox field, are they saved in the view for the data inserted until this moment? Exist an alternative to use a large option choice in a form with Internet Explorer (Firefox
Execute form
Does execute event after specific date handles years? I am trying to set up birthday reminders based on born date, so i want to trigger an alert based on 5, 6,7 or 8 years after born date.... Party { execute event 5 years after born date at '07:30' yearly } how would I include 6,7 or more years options? Would OR variable do it?
Next Page