Sorting .count() by something other than ID
Hi Guys, Hope you can help as I’ve spent hours on this and still have no solution. I have a picklist in Form A that brings in a number of separate records based on Form B depending upon their particular status. These records are then selected in the Form A picklist and when submitted they are given a reference number from 1 to however many records are selected which populates a field back in Form B. This is all working great apart from one thing. When the records are counted using the .count() function
Need better explanation of Usage Limits on Deluge Statements, and options
I've written an HTML View to display daily timelines for staffing for an client organization. To do so requires iterating through a loop for each half-hour of the day for several employees, with the scheduled staff times coming from a Creator form. But if I try to display more than one day of staffing, I get the following message when the application is run: Following the link leads to this extraordinarily unuseful information: The information above is not only confusing and impossible to monitor
subString Function Error
I am trying to get a part of a field using substring function. But when execute the function, zoho returns an error. My function is void mediodepago.PegaCobro() { RegVisa = FileV [Fecha_de_Proceso == null]; if(RegVisa .count() > 0) { for each Rec in RegVisa { sLinea = Rec.Linea; sFec_Compra = sLinea.subString(71,6); } } } Linea is a Single Line type. The error is Execution Failed Error details: Error occured please contact application owner. Does anyone know what´s wrong in my function?
Copy data in same form/record
Once a year, need to move or copy data in one field to another field - same form, same record. Example: Membership form, criteria is [Status1 == "Member"] Last_Year_Paid needs to be updated with value in Current_Year_Paid Want to do this to all forms with the criteria of Status1 == "Member" Any help with a scheduled (01/01/2016, 6:00 a.m.) script in Workflow? Thanks, Stephen J Voss Houston Outdoor Group
Subform row change event
Hi all, i know there is a event for "On Delete Row" for each field in the subform. This event seems to get executed in real time as the user interacts with the form. What I'm looking for is the event when the user finishes changing the subform and hit "Submit" on the main form. That's when data gets persisted for the subform, correct? At that point, i want to compare the previous subform content and the new subform content and send out an email about the changes. Is this possible? If not, any workaround?
Barcode scanning with mobile app
Is there any way to use the zcreator mobile app to scan a barcode? Thanks
variable just bring me a value on user input action
Hello, i try to find the error in this code, but i give up.. i have this in a user input action: sum = 0; for each s in input.invoices { search_invoices_mount = Ingreso_de_Facturas [dato == s]; sum = (sum + ceil(search_invoices_mount.Monto_total_US)); } traeinfocanal = Ingreso_de_Clientes [Canal == input.Cliente]; traeinfocanal.Cartera = (traeinfocanal.Cartera - suma); works fine, but if i cut and paste this in form action, on success, dont work, show me the log Error evaluating
Add sum to form from numeric fields on other forms
Hi. I have a form called "Properties" where I add info about work sites. I have a second form called "Building Section" related to the "Properties" form by a lookup based on the property name. For each property there are several build section records. On the building section records I have a currency field for annual repair budgets for each section. What I want to do is to add a currency filed to the "Properties" form and show a total repair budget based on the total sum from all building sections.
HTML Report filtering
Hi, If I have 10 different reports and all of them have the customer name in common, how can I create a dropdown on the HTML page that displays all the different reports? The dropdown contains the customer name (lookup). Is there a better way of doing this? The goal is to see all the reports on one page, but filtered out for each customer. /V
Copying string values between the same field in succeeding row?
In a subform, how do I copy string values between the same field in succeeding row? Sound simple but has me stumped...help thanks Larry
ZOHO AppBox?
Can anyone shed any light on this app and what it offers? https://play.google.com/store/apps/details?id=com.zoho.zohobox https://itunes.apple.com/in/app/zoho-appbox/id968411132?mt=8 This seems like something I can use based on the reviews but I cant find documentation anywhere.
Converting Excel Formula
Hi Team, I am struggling to get a conversion of the following Excel formula to work correctly and wondered if someone could offer some advice. = IF ( G8 = 0 , 0 , IF ( AND ( G8 > 0 , G8 <= 5.3 ) , 12 , IF ( AND ( G8 > 5.3 , G8 <= 9.3 ) , 16 , IF ( AND ( G8 > 9.3 , G8 <= 17.3 ) , 24 , IF ( AND ( G8 > 17.3 , G8 <= 21.5 ) , 32 , IF ( AND ( G8 > 21.5 , G8 <= 33.5 ) , 44 , IF ( AND ( G8 > 33.5 , G8 <= 45.5 ) , 56 , "CANT DO" ) ) ) ) ) ) ) G8 is replaced with my field named B0 = IF ( B0 = 0 , 0 , IF (
Is it possible to add webhook in zoho creator
Hello there, Whenever data is inserted or updated in zoho creator, I want Zoho will send me notification to my applications URL endpoint. Is it possible to set webhook in Zoho creator, so my custom application will get notified each time new records inserted in Zoho creator?
Parsing string from integration
Hi all, I'm working with ecwid.com an eCom site that formats their data in the following way: [u'Desired Date', u'Desired Time', u'Sqft', u'Address Line 1', u'Address Line 2 (Optional)', u'City', u'State', u'Additional Spaces*', u'Access Instruction (ie. meet agent or combo code)'],[u'Domain Choice 1 (123Main.com)', u'Domain Choice 2 (123MainSt.com)'] If I parse it manually, I would get the following structure: [ u'Desired Date', u'Desired Time', u'Sqft', u'Address Line
Auto update
I have created a field that reports the number of days between a date field and the current date. How can I get this value updated automatically each day to reflect the change in current date? Thanks, Martyn
Unable to download zar
I took the zoho training that was done in Atlanta. When I am in Creator and I attempt to download a solution all I get is 3 dots on my screen (see attached file). Is there someone in the US who can help me ? Hal
Push CRM Data to Creator
I have customers and prospects in Zoho CRM. I have a Zoho Creator app for sales and servicing in my business - when taking an order, I want to retrieve the customer info from CRM. No problem using Creator's CRM Lookup type field EXCEPT that I have three users of my app who are shared users. They do not see my Contacts because they are not signed in as me. I'm told I have to use workflow and APIs to send the contact data from CRM to a form in my Creator app and then do the lookup via the data in
HTML Link with parameter variable
Hello All: I am starting to develop a HTML page for a dashboard. I am completely new to HTML but it has gone well so far. I ran into an issue when trying to insert a HTML link to a report that I want to pass a filter parameter to. I am able to make the link work if I set the parameter equal to a value but cannot get it to work when trying to use a variable so the link adjusts based upon the information on the HTML page. Here is the code for the link that works when I set <Job_Number>=851005.
Sending from Users email addresses
Hi, In an application I'm working on I find it necessary to send an email from an email address other than zoho.adminuserid. Is it possible to use an email address of a User who is not currently logged in? Thanks, Damien Cregan Hire an Expert
Deluge script code view line length limit?
Dear Zoho Creator Team, I was coding a sendmail for deletion of a record in our new module. However, I ran in to a line length limit issue. Question: #1. Is there a way to force a new line in the deluge code. ( I'm not referring to "\n" or "<br>" ) I'm talking about forcing a new line in the code editor? The reason I bring this up is because the form has around 90 fields of data. I wanted to send this data to the admin if it were deleted as a backup just in case. So, I concatenated the code in the
Embed form or report in website problem with mobile
Hi. I'm attempting to embed a form in a website. The website has both desktop and mobile versions. When I open in mobile version the embedded form/report displays as the desktop version. Anyway to get the mobile version? Thanks Arlan
E-Mail data not working
Hi, I try to send email data to my form. I copied the template data and send it from a registered email account as plain text. I get no corfirmation or error. Also in the logs there is no entry. Seding the same from a not authorized account will give me an error mail back and also an entry in the email log. What can be wrong? Regards, Marco
Is this even possible with Zoho? - Pull data from one site with their API then push orders to another with their API
Hello, I've been trying to learn Zoho, but before I get too far I'm wondering if any gurus can tell me if this is even possible? Basically I'd like to connect into the Etsy API and import my orders and customer information then I'd like to use that data to create corresponding dropship orders on Shapeways with their order API. Can Zoho both pull in data from one site, allow minor manipulation and then push it back to another website? Thanks in advance, just want to make sure it's worth my effort
Error: Unable to update Template Variable
Hi - I have been using the following code for over 12 months User_Email=zoho.loginuserid; crmContactMatches = zoho.crm.searchRecordsByPDC("Contacts","email",User_Email); alert (crmContactMatches); for each contact in crmContactMatches { accId=(contact.get("ACCOUNTID")).toLong(); accountResp = zoho.crm.getRecordById(("Accounts"),accId); System=(accountResp).get(("Parent Account")); siteResp=(accountResp).get(("Account Name")); facilityResp=(accountResp).get(("Account Site")); Site:ui.add(siteResp);
Amazon SES + ZOHO Creator: Now Live
This is a continuation of my effort to use ZOHO Creator as the front-end interface to Amazon Simple Email Service. I had posted an update to this recently, but removed the post due to a sign-up issue. The issue is fixed and the whole application is working! This really stretched my abilities as a programmer and I'm happy with the results. I invite you to sign-up as a subscriber and help me test the application. https://creator.zoho.com/niskypto/cloudmail# Note: When you get to the subscriber profile
Restriction on entering duplicate data already existing in an excel spreadsheet. ie. checking a spreadsheet for duplicates before accepting a lead.
I need to create a form that, 1. Does not allow a list of numbers to be entered. ('Does not equal' query is not possible since list is very long). 2. Gives a warning message whenever such number (existing in spreadsheet) is filled in a field. 3. Fails submission of form containing such number (existing in spreadsheet). Is it possible to do in zoho forms?
How do I get the developer version?
I already have and account and I've applied for the developer certification program. When I try and sign up for the developer version of creator, i get an error that I already have an account. How can I upgrade to the developer version?
File upload problems with IE10
Within the last 14 days we have started receiving calls from users who say that they can't upload files anymore in Zoho Creator. It gets to the "Please Wait" message and then just hangs. On checking, we have found that each and every person having this problem is using IE10. They're from different companies, with different network setups, but all have the same browser and version. Interestingly, if they use Firefox or Chrome it works. Anyone else finding this, and if so any bright ideas for a work
Can you set up a form to send payments?
Hi, I know it's possible to set up a form to receive payments by going into settings and enabling payments. I also noticed you can have the amount, item, and quantity fields dictated by fields within the form. However, is it possible to have the "Paypal email id" field dictated by a field as well? I want to create a form to be able to send payments to customers rather than receiving them, and to be able to change the paypal email id through the form rather than having to go through the settings for
How to read my full name from the API
I'm using Zoho API in my application. Users are getting access tokens by providing their email and password. Everything works great. I'd like to improve my GUI and display user's full name. Currently, after successful authentication, I'm showing them the email. Is there any method in Creator CRM API or general API to get user's full name?
import links
I know this has been asked before but i wish somebody would explain step by step. When you import data from crm you get form ID which is the unique link back to say and account or customer. In my case service history linked to customers. When i import this data i am stuck with a customer id number. What is the technique to change this to the correct linking info back to the crm. Please could somebody do a video or explain simply for some of us who would like to learn.
Only show records being sought.
I want to know whether a view can make the record only appears if searching for the ID number,but if you do not want any record, appears completely blank list.
Two Field Layout option for Desktop and Mobile. I.E. 2 column layout
For example, If you make an app that has a two column layout used with a PC/MAC and the left column field is relative to right column field. I.E. The Contact and the Event Date and Time. If you view this form in the mobile app version the right column fields are placed below the complete left column data fields. So, the form doesn't make as much sense on the mobile app. Granted If I move this to a one column layout it would fix the issue for mobile but would make this a scrolling nightmare on PC/MAC.
Custom actions on a published report
Hi I have a publicly available table report with a custom action which opens a summary report. The summary report has all navigation and functions turned off. The issue I have is that the summary report only displays the last record, not the summary linked to the record which was selected. I tried using the advice in this discussion thread: https://help.zoho.com/portal/en/community/topic/how-to-define-openurl-function-with-id-of-current-record But the person clicking on the custom action needs to
Limit exceeded
Hi, I'm getting the below error while updating one of my record. Record ID No: 190193000013538102 Form url: https://creator.zoho.com/piju2111/penta-crm-15/#Form:To_Do_Form Error Message: The number of deluge statement execution limit exceeded the maximum limit. Solutions tried: Tried using different variable (input3. ), getting same error. Note: I have given access to support to solve the issue. Thanks
How to Allow user to dynmacly create options in a checkbox field?
I'm using customer portal and have many people log in and access form. I want them to be able to set what the options are for a checkbox field. Then when they come back to that form and use it later it will have their options in the checkbox field. How would I do this? Thanks Scott
Same display of radio buttons for creating and updating a record
I'm new to Zoho. Loving the platform, especially Deluge scripting and HTML. I'm trying to collect responses to a long list of questions from my users, like a survey. The questions (400) come from a table. The answers are all yes/no. The plan is to present the questions in categories. A user will click on a category and see the question from that category. This part seems easy to do using an HTML page. My problem is that I can't find an easy way for users to see checkbox or radio button controls in-line
Does the Ctrl+F not work?
Dear All, Does the Ctrl+F (search) not work inside the editor? Or maybe is my browser issue 2 days now? I tried with IE, Mozilla, Chrome but it does not work. Do you face same issues with me?
Test
@rubenIMC @tpacurtis Hi, We depend on browsers; not OS. Please let me know the browser you use We support Chrome, Safari, IE and FireFox @zohocreator
Im sure this will be simple for most but i just cant work it out. please help
All i want to do is have a form where people fill out, name, age and email address, after that it takes them to pay via paypal and i am notified of payment with their linked information so that i know who has payed and what email address is linked to that payment so that i can then send through the requested info. or even better, is it possible for people to gain access to a page on my site only once they have paid and they can continue to have access for say 24 hours but then thats it? i assume
Next Page