White line in header
Most (not all) of my html pages with embedded views show a white horizontal line between the view header and the column headers (see pic). That looks ugly. Please assist. Here is the div tag I used for embedding (I don't see how this one is different from the views which look fine though): <div elName='zc-component' viewLinkName='Players_embedded' params='zc_Search=true&zc_AddRec=true&zc_DelRec=true&zc_Header=true&zc_Footer=false&zc_DuplRec=false&zc_EditRec=true&zc_EditBulkRec=false&zc_Summary=false&zc_RecSelect=true'>Loading
Should Developer Role in Creator give you ability to "Edit this Application"
I would like someone besides me, the Admin, to be able to edit a form in my Zoho Creator. I thought making someone a "Developer" would do that? But when they log in they don't see anywhere to Edit the application? Thank you, Andrea
I need some help
I'm a realy noob in zoho creator, i need to set up my registration page that will connect to log in page so no duplicate information and also username and password should match the data that is enter in the registration, I having lots of error, can you help me? I really dont know how to start, Hope you can help me. Richard
Test if form is loaded in "on add"-, "on edit"-, or "on delete"-mode?
Hi! I have an "on user input" field action for a dropdown field that I only want executed if the form is loaded in "On Add"-mode. Can I somehow test for this in an if-statement in the script? Thanks, Espen
toList() can it build a list of inter type
Understand that toList() is implicitly a string function In my case the toList() is for type integers Any way to tell toList() that the list to create is of type INT ?
NO Admin or CSR answer may question, almost 3 days ( i will repost it here)
I need help regarding my log in page, I need to set up my log in I need to match the username and password so it will execute in and transfer to next page Then if is not match i will stay on that page. Please help me
Link to edit a field in a record- Can this be done??
Hi All, Just wanted to see if this is possible before I try developing it. I have a event where I would like to email each contact (whose details I have in a contact form) containing a link that on clicking would confirm their attendence. I suppose it would very similar to an unsubscribe link in a email you get from an online trader. If this is not possible, could the link direct them to a html view where they would pass their email address/name as a variable and clicking a button would update
Views not showing custom actions in view header
Hello, I've tested this and it is working in -precreator.zoho.com-, but not in standard creator.zoho.com. I can create custom actions and show them per item properly, but when I tell them to display in the view header, they do not display (even on a mouseover). Very nice work on views at precreator.zoho.com by the way :) Best, Andrew
Tracking referrals from leads or contacts
Would it be possible in Creator or another way to add the ability to capture multiple referrals from existing leads or contacts that would be reportable or trackable?
Having Data already filled out based on the link of the Form
Is is possible to have someone click on a link to a form, and based on factors, have some of those items already be filled out?
Stuck on updating record from a stateless form
I've made some progress on creating an effective comment system, but I'm stuck on something that I would have thought was simple. My scenario: 1. I have a view for a Project Request Form with a custom action/button that calls a stateless form. [this is working] 2. The stateless form has a Notes field, which it populates with the Notes field from the Project Request Form with the matching ID. [this is working] 3. I want the user to be able to edit the Notes field in the stateless form, which updates
Passing parameters to an embedded form.
I have an embedded form to which I want to pass a html parameter. A page "test.html" includes <iframe height='500px' width='100%' name='zoho-Student_Web' frameborder='0' allowTransparency='true' scrolling='auto' src='https://creator.zoho.com/<user>/<app>/form-embed/Student_Web/Arg1=xxx'</iframe> I would like to call test.html&Arg=<string> and pass the value of Arg to the embedded form. In other words substituting xxx with the dynamic value passed to the html page. I've tried all sorts of options
Can registered users update their information with a password?
Hi people, I have a question which I couldn't find the answer in the support forums. I have developed an online database for volunteers. www.evsturkey.com The volunteers are filling the form and make their registeration. Now I want to create another FORM for updating the records. I found out to update a data in a from from another from with "STATELESS FORM". But what I want to do is something further: When the volunteers make their registaration I want them to define a password in the "Password Field".
Course Registration View Help
We have built an application which is used for course registration by our employees. The issue seems very simple, but has been difficult to resolve. The following link is of a simple application that Zoho Support was helping me with, but wasn't completed. The issues with the app is detailed below: I would prefer the when a student clicks register it automatically will register them. Not open a form and they select the course. It does not appear to behave correctly. Example: I registered for Zoho
Pre-filter Reports based on signed-in user's ZOHO ID
When a report is loaded, is it possible to pre-filter the data graphed/tabulated based on the user's ZOHO ID? In other words, hide some of the data as the report is loaded? Use-case: Managers need to view local inventory at their site, but should not see the complete inventory in the company as this is a security policy voilation. Thanks, John M. Whitney
Criteria in zoho.reports.updatedata ??
hi i use the zoho.reports.updatedata deluge task from zoho creator. i would lik to use a criteria depending of an input field value. i dont find the good way to write this criteria wich must be a string.... trans1=map(); trans1.put("Agence",input.Agence); trans1.put("AFFECTATION ANALYTIQUE",input.AFFECTATION_ANALYTIQUE); trans1.put("LIBELLE",input.LIBELLE); trans1.put("AFF-CS-PS",input.AFF_CS_PS); a="AFFECTATION ANALYTIQUE=" + input.AFFECTATION_ANALYTIQUE; mapResponse = zoho.reports.updatedata("BASE","TABLE",trans1,a);
Delete records does not work properly for decision boxes
Hello, I've created a test application to expose this issue, which I have shared for tech support (it is named "delete-bug"). The issue is the following: I create a decision box for my application, and submit it as FALSE into the database. I then run a script to delete the decision box, but it only deletes data if the decision box was marked TRUE. The code is as follows: delete from decision_box_form[ Box1 ]; The only way to get this to work is to compose: delete from decision_box_form[ Box1 == false
"zc_Header=false" doesn't work in view-embed (since view enhancements)
Hi, Style based URLs: "zc_Header=false" doesn't work in embeded views since view enhancements. Regards, Leszek
Field does not update/update properly on "on input"? / Adding values of selected entries in real time
Hello, It's probably something small that I'm missing here, but I'm trying to get your example application, "calculate-multi-select-price" to update with the price of the items selected in real time. The application is shared with development and is entitled "Copy of Calculate Multi Select Price" (http://creator.zoho.com/andrewkahn.me/copy-of-calculate-multi-select-price) I placed the code from the on success script (which does work properly for On Success only) into On Input: val = 0.0; for each
How to create a filter in a database?
Hello, Exactly, that I would like to do is to create a filter: The user will have to choose between different option of language: English, Spanish, French, Deutsh .... In fonction of the answer of the questions the user will be redirected in a different dataform. In the same time, when the user create some filter in the product finder price, type, brand, features.... he could find the correct device. How can we do that? Thanks very much for your help,
Purpose of Function and Scheduler in Application Home Section
Sorry maybe i missed the announcement, or cant seem to find it What is the purpose and difference of the Function and Scheduler in the Application Home Section as opposed to what i have been using Functions and Scheduler for individual apps ? I have an idea but don't want to waste time writing stuff in the wrong section
Need help for convert string to date or number in HTML view
Hi Why can't convert a string variable to date or number in HTML view by using toDate() or toLong() built-in function? I try to so many times it's can't save the script like bellow: Waiting your help and thanks Stanley
How to make notes appear in the email sent when the user clicks submit?
I wrote an html code and added it to the form with the field notes and I want it to appear with the rest of the information that is send to me when the user clicks submit. Thank you for your help! :)
Could use some help with challenging script
Hi, I'm at a loss. It seems I'm terrible at math and not much better at scripting Here's my issue: I'm developing matching software for a speed dating like event. There will be roughly 20 people from 2 different categories ranking each other after a series of first round "dates". Think of them as 10 males and 10 females. After the first round, each person will submit their top 5 choices and we will come up with their 3 best matches for the 2nd round of dates based on comparing everyone's top choices.
zoho.currentdate.subMethod(1) returning wrong value
current date: 03/30/2012 <%=zoho.currentdate.subMonth(1)%> returns 03/01/2012
Custom Action on phone
Is there a way to use a custom action on a view on a phone (Android or Iphone). Currently the view is displayed in Summary style which does not show my Custom Action button. Herb Wexler
Using zc_LoadIn=dialog to edit and add records from an HTML view
I have an html view and would like to mimic the Edit and Add record found in a standard list view. I can get Edit to work, but the required zc_NextUrl and openUrl("#Script:dialog.close", "same window") in the form definition are clunky at best. I can not get Add record to function, however. The add record form opens in the popup window, but the NextUrl does not cause a refresh and the #Script:dialog.close in OnAdd...OnSuccess does not close the popup. I will respectfully disagree with Gaev (About
Allow more space for form name in edit mode
When in edit mode for a form the form name appears above the code. However only the first 15 characters of the name are shown. Can this be increased or the full name show when the mouse is over the name. Herb Wexler
Carriage Return in list view doesn't show in html view
I have a form with a couple multi-line fields. They commonly get carriage returns just with an "enter" key during input. In a list view, those line feeds show up correctly. But when I pull those fields into an html view with a fetch, the line feeds don't show in the html view. Am I doing something wrong, or is there another way to do this? Thanks for any input...
Help on inserting capital names in single text box
Hi, i have a problem, i have a single text box where i insert names, is there anyway i can make the box give error if the name entered does not comply with a list of name i have in a form? or do an if not equals name condition? e.g. i have several names all with capital letters JOHN JAMES EMMA TIM but if the user inserts john or james or James or ja.mes or ema, Ema, Emma, resumming if does not match the name in capital it can´t be inserted.
Scoring Application
Hello, I am asking this question to see if what I am looking to do is possible before I waste a lot of time and effort trying to make it work. I would like to create a scoring application to track the results of a competition. There will be multiple athletes competing and there will be multiple events. Each event will be scored and the athletes will be ranked depending on how they perform compared to the other athletes in that same event. I have created a form for athletes and an event. I can enter
Opening an email using deluge script
Hello, I'm trying to set up an app to track on call staff members. One of the functions I would like to have is the ability to have a script open an e-mail addressed to a specific address using my computer's default e-mail client. The reason for this is that the e-mail address I would be sending to is an internal address that can't be directly e-mailed from outside our network. If the script were to open an e-mail using the default client (for all users, this would be Outlook), it would allow them
Zoho creator to Zoho reports
I have successfully linked a creator form to a zoho databe but are only aple to pull text fields and not the number or decimal fields. Has anyone had this issue? Pleae help. Regards, Michael
Clearing / Resetting an iframe
I've created a stateless form with 4-buttons - each button, when clicked, populate an iframe ("form-iframe") with another form. I'd like to tack on a "Reset" or "Clear" button that will refresh the iframe back to it's blank state. I tried blanking out the URL in the iframe parameters, but that didn't do the trick. Any thoughts?
On Update : Lookup error...
Hello ZC Team, I have a problem trying to call a function on a lookup field, I can sucessfully invoke and use on the user Input action but when I try to use same code on the "On Update" action I'm having problems: My code on de User Input is: list = base_de_curriculums.gconsu.gclistaconsultores(input.Skill_Disponible); Nombre_Consultor:ui.add(list); This is working very nice- Now I want same but in on Update, message error say" was expecting append, I change add by append and message say
Check number of entries in the database
Hi, I have a form to input a list of location with date. Now i want to consolidate to see which are the location i frequent the most, therefore I want to design out a form to list down the list of location with the number of time visited beside. How can I do so? Thank you.
update a row in zoho reports from zoho creator
Hi, i succedd add a row in zoho reports from zoho creator but can't update a selecting row. I wrote this deluge code. Where have i made a mistake please ? trans1 = map(); trans1.put("Agence", input.Agence); trans1.put("AFFECTATION ANALYTIQUE", input.AFFECTATION_ANALYTIQUE); trans1.put("LIBELLE", input.LIBELLE); mapResponse = zoho.reports.updatedata("BASE", "Table", trans1, "AFFECTATION ANALYTIQUE="+"'"+input.AFFECTATION_ANALYTIQUE+"'"); TY
update data in reports from creator/ criteria
I understand how to update data in a zohoreports table with the deluge tasks zoho.reports.updatedata ( BASE, TABLE, map, Criteria) but i don't success to use a criteria depending of the value of an input field. My example is : trans1 = map(); trans1.put("Agence", input.Agence); trans1.put("AFFECTATION ANALYTIQUE", input.AFFECTATION_ANALYTIQUE); trans1.put("LIBELLE", input.LIBELLE); a = "AFFECTATION ANALYTIQUE='" + input.AFFECTATION_ANALYTIQUE + "'"; mapResponse = zoho.reports.updatedata("BASE",
My Wish for 2012: Concurrent User Subscriptions
This is my wish for ZOHO Creator in 2012: For domain level accounts, offer application-level sharing for a limited number of concurrent users. For example, a 5 concurrent user plan would allow one admin and four active users to simultaneously access applications. If another user attempts to sign-in, he would be denied until one of the other four users signs-out, or until the admin deletes a user from the account-level share, or until another user logs 15 minutes of inactivity (no page refreshes or
3 small issues remaining
Hello, I am very very close to finishing my app! My Director is very impressed with what I have done so far - I just need some help with 3 outstanding issues that I am having. 1. - Filtering Issue numbers. I have 3 forms in question, Drawings, Issue_no, and Work_Order. When the user creates a new Drawing in the Drawings form, they also create a new Issue no in the Issue_no form which is a sub-form within the Drawings form. When the user selects the drawing from the Work_order (via. a look-up field)
Next Page