conditional formatting of a formula field in a report
I have a formula field in a report that show a total of two other fields in the same report. I want to change formatting if that formula field is above a certain number. When I go to custom formatting it no longer gives me the option of greater than or less than. What am I doing wrong?
Updated: Parameter-based query on ID of related record - solutions and bug?
This is a combination question / feature request / workaround. We have several cases of quite-common business need to "view all <other object> related to this record, based accurately, on ID. Such as: in our list of Properties: for any particular property row, to "view all Tasks that have been associated to this Property". (We are OK with the technical setup: creating on the Properties report the custom action "View Tasks" under the Edit pulldown, which calls a custom function, that opens the Tasks
Copy a record and a subform as a function
Hello I am trying to ma a function that gives me control of copying an old record. Som fields should be as the are in previous record an som should be different. This is no problem but when it comes to make inserts from a subform (which also is included in the form) I can't do it. Can anybody help me? It looks like this void RE_Previous_Record(int Previous_ID) { Previous_Record = Trycklista [ID = input.Previous_ID]; New_Record_ID = insert into Trycklista [ Offert_order = Previous_Record.Offert_order
Setting date field to null if string date value is empty or null
Hi, I'm recollecting data from CRM and updating in Creator. Some fields could be empty - no problem with strings. But date fields, when they are null, I haven't found the correct way for setting them. I've tried like this: r = zoho.crm.searchRecords("Contacts", "(Last Name|=|" + last_name + ")"); contact = r.get(0); new_id = insert into Persona [ Added_User = zoho.loginuser ... (more fields) Fecha_Alta_Persona = if (c.get("Fecha Alta") != null, c.get("Fecha Alta").toDate(), null)
Can I edit the field name length to be more than 200 characters?
Hi, Just starting out with creator and ran into a little issue with my field name lengths...can this be adjusted >200? Cheers Eric
Detail page embedded views (filtered)
Hi, Let’s say I have 2 forms that are linked to each other in a 3rd form. On a html page I show information from fields in Form 1. For example Form 1 is Product categories, here are details listed about this category. Form 2 has the products. Products should be able to be assigned to more than 1 category (unlimited). Form 3 is the linking form. A records contains a lookup field to a product, and a lookup field to a category. On the html page I want to show next to the details of Form 1, an embedded
URGENT! what is with admin interface?
hi try to add radio-button field see example it waits so much time without response has try from firefox/chrome
DB in Creator or Report?
Hi, I am writing an application to collect data using form (with a lot of scripts inside) and show sophisticated reports and graphics. I also need Customer Portal Function and SMS integration. As far as I understand there are at least 2 scenarios: 1) the DB and the Form is in Zoho Creator and the reports are made in Zoho Reports and shown and embedded in Zoho Creator pages or in web pages. 2) the DB is in Zoho Report and the Form is in Zoho Creator. The Reports are in Zoho Report and are shown and
Need Help With Images in HTML View
I'm using an HTML view to produce printed documentation of a supervisor's evaluation of an employee. I want the supervisor's signature to appear on the printed documentation, but I can't seem to get it to display. The supervisor's signature is stored in a field called signature_image in the form Employees The linkname of my HTML view is Supervisor_Visit_Record_HTML Up near the top of the HTML view's script, I have the following: <%{ r = Supervisory_Visits [ID == input.ID_in.toLong()];
how to make on_add/on_success if with "contains" ?
hi need in workflow a rule that will on_add/on_success use condition with "contains" right now workflow rules work with == or != how to make rule in such manner? if ( field_A contains " text_in_field_A ") { ..... }
Best way to update a single record via an ZC HTML Page
I have a ZC HTMl Page that I am creating and have a table where I am listing elements. On each row I would like to have a button that when clicked will update one specific field in the associated record. What is the best way to do this? Thanks!
Is Custom Action passing parameters in Public View Possible ?
Is it possible to create a custom action on a public view that passes parameters to a payment form also with public access? I have a view that's embedded in a webpage. The view has a custom function on each record. The idea is a visitor on my webpage could find a product they like, click the "Buy" custom action button and a form opens that shows what they are about to purchase. They then click the submit button and it takes them to paypal for payment. The trouble im having is from a public view
Managing application for sale on market place
Is it possible to share an application and allow another zoho account to install it but not be able to edit, duplicate or download the application? What im trying to achieve is to be able to install an application on another zoho account where the owner has purchased the application from me but not allow them to edit or duplicate the application. I notice some applications on the zoho market place are for sale. I assume that once purchased someone cant just copy the application and post it online
CRM Opportunity Amount in Creator
Hi, I am trying to get the total Opportunity amount from Zoho CRM for a Sales rep for a particular month and have that information fill up a field in Zoho Creator. I have tried various ways and scripts but was unable to. Can you please point me to the right direction or may be provide me a sample snippet? And I apologize if I have posted this in the wrong place. Thanks, Wadoos.
Email
hello I'm new to zoho creator, I'm trying to create forum called leaves which employee can apply for leave, when employee apply for leave I need the form to send me email for approval or rejected. please advice how to achieve this.
Subform lines limit
For a subform, if there are too many lines, is it going to have performance issues? If a subform has 2,000 lines, can I limit the # of lines to 10 maximum, and page-lize the records, and add in a search function for the subform records?
Is Zoho Creator Integrated with Zoho Subscriptions?
How to call Zoho Subscriptions API[ "create new subscriptions"] from Zoho Creator? https://www.zoho.com/subscriptions/api/v1/#create-a-subscription Do you have any default method or Do I need to call POST api?
Adding new fields on load
Is it possible to make a form dynamic and add fields on load ? For example, if on load i request records from CRM and in the response I have 5 records. I would like to recreate a new input for each record loaded from CRM. Is it possible ? thanks, Guillaume
Adding one row for each record in my zoho CRM base
Hello ! I'm trying to build a page with a list of records coming from my zoho CRM database. What I want is to put a checkbox next to each record and then a submit button on the bottom of the page, then, for each record selected, I want to insert another records in my CRM base. ----SOLUTION 1 I thought about: What I tried: -I created a page (not a form) -I retrieved all the records needed from Zoho CRM -Added a line per record (with name, position, checkbox) with a "for each" -Added a submit button
Using a form to query and receive output & Passing Dato to a web page.
I have a question in regards to Zoho Creator and it capabilities. 1st Question Here is the hypothetical work flow process I was curious about: 1. Zoho Form Captures Contact and info. (This I know can be done) Below is the step I would like to know how difficult to create would be. 2. Data from the form then passed through a to wordpress/or zoho site. They would receive an email with link and if they would confirm accuracy and asked to like to "share" on social media. (Is this possible using Zoho
Ipad and the ZC App
The ZC App has the useful function of being able to easily update and edit records on the Ipad, something that does not appear currently possible with an embedded form (unless I am missing something). However the upload document function is very limited, namely from Photo or Camera. I I use ZC with Google apps so it is most unfortunate that there is no option to upload a document from cloud storage such as Google Drive/Google Docs Anyone working on this? Any work around? Am I missing something?
I am new
Hi everyone, how to add validation in zoho creator i have 3 forms, 1)Registration form( contain details like username,password and personal details) 2)Login form(contain username and password) 3) third is a welcome page what i want if a user register with all the details,whenever user enter username and password in login page user should be navigate to 3 page before that i need to check username and password is matching or not
How can I get the username field type to appear in a Field Name?
Hello, How can I get the username field type to appear in a Field Name (Make this field as Record Owner)? My subscription is a 3-user , 6,000 record subscription, but I can only get one username to appear in the field name dropdown. If I share the app, the user cannot access the app. Please help me get out of this conundrum. Thanks, Norman
Image Field and Upload Field in Zoho Android App
Hi, First I would like to thank you for an excellent web and Android app! Our company has just bought a Samsung Galaxy Tab Active 8" tablet running Android 4.4.4 that we hope to use at our goods recieving. In my form I have added one Image field and another field for file upload (for documents, PDF etc.). The problem is that when I try to add a picture (either by camera or gallery) or add a document, nothing seems to be uploaded. The filesize is less than 1MB for both images and documents that I've
Viewed email link in Creator
Dear All, Is there any way (or an app in marketplace) when I send an email with a link (lets say a contract) then to return me that the 'Link is viewed' by the client? Like the functionality of the 'Send Email' in Zoho invoice where the user knows if the link (in an email) is viewed by the customer!
Importing data tree
Hello, I am having trouble keeping the data tree together for a multiple lookup box. Here's the issue I'm having: (In this scenario I have 3 fields) Year, Year 2000 has ID "YEAR2000" Year 2001 has ID "YEAR2001" Make, Year 2000 has ID "YEAR2000", Make Suzuki has ID "YEAR2000SUZUKI" Year 2001 has ID "YEAR2001", Make Suzuki has ID "YEAR2001SUZUKI" Model, (on import) Year 2000 has ID "YEAR2000", Make Suzuki has ID "YEAR2000SUZUKI", Model Wagon R+ has ID "*UNIQUE1*" Year 2001 has ID "YEAR2001", Make Suzuki
Need Help with Code in Zoho Creator (CRM/API)
Hello, I work with a manufacturing business and we are trying to get products that are listed in the ZOHO CRM as sales orders to transfer to a new app in Creator without the price but with product information. Currently the info from the sales order does transfer to Creator but only the first product! How do I get all of the products to transfer? Can someone help me with my code? I would really appreciate it! sales_order = zoho.crm.getRecordById("Salesorders",input.order_id); line_items_str=sales_order.get("product");
Uppercase on edit?
Hello, i have the following script: //You can drag and drop tasks from the immediate left pane //Below is the SAMPLE validation script if(!(input.IATA_No.toString().matches("^\d{8}$"))) { alert ("The IATA Number should be 8 digits long!"); // replace 3 and 5 with min and max digits.. cancel submit; } if((input.Amadeus != "") && (input.Amadeus != null)) { if((input.Amadeus).length() != 9) { alert (("Office ID Amadeus must be a length of 9!")); cancel submit;
Date -Time difference
I have this code to return Days, Hours, Mins, which somehow doesn't seem to return the correct amount of hours. I have been looking at it for a while, but I am not sure where I am going wrong. (((((((((Task_Completed_Date_Time - Request_Date_Time) / (1000 * 3600 * 24))).toLong())) + " Days ") + (((((((Task_Completed_Date_Time - Request_Date_Time) / (1000 * 3600 * 24))).toDecimal() - (((Task_Completed_Date_Time - Request_Date_Time) / (1000 * 3600 * 24))).toLong()) * 60)).toLong()))
How to create URL valid for mobile and non-mobile version
Hello, I'm creating an application which will be used with PC and mobile devices. I don't know how to know in deluge script if the user is on mobile or classic interface and URL that I create for redirections works on classic or on mobile version, but not on both versions. How could i know if i'm on mobile version or how could i make redirections that works on both versions. Thanks, Chrsitophe
Transferring info from one form to appear on another.
I am building a database and need information from one form to appear on other form, I have looked into the look up function but this doesn't do what I need it to. I have a form where a persons info address and contact details are entered but need all that into to appear on other forms in the app. How do I do this.
ZC and Ipad: Edit and View Record functions
When viewing an embedded list on a google site on the Ipad i can see the list of records. I can also print the individual record. However the Edit and View Record functions do not appear to work. Basically the screen goes white and nothing happens. Is this the expected result? Fixed this issue thanks
Problem with adding scheduled tasks
Hello, As it happens I am a rather clumsy newby. I am trying to set up the scheduler for adding new tasks, which base on the older ones (where new entries are meant to be dated for another month). So: Added_User = zoho.adminuser Date_field = input.Date_field.addMonth(1) Name = input.Name Notes = input.Notes Status = "Open" I have been trying to use if to add automatically new entries only when input.Date_field <= zoho.currentdate. It does appear to sort of work. I expect it to
pass ID of record to a custom page
Hi, I have a custom page where I display more detailed information of a record, plus information from other linked tables. What I would like but can't find: A link in the list view of a report (for each record) eg 'more info...' which links to a custom page, passing the ID of that record so that I can fetch the record in the custom page. How can I achieve this? Thanks, Peter
Iphone Picture too large for Image field
Hello, I have an image field in my form. On my iphone I need to select a picture I took with the Iphone camera to upload into the form field but I can an error saying the image is too large. How do I get around this or what are my options? I need to be able to upload pictures into the Zoho Creator database from my iphone and Ipad. Iram
List of currently active users
Hi, Is there any way in a Deluge script to get a list of the Users current using the App? I don't mean authorized to use it, I mean actively logged in right at that moment Thanks
How to add a name to the FROM field of the Sendmail task
Dear All, As we know the sendmail task has the following format: sendmail [ From : <string expression> To : <string expression> Subject : <string expression> Message : <string expression> ] In the 'from' format I can add my email etc etc. I would like to ask you, when I send an email is there any way to show to the recipient the Name and not my email in his inbox (like the second email in the image below)?
Help with file size of image uploads
All of our image uploads are being done on mobile, but all of the images that smartphones take are bigger than the file limit. Is there any way to lower resolution or something to reduce file size upon upload?
how to update a account in crm if changes made in edit in creator?
i want to update a record in account if i edit in creator account.
Fetch & Update Records in a Form
Hi, Can any body help me with deluge Script , to fetch and update the records if records already exists,and create new record if no record found. Thanks, Neha
Next Page