Zoho CRM field in Native Mobile App
I realise that forms using the Zoho CRM field aren't available in the Native Mobile App. I am curious if this is because of a platform constraint on the Native Mobile version or will we see this in future? I am developing an app that requires CRM contact data and know that I can code a method to pull down contacts that meet criteria x and populate a dropbox with them, but its not as clean. Really hoping we will be able to use the CRM lookup field on Native Mobile at some point... Thanks, Mark
Filter a subform?
Is there a way to filter a subform. Perhaps if row.field = "Inactive" { hide row }
Error in executing zoho.invoice.createinvoice task
Hi Team I have been using a Zoho Creator to Zoho Invoice creation task for several months. Today it stopped working. The error it produces is this: Error details: Error in executing On Add - On Success script. Error. Error in executing Set Variable task. Unable to update template variable invResp. Error evaluating MAP expression : Error in executing zoho.invoice.createinvoice task : Error.. Here is the code that I am using to create the invoice.. .Can anyone please tell me what is wrong with
Need Help
I am farelt new to Zoho creator and had schooling on Microsoft Access, but it has been years since I did any coding and this is almost a different way of coding. It just seems I just can't get it right on this. Here is a draft of what im trying to do: If Company_Name = "Company" { Labor_Total = Labor_Hours * 60 } { Else Labor_Total = Labor_Hours * 70 } Note: -The Company_Name is a dropbox...would I need to give the comapny I put in there a value and if yes how? -Labor_Total is a currency
Formula field
I'm new to ZC and am hoping there is an easy answer here. I created a form where people are rated "evident", "emerging" or "not evident" on a list of competencies. Each competency is a different field and they rating is selected using a radio button. I am trying to create reports on how many evident / emerging / not evident ratings were assigned and am struggling to find the solution. I am trying to use a formula field to sum the number of each rating on the form and am struggling. I also tried using
Default value for related drop down
Hello, I have a related field that contains a list of employees and is displayed as a drop down in a form. I need to set a default value for this drop down, how can I do that? This value depends on the logged user, if this user is listed on that drop down I have to set it as the default value, how can I achieved this? Thanks!
Drop Down field looses it auto complete function when populated from a list.
I have a drop down field that i populate from a list. The list is created then sorted into alphabetical order and placed into the drop down field. Once I do this the list is correct, but the drop down field loosed its auto complete function. How can I maintain this feature as it is very useful to the end users.
Schedule limit
What does this mean please You have reached the maximum Schedule limit permitted for this account. Please upgrade to add more. Thanks
Send entire form to external site
I want to submit my entire form to an external site to be processed. I see that there is a deluge function, post Url. When I try to set up the function, I don't see an option to send the entire form, only a single field. Is there a way to send entire form?
Retrieve the data from another form
Hi, I have a application in Zoho creator which consist of three form -- Market , TV Station , Census Market form has two field : Market Name ; Market_id ; Census form has three field below: Market Name ( look up from Market form) , Market_id ( lookup from Market form) Households Value . TV Station Form : This form has three fields below TV station Name Market (lookup from Market Form) Households What I need to do is when user select Market from drop down then a script will run and fill the
Field Filter not working after variable assignment script
I have a lookup field with a filter added. When I choose a value in a different field, deluge script assigns a value to the field that is indicated in the filter, but the filter does not execute. If I manually select the Value in the field, then the filter works. I also have a script that runs on user input to that same field in which the filter is dependent "GHS Co". and that script runs when GHS Co is autofilled. The filter is not added via script, it is added in the field settings.... so
All Zoho creator applications are missing.
For our Zoho account caluganda, all of our creator applications are missing. When we sign in with any of our user ids/passwords no applications show up. We created several applications and they are all gone. We need them restored as soon as possible and we need to know what the problem is. Why are they missing in the first place??? Jim K.
Barcode scan
Is it possible to achieve the following? I want to add some barcodes in the windows applications. This barcode should be displayed when I click a button. I am new to this and wondering if someone could help. If some sample code will be great！
Add Button to a Page
I have a Page which pulls and summarises data. At the bottom of the page I would like a button which once the user is happy the summary is correct can click to load data into ZCRM. I have created the data load to ZCRM using a button on a stateless form but would like to do it from a Page. Is this possible? Thanks Gordon
Import Dropdown choices
Hi, sorry if this question is answered, but I didn't find it. How can I import all choices of a dropdown field? For example, if I have a list of countries, how can I import this list to a dropdown field to be selected in a form? Thanks in advance!
Unable to Set Access Permissions for Fields
I am not able to set or edit the Filed Permissions for all the profiles. This issue had started two days ago.
I have set a scheduled email for a specific date, tried to execute but I get an error, what am I missing?
The error message is Execution Failed Error details: Error in executing form schedule(Form Schedule). Error. Error in executing Send Mail task. To Address is NULL. The function is below SendMail [ From : zoho.adminuserid To : input.email Subject : "Subscription update" Message : "Hi " + input.First_name + "<br />\n<br />\nJust a quick not to say your subscription is coming to an end and wanted to check that you still need access to the proxy server<br />\n<br />\nRegards<br
First line of code gives error
I have used this code for 3 years and now it gives an error If(input.Owner_Offering_Trade == "Keith”) Error when I try to edit: Error at line number : 1 Improper Statement Error might be due to missing ';' at end of the line or incomplete expression What do i do?
<enter> key for "add new" in subform
Hi, I have a subform that records bin weights for harvested grapes for each of my growers. I can receive 30 to 50 bins at a time. I would like to use the <enter> key on my keyboard to add a new row instead of having to click on the "add new" button. I would be grateful for any advice on how to do this. Best regards, Jeff
Invoice with Multiple Lines
Hi, I'm working on a project where I'll have vendors across the country that will collect orders and payments for me. They will pay me the total payment less commission that we agree upon. I will grant them access on Zoho Creator - Customer portal where they can keep track of the orders they submit to me. For each vendor, I want to export all the orders they submit (on a given period) to Zoho books and prepare an invoice. I've just tested the export feature from Zoho Creator to Zoho Books and it
Copy Record only once
Hi, I've been testing the script below on copying records to another form: void copyRecord(string Name, int Phone, string Email) { insert into Clients [ Email = input.Email Name = input.Name Phone = input.Phone Added_User = zoho.loginuser ] } I noticed that this script allows you to copy the same record more than once into another form. I want to only copy a record only once. How can I modify this script (or another script) so that once a record is copied into another form by executing this script,
Go to URL after form
From a list view, I have a custom action which leads to a form: void Company.AddCalendarEvents(int CoID) { openUrl("#Form:Calendar?Company=" + input.CoID + "", "same window"); } Once I enter values, and hit submit, the form re-loads, but it's not useful to me as the Company Value is not pre-loaded. I would like to either: - have the form reload with the same CoID value OR - re-direct to a different url what do I do?
Can you filter a subform based on a data in the main form?
Can you filter a subform based on a data in the main form? Example I have an employee Data Form and an Employee Time form (for time entry) Can I add the Employee Time as a subform to the employee Data form and only show the time records for that employee? does this make sense?
Creator form code to embed on webpage (not iframe)
Is there a way to get the html / java / whatever code of a creator form so I can put it on my webpage? The iframe embed code does not work for me as i need to be able to add my own css to the form. I need to be able to manipulate the way the form is displayed beyond what you can do in creator. If i could get the source like you can for a CRM form i should be ok. My main problem is i need to put the form at the bottom of the page and the drop down menu from the search form field appears below the
Using ZCStyles
Hi I found this application called ZCStyles (https://creator.zoho.com/public/showAppInfo?ownername=srhyne&callbackUrl=zcstyles) and tried using it. But, noticed that the <style type="text/css"> tags got wiped the next time I opened the note. Maybe that's a bug? Could you please guide a little how to use this application? Could you please guide on changing the theme of my application? I have my own theme and want to customize the application's look and feel.
quote a column in HTML hyperlink
Here's a part of my code below, <p align="middle"> <a href="<%=y.Map_Link1%>"> <%=y.Name%> </a> </p> <p align="middle"><%=y.Map%></p>An example of expected output, two lines for each of the record, both contains hyperlink XXX school (name ONLY) XXX school map Map_Link1 is a column in my form contains all the Google Map addresses for each of the schools. I don't know what to change in order to make the href part to work. Here's a wrong output I have. 75th Street Elementary
File uploader tool has stopped working
I can no longer access any of my Zoho accounts through the File Uploader tool. Do you know any possible reason for this? Earlier it was working but now i am not able to login into it. Your team has suggested us this tool to bulk uplaod the files from the hard drive via an exe file. You have provided the below given link to us to download it :- http://code.google.com/p/zohoclient/downloads/detail?name=FileUploader.exe&can=2&q=
Problem Setting the Field Permissions
I am a Zoho Creator Enterprise subscriber. For the last two days, I was not able to set or edit the filed permissions for all the profiles. Does anyone also has this problem?
Error while summing rows in subform
Hi, I have a subform called Bin_Weights. I am using the following code to calculate the total net weight: temptotalB = 0; for each record in Bin_Weights { record.Sub_Total = record.Net_Bin_Weight; temptotalB = (temptotalB + record.Sub_Total); } input.Total_Net_Weight = temptotalB; The script saves but has the following errors when I run it: Error details: Error in executing On Add Row script of Bin ID. Error. Error in executing For Each Record task. Error in executing Set Variable task.
All Requests report wrong HTML
As you can see from the attached picture the issue I'm experiencing has something to do with HTML escapes. It seems Zoho sends HTML link code (subject column) with < and > instead of < and >. This leads the code to be incorrectly interpreted by the web browser as plain text instead of HTML. Any advice to resolve this issue? Thanks, Marco
How to set up a detail Records Count?
I need a quick report of how many records per form I have in database. How do I set this up?
Best way to create Master-Detail Forms / Sub-Forms
What is the best way to create a master - detail form when a master has multiple sub-forms where each sub-form needs to be entered and maintained by a different role 1. Create a master form and then in the master form add sub-forms. Assign access rights for each sub-form based on roles. I guess in the form entry and the form report view this will show only those sub-forms assigned to a particular role when they are viewing it. Also in the Record View it lets you select the sub-forms to be added to
Accessing text of lookup field record rather than record ID
I've been working for several hours on trying to retrieve the String value of a record that I am accessing via a lookup field, but I cannot seem to figure out how to do it. Here is the script I'm using: RepresentativeItems = (Products1[Representative == input.Representative1.toString()].ID).getall(); Basically I want to be able to populate a subform with all of the product sales by a representative, which I will select from a drop-down list, as you can see in this photo: My problem is that when a
Call Function with CRM
We have a "Product List" app in ZCreator and when we add/edit/delete a line is this app we want this data to push to "Products" module in CRM. I seem to have configured this correctly other than on edit and delete I can not access the unit price field because it is not a string field. I have been editing the app and On Edit -> On Success -> Call Function (Integration Task) with CRM -> Update Recod Thanks for any help
Published Report Permissions
Hi, When I set the criteria on my report to.. "Email" == zoho.loginuserid ..it works fine when I access the application, but when I publish the report and access that particular published URL, no records display. However, when I set criteria to.. "Email" == "me@myemail.com" ..all records with "me@myemail.com" are displayed. Why does publishing criteria work for a hard-coded values, but not work for system variables? This seems like a bug..
Error on add row script in subform
Hi, I am using a subform called Order_Details to enter the products and quantities on a Purchase Order form. In order to filter product availability by Supplier, I have written the following script which runs "on add row". itemlist = Winery_Supplies [Contacts == input.Contacts]; clear row.Product; row.Product:ui.append(itemlist.Winery_Product_Name.getall()); The script is filtering the products by supplier in the Product field but the following error appears when a row is added in the subform:
Signature Field
Hi, We have equiped our Sales Team with Android tablets which they use to record site visits. What we would like is a field for customers to sign a free form with their finger or stylus which records their signature in a field as an image for future reference. Is there any way to currently do this or the scope to do it in any future release (if so, any ETA)? Lastly, would be good for paying users to be notified of any issues with the platform currently experienced. This will reduce support cases
Permission Denied To Update Record(s).","code":2897
Using the REST API (I know where the documentation is : (https://www.zoho.com/creator/help/api/rest-api/rest-api-edit-records.html) to try to update a field on a record. Am getting a response with error 2897 - Permission Denied to Update Records. The view has edit permissions already. Here is the request url: https://creator.zoho.com/api/<owner>/json/student-record/view/myob_invoice_line/record/update/?scope=creatorapi&authtoken=<mytoken>&criteria=('ID = 1612333000001258123')&SYNCDATE=20140905Can
Can MS Access 2013 Custom Web Apps Use ZOHO Creator
The "Custom Web App" Template in MS Access 2013 is designed I believe to be "created" on SharePoint or on what MS call the Home365 versions that support (via shrepoint again as I understand it). It would be a good thing but I do not have access to SharePoint of the Home 365 equivalnet. So my question is can I create a MS Access 2013 "custom web app" on my ZOHO account? If so - what would be the general Web Locactin URL/Address ??
For a List type report is there a way to display/print only the totals rows?
For a report type of "list" you can group by certain fields. When you run the report it shows the grouping header row, detail rows and then a totals row. I want to display/print only the group heading and totals rows and not each detail row. Is there a way to hide the detail rows so that only the group header row and totals row displays/prints? For example we have a table that captures payments (receipts) from donors. This table (view) is linked to the donors table. On the donor summary by name
Next Page