Number format
Hi, I need check if people insert in correct format a number in text field: 123.456.789-00. With the below script ON INPUT of the FIELD I do it with success. I also need to check that people insert 11 characters not less (up to 14), because with this wrong behaviour script return an error. Any suggestion? Thanks Mic if (input.FIELD != "") { FIELDFormat = (input.FIELD).replaceAll("^[0-9]{3}.[0-9]{3}.[0-9]{3}-[0-9]{2}","correct"); tFIELD = (((((((input.FIELD ).subString(0,3)) + ".") + (input.FIELD ).subString(3,6))
Functions for faster accessing to application items
Hello I have applications with a great number of forms, reports, pages and so on (for example, in one app: 83 forms & 535 reports, 111 HTML pages, 715 deluge functions in workflow tab) I want to fast acces to: last modified elements (Forms, Reports, HTML-pages) - actually - very often it's hard to remember the name of report, you have worked on 3 days ago or name of the test function you use to make some changes in database and so on Please....... 1. add SORT BY LAST CHANGES link which will show
help with date
Hi Simple request I think This_is_the_Date_field 25/6/2014 What_is_the_Month 6 What code do I use to return the month only in my second field Thanks
Validate multiple fields.
Hi, Is it possible to validate multiple fields in a form to make sure that data is unique? I want to count the records and if fields StarDate & Location & Employee are already present in that certain combination, Cancel form submission. Iif(count(WorkSched[StartDate=input.StartDate&Location=input.location & Employee_Name == input.Employee_Name]) > 0) { alert (("StartDate, Location and Employee_name already exists")); cancel submit; } Thank you.
Slow access in China
I have a collaboration tool developed in Zoho Creator. People in the US/Canada and China are accessing it. People in Zhejiang, China, today told me that the access is very very slow, unbearable so they can't do their job. Is there a way we can go around this? The same people in the same location used to access Zoho Creator with decent speed. Thanks.
Attachment via subform
How can I send an email notification via a sub form attachment? Any assistance in this matter would be greatly appreciated.
REST API response speed
Hi ! I think that something wrong going with REST API. I testing 2 different way of fetching data from Creator. 1. REST API GET https://creator.zoho.com/api/json/<application name>/view/<view name> (with credentials) response time - 390ms 2. GET https://creatorexport.zoho.com/showJson.do?sharedBy=<zc_ownername>&appLinkName=<application name>&viewLinkName=<view name>&privatelink=<privat key> (privat key is part of url for public link) response time - 160ms note 2-nd way is undocumented ... but more
Import form and subform data in zoho creator
Hello Situation There are two forms: Customer Account and Additional Contacts. Customer Account has a subform for additional contacts. However, the additional contacts were added separately before the subform was built. I need to connect up the additional contacts with the appropriate customer account. I have exported the data for both in separate excel sheets. Details The parent Account for a contact can be found by matching the "Ship To numbers" field.
Specified Duration in Success Message Issue
When adding a success message, I noted a new option to specify a duration. I assumed it was in seconds. But the value seems to be ignored. Is this a beta-feature? John M. Whitney
Dynamic picklist
Hi guys, I want to add a criteria that remove Staff that have more than 10 Service record from Staff lookup picklist field in FormA. At the moment I have script that filter Staff for Services offered. Is possible to add also this criteria? I try with IF and FOR EACH without success. Thanks for any help. Mike stafflist = (FormB[(Service == input.Service && Status == "Active")].ID).getall(); Staff:ui.add(stafflist);
Testing Environment
Does anyone have any suggestions regarding how to setup a Testing environment for Zoho Apps. I know you can copy an application, but the data is stripped out. How do others test and roll out changes?
Dynamic picklist
Hi guys, I want to add a criteria that remove Staff that have more than 10 Service record from Staff lookup picklist field in FormA. At the moment I have script that filter Staff for Services offered. Is possible to add also this criteria? I try with IF and FOR EACH without success. Thanks for any help. Mike Copy code Copy code stafflist = (FormB[(Service == input.Service && Status == "Active")].ID).getall(); Staff:ui.add(stafflist);
Incorrect username or password in Migration tool
I keep on getting the error in the Access migration tool that says that I am typing in an incorrect username or password. As far as I can tell though, they are correct. I usually use my google account to sign in though, so there is a possibility the username I am using is incorrect. Is there a way to find the username that I am supposed to use in the tool? Any help would be greatly appreciated.
Questions | Zoho Creator
Hi Team, I have a few questions for you: 1. Similar to Zoho CRM Mail Add-on: How can we have a similar solution for Zoho Creator App so that all inbound and outbound emails can be tracked from inside the Zoho Creator App against the relevant Contacts (Note: "Contacts" will be a custom module inside Z Creator)? 2. We have created a Quote Template inside Zoho Creator. Now through a "Send Email" custom function we want to send that Quote as a PDF attachment to a contact. Is that something we can achieve
Fetch with two form criteria
Hi guys, a fetch question are drive me crazy. I need fetch data in FormA with some criteria from both form (A and B). I try with list or variable without success. Anyone have a idea how develop it? Thanks for any help. Mike Stafflist = (FormA[((Day = input.Day && Staff = input.Staff) && Availability(FormA) <= input.Availibility(FormB)].ID).getall(); Staff:ui.add(Stafflist);
Help with some code Please
Hi, Could someone please tell me what is wrong with this code... myUrl1 = ((("https://creatorexport.zoho.com/" + zoho.adminuser) + "/") + zoho.appname) + "/print/"; rec = input.Job_Number; myUrl3 = "/fame=" + rec.ID; myUrl = myUrl1 + "Invoice" + myUrl3; openUrl(myUrl, "new window"); It is in the app new starlight digital which I have enabled for you if you need it. I have a feeling I have done the rec variable wrong but I am not sure. The code is attached to the action on user input of the print
Q: How to create Unique Index by combing two or more form field together ?
I know ZC only allows only one field in making unique index. Through deluge script, you can combine two or more fields in submit action to restrict dupplication. I know and did the same, but it worked partially for me. My issue is - as ZC consider lower and upper case separately, it allows duplicate entry when the data entered differently mixing lower and upper case though spelling remains the same. I tried upper function in my deluge script, still it didn't worked properly. It only works when
Q: How to customize ZC form field positions and style as required.
1. I am trying to develop an application whose one of the form would be like: 2. I set the form as Two column wide. Lower section contains the sub-form which may be extended many many lines as more and more product variation is added. 3. Accordingly this form may need to be extended multiple screen down, which means Submit button will be placed in a place which will not be convenient and user friendly. 4. Unlike ZC default CSS settings, to make the application more user friendly I want to customize
Radio button add date
Is there a way to automatically add & display the date, in line, when a radio button is checked. My example is in an application for construction progress. I have a check box radio button for when the rough in wiring is complete. I would like to show the date when the box is checked so I know when the work was completed. thanks
Help newby question
Help sometime when I log in I can't access my email account it just goes straight to home page and then i'm stuck, I have to log out and wait a few hours then try again and i go straight to my emails why? what happening. thanks for any replies.
Complex count
Hi guys, I want to count all availibility for staff member filtered for specific service. I try with: input.Avalaibility = FormA[Day= input.Day && Staff.Availaibility in stafflist].count(); where: Avalaibility - is a field that sum all availibility of staff in the relation STAFF=SERVICES in FORMB. FormA - allow user to choice service for Day and Staff. Staff - filtered field with stafflist and Staff:ui:add(stafflist) stafflist - FormB[Service == input.Service && Status == "Active"].ID).getall();
Deluge guide
Hi, in https://www.zoho.com/creator/help/script/built-in-functions/built-in-function-list-date.html the text refer to boolean and not date. Thanks Mike
Look Up & Complete Fields
I have been trying to figure out how to use the lookup field where once the data is selected other fields from that database are also added. In other words, If I have part #, Part Name, desc & price. If i lookup part number, all other fields for that part will show up with it. Its probably right in front of my face but I cant find it.
How to prevent hackers?
I am publishing two forms and embedding them in my Google Site (soon to be made available to the public). I want to make sure I take all necessary measures to prevent hackers from gaining access to my database. I am concerned that someone could insert HTML or other malicious script into form fields to break in. I considered using getAlphaNumeric() to strip all possible scripts but that would disallow me from using special characters. I noticed that if I try to input the HTML script <br> in the name
how to send a group email?
Hi, I'm not good at sripting. I need to send an email to all customers in my Customers database. How do I do that? Please do not just tell me to use Fetch and Email scripts. Please provide details, as much as possible, best with examples scripts. Thanks
Replace function
I have a field called post code I want to do 2 things 1. If the user inputs the post code as DA81HG or DA116DF I want to convert these to DA8 1HG and DA11 6DF 2. I want to be able to convert DA8 1HG to DA8+1HG for google map purposes. Cheers for any help.
creator formula for lookup value
I am using zoho creator and doing some really cool things with the formulas, one thing i am stuck on in creating a field with a number from data I have added, for example, my input field value would be something like "54" - 1372mm" but i would like a filed to look at this and automatically enter "1.372" also it would need to also be able to convert "30" - 762mm" to give a response of "0.762" ... many thanks for looking at my post :)
get items in a Dropdown as a list
I have a static Dropdown with (say) 5 options: A, B, C, D and E. is there a way to call these options as a list? alert Dropdown ; will only return the selected item ("-Select-"), not all the options. I'd expect that to be the result for (which it also is) alert input.Dropdown; this doesn't work either: alert Picklist.toList(); any suggestions? (I'm hoping to find a way to make a subselection for a list without having to lookups all the time, because this lookup is significantly
Remove all Non-alphanumeric in a String via Regular Expression
I had a need to remove all special characters in a string. Regular expressions saved the day: validation_string = string1.replaceAll("\W|_","",false); Ref: http://stackoverflow.com/questions/3114027/regex-expressions-for-all-non-alphanumeric-symbols Cheers, John Whitney
Data Type in Reports Incorrect
I have some formula fields in my table that when I try to use them in report show up as text so I only get the option to count them rather than sum, count, avg, etc. The formulas work fine and show up properly in the views, but not in the report of the view. I have made http://creator.zoho.com/kavery327/powered-parachute-log-book available to support. In the Report the field Total_Hours is numeric (or should be since it is a formula calculated from numeric data), but shows as text. Any insight would
Rest API delete not supported?
When calling an external API, Zoho Creator lets me do a Post and Get call. But for some reason Delete is not allowed. Is there any way to do a Delete call? (this is NOT RE: the Zoho Creator API - Delete is supported there, but RE calling an external service.)
D.O.B and Age
Does anybody know a way to create an age field that automatically updates based on a date of birth field?
zoho.currentdate
Hi guys, I cannot use the zoho.currentdate to express condition that a service is not available today or in the past. Anyone have found a different solution about? Thanks Mike if (zoho.currentdate >= input.Day) { alert ("Times availables only from " + zoho.currentdate.addBusinessDay(1); }
help with reminder
Can someone help please On a database I have written there is a field that is named tasks. So a task could be {call client at 2.30} How can I set this to popup a reminder on the screen at 2.30 Thanks
[URGENT] Integrate Google Visualization API (charting tools) with ZOHO HTML views
ZC currently doesn't support org chart which I'd like to add to my application. I've searched for other ways to render dynamic org chart and found a Google Visualization API (http://code.google.com/apis/visualization/documentation/gallery/orgchart.html) which can achieve my goal via a few lines of JavaScript. I tried integrating the JavaScript in a ZC HTML view but couldn't get it to work. I found later after reading a couple of posts in the forum that JavaScript is not supported in HTML views.
Word Wrap/Table Width Styles in Creator HTML Pages
What should I add to the css styles of tables in Zoho HTML pages if I want to avoid having the text push the width of the page out to fit everything in one line? I just want to create a table (or div) that keeps the width of everything inside within the width of the page. Below is what I have now, but paragraphs of text in nested tables will push the width out and keep all the text in one line. I don't want to set a specific width, I just want the width of the entire table be at least 500px wide
Zoho Creator Spreadsheet Import defeats me
Dear Zoho folks and support team, why is importing spreadsheet data so elusive ? I thought I'd give your app another try as I am partial to the Zoho approach: I've been a happy subscriber of Zoho Invoice for four years now. One option had been to wrestle with your CRM but I preferred the design and elegance of Creator. Yet I can't import any spreadsheet data at all. I am clearly missing something, but what? I've tried smaller versions of my data with an Excel spreadsheet with just five (5) rows.
Assigning permissions for shared apps and reports
Hi, I need to know how I can assign viewing and editing permissions to those with whom I've shared apps and reports. More specifically, I created a database in Zoho creator, to which all shared users can add records. I would like (1) to have the users be able to view only those records that they've added, and (2) to have certain users be able to edit records, and others not. How can I do this? Thanks, Jeff
Adding ASCII characters to strings
Is there a way to add an ASCII character (e.g. new line = CHR$(10)) to a string? I want to display messages in a multi-line field in a stateless form and I want each element of the message on a new line.
Form object instance: function for pulling data?
For a form-object variable defined for a custom-action , say variable formObjectInstance1 , what system function can I use to pull all data in a form and put the data in an email message? somethine like input.formdata; for formObjectInstance1 it would be something like formObjectInstance1.writeAllFieldValues() ? I have been trying to find such a function/method but could not... can you help ? thanks.
Next Page