Error in summing and counting a subform data
Hi there I made a form with a subform, where I want to add products names and quantities by adding a line for each new product, I then made another two boxes, where i want to count(product names) and sum (quantities), i did: input.Refer_ncias_com_erro = clientes.count(referencias); input.Quantidade_Total = clientes.sum(qtd); but it doesn´t seem to be counting and summing, can anybody give a hand? thank you in advance
Add tasks to Mail Suite Tasks from creator
Hi, is it possible to build a web form in creator that will add tasks to the Mail Suite Tasks? What i want/ need is a web form from where my clients can add/ request tasks that needs to be done, and i want these tasks automatically to be added to our tasks lists in Mail suite.. Bo
Programmatic access to user groups
Are there plans to allow programmatic access to user groups? Use-case: A form allows a user to select a site location as his primary place of work. The on-submit code places this user in a specific group (in the share module). This is similar to how Sharepoint groups work. Group membership determines what a user can view/edit/access. I suppose this makes most sense of domain-enabled Creator accounts. John M. Whitney
View Data in Google Earth
My data is all based off of addresses. Is there a way to load this into a Google Earth view through Zoho Creator? Ideally, I'd like to be able to select the records I'm interested in, click a button, and have them appear as Placemarks in Google Earth.
Starting a function by clicking on a button / link in an HTML view - is it possible?
Does anyone know if this can be done? Suppose in an HTML view I have a link or a button that says 'execute function x', is there a way to get this to run function x when it is clicked without making it into a link to another HTML page with the function call embedded in it? Thanks, Chris
Update formula field from custom action
I have a form that contains (2) fields called Reg_Users (lookup multi-select) and Reg_User_List (formula). The reason for the formula is due to the View criteria not working correctly. Example: If you were to set the criteria as Reg_Users == zoho.loginuser it will not work correctly, but if you use Reg_User_List (Formula: "" + Reg_Users) it works. My issue is the formula field only updating if you edit/update the form. The application uses custom actions to update the Reg_Users field, which does
Allow invited Users to update their records - without login required!
Is it possible to allow invited users to update information of their records ONLY. What I want to do is send each user an email link that will take them directly to THEIR record without having to do any login. These users will NOT have a ZOHO account and neither should they be asked to create one. The link that I provide should allow them to see/update their records only and nothing else. The idea is for me to create a database of my Users and occasionally ask them to verify their information.
Disabling public Views in Application?
I have a public application for which I have several unshared views; as expected, they do not show up when a public user accesses the public form. However, I'd like to set up a public view (for editing reasons, I can go into this in more detail if necessary) without the view or report showing up as links in the application. See the attached image for an example; in the top illustration I had made a view (in the reports tab) public, causing the Reports tab to appear; in the bottom case I made a
URGENT - CREATOR VALIDATION FIELD with SAFARI, ZOHO response
Hi, I really need strong support on this; I am using soho creator to use its forms in my web site. 1- Zoho form became unstable since the last 2-3 months. Very frequently it changes its response time during loading or after the data submitted. This is not something I experienced by myself but also the people who filled out the form via my web site. The browser status lines say 'Waiting for the server zoho.com' 2- Zoho creator's field validation DOES NOT HAVE A PROBLEM in ALL SAFARI browsers. I am
Usage Limit error
Between my two application I have 581 records. My account allows for 1,000. End users are receiving a usage limit error. I believe this is incorrect. Can someone please look in to this? Thanks Aron
Subforms and scheduler
Hi I have two forms, Form A and Form B. Form A contains the details of a product and Form B as a subform. Form B contains the name and email address of a person and a date. I want to run a scheduled job which 3 weeks after the date on form B emails the person on form B. However, the email must contain the relevant product information from Form A. The problem I have is getting the relevant information from Form A. Additional information: Form B permits duplicate entries ie a person's details may
Input masks?
Can someone tell me how to create an input mask in Creator (such as automatically formatting a phone number with hypens)? If this capability is not already in the product, can someone suggest a way to make this happen upon update or upon add?
New Field Type "GRID" for Zoho Creator
Google Docs Forms are pretty limited in comparison with ZC but I do like this form element:- It collects a lot of data in a small space and means that feedback forms, profiling forms and questionnaires can be built closer to the levels required by my customers. It allows me to define how many columns and their names e.g. change from 1-5 to Disagree, Neutral, Agree in 3 columns and also to define the Row Labels. Each row: Comfort, Reliability & Design should relate to a single column in the view/table.
Little issue with View params zc_SecHeader=false
Hi, When we use zc_SecHeader=false, the paging management is hidden too, even with zc_Paging=true. As a workarround, I set to false all the SecHeader params (add/Search...), but "export Data" and "Total count" params are missing (I didn't find it). Cyril
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
Unable to Share Application
I'm not the account Admin, but I'm listed as a developer on our organization's account. I created two registration forms that I need to share on our web site. It tells me that I need to upgrade my account to do that. I have "shared" both applications with everyone in our domain hoping that I could make it public from the Admin account, but it's not listed as a shared application when I sign in that way. What am I doing wrong? I need to get these forms on the web and I don't want to have to recreate
Allowing users to update data they have previously entered
I have a ZOHO Creator form we've used in the past for data collection, where we had collected email addresses for each entrant (parent email 1, parent email 2, billing email, etc). Now that we are preparing for a new school year, we need to reregister folks; new folks are easy, they'll just enter data in the current form. For returning folks, though, ideally we would like to give them access solely to their own record so they may review/update information. Is that feasible? Since the target users
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 ?
Email new and modified records to user
Trying to set up a custom task environment. Would like Creator to send an email to my employee whenever a record with their user id is created or modified. The employee id would be a look up on a user file which stores their email addresses. Help on this is appreciated! Thanks Peter Forman
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
Set View Width
Is it possible to set the pixel width of a view without embedding it within a table in an HTML view?
Limiting Number of Registrations
Is there a way to use the "Validate" function (or any other method?) to limit the number of people who can register for a particular item. For eg: I want users to select the seminar they wish to attend at a convention but cause the database to cease accepting registrations for any specific seminar once the number of seats are full.
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?
Importing Tables from ZOHO reports into Zoho Creator
Hi, I just found out ZOHO creator and I believe that can help me in some things. No I have already been using ZOHO reports, but my question is, How can I import Data from Zoho Reports into Zoho Creator. Regards
Sort Dropdown Field in Descending Order?
Hello, I wanted to ask if there was any way I can sort an import-data, dropdown field in descending/reverse-alphabetical order? Thanks
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?
Exclude items from picklist
Using the help center I was able to create a dynamic picklist that I am very happy with (and proud of )./ Well, now I want to take it a step further. As it stands the dynamic picklist will display cities based on the selected state. I want to be able to exclude certain cities. This is used to manage our company locations. I created a drop-down field named "Active?" with the choices "Yes" and "No". I want any record marked "No" to be excluded from the list. How can I do that?
Unable to create Reports in Free Account
Hi, i'm using Zoho Creator for the purpose to test the aplication for my organization. However i can't create any reports, in the aplication that i have created. In the Free account can i real create the 2 reports, in the mention aplication? Best Regards, FM
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
Unable to filter data based on zoho.loginuser
Dear Sir/madam I have made an application for customer registeration. In this application different user will enter data of their respective customers. When user do the login and registered a customer by entering its firm name, a record will add in to all table with login user name. Now I want whenever user login for futher updation of registered customer, he can see list of those customer which are registered by him only. For This I have created a stateless form in which a lookup field used for
I really Need help badly
I have created a LOG in for, from there there is a 2 single Line, The username and Password My question is how can i connect the username and the password so it will transfer to the next page and also if failed it will not transfer from other page, I know this is basic for some people, hope you can help me guys, I really need help badly. I want to use the Registration view to be use in Log in. Thank you Richard
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".
Single Record
Is it possible to email or print a single record in a summary view?
File management
I developed a form which purely manages files only. I use this form as a subform for variour other forms, so a master record in an "inventory" table is related to say, 5 image files...... The problem is, the file loads to the Zoho servers are not always successful!!!!! and it's slow some times. And it's expensive to store files on Zoho servers. .... where I can care less if it's a good solution.
Next Page