Google Apps Users
Help! I have an application I started building back in January. I've come back to update it, however the GoogleApps Users function is not updating to my current USERS. Many have left, and need off my list and many need to be added... How do I update this field?
Confused about record selection in URLs
I've created a Summary Report to display a single record. However, the id selector doesn't seem to be working. Whatever ID I use, in the form of: ....view-perma/Organization_Display?id=1526298000000079470 (the IDs I use ARE valid!) I get exactly the same record displayed, which is the one displayed by: ....view-perma/Organization_Display BTW - I've used the same format to do the same thing on another table, and it works perfectly. Alex
Apply same filter for multiple reports on HTML Page
Hello, I'm trying to make a 'dashboard' view to summarize a customer's history based on input from multiple Forms (service reports, customer data, time since last maintenance, etc.). I've created a Report for each Form, and then embedded these in a Page. In order to select which customer the dashboard is for, I've enabled filtering by this field for each embedded Report. However, this requires setting the filter separately for each sub-Report on the Page. Is there any way to set the filter once
Custom Styles in Embedded Reports
What is the best way to create custom CSS or other styles to a Zoho Creator Report? Do I have to create a separate "Page" and build it from scratch? Certainly not.... All I have found so far is very limited color changes but I need to adjust the font size of various records and even better would like to highlight certain groups or records differently. I am new to this so maybe this is not too complicated of a question... Thanks
Primary_Contact=crmResp.get("First Name"+"Last Name"); Not Working
Apologies for the seemingly simple question but I am very new to the whole Zoho world. I have built an app in Creator that has a Zoho CRM field that pulls from Contacts to populate fields on my form. One of the fields is called Primary Contact which I would like to put the Full Name (First Name + Last Name) I CAN get Primary_Contact to equal First Name OR Last Name but not both, I don't know if I can concatenate First Name and Last Name but everything I have tried doesn't work :-( My code below works
Grid View not working due to "on edit" action that I did not add
According to this thread, https://help.zoho.com/portal/en/community/topic/changing-the-display-type-of-view-to-grid-does-not-work, you can't have a Grid view if there is an "on edit" action. Fair enough. I have a form that I did not add any "on edit" actions to, but when I go to the Form Definition (With Action) area, it shows the following: actions { on add { submit ( type = submit displayname = "Submit"
combine info from two forms in one report
Hello all, Some help would be appreciated. I have three forms which make up kind of a library for hard drives which come in and out of our office. The first form (DRIVE_CATALOGUE) establishes a unique ID number for each drive (DRIVEID) and saves some other permanent details. There is also a LOCATION field which is hidden and cannot be edited via the form. It pulls data from the other two forms, depending which was updated most recently (see below.) The second form (DRIVE_CHECKOUT) is filled in
New auto-hide dashboard's horizontal scroll-bar doesn't load always.
Steps to reproduce: 1. Create as many forms as it would take to exceed the 3-column listing on the auto-hide dashboard, such that a horizontal scroll-bar would be required to reach all forms. 2. Logout and login (or just open a new tab). 3. Go to the "Forms" tab in the auto-hide Dashboard menu. The horizontal scroll doesn't appear. However, when you navigate to other tabs ("Pages" or "Reports") and return to the "Forms" tab, the scroll bar starts to appear. The problem occurs consistently. -Varun.
Sync my API with Zoho CRM
Hello, I have my own API that already contains info, and I want them info to be transfered to the crm I don't want to use your Zoho CRM API I want to use my own API I want to know if it s possible to do that ? I am awaiting your response. Sincerely,
Graphical view of a referral network
Hi, I would like to create an application to manage a referral network. I have a table with members info (name, referred by, reffering to, etc.) Is there any way to have a graphical view of members? I mean to see who is reffered by who in a view, not searching in DB. Thanks
Keywords used in HTML Page disallows saving it but with an irrelevant message.
If a variable is named after a keyword (like say "count") in the HTML page, the save fails with an error message that asks the developer to contact the support. A relevant error message would be beneficial. (more relevant the better. if the parser can report use of a keyword, even better) -Varun Yagain.
set variable to portion of lookup field
I have a lookup field in FormB that is pointed to FormA. That lookup field is pulling a string and a date. I am trying to look at the date associated with the string to figure out if the item is acceptable or not. When I create an if statement looking at the portion of the lookup field it says it cannot access child fields. Am I coding this wrong or what way should I go about it so that I can get the information I need. Thank you.
Chart X Axis Numbers Not Sorted Correctly
Granted, the numbers are coming from a text field, but there should be some provision to sort numerically. Cheers, John Whitney
How to sum up values?
Hi, Currently I have a form that records student attendance for attending certain events. Each event is worth 10 points and by attending, for example, three separate events, they earn 30 points. How can I sum up these three separate events point values and use this sum value in another form?
Is this possible: On deleting a record an email is automatically sent.
Is it possible to have it so that on deleting a record with a field set at value 'Yes' then an email is automatically sent with details of the record in the body of the email? If so how can this be done? Screen shot:
What are the best programming practices to improve performance?
Hello, I find that Zoho is a bit slow when opening a stateless form for editing and I'm wondering if there are some best programing practices to enhance performance. For example I've realised that: 1) Loading data for a dropdown box that depends on other dropdown box that has to be also loaded deteriorate loading performance. 2) If the menu has many views or forms also deteriorate perfomance as the many has to be loaded also when opening the stateless form. But, I would like to know if
Segmenting fields on Zoho Creator
Hello everyone, I would really appreciate if it is possible, using zoho creator to segment fields on the (SORTING/GROUPING menus) so that I get the following presentation on my form, instead of having all the data in random order. Thank you very much for your quick reply GENERALITIES 1) 2) 3) APSECTS 1) 2) 3) PARTS 1) 2) 3
Specify username while registration
Hello recently when i add new user into ZOHO service it seems not have to specify username anymore the system create a username automatically (eg: zoho_userddd) it this the new registration rule? please advise, thanks Regards, Matthew
How do I fill a field's value based on the value of another field?
When I am in the Cases (or other modules) of CRM and Choose an existing Contact (lookup), the associated account is automatically filled in for the Case. I would like to do the same thing on Creator form's I have created. The first thing I would like is exactly what I described for CRM Cases. If I get that to work I would like to fill other fields (e.g. phone number based on contact). I am new to Creator programming. I've been searching the forums, KBs and help for this problem. I've found a few
Script to generate a new form
Hi All, Is it possible to generate a new form and view by scripting? I have an application where the user will enter a name for the new form and somehow I'd like this to be created On Success. Alternatively, I could have a template form and somehow script that it should be copied and renamed to the name the user entered. I'm stuck :) Any help, hugely appreciated!!
Links to edit records
In Reports, I can set lookup fields to display with a link which displays the linked form's values. Is there any way to achieve the same thing but with the form in edit mode?
filling a URL Field with a null address
Hi All I am a newbie both to databases and this particular method of creating them. I have made a form with the main primary field being the identifying name of an item. What I would like is that the name is clickable to an associated URL path, if there is no link I would still like to see the identifying name. I have used the URL field but it doesn't like a blank URL field and if I use just http:// it brings up a blank page (not very elegant). The important part of the URL field for me is the link
Dependency Fields
How do I get fields to be dependant. Eg: Question: Yes - No (so this is a radio field) IF Yes, I want a few fields to become visible underneath it or even a SUB-FORM and required. If NO then nothing. Thank you in advance.
Inserting bidirectional subform without display type
I'm trying to create an app with a bidirectional subform that doesn't display the linked field below the subform. I have two forms. Main form is "Clients" and subform is "Appointments". I want to be able to enter appointments in on the clients form and have it be a bidirectional link, but when I do it adds another dropdown field below the Appointments subform. There is an Application called Employee Management that I'm trying to mimic, but I don't know how to accomplish it.
Strange repeated and displaced sections of screen
Sometimes I get displaced sections of reports. I am using Google Chrome running on Windows 8 and a very fast Internet connection. I have seen it many times on my new and old PC. Any ideas?
unable to edit any application settigs
I am unable to edit any of the general settings for my creator applications, The error message tells me to contact support. Well, support has been completely unresponsive. This has been going on for about 1 week. Access to my Creator account has been enabled for several days now and that is making me uncomfortable as well. I simply cannot move forward at this point. Please advise.
Filters not working
I sent a support ticket but no one answers so I was hoping someone could help me. My views keep losing the data and I have to delete the filters and create a new view every time to get the data to show. Any suggestions on what I can do to stop this. It seems there is a problem with the filters.
Formula field looking up Child of input
I have two forms. Clients - Has First_Name and Last_Name fields. Attendance - Has Client lookup field, Date, and Status. I want to add a formula field to Attendance that will concatenate Client.First_Name + " - " + Status When I try this, the Client.First_Name I get 'Client' is a lookup field and child fields cannot be accessed When I try Clients.First_Name I get Variable 'Clients' is not defined When I try input.Client.First_Name, it accepts it, but returns null for input.Client.First_Name If I
email quota with paid plans
Seems like I saw something on zoho about email quotas per user per day but now I am about to sign up for a paid version and there is not description of email quotas on the paid signup page except for add-ons (emails $20/ 500 / month). Here is the page I am on. How many emails are included in each plan? regards, David
filter a lookup, based on another lookup
I have a small database holding info on the following candidates employers vacancies referrals Vacancies are added with a lookup to the employers now in the referrals table I want to pick a candidate, then pick an employer and have another drop down listing the vacancies for that employer instead of all vacancies. can anyone point me in the right direction ? cheers Mitch
Calculating prices using checkboxes?
Hi Im pretty new to this application and Im trying to set up a BMX database for our company. Im just working it out little by little by Im trying to figure out if you can use it to calculate prices for the different types of riders that we get and if they hire equipment using checkboxes. For example if someone checks that the rider has hired a bike and is a member it automatically brings up the price the rider needs to be charged. However if another rider comes and hires a bike but isnt a member,
ETA for Query - Paid Customer
Hi Zoho Support, What is ETA for defect fix or help? I have been trying since 24 hours to contact Zoho Support, as well as sent mail with my requirements. I am not able to reach through Phone and nobody is there who can respond mail promptly. We are paid customer and one issue/query holds entire application development process. At least, give call back if you are not able to answer when we call.
Enterprise subscription question
Quick question, just updated subscription from pro to enterprise due to additional users. What is the Manage Contacts section in Account Setup for? Unlike Manage Users and Manage Groups their doesn't seem to be any way to add data to it.
Newbie question - read only databases?
Hi all Newbie to zoho creator, not to databases. have created a database for personal use. i use the view in order to query the data and it works fine. i want to prevent myself from accidentally editing the data as it will never change. can i make the database read only or inhibit add up delete on the view? Many thanks in anticipation :)
Mi Zoho Creator is missing !!
I entered in my Zoho Creator page. All gone !!!. My apps are gone. There is nothing on my page. It is completely empty. Please help me. All my information is missing.
Marketplace Client Publishing
In Marketplace, if you Publish an app to a client with data and source code, can they then create a copy that will "live" on independently of the original app. Will the copy have full editing privileges as if it were created by the client? Will the copy lose any functionality if the developer closes their Zoho account? The reason I ask these questions is that I need to move an app from its original account to a second account and the ds file I created from the original account will not import into
How to reference subform data (pre-fill from existing data)
This sounds like it should be fairly straightforward - I have a form that has a subform which is filled out. A second form pre-fills in data from the information submitted. I can't use this older information to fill in the subform in the new form. (other fields work perfectly fine) I've tried: z2=FormName [ID = IDofOld].SubformName; And this returns the IDs of the subform. If I just set the subform in the current form equal to the z2, I get an error when running the application saying: Error Executing
ds file import problem
I can't get a ds file to import. The ds file has many lines...could there be a limit? I get this error: There was a problem importing application null. The ds file was created as a back-up of an application in an account that I own, but that is different from the account I want to import it into. Is it possible for Zoho reps to make this move for me? Would it be worth a try to put the app on marketplace temporarily just to get it moved over to the other account?
Images in HTML page and ZC Form viewable in Google not shown in Yahoo
Hi, Images in HTML page and ZC Form viewed in Google but not shown in Yahoo. Could anybody have idea on how to fix this? Thanks, Lagromac
Why is Zoho making a "secret campaign"?
Why not tell the user that "if you display zoho banner in your website, you will have this incentive", like others did, 30% when there is a sale from a click of the banner. I embedded an HTML page in my website, without my knowledge you put this anywhere, in a image or in a text, https://www.zoho.com/creator/online-form-builder/index.html?utm_source=Zoho_Form_Embed&utm_medium=view_footer&utm_campaign=ZohoAds This result to destroying the layout of images when in live mode or forcing the user to open
Next Page