Multiple operators for Creator searchRecords API when accessing CRM i.e. And, Or
Hello, The following call to searchRecords, specifying one item of 'search criteria'...when I am retrieving all of today's 'due tasks'... tasksList = zoho.crm.searchRecords("Tasks", "(Due Date|=|" + todaysDateAsString + ")"); But if I want to further restricted this to only Open tasks...then what should I do? The following does NOT appear to work...but it may be that I have got the syntax wrong... tasksList = zoho.crm.searchRecords("Tasks", "(Due Date|=|" + todaysDateAsString + "|&&|Status|=|Open"
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");
Associate completed form with registered candidate
Can zoho creator associate the submitted form data with an already registered user?
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;
Add a Signature In Zoho Creator Page.
Hi All I have created a HTML Page in zoho creator. Page is fill by the admin and send the form to user to add signature in it and user then revert back it to admin after adding the signature. Admin will then create a PDF of that form and send it to the user. Please tell how can I send the form to user to add signature on it? Which field I need in HTML page to add signature?
fetch data from view and fill into html page in zoho creator
Hi team I have a form and a HTML page in zoho creator. I have to fetch data from zoho view and used in the input field value parameters. Please tell how can i fetch data from form view and insert into page. I can fetch one form value into another form but how can i use it in page?
How to display HTML page fields value in zoho creator
Hi Experts I have created a form in HTML in zoho creator. When I fill the form filed and click on submit button, I want to display their field value there. How can i do this?
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()))
Form Embed
hello there, how can i embed my db form in center of my website? what css or js code i should use for this. please reply me with the codes! thanks in advance!
Is there a way to create custom spacing of the tabs on the dashboard?
Currently they are side by side. I'd like to group some and place others not used frequently off to the sides.
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
Autosize on mobile device
Hi, I have what I feel is a very basic question but after building a form and re-checking everything 5 times I can't figure it out... I have build a form which allows people to register for an online ticket (nothing too technical!). At the start when a friend was reviewing (on her mobile) it autosized to fit the screen... now that I'm done it no longer resizes and the form is too big (font and pic). I've checked to see that everything is on 'auto' and I THINK I have everything but obviously not....
ZC and Ipad: Viewing a pdf
On opening a pdf on the ipad app it does not seem possible to view the actual PDF, all that I see is the link reference. There is the normal option to "Open in" another application. However it seems to export the pdf to the second application rather than actually open in the second application. Am I missing something? I would like to be able to open the pdf in pdf expert for viewing purposes Is there an Ipad forum?
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.
HTML Function call error
I click the done button and I get a null error, can anyone enlighten me as to why? Also all three of the arguments I'm sending to the function are supposed to be strings. I tried putting in text instead of trying to gather input from an HTML page and it still gives me a null error. Any help would be appreciated.
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
cant see apps in creator
i log in but was unable to see my apps i got a message saying no one as share any apps with me and if i click create new it said i reached my limit
How to fetch records from Zoho Creator Datatable using jdbc?
I have created an application in Zoho creator and I want to retrieve records from data tables using java application. Is there any way to meet my requirement?
How to get value in PDF Form.
Hi All I have created a custom HTML Form in zoho creator. When I fill all the information and click on submit button then a pdf will generated which show all the fill information. Please Help how can i do that?
Is there any autofilter for singleline field in zoho creator?
Hello, Is there any autofilter for singleline field in zoho creator? Thanks, siva
Creating Authority account in zoho creator?
Is that possible? for example.. accounting can view only this data. warehouse can only view this data personnel can only this data? is that possible?
Increase file size limitation
I need to have a much larger limit to file size uploads. Most of my uploads stick around 3 or 4 megs but occasionally I have a file that can be as much as 15 megs. This is not that often but I do need this facility. Thanks in advance. Nigel
Zoho Appbox on android
Hi, How do i find the appid for an app for use to load apps into "Zoho Appbox", android application? Kind regards, Bo Thygesen
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
working days between today and end of month
Is there any guru who can help me? I would like to exclude sundays and holidays. tks
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)?
Spreadsheet View cannot copy/paste Dropdown or Lookup field values?
It seems that the nice copy/paste feature of the Spreadsheet view (in this case copying from another record in the same sheet view) is not able to copy/paste values in Dropdown and Lookup fields? I've tried in 2 different apps, both in Chrome and Firefox. Dropdown fields (choices are defined in the form) and Lookup fields (choices from another form) don't copy/paste. Is this a bug or instead a not-yet-supported feature? Are there other field types that do not copy/paste? thanks...
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.
Form email notification with form data
Hi! I use "Insert Field" to insert form data to the notification email, most field shows correct data when I receive email, but some custom field from other form that I use "lookup" to insert shows something like this on my email: 1929807000000018033 I don't understand what's wrong, anyone can help ?
error link
For about one hour on all my applications it does not work display view ( or pages ) passing parameters via links . Example result with blank page : https://creator.zoho.com/name/application/#View:Test?Code=1 Working example : https://creator.zoho.com/name/application/view-perma/Test/Code=1 We use the latest version of Internet Explorer to date one month ago. We It is urgent , hundreds of people can not work well . David
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
when i edit the record from formreport it should update the record in zoho crm?
help
Calculating difference between two date-time fields, EXCLUDING weekends
Is it possible to calculate the difference in time between two date-time fields, EXCLUDING weekends? I need this to measure the productivity of one of our departments. At the moment, it includes the weekends, which is not an accurate reflection, since - say, if someone submitted a ticket on Friday late afternoon, it makes it look like it took all weekend plus whatever actual working time to complete the request. Thank you in advance!
Deleting dates that have passed
Hi there, I am trying to work out how to automatically delete calendar dates that are over a week old within zoho creator. Any ideas? many thanks!
Report Summary - Page Layout - Fonts
Hi I am trying to create a letter using a report summary. It seems to work ok apart from the fact that the font seems to scale incorrectly and is very small on the page. Does anyone have any ideas on what I could possibly be doing wrong? Thanks in advance.
Generate PDF in Zoho Creator
Hi Team I have created a Page in zoho creator using HTML. When I submit that page then a pdf will be generated and a email is send to user with attached pdf file. How it is possible in zoho creator?
Next Page