Is it possible to have a realtime updation of graphics.
I have a question regarding real time updation of colour of certain graphics. For example, suppose that I own a lodge having number of rooms. Customer 'ABC' is booking a room(i.e.room no. 10) from Delhi at the same time another customer 'XYZ' is booking the same room(i.e.room no. 10) from Chennai. Now the problem is that if customer 'ABC' booked the room(i.e.room no. 10) one second before 'XYZ'. How can a booking agent at Chennai come to know that the room is booked, so that he can tell customer
I would like to give a initial value to a Lookup (multiselect field) dynamically from a user input.
In my samples form, I have a look up field sample type, from a sample_type form, which displays the name of all sample type in a single select drop down. In the same form (samples), there is a look up field parameters, from a parameters form, which displays all parameters, in multiselect list. But, in the the sample_types form, there is already a look-up parameters field from the parameters form, which displays all parameters, in multiselect list. A sample type has already the the parameters chosen.
If selected a value, a field must appear
The case is this.. I have Field 1, Field 2, and Field 3. Field 2 and Field 3 are hidden... Field 1 is a dropdown box and has values of: Name 1, Name 2, Name 3 Now, what I wanted to do is... When a user selects Name 1 in Field 1, Field 2 will appear.. And when Name 2 is selected, Field 2 will appear.. I can't seem to do it with this code.. if (input.Field1 == "Name1") { show Field2; enable Field2; }
How to get submitted application data to another application?
I have two applications and I need to take a list from the first application to insert into the second. How can I do?
How to login from my domain to Google Apps mail using zoho creator ?
hello, I want to setup a login form in my website where people will enter their google apps login to access their google apps mail. How to do this with Zoho creator forms.
How to only display a URL link to an uploaded file if only one of the four is actually uploaded in the form?
I have a form with 4 optional image uploaders. When the form is submitted it emails the input of the form fields and 4 links to the uploaded files. What is the script to only display the link in the sent email if for instance only 2 images were uploaded instead of 4?
Custom action on view
I want give the option to users to edit a field (radion button, with two choice : "Approved", "Not approved") by a custom action on a view. I want to change the Status "Not approved" by "Approved". I wrote this function : void status.Approval(string TheStatus) { if (input.TheStatus == "Not Approved") { input.TheStatus = "Approved"; } info input.TheStatus; } I added this function to my view : custom actions ( "Approve" ( function = status.Approval(Status)
How can I transfer data to another database upon user action?
Hello, I have two request form databases managed by separate administrators. If a user fills out a request on one form that does not belong in this database can I have a funtion that will auto send this specific request form to the other database? For example, if the two forms are managed by separate administrators and there is a field in the form that administrators can sign-off that they are handling that request -- can i create an action on that field so that whenever another administrator
Spacing between Questions and answers
HI, Recently, a large horizontal gap or space started appearing between the questions and answers in my form. It makes it extremely awkward to use. Is this changeable? Does anyone know why?Any suggestions? http://creator.zoho.com/jmarzluft/owhl-statistics# Thanks, Jeffrey
Automated application documentation
I've created an application in Zoho Creator - a whole lot of forms, views, custom actions, functions etc. While the application is shaping up quite well, I've begun to realize that I have not created any documentation on the application software. Without documentation to fall-back on, I can imagine life getting quite messy down the line. I believe the Zoho team can come up with a simple solution for this. The fields, forms, views along with their actions (on load, on submit, on user input etc) are
Internet Explorer 7 open URL script commands failing
As at this morning Australia time, all of the open URL in window functions using Ineternet Explorer no longer work. Why is this? My customers can no longer get all of the features from our site. I am loosing business. Should I put this on the forum and let everybody know not to spend $ 10,000 developing a Zoho program because it may work just fine to begin with and you will wake up one day and for no reason it will not work anymore. It still works perfectly in Firefox but because around 60% iof people
Open Duplicated Records in Edit Mode
I'm tracking certain items where new records often are the same as old with the exception of a change of date or other minor difference. It would be useful for the duplicate function to open the new (duplicate) record in edit mode so that I don't have to scroll around looking for it after it's created. Thanks.
Help.....!!!!
I don't know if this is possible but in my database i want to show a spilt between two employees like if they worked on a project together and recieved money they would spilt it. So what i want to do is have a button or a check box that when i click it..it will spilt that cash and is shown for each individual on there own seperate record. Is that possible or is there something close to that. If so can somebody show me how.
Cannot use passed parameter while setting new variable in HTML view
Although it seems to be this is one of the most basic things one might need to do, when I try to use a passed parameter in an HTML view to set a new variable, it says the the parameter is no declared. Am I doing something obviously wrong? If I want to declare a variable, I use "set variable", right? Then if I click on the parameter under "variables" in the script builder window that pops up, it says it's not declared. Please, I need help on this asap.
Page Error from Private to Public
I wouuld like to change from Private to Public, but when I try it there is a page error, so I can't. Could you please help me? Thanks in advance!!
on update ....can not make it work....About to dump zoho.
Hi, I am almost giving up witht he On Update command. I am trying to update fields that I called out and following the example and I can not make it work. I want to query using the serial number and puplate the rest of the fields (that pieces is working) but then I want to be able to modify such fields and update them back ino the DB,......... that piece is not working. here is my complete code in case soemone can guide me.... form Actualizacion_De_Players { displayname = "Actualizacion
CANNOT IMPORT DATA
For some reason, every time I try to import data (either CSV, XLS, or even pasting it into the form), when I hit 'OK' the page just does not post correctly. I tried the same file on multiple PC's and get the exact same result. This problem seems to be new, since I was able to import data 1 day ago. Did something change with the 'import' function? Any help would be greatly appreciated. The 'page' erros are below: Webpage error details User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT
I would like to give an initial value to a lookup field (multiselect) dynamically.
In my samples form, I have a look up field "sample type", from a sample_type form, which displays the name of all sample type in a single select drop down. In the same form (samples), there is a lookup field "parameters", from a parameters form, which displays all parameters, in multiselect list. But, in the the sample_type form, there is already a look-up parameters field from the parameters form, which displays all parameters, in multiselect list. A sample type has already the parameters chosen.
Why doesn't the Help topic for open Url tell me how to open a view while passing more than one parameter.
I need to open an html view, and pass 4 parameters. I see that I can pass one using the example: searchUrl = "#View:Employee_Search?searchParam=" + input.searchEmployee; openUrl(searchUrl, "same window"); But what about when there is more than one?
Remove the logo zoho creator applications using iframe
It is possible to remove the logo zoho creator applications using iframe. See attached http://img64.imageshack.us/img64/6827/reqw.jpg
Can a numeric field generate a number by itself?
I want that a numeric field generates a number, and iterates it. Also I would like to give a special number format, like : YYYYMMDDiteratednumber. Is it possible? I went through ZOHO creator tutorial, but i didn't find it. Thanks
Auto numbering
Hi, can soneone describe in simple terms how to auto number a field. Thanks
Create a View/Report?
Hello - I just switched to the paid version of Zoho Creator and am trying to figure this out. can someone help? I have a form that contains a drop down field with 4 options: AAA BBB CCC DDD I am attempting to create 4 individual reports or views that are password protected and based on the selection of either AAA, BBB, CCC, or DDD. (So you can view all the records that include one of the above selections) This is simply a commissions report Can anyone assist?
All forms form one application migrated to another application
Can I easily migrate all the forms/views from one application to another? I am trying to consolidate several applications into one......
Doc in PDF?
Is it possible to get a PDF version of the userguide, developer guide, and other documentation?
Hiding records from users when searching and viewing
Hello, I've done several searches on this but have not found an answer. I currently have a database into which the public can add records. I want a public view where only certain fields will be searchable and viewable, and I know how to set that up. However, when a user does a search I want only the records with a certain value set to "yes" to be shown to those users. Let me explain why. The database will allow users to add their own entries, but I want to verify each entry before it is
Changing view criteria based on user?
I have an public form that i have multiple sales people submitting sales information to me from. I want these sales people to be able to view all records that they have submitted. I do not want them to be able to view other sales persons records. Is there a way using html views to have them input a user name and password. If it is correct, view all records that they have submitted? I figure they submit a logon form that then does an if then and determines if it should forward them to the view
I'm having trouble with PERMAlink
I'm having trouble with PERMAlink all the forms works except for one. https://creator.zoho.com/avivacanada/midmarket/view-perma/All_requests/mgAkbGQYvABm5pK1DrxAQA4kdSshOs57BKxrpUADXpbH7RffP7GvSqekx4QfG7aY5jJr9k4jZX26BJtWUfVde67VVZsMKYxwnWKp works but https://creator.zoho.com/avivacanada/midmarket/form-perma/Feedback_Form/6sAa49Ja3RwrbK4F3ABmH61BMprAGZZKAktCbfP1n1K6bN02NrufBPAE3EtdbeGmD3aqDseHe3yZUBh375fUPthxMqY8O71gCrtq/ doesn't any help?
Can't remember how to display fetched records without using HTML view
I haven't used Zoho in a while and I can't remember the best way to do the following. I know how I could do it using an HTML view, but I don't want to because of the built-in functionality of the Zoho View's. I need to filter the records in a view based on criteria selected by the user in a form. I have a table of three different size criteria of an item in the "Item" table. Let's say, width, length and height. I want a user to be able to enter specific criteria in a stateless form "Search" for
Adding a new User
I've been trying to add a new user by entering their email address, but no email is being sent to the new user? Am I missing something? Martyn
Says variable isn't declared, but was entered as a parameter
I am trying to fetch records where a field is greater than a parameter. Using deluge... I am passing a parameters into the function, criteria I want to fetch records where Height of the item is larger than the criteria items = item [Height > criteria]; but it says Error in statement at line number 1 The Left expression is of type BIGINT and the right expression is of type STRING And the operator > is not valid here So if I try to set the variable by using criteria = .toLong(criteria)
Client Survey
Hi all, I am new to ZOHO ...i know this is used to create survey forms I would like to know how will i generate leads using this forms...what key info do i fill in and How? Rgds Naveen email:Naveenrao02@gmail.com
Hide/Show option in embedded forms
I have embedded one of my Zoho forms in a Google Sites page. The form is configured to show one field based on an input to another field. This works fine in the Zoho Creator page, but once embedded in the Google Sites page, the application throws up the foll error message - "Error occured please contact application owner" when the trigger input is provided. For greater clarity - here's a simple example of the problem I'm facing. Say, I have a form which has, among others, 2 fields: A and B. A
About the Tabs
Here's a simple suggestion for the application interface... I make extensive use of tabs and hidden tabs in my applications. One thing that bugs me is having to click edit application to find some of my views or forms that are in hidden tabs so I can open them in live mode to see what's there. A better implementation would be to have an options to hid tabs from public (everyone), or users, or developer, or admin. Maybe gray-out the tab to indicate that's its hidden property is set in one of these
Settings Page throws error instead of validating the input
I was trying to create a simple form as a support one to an article about cross-site scripting vulnerabilities. When the link name was having a <script> tag it immediately bombed with an error message instead of showing a validation message. See attachment for more details. ---- Deepak Vasudevan http://thamizhththendral.blogspot.com/
save data in Google spreadsheet
I am trying to use Zoho creator as front end and like to save all the data in google spreadsheet. is it possible to do so!!!
How to refer to some table in Criteria ?
Hi, My application has more than 1 users and I want them to access to different set of data In the Customer form, there is the field called "SITE" I have another form to assign which "SITE" a userid can access However, I can't query that userid-site form in the Criteria for View. Is there any way to do this or can it be done in a different way ? Thanks
Can't See Google Apps Users
I'm currently trying out Zoho Creator Helpdesk. When I go to adding technicians and requesters, the form is completely blank. I can't figure out why.
NULL RECORD COUNT
WHILE DEBUGGING MY APP I CREATED "TEST" RECORDS. I DECIDED TO "GO LIVE" AND DELETED ALL THE RECORDS. NOW THE APP RECORD COUNT IS NULL AND APP WILL NOT LOAD. HOW DO I RESET THE RECORD COUNT TO ONE.
APItite (Zoho CRM API application) updated...
Hello ZC Users, I just republished APItite and here's why :) Hi, I have modified your APILite application to include a daily schedule to fetch recently created contacts in Google Contacts and update in ZohoCRM. Kindly re-publish your application to Marketplace and get back to me for further queries. Rajesh.U, ZohoCorp, http://zoho.com Hi, We have enabled support in GETURL task for reading GData API. Earlier we did not have option for sending Header information and hence it was not possible to authenticate
Next Page