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.
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
Modifying the grouping names for display
I currently have a view that displays and groups a series of real estate closings. Grouped first by year descending and then by month descending. The group headings show 2012-1 followed by the data then 2012-2, etc. I would like to translate the 2012-1 to 2012 - January, etc. I know how to call the function to convert the numeric value of the month to it's equivalent name but I don't know if it is possible to modify the auto-generated group headings. FYI: I get the year and month information from
Work Hours in a Month
Just sharing a function I made to calculate the number of work hours in a month. It takes the input of a MONTH string (1 to 12) and does the rest based on the current year. MONTHS={"Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"}; this_MONTH=MONTHS.get((input.MONTH.toLong() - 1)); DATE_STRING="01-" + this_MONTH + "-" + (zoho.currentdate.getYear()); DATE1=DATE_STRING.toDate(); DATE2=DATE1.addMonth(1); DAYS=((DATE2 - DATE1) / 86400000); HOURS_LIST={1, 2, 3,
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
'Backup Apps' failed in Creator permanently
Hello Zoho! We have a problems with backup of our app ‘CRM’ in Creator. Trying few times on last week, but still unsuccessfully. Please, help us with a backup. Alexander Smit. Clientbridge.
Login?
Hi! Is there a way to use Zoho as a login screen, where it would return the users name or something if the data matches up correctly? I would then use cookies i quess to store that info, then delete the cookie when they log out. Is this system possible with zoho?
Validating user input in decimal field
In a form, I have added a decimal field to capture "duration" in this format - 00.00 (hh.min). Once user inputs the value, I would like to validate the field to check that the input is in exact format as requested. Can anyone help me with an answer on how to achieve this.
Help with limiting user access
We have 10 case managers with hundreds of clients and are trying to prevent our case managers from seeing any records that are not assigned to them. We have a case manager view created which links their names and email address. Tech support has provided to following code: cm_email=zoho.loginuserid however when this is used in "Set Critera" I (ADMIN) lose access to my whole pipeline view. I have tried to duplicate views unsuccessfully. Thank you in advance for your help on this.
"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
Urgent ... Client experiencing problem as of this morning !!!!
ZC Support: My client has just reported a problem (a popped up Stateless Form is no longer closing via script) ... nothing has changed on this App for a long time ... I tried to examine the code ... but the system goes into a never ending wait state as soon as I ask to see the code associated with a Button ... on both the Test and Production versions of this Application. According to the client, problem only occurs on machines where the Browser was NOT closed from the previous day !!! There is no
Can the ZOHO Creator Team please explain this situation ?
I just received an email from noreply@zohocreator.com ... here is its content ... Hi scriptedlogic, The user orders@wmxchange.net has been added to the list of users associated with your account. Since the user has shared access to your application, he/she has been added automatically while accessing your application. https://creator.zoho.com/scriptedlogic/sicar-lite/#Form:User_Info Regards, Zoho Creator PS: This is a system generated mail from Zoho Creator. Please do not reply to this mail. When
Next Page