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?
Company intranet
I saw a post from 8 years ago on opening up zoho to company intranet but at that time there was no solution. Is this possible now ? If so can you share a link to information around this subject? Thank you
Product Subform - change Price field
On the Product Subform template, how can I change the price field to allow for currency and for user entry at time of order? The price showing up on New Order form is rounded based on the Wholesale price. I want to manually enter the retail price that was paid for the product.
Tip: Add to forms a courtesy display of the record's Created/Modified user & date
Sometimes it is helpful, when on a Form, to know the AddedBy or last ModifiedBy user and date. (Without having to open the record summary or a view that has these columns.) Example: Simply create one function, and then for each form desired, add an Add Note field, and 1 line to OnEdit/OnLoad (takes about 1 minute per form :-) Function: Input is 4 params for created/edited by/date, output is a string containing an <hr> plus HTML table with the data. You can modify the HTML to your liking and since
Question regarding users and free subscription
Hi all, I am just getting started testing and using Zoho Creator, and have a question. I have a very simple database that I wish to share with my organization - it is simply a database of our members. I wish to have a second person be able to add/modify/delete members; I have added their e-mail address to the Application, and they can see it listed, but cannot modify it or view it. They are getting a message saying that they do not have access to that Application, although I have added them to that
Create & Update Records from Zoho Creator Form to Zoho CRM
Hi, I have a Form in Creator which have lead fields, when i create a New lead from Creator ,it should be created automatically in Zoho CRM. Need Same Functionality for Update also, Please help me how i can do it. Thanks, Neha
when i edit the record from formreport it should update the record in zoho crm?
the code i return till now record = zoho.crm.create( ("Accounts") , { ("Account Name") : input.Account_Name, "Phone" : input.Phone1, "Emplyees" : input.Employee } , 2 ) ; its updating only in formcreator but not in crm account
zoho creator for SMS reminders?
Hello, I was wondering if zoho creator can be built to send SMS reminders to recipients. I am aware that creator provides auto email reminders however not every trady uses a computer. Any info on this would be helpful. Thanks
number of unique values in the report total only
I have a standard report with managers and their transactions with clients during a month. What I need is to add a total number of (unique) clients processed this month. It is easy to add such a column using Aggregate formula but I don't need the column, only a total number of unique clients. What is the easiest way to do it? Thanks in advance! Ph
how to display data in page ?
In the form page i have username one field and search one button, enter username xyz it should fetch the username and display details in page as a table data
Export Master and Sub Forms data to one spreadsheet
Is it possible??
unable to edit when i click on insert html from pages?
when i click on insert html from my page unable to edit or do something.after clicking nothing is working.
Problem with Google Apps Integration
I probably created this problem, but now I can't seem to fix it. I had an app with "Google" authentication setup on the General settings page. Since we are a Google apps domain, I went through the steps of enabling Zoho Creator on our apps domain (installed it on our domain and enabled "Google Apps" on the General settings page. After doing this, I discovered an OAuth 2 error when any of our sub-domains try to log in with their google apps credentials (we have a primary domain with some users, and
Bug creating a list
Here's my code userID = users_form[Email == zoho.loginuserid]; Location=userID.Location; proj_list = (project_form[Location.contains(userID.Location) ].Project).getall(); The obtuse error says Error at line number : -1 Improper Statement Error might be due to missing ';' at end of the line or incomplete expression project_form is a database of project names each one having a multi-select of locations I'm basically trying to make a filtered list of all projects ("proj_list") with the commonality
Date and time difference in Days, Hours, Mins
Hi, I have a formula which calculates the difference between two date and time fields. It works, except I have it set so it only displays difference in hours and minutes. (((((((Task_Completed_Date_Time - Request_Date_Time) / (1000 * 3600))).toLong())) + " Hours ") + (((((((Task_Completed_Date_Time - Request_Date_Time) / (1000 * 3600))).toDecimal() - (((Task_Completed_Date_Time - Request_Date_Time) / (1000 * 3600))).toLong()) * 60)).toLong())) + " Mins" What would I do to have it
I have Copied my Application and it is showing Copy of Application
How i can remove Copy of from the Application Name. Thanks, Naveen
Record summary horizontal label adjustment
Hi, I need to know how I can adjust the horizontal position of the label-object for a field. I looked through the options of "Format Label" but couldn't find anything besides the left-middle-right alignment options. I thought it might be possible using the "edit as html"-option but after trying several commands I gave that up. Can somebody help me? Thanks, Hans
I need help ?
i want to create search interface? till now i have done this created stateless form containing username and search button here is code(in registration form i have username, firstname,lastname,email,address) if (Registration_Form[Username == input.Username].count() > 0) { x = Registration_Form [Username == input.Username]; } else if (Registration_Form[Username != input.Username].count() > 0) { alert("Invalid username"); } if i enter username and click on search it should
auto filters should respect "set criteria"
Suppose there's a dropdown field "Group 1 Reviewer". This field is linked to another form which contains names of all possible reviewers, as well as the group they belong to (a text field "Group"). The "Group 1 Reviewer" field has a criterion "Group == '1'", since I only want the dropdown to show names of reviewers who belong to Group 1. Now when I add this "Group 1 Reviewer" field to the auto filter in a View, when I try to filter while accessing the View, I can see all possible reviewers, not just
Importing data into related tables
I have a csv file with data for three related tables and want to import it but am not sure best to go about it. Curriculum -< Course Course -< Lesson Lesson -< Resource Do I import them all at once or once each for each table?
Is it posible to run script auto updating a field when one of the fields used to find it is its self being calculated with script?
Hi I know this may sound link a big ask but I would like to use this in a couple of places. I would like to calculate a total from rows in a sub form the problem is that the field in the sub form is pulled from the CRM rather than being user entered. I also would link to us this total in a formula field (i.e that this fired and subtract another calculated value to get a figure for the profit. Any thought would be greatly appreciated. Cheers Dan
Lookup Dropdown default value
How can i set Lookup Dropdown default value?, I have a Cliente Lookup Dropdown. I capture the client ID and with it i get the contact ID, based on that I want to set the Contact Lookup Dropdown to this value. With the code i get the value and i have in the Dropdown the select option and the value, I want to have the value, not the select
Zoho Creator auto email
I know there is an ability to send an email when people click submit on a form. But how can I send an email that contains the data that was filled out in the form. Also, is there a way to trigger emails based on a specific field that was filled out. For example if in the dropdown "Color" someone selects "Blue" I want it to go to person A and if someone selects "Red" I want the email to go to person B. Sorry if this doesn't make sense but I've been working on this for a month and cannot figure it
un/share deluge task too restrictive
I was really disappointed at how limited/restricted the deluge share task is. What should have been a simple 1 line loop has turned into a 100 line routine due to the fact that this task requires a hard coded name that is validated for its existence at design time precluding the simple use of tables rather than : for each rec in permissions[] { share (rec.item,user.email); } we are instead forced to unwind it for each and every possible sharable item : if(item=="xxx_tab1")
UI issues with position:fixed headers
Is anyone else having issues with the report headers? For the Zoho Team... I checked out the console and it looks of course like position:fixed is used with a scroll spy event listener to update the top css property. The issue is probably due to the fact that a dialog (with screen mask) jossles the scroll but doesn't fire the listener when closed.
Create Formula for Pickup Value
Hi, I need assistance to set up a formula to match values between 3 drop down list. I have 1 drop down named it as ITEMS with 2 listing. HDD and RAM. The 2nd drop down named it as Size with 2 listing..4 GB and 8 GB. The 3rd drop down names it as Cap with 2 listing..100 GB and 500 GB. Who do i write the expression to show that when i choose HDD it should only shown Cap with 2 listing? Highly appreciate your assistance.
Validating File Uploads and Disappearing Uploads
I want users to be able to submit up to 5 attachments via File Upload and I want to validate those attachments. To do this, I have a Dropdown list called How many Attachments with 1 through 5 This dropdown list will either show or hide the appropriate number of file upload fields. After they upload the files, and click Submit this On_Validate script runs: if (input.How_many_Attachments == "0") { input.Attachment_1 = ""; input.Attachment_2 = ""; input.Attachment_3 = ""; input.Attachment_4
Is there a program available to open/edit .ds files?
Hello, I am trying to import a .ds file to duplicate my application for testing purposes. The application is built on an older version of Zoho Creator, and there are scripts in the .ds file that are no longer supported in new applications. I'd like to edit these out of the file, but I'm not able to do that on import. I have attempted to open the file in WordPad and Notepad, but I believe this corrupts the .ds file. It generates incorrect characters that I believe interfere with the import (in addition
Sorry we are unable to regenerate this report
Hi, I am unable to regenerate data in my report. When I select regenerate I see the message 'Sorry we are unable to regenerate this report' Please advise Thanks, Kris Tyte
PRD refresh to DEV
I have a Zoho Creator App which I have been using for years. It's PRD and I never had a DEV version of it. Now I want to create a clone of PRD and call the clone DEV, in another Zoho account. In the future all development and coding will be done in DEV, and from DEV I will push incremental changes to PRD.... how this can be done ? this is in a retroactive fashion... usually u create a DEV then do a copy from DEV to PRD and call it system copy... thanks!!!!
zoho creator export
How can i export report from zoho creator with PDF format but keep the headline for each page?
Criteria with space and date add time
Hello, Could you help me in two items: I'm trying to make an API via query by using: https://www.zoho.com/creator/help/api/rest-api/rest-api-view-records-in-view.html # 1 - But I can not seek criteria containing space. I can get situation = Cancelled I can not get: situation = Waiting Sale How should I do? # 2 I would seek also to seek the registration date, as I do? Added_Time> = 4-May-2015 11:13:10 It does not work. How should I do? Tanks Tulio
Help with html code
Hi Before I start, please excuse my lack of knowledge regarding the correct language/terminology to use in this request for help! Our IT Manager (with the assistance of a very helpful developer she found through this forum) devised a report in Zoho Creator using html - it pulls together lots of information from different forms within the Zoho database she created, in to a lovely looking health and welfare plan for each child at our school. There is a consistent field (child's name) within each of
Next Page