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-
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
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.
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
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
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.
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.
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"
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.
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
SAML Authentication - Is this only available for ZohoMail ?
I read that SAML authentication can be implemented for ZohoMail, but no mention of it's implementation for other Zoho Apps, namely Creator ? Why is this feature not across the range of Zoho Apps ? I have a customer who insists on using a Microsoft Enterprise Sign-On, which is not available on Creator, which has forced me to start investigating Knack.com which does offer it. Any updates or a definitive answer would be appreciated. Neil The diagram online, indicates it is across Zoho Applications,
getting { "message": "Invalid Portal" } in response.
Hi, I have been hitting the below API GET method url = https://desk.zoho.com/api/v1/tickets?include=contacts with authtoken and orgid as headers like mentioned in the API documentation. But I am getting { "message": "Invalid Portal" } in response. I am sure my request format is correct. What would be the problem? when do I receive this response. Please revert back ASAP.
Linking two forms imported from Excel
OK, new to creator but have some database experience. I have imported three sheets from Excel that are related, i.e they have the same unique column index in each sheet. Had to split my data into three since I had too many columns for Creator. On importing into Creator I want to link / join the forms together so that I can create a report that has all the information in one view. (From reading the help sheets I need to create a relationship to do this. Lookup or Subform.) So, on the Members form,
Email link to record
I'm trying to create an onSuccess email. I want the email to include a link to the record that was just created. How do I go about getting that url?
Subform row heights - anything to do about it?
I would like to change appearances of subform rows in Creator Forms. There is a lot of space around the subform fields, which may look good on simple forms. However on large forms this is not practical. My client is looking to move the spreadsheet below to zoho forms. Additional options for columns would also be a blessing! Are there other means to achieve my goal?
Web Site embedded Dynamic Reports
I have an APP that takes User Input data and does a calculation & queries a database table. When it finds a Record in the database that matches the Query criteria, it generates an Output Report. I have embedded the links for the "User Input" form and the "Output Report" into my Web Site and they appear on that web page. The User Input form works properly accepting data entry from a user, and performs the calculation & query when I click the Submit button. My problem is that the "Output Report"
How to zoho creator create, update o manage variables of XML? Could you give a example?
Good afternoon everybodye, How to manage the XML response of a webservice? For example: <response><result><application_list><applications></applications></application_list><application_owner>Public</application_owner></result></response>
Ideas for Script Editor
I am not a big fan of the script editor adding parentheses. It often makes the code hard to read later. I would like to change the color coding of the text. Thanks,
Quick question
Hi, Need to import data from an Excel file, I have a column related to the checkbox field in Zoho, what do I need to put in the excel column to show in Zoho that a checkbox is checked/not checked? I've used decision boxes for the checkboxes
Change Primary Contact
Hi Team, Good day! Can i possible change the "Primary contact" of my application? see attach picture for details: picture name 123.jpg How can I change the email address send after invitation of the application? see attach picture name 1234.jpg Regards, Jee
CRM lookup not working for some users
Hi! I made a form that has a CRM lookup field (to the Contacts module). When I access the form from the application creators account the lookup field works fine. However, when I access the form as a different user the lookup field doesn't work - it just says "No matches found". Could this be a permissions problem? If so, how do I resolve it? If not, what is the problem? Thanks! Rob
Restore failed / Error Occurred
Hi, I am trying to restore a recent Backup of my main Application (called DEOR) including forms and data to another application with a different name. I get the "Restore in Process" message, but after 10 minutes this is the what I get: Every time creates incomplete copies (no reports) of the original application which I am not even able to delete: Please, I need your help urgently. Thanks, Ceasr
Portal Emails
I have setup the Customer Portal, along with all areas. I have tested and works fine, except for customers email when they do not have a "Gmail account". I can receive the emails if they have a gmail type account, but not from others, like Yahoo, hotmail, or even customer based extensions. I have even tried the notifications area as well. Any ideas?
Execution of form On Load
Form On Load function has.. .... alert("hello"); ... alert("goodbye"); ... When the form loads guess which order the alert messages appear? Thats right goodbye then hello. Errrrr?
Create a Custom Module
Hi, I am working for a client and have a custom requirement. I need to Integrate third party library in ZohoCRM and client prefers it to be in the form of "Extension" which he can install in multiple ZohoCRM instances that he is having. Can you please let me know if this can be achieved? Thanks
Next Page