One Click commission
Does anyone know which is the difference between "Quota" and "Annual Quota" in "OneClick commission Tracker"? It looks to be something confused. Thank you Matteo
How to segment fields
Hello everyone, Do you know if I may segment fields on my app page so that I get a clean presentation when I log onto my app page. Basically I would like to have the following display: GENERALITIES (as to the title) 1) 2) 3) DEPARTMENTS 1) 2) 3) 4) Indeed, I need to allocate those information to each title. I tried using the GROUPING/SORTING option of zoho creator but I don't get the desired display. Thanks for your reply
Sharing issue
I realized this is trivial, but i haven't been able to figure it out. Probably my inexperience. I am trying to share portions of my app with two individuals. I have shared it and sent the email notifications but neither one has received the email. Anyone have a solution? Thanks for helping the newbie.
How to embed an uploaded css file in an HTML view?
How can I use an uploaded CSS file in my HTML views? I've tried two different ways, but neither seems to work: <link rel="stylesheet" media="screen" type="text/css" href="https://creatorexport.zoho.com/DownloadFile.do?filepath=/[blablabla].css&sharedBy=<%=zoho.adminuser%>&appLinkName=<%=zoho.appname%>x&viewLinkName=Supporting_files_View" /> and <style media="screen" type="text/css" src="https://creatorexport.zoho.com/DownloadFile.do?filepath=/[blablabla].css&sharedBy=<%=zoho.adminuser%>&appLinkName=<%=zoho.appname%>&viewLinkName=Supporting_files_View"></style>
Clarification on ways of displaying content in Pages
I want to check my understanding of the use of pages. Can someone confirm I have this right, or correct my misunderstanding, please? To display Zoho data in a "page, there are three ways: 1. Use a "div" statement 2. Use an iframe - With the URL explicitly included - With the URL generated by a call to OpenURL 3. Embed fields explicitly within the page Am I right in thinking that, when using a "div", you cannot perform any filtering on what gets displayed. For example, if I want to display a single
Hiding Tabs for Certain Users
Is there a way to hide tabs based on the logged in user? In my application there are three tabs. I want to have the "request" user to see only the first tab. While the "manage" user sees all three tabs. Possible?
Need to Sync between CRM records and Creator records
Hi Everyone, I need to make an automated flow which can make a sync between CRM and Creator records. If i update a record in CRM then it should change the creator record automatically and vice- versa Half of task is done by me, if i do anything in Creator then its reflecting in CRM as well whether its creating new record or updating existing record. Also when i create a new record in CRM, same record is being created in Creator form but if i update existing record in CRM then i am not able to update
Track users
I have an app that I share with 2 other people. Is it possible to track their activities? Would it be possible to tell which user did or didn't make an update or change to our data?
Using Record ID to autopopulate
Is it possible to use Record ID from one app to autopopulate (certain) fields in another app? I'm using forms to set up a workflow, so as a form is submitted, an email with the appropriate info is generated to a second group. That group picks and chooses which sets of data to take action on (3/10). The info from the first form is needed, along with new info that the second group adds. Want to remove the need to retype (mistakes+extra effort) all data and use the record ID to pull data from first
Dealing with & in URL parameters
I am dynamically creating URLs to display filtered views of tables based on some table values. When those table values are strings that contain the & character, the search does not work because the & is taken to be a parameter separator. e.g. /view-perma/Contacts_List?Org_Site=B&M%20Services doesn't find any results. But if i replace & with it's ascii value, and use /view-perma/Contacts_List?Org_Site=B%26M%20Waste%20Services-Cheshire that works fine. Now, I COULD write some code to do that replacement
Basic Question on Creator layout. Cannot see the tabs
I have a silly question. I have not used Zoho creator for a few years and cannot figure out how to get my layout to show the tabs as shown in the tutorials and videos that I see. I do not have a tab for Views or Share... This is the layout that I see in the tutorials and videos and remember from the past. My Layout looks like this.... Please could someone tell me how to get the normal layout view?
how do i submit zoho forms to android market? can i change it to apk format?
how do i submit zoho forms to android market? can i change it to apk format?
Sharing forms in a section
Hi, I have numerous forms that I organised by building them into pages, and then putting the pages into sections e.g.: Section 1 --->Page 1.1 (with Form 1, Form 2, Form 3) --->Page 1.2 (with Form 1, Form 2, Form 3) Section 2 --->Page 2.1 (with Form 1, Form 2, Form 3) --->Page 2.2 (with Form 1, Form 2, Form 3) I use Deluge to share specific sections with invited users, but when the users log in, they cannot access the forms on the pages. Also, there doesn't seem to be a way to share pages, just sections
Set variable not working in the custom button of stateless form
User Name: kumar.n Application URL: https://creator.zoho.com/appbuilder/kumar.n/reportissue Access To Support: Granted -Neeraj.
Database Questions
I am a real estate agent in VA. I have created a form, allowing me or another agent to enter in several fields to capture information on incoming leads/prospects, then save that record to a database. I have 5 buyer agents working for me. Now I want to be able to assign a buyer's agent with a particular lead(s), so when they log in they only see the leads assigned to them, and no one else. I have created a drop down box with each of their names in it, and this drop down box is only viewable
How do you convert number to string?
For my Products I would like to create a new SKU which consists of several Single Line fields and the Auto_Number field. When I try the following: input.SKU = input.Auto_Number; I get the following error: "Variable 'Indd_File_Name' is already defined of datatype 'STRING' but trying to update 'BIGINT' datatype" When I try input.Indd_File_Name = input.Auto_Number.toString; I get Invalid collection object found But it also won't let me put String values into a Number field: E.g. when I try: input.Number
Persistant Problems with ZC Groups
1. I cannot delete a member from a group: I'm the account owner! 2. I cannot add one of my domain users to a group. In fact, it shows none of my users!
Barcode Integration: iPhone Scanner
Related: https://help.zoho.com/portal/en/community/topic/barcode-integration I have been attempting to use the iCody iPhone app as a barcode scanner: http://www.appthology.net/de/iphone-apps/icody There are some technical issues with ZOHO Creator forms the Appthology support staff finds for error-free integration. They are talking about DOM and tables (what?). Anyway, would ZC support have the time to speak with them to see if a mutual solution could be enabled? I have been speaking with Frank,
Identifying Subform Entries to a Mainform Entry
Hello I'm creating a database to manage members of a University student organization. I built a People table and a Members table since not all people that attend meetings are members of the org. I created the People form and inserted the members form as a subform. With the example I have below, I have John Smith as a person and he's a member but how do I include his name into the subform without having to duplicate work when I first enter his information into the form? This is an issue because if
Concatenate fields on user input
Hi I'm creating a database to track my student organization and I'd like to make it easier to look up records. If someone enters their First and Last name into First_name and Last_name fields, I'd like Full_Name to concatenate the first and last name. Thank you ahead of time!
Zoho Docs and Zoho Creator - integration ?
Hi team, Is it possible to upload files to Zohodocs using the file upload tool in ZC ? Requirement / Issue File upload replaces the existing doc -- No, we dont want to replace the doc -- we want to add / append docs to THE record in ZC On the same note, If ZDocs is not possible, Can we use Dropbox / googledocs / via ZCreator's file upload & view the list of docs in the record's [detailed] view -Deepa Govind http://homepreneur-online.com/
After editing in summary view, don't see the edited record
When I display a single record (via a Summary View), then edit it and press Update, the next record shown is NOT the record just edited. Is there a way to make it so? It's very confusing otherwise. It seems to make no difference whether I use a URL like this: ..../#View:Organization_Show?recLinkID=1526298000000079110 or like this: .../view-perma/Organization_Show?recLinkID=1526298000000079110 I get the same result of it NOT displaying the edited record. Thanks Alex
Success Message not Displaying
I have a stateless form that I am trying to embed into my website. It works great, with the one exception I can't seem to get the success message to display. When I submit the data, it just resets the form with no indication that it was successful as opposed to just reseting the form. I've also tried a link in the next url field, but that doesn't work either. Any help or suggestions? Any other information you might need? Thanks!
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
Next Page