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
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.
Zoho Creator integration with Books
I have created custom applications in Zoho Creator for billing customers, and sending purchase orders to vendors. Some of these orders have more than 1,000 line items each order. I need to reconcile the credits/debits back to Books. So some integration is needed. Has someone done this and/or can I get some directions on where to start? Thanks.
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?
Add signature to different records at the same time or with deluge
Is there a way to add the same signature to different records at the same time on Zoho Creator, or add signatrue with deluge?
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?
Open Google Maps mobile from an application
I am a new user of Zoho Creator and my skills are low I want to be able to open the Google maps mobile when my application is opened on an IPad Using the URL from google maps does not open the google maps app I have tried using Google maps URL scheme but it does not work Overview A URL scheme allows you to launch a native iOS application from another iOS app or a web application. You can set options in the URL that will be passed to the launched application. The Google Maps for iOS app supports
new topic posting problems
why my new topic is not getting posted?
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
HTML page to create record
Hi, I'm very new to Zoho Creator, is it possible, in Creator, to create an html page that users can use to create/edit records? We are finding that the 2 column CRM modules and Creator forms are very restrictive in terms of layout. I have created an HTML page with multiple columns but all I have found is that you can import data into the page from existing records where the input method would be a 2 column form. Our data is working data that is constantly changing and updating, not data that is
Creating picklist in code referencing form in other app
This is weird. I can have a lookup field which references a form in another creator app... but cant have descending order within the lookup field. I looked at the syntax for how the form lookup is declared and figured I'd try and manually build the lookup field contents mylist = othercreatorapp.formname[formfield == input.myfield] ; The above errors with Form 'formname' does not exist in this app! Whereas the form definition has type = picklist values = othercreatorapp.formname[formfield == input.myfield].ID
Is it possible to embed a pivot table report into a record summary?
Hello, I am trying to build a record summary that includes a report I have already created in the record summary along with other information. Is it possible? Thanks
Attachment
When i add attachment as link ( Record Summary as PDF link in Zoho Creator ) in zoho crm it shows as 400 Bad Request How to change that Name? The link that i have used was "https://app.zohocreator.com/parath2/management/report/Management_Report/exportRecSummary?recLinkID=" + input.ID Anyone Solve this
Custom Report looking for differences between records
I'm having a hard time figuring out how to create this report. Let's say I have these forms. Product ID Name Package Template ID Template_Subform Product Package ID Package_Template Package_Subform Product There are other fields in the Subforms, but they're not important. I would like to find out which packages don't match the template. So it's something like: Show me all packages where Package.product not in Package.Package_Template.Product Thanks for any help.
Set Display in a Lookup field to a field in another form which is itself a lookup field
Is it possible to set Display in a Lookup field to a field in another form which is itself a lookup field? Say I am setting the lookup field to connect to the auto index number in another form since it is unique but I want the user to see a combination of a Customer Name + Lot Number since that make more sense for him. How do I do this. Any ideas?
Next Page