Field Action On User Input - requirement for field
Is there a way to check the user's input for a certain field critera? Field value needs to be at least 12 characters long and has to be in alphanumeric format. It can contain special characters. I've been at this for a couple days now. Thank you in advance for any help ... Cheers! Here's what I have so far ... if(input.field.length() <= 11) { alert "Field Entry MUST be at least 12 characters and alphanumeric."; } else { Field_Formatted = input.field; }
Maximum file size can be imported
Hi Good Day, Just like to know the maximum file size in .xls can be imported in in zoho project Best Regards, Harvey Mar Panes
Submit button pinned to screen
It would be nice to have the "Submit" and "Reset" button pinned on the form (i.e. always visible regardless where the user is within the form). Currently I have some forms that are fairly long, and it can be very irritating to have to scroll all the way down to the bottom of them form to click submit, especially when doing a quick edit at the top-most part of the form.
Function Bug: Solved
Is this a bug? I cannot get this function to work. int TEST(int counter) { if(counter == 0) { return counter; } else { counter=counter - 1; thisapp.TEST(counter); } } The error is missing return statement
Convert RTF to string removeing html code
I have a form with a RTF named Comment. The user could enter a lots of text making the view cumbersome. I added a string field called Short_Comment. This field that contains the first 200 characters of the Comment. This makes the View more manageable. However I get html code in the string field. Is there a function that will strip out all of the html code? Herb Wexler
Zoho creator integration with another webservice
Hi guys, i would like to put my app to integrate with one of the delivery service provider. without much knowledge on the API , i am here to seek for help as i cant find much information online. what i want to do is to pump data from Zoho Creator to another webservice called Easyparcel. and i have got the required documentation and API key generated by the Easyparcel. one of the action sample as below <?php $domain = "http://demo.connect.easyparcel.my/?ac="; $action = "EPRateCheckingBulk"; $postparam
Dependant drop down
Hello evryone I have a vehicle data base with year,make and model column approx 7000 vehicles. I would like to set up a form to filter through year make and model. When I select year I only want to see all of the makes available in that year. When I select model I only want to see the vehicle year and make that I specify. I want each drop down to be depenant.
Strange error updating register (problems with map)
Hi All! I'm starting with Zoho creator and handling an strange error here.... Can anyone tell me what i'm doing wrong? >.< Function Parameters : accountId, accountType PORTAL_NAME = "xxxx"; AUTHTOKEN = "xxxxxx"; DEPARTMENT = "xxxxx"; SLA_MAP = Map:String(); SLA_MAP.put("CLIENTE","88184000000020031"); SLA_MAP.put("IMPORTANTE","88184000000020029"); SLA_MAP.put("CLAVE","88184000234882025"); SLA_ID = SLA_MAP.get(accountType); if(!SLA_ID == null) { REQUEST_MAP = Map:String(); REQUEST_MAP.put("associatedSLAIds":
I can't see relationship diagram
I can't see relationship diagram I follow the instructions that appear on: Help > HomeApplication > SettingsManage > developer tools > Relationship diagram > View relationship diagram But I don't find that option, it's much more to make deep basques of data without this tool. This feature is broken ?
Pivot Table Report
Hello, I need to generate a Time Table report as per attached format where the data is lying in Form and Subform. The header information will come from the main form and details will come from the subform. I tried using a Pivot Table but the cell values are count and not the actual entries such as Faculty Name and Subject / Course name. Is there a way to get the actual cell entries rather than some aggregate function. The record summary helps but I am not able to get it in the format I want. Thanks
Creator API limit
Hi, recently we are hitting our API limit regularly and we have paid to increase this a few times now.... i have a script (see below) that is in every form (and also in each page in order to access a view) - we need this as we have many different clients who access the same system and we pre-populate the form with information from CRM and we use this information to also filter data depending on what system and site they belong to when they access a view (fyi - i use the customer portal to control
Using data from different forms to calculate profitability
Dear Zoho Community, I'm really new to Zoho but I'm excited about the world of endless possibilities that it gives me! I will really appreciate any help to guide me! I have Heating and Air Conditioning business and I created an app to get more in control in my business. One thing that I need to accomplish right now is creating a report that would show me profitability of my jobs. To count that I need to pull data from the Job Form which has the price of the job, then deduct the materials logged
CORREOS DESDE CRM A SPAM
Buenas tardes, quisiera preguntar el por que al enviar correos masivos desde ZOHO CRM a contactos estos se marcan como spam? por lo anterior los clientes a los que se les envía el correo electrónico masivo no tienen forma de visualizarlo a menos que se dirijan a la carpeta de spam directamente. de antemano muchas gracias. Quedo atento.
Parsing JSON format responseText - not as easy/clearcut as XML. Does it even work?
The usefulness of JSON is clear in that you can you use key-value pair 'get()' method to retrieve the value of a key...which in theory is a lot easier than used Xpath and XML...but I have found this to be difficult to resolve when using getURL or postURL and I need to parse the responseText that gets sent back. In the case of the example I have dealt with the JSON format data, I think it is sending back a multi-dimensional array of data...and my assumptions about using get(keyname) seem to break
Creating record in Zoho CRM and upload file
Hi, I'm stuck on this issue, and I don't find the problem. i have a Zoho creator form with several fields : This application is linked to Zoho CRM, it creating a ticket in Zoho CRM. Everything works fine, but I can't upload document to Zoho CRM. Here my code : //create the CRM vs Creator fields map to push data to the CRM module. myFieldMap = Map(); //add values to the map. CRM fields first and then Creator fields ( without the quotes ). Creator field’s deluge name is used here. myFieldMap = Map();
Not Able To Find the "replaceAll" Function
I have a function where I am trying to replace a series of "tags" with values from various forms to create a status string. However, when I attempt to call the <string>.replaceAll() function, I get an error message that says "Not able to find "replaceAll" function". I've tried this with a couple of other methods, such as replace() and replaceFirst() and ge tthe same error. Additionally, I've tried calling it like this: <mainstring>.replaceAll("tag", "value", false); As well as like this:
Timeline
Hello, Is it possible to hook into the Timeline report and change how the properties of the default date? I have a field that holds the day of the week but only need the timeline to show a 7 day period. I have also got a date field which i need to set the initial 7 day forcast of timeline by. So an example would be to set the date field in the form and when the report is generated it only shows 7 days from that date relative to the date field. Thanks
Online payments through web forms
I would like to be able to accept online payments through my website. It is my understanding that I cannot implement that with the CRM Webforms but there is a way to do that using creator. If someone has already written the code for this in creator, is there a way I could pay for it? I am not a developer and do not want to have to start from scratch when I 'm sure it exists in this community somewhere. Any thoughts?
Cannot Add Subform to Form Section
It appears that we are now unable to add a new subform to the main "Section" of my existing forms - it needs to be below the main section. This is a new situation - we have many forms with subforms inside the main section, and we can add other components to the main section, but not subforms. Has anyone else seen this behavior? Is there a way to allow this? It is required for us to be able to add subforms wherever on a form we need.
Drop down Problem
I have created a sub form, in that sub form there is a drop down field in which data is being fetched from another main form, but I have a problem that in drop down the selected data doesn't get hide after clicking on add new row in drop down field, so can you please help me how to hide(similarly like multi-select field) the selected field when I click on add new row.
Issue with mobile notifications? Anyone else having problems on IOS
Hi all, Has anyone been experiencing mobile notifications on iOS over the last couple of days. I've started using them in an app im building and cannot get them to work at all. I've dived through the documentation and followed the basic instructions of enabling notifcations on the app its self. I've setup a workflow to send one when a record is created, but i get nothing at all. I've also created a fresh app in case it was an issue with the one i was working on, but still no joy
Function field treated as text in Pivot Chart
Hope someone can help with this issue, as cannot find anything on this in the support field. I am creating a new Pivot Chart where are need to use a function field to do averages, however, for some reason the given function field is being read as a multiline text? The function reads as below where the two first referred fields are nubmer fields and the two last referred fields are time and date fields. ((input.SEM_SCH01_16_TD_ID16 + input.SEM_SCH01_19_TL_ID19) / (((input.SEM_SCH01_33_ATD_ID33 -
switch inferface language
Hi, does anybody know how to switch the ZOHO Creator Inferface language? i have a german Windwos and Chrome Browser, but i would like to develop with English ZOHO UI - is this possible? kind regards Lambert
Master - Detail relationship in record templates
Hi, We need to make a record template to create a form similar to an invoice o estimate, where we have a master form and a detail form that are linked by a field, that is: Master Form: Prebill Detail Form: Time Entry The Time Entry form contains a field called Prebill which contains the ID of the Prebill form record . How do I establish the relation and filter the registers of the Time Entry form by means of the Prebill field associated with the Prebill form, in such a way that for each Prebill the
Bidirectional Relation on subform not available
Hello, I've created a blank subform and added a lookup field to it. For some reason the Bidirectional Relation option on that lookup field within the subform cannot be turned on (the checkbox before Bidirectional Relation is there but nothing happens when I click on it). The subform is designed to add Contact names to an Account form, and I'd like the Account itself to be shown when looking at the Contact data. Any help would be greatly appreciated. Al
How to Add Row to subform via script?
Hi all. i am Developer, and i need add row in a subform Creator automatically with a trigger. exist a method for do it? thank you
Can note(plain) field's value be used in action?
I know the note(plain) field's content can be written in, but can it be get out and be used by other fields?
From Creator get a record from ZOHO Crm by using the Lead ID
Hi, I know the lead ID of a record created in my ZOHO CRM My Zoho CRM and Zoho Creator accounts are linked I tried this crmResp = zoho.crm.searchRecords("Leads", "(LEADID|=|520729000000065376)"); but get an error {"4832":"Invalid parameter value"} Any advice on how to achieve this ..
Getting the lookup field value in string format only
Hi, I am writing a script where in i need the lookup field value as it is For eg : I have lookup field for Order Number which is pure Numbers (002202023, 039393393 etc) But now when i am using it in script inupt.Order_Number so abrupt value pops up i guess Please guide
how to create a button in a form to open a new form in pop up window.
how to create a button in a form to open a related form in pop up window. pls help.
Is it possible to create a Creator app that pulls events from Zoho?
I want to create an app that pulls accounts from Zoho and events so I can plot check ins on a map. I need to be able to let our outside salesmen see how long it's been since their last customer contact. It appears that I can only create a map that plots data created inside the app from a form? surely this isn't the case. Dan
C5 and Google Maps API... OH MY!
So I've found one video on the internet that shows what I basically am needing to do. I reached out to the author, and found that he would develop it for me if I was so inclined. I would much rather continue my learning of C5 and deluge, so I'd rather find some examples out there and work with them to build my Map. https://www.youtube.com/watch?v=3e7XyIDtP3E ZOHO's support said that their own built in Map cannot do what I'm needing, so I will have to use the Google's Map API. I have a key and am
Takes the temperature from IP Address
Hi All, I am hoping if someone can help me here. I have been struggling how to get the customers IP Address and then transfers the data to the temp field on success of form. I have found a free way to get the weather from IP Address. //Get the user's IP address $user_ip = $_SERVER['REMOTE_ADDR']; //The Data Science Toolkit URL $url = 'http://www.datasciencetoolkit.org/ip2coordinates/'; //Find the user's location from their IP. //*** You need the get_data function from the sample code $raw_geocode
Calendar - making an appointment
Hi Guys I have an app that I use to create appointments - its in calendar view ... This is the issue : Say I make an appointment in two weeks time at 9.30 .... I go to that time ,see that its clear click an add the appointment ... BUT it defaults to current date / time not the selected date and time... Is there some code I can add so that it uses the selected date /time and not the default Now date/time. Can any one give me some clue to fix this please...this super frustrating.. { displayname
Mobile app - Offline mode
Good day, I am developing a form in Zoho Creator. I have a few hidden fields based on the status of the form. However, when I use the Zoho Creator mobile app in offline mode these hidden fields are NOT HIDDEN. Is this a known issue or am I doing something wrong? Thanks.
Can Zoho Creator Groups be nested?
Can the "Groups" be nested? Ref: http://help.creator.zoho.com/Manage-Groups.html In my Creator application I would like to create an hierarchy of access by means of using groups. E.g. employee group has assess to 2 views and manager group has access to the same 2 views and 1 additional view. So that I share with 2 views with the employee group, make manager group a member employee group and only share the 1 view to the manager group rather than having to share all the 3 views to the manager group.
PLEASE add support for self referencing table and tree view in report
Hi, Self-referencing table is a basic feature in a lot of comparable software (Access and Filemaker Pro). It's frustrating to migrate here and be left without the possibility of doing so. Self-referencing table is critical for allowing sub-record (sub-task, sub-milestone, etc.) management. If you have a Task form, you might want to allow your users to structure their work in a task/sub-task way. Zoho Project allow such feature. For this, you need to be able to reference a task to its parent task.
Deluge Script Alert function Not Showing
Hi I have the following deluge script in the On Edit, On Validate section of my form alert ("Testing"); info ("Testing"); The info line works fine the alert doesn't. In the Zoho script documentation I find numerous mention of using the Alert in On Edit On Validate section. Has something changed Thanks Gordon
Themes custimization
Hi there, Its great to see ZC adding more theme to the app, especially the recent icon vertical layouts. But please.... ADD SUPPORT FOR CUSTOM COLORS! We build apps for clients, who already have their own color scheme for logo and such. You need to stop forcing us to use specific colors for headers and font and buttons and etc. Please add in the Theme menu the following customize options: - Header background color - Primary and secondary buttons colors - Link font color Or please at least, let us
Newbie, question about Fetching
Hi, i'm new to Zoho, and have a question about fetching. I'm used to Acces and a bit of VBA, where i'm used to open a form and where i can have a subform based on for example a CustomerID. I've looked into the help files concerning Fetching and stuff but i just don't seem to get it the right path perhaps one of you could help me ? I made 2 forms form A holds Customers, form B holds CustomerContacts. So a customer can have a brother.sister,father,mother as a contactperson. What i want to is make
Next Page