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?
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
Next Page