Report hang when scrolling
Hi, I noticed the new enhanced feature on reports, there is no paging any more, but when user's scrolling down to the end of the screen, the report fetches more records. However, this ALWAYS causes screen hang. I have a report with around 40 columns and less than 3000 records, every time when users scrolling fast, the screen will be frozen, and IE will prompt that "the scripts takes long time, stop it?". Moving back to the paging style shall be helpful. Or, please help to fix this defective. Thank
Creating relationship between form and subform
Hi all, Please excuse my ignorance as I am very new to Zoho and while for the most part the user interface is very intuitive, the deeper possibilities with coding remain a bit obscure to me as my knowledge in that field is quite limited. Essentially what I am trying to do is create a database for storing information about lectures. This database is very simple and I have designed it using only two forms: talk and excerpt. Whereas a talk can exist without any excerpts, every excerpt is part of a talk
Zoho Creator EU edition
I started using Zoho Creator in zoho.com domain, but due to regulatory reasons opted to move to zoho.eu domain. A lot of functions we see in zoho.com are not yet available in .eu account, almost a beta version of .com. Is there a time line when the full functionalities of .com will be available in .eu domian? Thomas
Many to many relationship with note field for each relation
I'm trying to create a many to many relationship while storing some information about that particular relation. For example: A SurveyQuestion has many AuthoritativeSources. When an authoritative source is chosen for a question, the rationale (or justification) for the selection should be documented in a note. An AuthoritativeSource can be used in many SurveyQuestions. In a database this would be represented as: SurveyQuestion >-< AuthoritativeSource SurveyQuestion - ID - QuestionText AuthoritativeSource
view-perma view conditioning Add button
Im loading a view via view-perma link w/ url parameters. I also need to limit the Add button to only add records which are preloaded with the url parameters so like records can be created. I tried to interrogate the url parameter via the onAdd/onLoad event but I could not access the views params. How do I modifiy the view's Add button on a view-perma screen? Thanks :)
Creating a page to display record counts by field criteria
Greetings all, I did my best to find the answer on my own.. here's what I've got: I have a Creator application with a bunch of records with different "Statuses" by field. I want to create a simple page in the application for my users which would provide a summary of record counts by "Status" Example: Status field values: Pending, Paid, Cancelled Page/Report desired: Pending: 37 (records) Paid: 31 (records) Cancelled: 12 (records) From what I'm gathering, this can be done
Can table names be programmatically referred to?
Hi, I would like to store zoho creator table names in another table and then uses those field entries to access specific tables. Is this possible? Thank you.
Zoho Creator iOS app Offline access of forms
I am trying to access an app through iOS Zoho Creator and work in offline mode. No matter what I try, I am only able to get 1 or two forms in offline mode, rest won't appear. Following the instruction, I opened each data entry form and submitted a record each from the mobile device in wifi or 3G but when I tuen off the wifi or 3G not all these forms are visible. Is there anything / any steps I missed? Is there a form which addresses these issues in Zoho Creator mobile app? Is the App fully functional
For Each Record - need help with criteria
Hi guys, Could you please help with this? BACKGROUND ---------------------------------- We have a form called "New Claim". The form has a field called "Today_Field". It also has a field called "Status". SCHEDULE ---------------------------------- We have a daily schedule set up which updates "Today_Filed" with current date. The code is below: for each r in New_Claims { r.Today_Field=zoho.currentdate; } THE PROBLEM ---------------------------------- Right now, the schedule iterates for all records
Access desktop ip cam or webcam
Does anyone know how can I access the desktop IP cam or web cam with Zoho? Thanks in advance, Mauro.
How to display auto number field?
How do I display an "Auto Number" field I created in a form? Can I generate this auto number at time the form is loading instead of on Success of completing the form? Is this why the Auto Number field can not be displayed to the user? Sorry I am new to this, any help greatly appreciated.
Error at line number : 1 Mismatch data type for function zoho.crm.updateRecord at argument index 2 expected data type STRING found dataType BIGINT
I'm trying to make my inventory update able and editable through an app. What I've written: resp = zoho.crm.updateRecord("Products" , input.Products_ID , {"Product Owner":input.First_Name,"Unit Price":input.Unit_Price,"Usage Unit" : input.Lead_Email}); Error Message: Error at line number : 1 Mismatch data type for function zoho.crm.updateRecord at argument index 2 expected data type STRING found dataType BIGINT I don't understand what I've done wrong. I've matched all the field types and I've
Auto Update of Form
I have a form in a Zoho application that is only used for information i.e. no updates are done in Zoho. The data is kept in another application. I have had the application export a .tsv file of the data needed in Zoho, and when I delete all records and import the .tsv file, it works perfectly. The client wants to automate this. Is there any way to have a Deluge script that runs say at midnight to delete data in the form, then import from a file? Maany thanks
CRM custom functions: Update fields cross module based on look-up field type
Hi there, We are linking our products records with our contacts records using a look-up field between products and contacts module. Is it possible to (via a custom function and workflow automation) update a field in the product record based on a value from the contact record associated to the product record via the lookup field? Kind regards, Bo Thygesen
Free vs Premium
I understand the free plan limits the number of records to 750, along with 3 users, but what other restrictions exist for free plans? I have a client that has very simple needs and probably only needs the free version, at least for now, but want to make sure I understand what all the limitations are on the free plan before I proceed. Thank you
Adding record with multiselect using Creator API
Hi, Is there an issue in adding records with multi select fields using Creator API? I can add the record if there is one option selected but doesn't allow me when there are multiple options selected. This is part of my PHP code $opts = explode("##", $form_data->contractorOptChk); $this->XMLString .= "<field name='fieldname'>"; $this->XMLString .= "<options >"; for ($j = 0; $j < count($opts); $j++) { $this->XMLString .= "<option>" . $opts[$j]
Creator database search
Why does searching my Creator database produce no result when the information is clearly in the database? This happens with some records and not others. If I export all the records to a spreadsheet, all records are exported. However if i scroll through the list of Creator records, I don't see the one i'm looking for. What's happening here?
API issue
Hi, I am trying to add records into a form by add using the API. Here is the example with dummy data. form method="POST" action="https://creator.zoho.com/api/MYSYTEM/xml/MYTABLE/form/Room_Sponsor_Data_Form/record/add/"><input type="hidden" name="authtoken" value="MYKEY"> <input type="hidden" name="scope" id="scope" value="creatorapi"> <input type="text" name="GiftDate" value="11/11/2016"> <input type="text" name="ContactType" value="Telephone"> <input type="text" name="AppealId" value="RAP617VV">
Customer Portal Login page redirect to open in new page
Hi, I want to use Zoho Creator's Customer Portal embedded in my WP website. Unfortunately Iframed embedded login page redirect to open portal in new portal page instead of Iframe. I discussed that with Zoho Customer Representative and learn that is a default action. Any idea, work around tips to force the page open in my WP page? thanks
Finish implementing the Users Field, or allow fetching from Users database.
It's annoying how such a crucial feature ends up being utterly useless and wasting me hours as I'm trying to figure out how to get the Email ID from the user I've selected within a Users Field. This field's only purpose as of now is to assign a record's owner name automatically as the user name of the user chosen from that field OR to do logic-defying assignments involving comparisons between zoho.loginuser and other such internal values from the application. However, there is absolutely, AB-SO-LU-TELY
Backup Issue
I can't backup my DB of creator with my enterprise account backend 07-Sep-2015 04:28 Onetime backup failed Error occured backend 07-Sep-2015 04:28 Onetime backup started
Give a scroll bar to a text field in a view?
Hi, I have a text field for notes in my form/view. When there's a lot of text entered into it, the row becomes quite high of course. Is there any possibility to provide the field with a vertical scroll bar or at least to limit the height in the view? Thank you. Jens
Charts and Graphs not forming after a certain date
I've created an application, regarding booking and collection in taxi services, I generated some reports too, but after a certain date i.e. 13th October the charts and graphs stopped taking data from the reports. And posing difficulty for us in analyzing the data. Pls. tell what might have gone wrong.
MS Word Plugin
Hi there I have installed the MS Word Plugin, and can sign in and setup my document with relevant merge fields - no problems there. When I select the records to merge, and then click merge, nothing happens. Does anyone have any suggestions? Cheers Aaron
BIGINT bug?
This is a part of my code : context is on add row row.Four=2938232000000091051; (this is BIGINT) it's WORK BUT WITH THIS Variable1 = input.Choix; (this is BIGINT) row.Four=Variable1; (this is BIGINT) THERE IS A BUG ? Thank you^^
API call
Hi, I'm new to Zoho and I'm a little confused. I have been asked to implement something that selects data out of our DB and adds record into Zoho. I am looking at the documentation and I'm just not getting it. I was wondering if someone could explain something to me. As I said, I am writing my script in Perl that will be cron'd that will submit records in real time. The documentation states I create a form using <form method="POST" action="the url" etc <input type="text" name="colname" value ="Me">
Zoho improvements
Zoho is fantastic. I think it could become perfect if anyone reach these features: treeview google maps or other maps integration I hope, thanks!
Trying to create a stateless search form
I'm trying to create a stateless search form with the instructions on this help page: https://www.zoho.com/creator/help/application/search-interface.html I'm not able to completely follow it though because it uses the code example from the old employee management app: https://creator.zoho.com/sampleapps/employee-manager/#Page:Dashboard I can't add that app anymore to my account and see the original code. The help article only has snippets. This is a frustrating thing in general that much of the help
How to track changes in report / summary data over time?
Hello, Zoho Creator Forum, Consider the following: Let us say I have an application that tracks my inventory of tasty fruit. I have a Data Form called Fruits, which has a Type field (Apples, Oranges), and a Status field (Unripe, Ripe, Rotten). Each individual fruit is a row in the table created by this Data Form. I would like to see at a glance how many of each type of fruit I have, and what proportion of them are in what status. To this end, I have created a PIVOTCHART, which displays a stacked
Rest API Help
Hello I have just started working on a portal to add records to Zoho Creator. I have successfully added records, however the page automatically downloads a json file with the data I posted. How can I stop this from happening?
How to Use a Custom Action to Invoke a Function to Send SMS/Email to Users selected in a report?
Hi Everyone, I would love some help with the logic on how to accomplish sending SMS/Email to many users selected in a report, then using a custom action to invoke a function. Here is what I have: My Report: As you can see I have many "Users" (Email, phone etc.) for each row. When I create the custom action I cannot pass the ID of the user, instead I am limited to only pass the ID of the "Delivery Location". Question #1: How do I create a "for each" loop that gets the ID's of the users after passing
Problem with purchase to Zohocrm from Creator
Hello all, i have a code to create a purchase order in zoho, work in generally fine, create the PO in zoho, but dont add the product detail.. i dont know what is the problem, if i dont send all data requirement or is a wrong format.. respuestaPO = zoho.crm.create("Purchaseorders",{ "Subject" : (("" + infoso.get("Numero de orden de venta")) + " t4 ") + infoso.get("Subject"), "Status" : "Created", "Vendor Name" : "" + infoso.get("VENDORID"), "Orden de Venta_ID" : "" + infoso.get("SALESORDERID"), "line_items"
Copying value of image field to another image field creates a broken link
I have a form that has five visible image fields and three hidden image fields. There are five check boxes that are used to select up to three of the five photos to be displayed in the report. In the OnSuccess action I have the following code: input.Hidden_Report_Image_1 = null; input.Hidden_Report_Image_2 = null; input.Hidden_Report_Image_3 = null; if (input.Include_Image_1_In_Final_Report) { input.Hidden_Report_Image_1 = input.Image_1; } if (input.Include_Image_2_In_Final_Report) { if (input.Hidden_Report_Image_1
Sync Google Contacts with Contacts in Creator
Is there a way to sync my contacts from in my creator app with my google contacts? Is coding with APIs the only way? I know some deluge but don't understand how to use the APIs.
Zoho Creator Portal App
Has anyone been able to use the Zoho Creator Portal mobile app? I had come to two types of error. Invalid_Request and Network Error. I had tried with different active customer portal users and different devices but sadly it happens the same. Im really looking forward to use this great functionality. Thanks in advance
Create multiple events concurrently
Hi, Any idea how can I program to create multiple events at one shot at fixed intervals, instead of creating one after another. Such that, the form allows users to select the frequency of the event (E.g. Daily, Weekly) and the number occurrence (E.g. span of 8 weeks). Gerald Lim.
Account moved to trash
Hi In some reports the account name appears duplicated. I have sent to trash one of them ti items and the account has disappeared.(both) How can I recover the account from the trash ?? I cont' see the Trash Thanks JM
Subform too large for main form
My Sub form is very large 30+ fields and my problem is that this is unusable in the horizontal sub form view and would ideally need to be opened in a popup window so that it can be worked on via an ipad etc. Has anyone else had and/or solved this problem?
Need a Zoho integration consultant in Los Angeles.
Anybody know of anyone? There are many on UpWork.com but I would prefer connecting through an introduction. Thanks! David
Request: In the Reports UI for User ad-hoc searches: support boolean logic within a column and between columns (ideally via Criteria builder?)
This is a common wish for us, and I see that this is has been requested multiple times. We see that we could build something of the sort using a stateless form with results shown on an HTML page. Yet... MUCH more powerful would be to support it in the native reports UI . This way, the user may have more flexible ad-hoc options in the search, and most importantly: when results are delivered, the user has all the controls of the standard UI vs. html list. NOTE that the Global search is not sufficient
Next Page