Access Admin Only Form Fields
Hello, I want to know that is there any way to access form fields using REST API which are labeled as Admin Only in permission section?
reports - Aggregate Formula - countif
I am creating a report and want it to count based on there being nothing and im using the following script: countif("Autoview_1496775088044_Row_Subform Table"."Scion"='') it always returns 0, am I using the right operator of ='' ? When I do the inverse !='' it works perfectly and counts only the cells with data.
Feature Request: control sort order in dropdown fields
This one is pretty simple. Dropdown fields have an option for "Alphabetical order". I've finally found a client who has a giant list of values, all DATES, and so to find anything in 2017, for example, the user has to scroll through many pages. I'd like to just sort in descending order, not ascending. It would be nice if you offered this option in the future. Thanks! Bruce
Layout app on Windows platform
Hi guys, Is there something wrong with Zoho Creator app on Windows devices? The headlines "Prijzen and Opgehaald" schouldbe "Bedrijven and Maatkleding"
Can you change a field type as a result of user input?
Hello, I'd like the field type to change for a few fields in a form depending upon user input. For example, if a Status field is set to "Trial", I'd like Total Words Per Month to be a Number field (to be manually entered), but if the Status field is set to "Ongoing", I'd like Total Words Per Month to be a formula (which adds up two other fields within the form). Is this possible, and if not, what can I do instead? Thanks!
How do I display data contained in a separate form based on user input?
I have two forms. One (called "Writers") contains a list of freelance writer names and their "Rate Per Word" (a currency field). The other (called "Clients") contains a list of clients, and includes three fields that are relevant to my question: "Writer": The writer assigned to the client. This is a Lookup field that is linked to the Writers form. "Total Words": How many words are written per month is entered in this field. "Monthly Cost": The monthly cost of the writer assigned to the client, calculated
How to fetch a String (instead of ID) of Longlist in Page?
Please see the attached images below. How do I change the Suppliers ID into String? and Is there any way to limit the number of row displayed? Current settings: Add_New_Product - Product - Suppliers [Lookup - Longlist - One Product to Many Suppliers] - Quantity - etc.. Suppliers - Supplier_Name [String] I have tried adding s.Supplier_Name but got "Invalid collection object found" error. <tbody> <tr> <td colspan="5"
Record Summary
Hi all, I have 3 reports of 1 form: Report1 = All Report2 = criteria "Paid" Report3 = Criteria "Not Paid" Can i add the traditional "Paid" on report2 on record summary, maybe with a picture? or even a script? like this?
Lead distribution
hello! I'd like to find a way to use creator to help me develop a system for distributing leads based on certain criteria. I.E. - leads are distributed to the person with highest gross commission on team, then once they're assigned to lead, they move down to bottom and the next person receives a lead and we go round robin and so forth. Can this be done in creator?
To graph date and time
Is there any option to graph the time and the date in a Pivot Chat Report? I tried to do the graph (attached picture), but it only shows the date (please note the points at diferent time as a vertical line - it's wrong)
How to get CRM custom fields into creator?
Hi I am using "zoho.crm.getRecordById", "zoho.crm.searchRecords" and "zoho.crm.searchRecordsByPDC" in Zoho Creator to access crm entries in "Contacts". This works fine and gives me the standard response incl. contactid, Last Name, date-modified etc.. However I cannot extract my custom fields, which i have added in my custom crm layout. Can i change the standard response from crm? How can i access my custom crm fields in Creator? thanks in advance Andy
button to launch another page (newbe question)
In my service order form, I have a field for the customer work order number. field action is configured to create a link to the customer's web site which will display the current work order (murl = "first part of url" + input.ticket_number) This produces a string which is the url to the desired web page. Next, I need a button or a clickable link to access that web page in either a new window, new tab, or popup window. I've tried to create the code for a button, but I just can't seem to make it work.
Is it possible to fetch all Sub form data which is a sub form on one form and update this data to other sub form which is a sub form on other form ?
Is it possible to fetch all Sub form data which is a sub form on one form and update this data to other sub form which is a sub form on other form ? My Requirement is: 1. I have a form named " Costsheet " and created a sub form named " Costsheet Product " under "Costsheet " form, I mean "Costsheet Product" is a sub form on "Costsheet" form. 2. I also have another form named " Quote " and created a sub form named " Quote Product " under "Quote" form , I mean "Quote Product " is a sub form on " Qoute
image display in page
Hi, I am building an app which records the travel expenses of users . Now along with the details the users upload recipts in jpg /pdf format. I have built a page which has embedded the report of expenses filed. My next step in the process would be to display all the recipts one below the other . I want to know is there a way to accomplish this.I have created a sample doc with one receipt which I am attaching for your reference. presently I have attached only one recipt. Like this multiple receipts
Please help. I am trying to remove 00:00:00.0 from datetime field formula
This is the expression that I am using at the moment: input.Customer_approval_date.addBusinessDay(15) This is the result I get: 2017-06-21 16:00:00.0 But I don't want the time to appear. Please help :) If the suggestion is string to remove the time, please let me know where I enter the string formula as I have seen this suggested elsewhere but don't know where to enter the code. Thank you for your help :)
how to do this task
Hi team Help me I have employee form here i have e number filed called total leave . i have another form in new section here i have date field start leave and end leaves and another formula filed called days requested i am unable to calculate difference of then i have to reduce Sunday and Saturday.then i fetched that total leave day from employee form into leave form now i want to subtract total leave from days and i want to display the result in reaming leave field that is number. thanks
Update records within Subform
Hi Zoho, I want to populate Subform field with multiple rows from Main form field update. Main form is Customers. The field for updating is Customer_Company. I have add Field Actions in Subform On Add Row to populate the same field in Subform. So every time add new row in Subform automatically copy the value of Customer_Company to same field in Subform. What I want to ask is, when I update the Company field in Main form, I want all the field in every row in Subform also changed. Please help. Thank
Zoho creator user account create and login.
Hi, I need a order management app.Where customer can create an account. If admin approve customer account then customer get login this account. It is possible?
Problem with OnAdd-OnSuccess workflow
Dear Team, I'm developing an application to generate Quotation ID. First thing, the Auto Number does not accepting prefix zero (Ex.001). So I was surfing the blog and found below post. https://help.zoho.com/portal/en/community/topic/auto-generated-number-field-with-prefix I have added the code in the OnAdd-OnSuccess Form Action, but when saving the entry, the code is not generated. I've tried the same logic with a formula field, and it works, but could not use one formula field in another formula
How to Import File Attachments from Other Cloud Provider?
Hi, I have hosting that is going to expire on my other cloud provider. I am in the process of moving everything over to Zoho, but I am stumped as to how best get my data off the other cloud, upload it to Zoho and link it to my records. I have the url's of all data currently on the other cloud platform, and I can link them logically to my records, it's the mass upload of these images from url's that stumps me. How best to do this? I can't link to the existing urls as they will be gone once I cancel
Report of Record Summaries?
Is there a way to do a Report of Record Summaries using a customized template?
function error - consolidate records by field for pushing to CRM
I'm writing a function to update products quantity in Zoho CRM. within my creator products form i have multiple products with the same name, so I want to sum the totals up for those products and then pass them onto CRM. However, while writing a function there seems to be one line that seems to cause me problems throwing the error on compile: " Error at line number : 4 Not able to find 'sum' function" ; fetchData = formName[ field == function_variable].sum(fetchData.fieldINform); the function passes
Show image in subform
Is it possible to show an image in a subform? Notes field is not displaying in my subform. Neither is the formula field.
Execute some code in future time
Hi, Is there a way to programmatically invoke a function 10 mins after the current execution time?
Bug with function-inside-function in <%= %> on html pages
Hi Zoho, Whenever I use a function inside a function on an html page inside <%= %> , the system fails: for example: <%=thisapp.MyFunction(Variable.toString())%> The html page is saved correctly and displays fine, but when I try to reload the edit mode of the html page or access it via "edit this application" button - I get a blank page (cannot edit it, not using script builder and not using the free-float). When this occurs, and after speaking with support, there is nothing else to do but to completely
Access user profile of customer portal from deluge script
Dear sirs in zoho creator I would like to disable or enable a certain field based on the user profile in customer portal. I know which user it is (zoho.loginuserid) but I don't know how to have access to information about the profile associated to the user. Is there a way to do this via deluge script? Because I tried first this, I went to settings, users and permissions, field permissions, chose my profile and my form, edit, and put "Read only" on true for my field. But this change had absolutely
Output of Lookup field
Hi, i want to use my output of a lookupfield in a rule to show a subform. But i get the error "In Criteria left expression is of type BIGINT and right expression is of type STRING and the operator == is not valid" Is it possible to show a subform using a outcome of a loopup field? Regards Jos
Create CRM record for each Subform with common Masterform data.
Hi!, I need to create CRM records for each Subform item. These record will include common data from the Masterform. Current script progress-----> PriceMap = Map(); for each pricedata in Hotel_Price { PriceMap.put("Items",input.Hotel_Price.Name); PriceMap.put("CostPrice",input.Hotel_Price.Pax); } PushMap = Map(); PushMap.put("Product Name",input.Product_Code); PushMap.put("Publish Name",input.Publish_Name); PushMap.put(PriceMap); PushMap.put("Country",input.Country); for each rowdata in Hotel_Price
date field default to current date or date created
How can I force a date fiedl to display the date the record is created. I can';t seem to find a deluge function that returns that variable. and If I do, how do I make that the default value for the field. Specifically, I am creating records of items that are shipped, so the "date shipped" needs to default to the current date.
Data not saving
I'm trying to create my first Zoho app. Adding fields to a form works fine, but any changes I make aren't being saved (despite the popup message claiming that changes are being saved). Any ideas why? Thanks!
Lookup field
Hi, i'm new to Zoho Creator and i want to build a form/app witch wil used by my employee. He will fill this form at the job site. Now i've manage to build the app for 80 % only i have a few issue's We have ± 20 customers and each costumer has ± 4 contacts. Now i made a drop down wit the costumers name and mad a rule "when customer field = "customers name"" then show the subform of costumer "costumers name". This subform has 2 drop downs with "sent quote to" "sent .dwg file to". This is working only
please add javascript, css, ajax, and bootstrap support to forms reports and pages
4down vote I wrote an article about how to make calls to the Zoho Creator backend here: http://www.lighthouselogic.com/cross-domain-ajax-requests-to-zoho-creator/ I have used this technique successfully to host a simple html and javascript frontend that talks directly to the Zoho Database.
Integrating zoho creator and zoho invoice
Hi, I am using zoho creator. As for now, I am creating zoho invoice from the script using zoho integration. My question is, I want to know the acknowledgement when the invoices are paid by the customer. How can I get that?
Need a Web Application Developer
Hi, I have a new payment system idea and I need a web developer. Before we begin with, I will always like an NDA agreement, I will also like to discuss the SDLC stage, know my rough cost from the beginning to the end and also, I will like to work with someone that is interested in new innovatiosns and can also contribute his/her own knowlege into the whole idea. We can always be partner, it depends on how interested the developer is.
Function to create record
is a function such as the following possible? I can not seem to get it to work. I am trying to create records in ANOTHER form based on every record in for 1. IE for each record in form1 report, place a record in form2. void scripts.customFunction(fun) { for each <myvariable> in <form> { insert into <form> [ <field> = <expression> ] } }
I found a bug...
Hi, I think I found a bug. On the mobile platform, when I select one or more values in a "Multi Select" field and this is the last field of the subform, the value (s) are not saved. To make sure it was not me the problem, I reversed the field so that it was not the last and my data saved. Tank you! Steph.
decimal number into words?
Hi there, I've been trying to convert a decimal number from a currency field into words to a text field using a function but I just found this solution: click here , which only works for int values... can anyone help me to modify this code so it can work for decimal values or is there any different way to do it? I would really appreciate your help! thanks in advance.
Problems with equalsIgnoreCase?
Hello, I am attempting to revive an App used last year for this coming summer. I have run into an issue with my registration validation and case sensitivity. The equalsIgnoreCase() function does not seem to catch case variations with my entries. Is this something others are experiencing? Thank you for any insight you can share! I check a new entry against my existing entries to ensure a new user does not share a First Name, a Last Name, AND a Phone Number. Here is the code I am using: temp = input.Phone_Number.getAlphaNumeric() ;
Fetching Records by ID if search key from URL is String
Hi, I'm new to Zoho Creator and tried to solve this by digging through the available explanations and posts for quite a while, but I have to admit now that I'm stuck. This is my setup: Form A and Form B contain records of different types of products with some details. In Form C, I select a product from B and assign multiple records from A to it in a subform. Now, I want to offer a search: The user selects a product from B from a dropdown, hits a button and should see - product details for the selected
Import of Data into Creator only seems to work for Administrator???
Is it possible for more than the Administrator to import data on a particular Form or Report in Zoho Creator? It seems that only the Administrator of the App is able to import data into the the App. Is there a way to allow other users to do the same? by Form or Report?
Next Page