Disabled but not Grayed?
Is it possible to have a text field disabled but not grayed-out?
How to update already existing data via import.
HI all Kindly help with below I have a set of data in creator app. for example Name | Email | expiry date. The expiry date changes based sales activity offline, which is reported as CSV with Email and expiry dates. how do i import the offline sales activity report so that it updates the expiry dates for the email address already available in APP.
Count the Value within a Anniversary Period
Hi, I have a table contains the attendance records of all customers, I want to count the no. of times a Customer_ID attended the class (Date) within each Anniversary Period (based on the Join_In_Date), and return the value to another report like below format, is there any way I can do so? Thanks a lot! Customer ID Range Count ================================================================ 8888 Year 1-
Emails from my domain
Can I send emails from Creator that appear to come directly from my domain?
Communicate ZOHO CRM through XML with other Services
Hello, I'm José Daniel, and I'm really new in this platform, I would like to know if there is a way to communicate ZOHO CRM with another platform what uses Web Services. The idea is the we take the some information from the Zoho CRM and with that information we create a XML, then we send that XML to this other platform, we received and use the answers to update the information in Zoho CRM. I don't know if this question should be here or in Zoho CRM. Anyway, I would appreciate all the help. Thank
property management app
I just started using Creator and tried installing the property management application. It has the usual "wait while work our magic" prompt with a ghost image of the application in the background, then it goes to a white screen with a "no usch application exists" message. Can anyone help?
Regarding Xml Response - Execute XML Path
An XML Response which is from another WebServices, need to be fetched and inserted in the creator report. For that i may using the "ExecuteXMLPath" build in script in the creator. Using those Script i need to fetch the XML Response with multiple fields values in a single variable.But using "ExecuteXMLPath" only one field value will fetched. I need to fetch the Data as mentioned below. xml_email&password_response_holder = get_data_from_job_ready.executeXPath("/parties/party/email/text() &&
REST API link is broken
Hi, When using the REST API link :https://creator.zoho.com/api/<user id>/json/<application>/form/<form name>/record/add the web server returns an HTTP error 301 and redirects to https://www.zoho.com/creator. Seems like the REST API link is broken ? Regards Malcolm
Visibility of report content
Hi, Consider i have some 10 employee data which is entered / imported by the admin but if an employee signs in he should see only his record / data. How is this possible? I have also tried by giving view only in customer portal but this works only when user enters data and then he is not able to see others data.I don`t want this as the data is entered admin. I have also tried by adding criteria in the report specifying [Email equals zoho.loginuser] or [Email equals zoho.loginuserid] But nothing is
HTML page doesn't show new line on textarea on content coming from multline fields
I get this code on a HTML page: <textarea readonly="readonly" rows="10" cols="100"><%=form.multiline%></textarea>But it doesn't show line breaks from multiline field content. I already tried to do a replaceAll("\\n", "<br>"), replaceAll("\\n", "\r\n") or replaceAll("\\n", " "), none of them work.
How do I populate radio field choices in code that have a fixed list of options in the field definition,
I'm new to Zoho, only started working on it this week, but not new to application development for business after working for many years in Lotus Domino. Anyway I am developing some new forms and can't find a way to populate the options for radio fields and selection fields in code rather than using a hard coded list. Any help you can give will be greatly appreciated as I can't find examples anywhere so far to show me how to do this.
Wordpress Integration for Current User
Hello We are a small company of 3 managers and 10 technicians. I wanted the ability to automate some of our work and create an app that we can use to organize jobs and vacations. Only one user is actually accessing the Zoho creator system (me), the rest would be using the app only (mebedded in a Wordpress site). Can I embed the app in Wordpress and then use REST API or something to send the WP current user ID so we can track who enters orders etc? Is this possible? Or against the rules? I've been
Fetch Value from dropdown within Subform
Hi, I am new to zoho creator and not sure about how to do the following with deluge script . In the Point of Sale application and I want to auto calculate the "Expiry Date" of each item added within the subform based on the invoice date. Expiry Date = Invoice Date + X months In Add_Product Form, i have added a field called Validity Product Name Validity(Months) 4 Lessons 3 5 Lessons 4 8 Lessons 5 Thank you for your suggestion!
Publishing a Creator Page with an included Form
Hello, i have a published Creator Page with an Included Form like this: htmlpage Anlageverzeichnis(CRMID) content <%{%> <div style="clear:both;" elName='zc-component' formLinkName='FORM_NAME' params='zc_Header=false&zc_SuccMsg=Data Added Successfully!&zc_SubmitVal=Submit&zc_ResetVal=Reset&CRM_ID=<%=CRMID%>'>Loading...</div> <%}%> but if i include this via iFrame in an Website i become the error: Can everyone help me with that? Kind Regards Klaus Brandt
Update two forms with same Data
Hie , In Subform i use this code (Code1 pic below) to show every category list depending on Lookup field option and this working well but i want these to update in Two different Forms of Same Application . so what code i have to use there ?
Date Field in Zoho Creator
Hi, I have been using zoho creator for creating many application. I always feel that it is nice to have a field for Time. I dont know why you guys are not allowing the "Time field" alone. It will be helpful you do so. Or provide any options for setting the time format criteria for single line fields.,
Download a CSV file but with semicolon as separator
Zoho offers a built-in CSV Download, but unfortunately it uses only "commas" as separator. Some systems requires a "semicolon ;" as row separator. Does anyone knows a solution for that ? e.g. programming the download based on a list from deluge ? Or does it Zoho has any plans to offer the "semicolon" version of the CSV Download as well? Thanks Alex
bug: matches function is not work in fetch record.
matchedRecords = formName [Single_Line.matches("abc.{4}d")]; matches function is not work in fetch record. abc.{4}d is regular expression can anyone help?
How to calculate business days between two dates ?
Team, I need to calculate working days between two dates for Task management . Two dates : ticketAssignedDate , ticketClosedDate . Need to achieve this without loop and recursive
Ask about records
Hi Team, We purchase EXPRESS account yearly: Unlimited User 100 Apps 250,000 recordsMy question is: If I already have ten thousand data/records and I deleted five thousand of it. Is the five thousand records will going back to 250,000 records? 250,000 expected records 10,000 records of my application 240,000 remaining records 5,000 deleted records Is 5,000 deleted records will add in 240,000 records? like from 240,000 it will going back to 245,000? Hope you get my intention.
keep the active session
I have a question, Could you help me or tell me the best way to connect to a REST API which requires to keep the active session? It means, First I have to call a login method to access other methods in the API. My code is: //CREATE THE HEADER PARAMETERS THE REST METHOD NEEDS mapHeaderParameters = Map(); mapHeaderParameters.put("Content-Type","application/json"); mapHeaderParameters.putAll(mapParametersRestMethod); // //CALL TO METHOD REST // // LOGIN
Need Help Hide / Show based of Checkbox entry
I am trying to shorten a form of unneeded fields by using a check box. On load of the form I am hiding the fields and as the Choices are made the appropriate fields are added, or subtracted if unchecked. I can easily get the first fields to unhide and re-hide based off the checking and unchecking of the "Roof" checkbox in this case, but I run into problems as I add more selected choices. Here is the code that works for the first selected choice: if (input.Exterior_Repairs_Needed.toString() ==
ID Field Required for Showing One Record In Report?
I use a link in an email to notify users that a new record has been added. The link is to the Report and I only want the new record to show. As far as I can tell, this only works if the ID is shown in the Report. Is this so?
Best Way to Filter Records by Field that Corresponds to Users?
So, I am trying to figure out how to filter records in reports based on the current user. I also have a field in these reports that corresponds to the user, but it's the initials and not the Zoho username Basically, I want to be able to filter the records so that only ones where the initials field is the one that corresponds to the current username. I had a bit of difficulty with syntax when I tried to create a formula to do this, so I am not sure how to go about this.
Copy data from one application to another application
Hello, Is there a way to copy data from one application to another application On Edit the record entry? e.g. I have two applications, 1) New Stock. [form name = Invoices] 2) Old Stock [form name = Invoices] Note: All fields are same in both application forms. I am going to edit the record and doing some modifications in "New Stock" app. When click on update button, I want to copy that record to the "Old Stock" application. Is that possible? FYI: In modification process, there may be some conditions,
Configure Menu Item
When I click on a menu item, I would like to go to a Form or Page based on where I was when I clicked it. Is that possible? Is it possible to tell the target Page where I came from?
Eliminating duplicates on import
Hi, I need to regularly import data from a supplier into Zoho to keep my records up to date. The supplier data contains a unique reference. The data will be sent to me weekly and may contain records already sent the previous week. I need to import all the new records, but discard the duplicates. My question is therefore how do I do this? My assumption is that I need to create a new table to hold the imported data, then to run a function to compare it to the "master" table, adding new records before
If statement to send email
I created the following if statement to send an email based on the input of a selection field. I keep getting an error on line one missing a ";" The code is as follows; if (input.Location_field == "Day Support") { sendmail ( To : XXX@xx.com From : xxx@xxx.com Subject : "Test" Message : "Test" ) }
Zoho Docs Integration
I would like to create a document from a Zoho Writer template and then populate some fields in the document with Zoho Creator data. Is this possible? So far, I am only able to create a blank document. If some documentation exists, please point me to it! Thanks in advance.
Account is inactive
I am paying since months, presuming that my secretary is using the system, i got to know that it is inactivated, my i know why Access all my information through Request Id: #19234682, i am really surprised how are you deducting the money on monthly basis and you decided to desactivate my account without even informing me
Calculate a currency field based on current manufacturer
I have an Inventory form where I store all my part info. I need to adjust a field to automatically calculate when a certain Manufacturer is selected from the drop down field. I was thinking about a Fetch Records to do this. example; Inventory Form Manufacturer Drop-down field three pricing fields (A, B, C) If Manufacturer(Big Int field) ="Apple" Calculate Price in "A" times.3 and place amount in Currency field "C" aep=(Inventory[ID=Input.manufacturer].count()>0) if Input.Manufacturer.toString()=="Apple"
How to set the Title on the PAGE View
Hello, How do I set the title of the html page in the PAGE View? It looks like the default is "Zoho Creator - Page Name" Is there a way to change that? Thanks David
Converting date-time to date on a report display where date-time is the side effect of a formula subtracting days from a date
In some of my reports there are columns that look like this: "30-Oct-2017 12:30:00". I think the source of the time element is that I started out with a pure date on a form and performed some date-arithmatic on it (subtracted 30 days etc.) using a formula in the form. So the base column displays as a pure date but the derived columns display as date-time. Is there a way to fix this? To display (or fundamentally do the arithmetic) on dates instead of date-times?
To display contents of lookup form with a subform
I have a Form A with a lookup field from Form B. In Form B there is a subform C. I want to display contents from Subform C when entering data in Form A, sometime with one entry in Form A corresponding to like 5 to 10 rows from Subform C. How can this be implemented? I was looking for a field type like "Array" to display all records found in Subform, but the "on validate" action can't pull up Array values to populate such a field.
Rtl option creator
Hello Freinds, Does zoho already have a creator interface in rtl? I want to change it especially with forms and main bar. As far as I know zoho crm has an option for rtl
How to delete all rows in a table
I am looking for a way to delete all data from a table through the GUI. Currently I can only delete 200 rows at a time which is not efficient when a table has 8,000 rows in it. If there is a programmatic way to do it that would be helpful too.
Please support reverse alpha sort on lookup dropdowns
Built a time logging app for technicians out in the field with dropdowns to log their time against a fault or job reference. Since the list of things to select from just keeps growing.. and reference numbers with them, the current implementation of dropdown lookup field with a fixed ASCENDING sort order puts the most recent at the very bottom of the dropdown. Pain in the a**** Please please add an option for descending sort order!!
zoho creator and google map
I have a form where I can insert information about my customers like name, telephone number and address. Is there a way to verify if the addres exists? Can I use google Maps API (how)?
autofill subform
how to autofill subform using details from another form. Help me with code.
Foreign key relationship - how to lookup records based on foreign key (parent key)?
Hi all, I'm modifying the Order Management application that comes with Zoho Creator. In the New Product form, I added an Add Items subform that captures individual serial #s along with a status field that captures the location of the the item. That all works well. Each time I go in to view or edit the product, it lists the associated items in the subform. Next, I modified the Product Subform that's included as part of the New Order form because I want it to pull all the related Items records for
Next Page