help to fit graph report into dashboard / screen
Hey guys maybe somebody can help me 1. Can I change the graph report size to be seeing in the window without using a scroll bar? 2. I am embedding reports like the previous in my dashboard, however the graph, even with a scroll bar, won't show the whole X axis, below the code I am using in it, I'm using a previous dashboard code so maybe I need an extra line to fit it in, thanks .monthFrame{ width: 99%; min-height:380px; max-height:100%; //margin-left:10px;
not receiving emails
hi, this is now the 3rd time within a week that we have not received emails sent through sendmail in Zoho creator. we have a production system that has been affected each time. zoho made a fix twice but the problem's back again? i called support and no one picked up. i've sent an email to customer support but no one's responded.
Can't access my uploaded documents
All of a sudden I can't view or download the documents that are uploaded to my application. Last week my staff and I could. Now they are denied access (even though they are granted access) and When I click on them nothing comes up. Anyone experience this? There is nothing in field permissions that has been changed. Help! Christine
Figures don't show up when creating report chart
As shown in the picture. There are a lot of thing that are in the form but are missing in this column to be chosen. Can anyone help me ? tks
Duplicate Application
Hi, I am trying duplication my application before making any changes, in home screen I click Duplicate Application under ICON, but nothing happens. no errors no message appears. Thank you in advance for any help or suggestions Lee
How to implement price into the form?
Hello. Could you please explain how I'm able to implement prices to the form. The idea is when person selects a certain service, the total sum should be seen in the bottom of the form. So each time when person selects extra services the total sum is changed. Thank you in advance.
Zoho creator old version
how can i go back to old interface on Zoho Creator?
API Integration
I'm trying to create an app to record our press mentions. I have created a form which creates a record for each mention, with one of the fields being a URL. In the report section, I want to show the number of times each URL has been shared on social channels using API (ex: http://graph.facebook.com/?ids=https://www.marketingtechnews.net/news/2017/may/31/how-drive-media-buying-roi-through-integrated-platform/) How can I get help doing this?
Can we call Zoho Migration tool through deluge script or can we extract data from Excel or CSV
Is there any possibility to extract data from excel file and from pdf we need urgent response . Thanks.
update record instead of create new
Hi guys, firstly I am new to this zoho, trying to remeber my ms access days, i hope you can help :) Where I'm up to, so far: 2 forms - form 1 : Customer Details, Name, Address etc - form 2 : Drop down - which displaying customer name and a Rich text format box What's happening at the moment is: Access form 2 - select Customer by name (drop down) - enter text into the Rich Text box - Submit this creates a new record every time: What I'd like to
Only posssible to see 65 records in a report, from a total of 259 records.
I ‘m experiencing now a problem when scrolling down to view all records in a report: I can only see part of then. I have 259 records and can only see 65. Before there was no problem. How can we solve this issue? Thanks
Send personalized email signature for each user
I would like to know if it is possible to add an HTML signature when sending emails. Where the signature changes according to the account from which the mail has been sent. If it can not be an HTML signature a signature image could be sufficient, but it is important that it be automatic for each account .. Is that possible? I have not found information on the subject.
Currency in zoho creator report
Team, Currency in the zoho creator report is showing in $ even if the currency on the form is different, is it possible (already) to change this?
How to edit (change information in an existing record) after opening a linked view?
When looking at a record in summary view, I am given the option to "Edit Print Delete". However, after clicking on the linked view (Project: KPTC Buildings ABCD) - there are no options to Edit or do anything else. Is there a way to edit this linked view directly? Can you please add a button to "Edit Print Delete" directly after opening the linked view? (See screenshots below.)
Under Maintenance Mode for Users
Hello, I am running an application which have 50-60 users. There are some effective changes I need to make on the app which requires people not to use the application until I am complete with the changes. In such situation I would like a click switch to Under Maintenance mode where users with certain profiles / roles as defined by me will have access to the application and others would only see an Under Maintenance alert page and cannot access forms or reports. Please let me know if this can be provided.
Positioning the pop-up date calendar
Hi Everyone, Is there a way to get the pop-up date calendar to position itself so it wouldn't get chopped off like in the attached screen shot? I also noticed the Submit and Reset buttons are centred. Is there a way to get the form centred as well? Here's how I'm calling the form. <iframe height='500px' width='100%' frameborder='0' allowTransparency='true' scrolling='auto' src='https://creator.zohopublic.com/rleiman/tutorials/form-embed/OM_Orders/sZ4vqFqP4syrKQ22x2JmQrBbQeVORKUqHj6p88VSVxADJNGfhX7gRxe7jqbOsdREQR4QbjgwbsAeaz9hNpZQDZEKazHgwMg774nf'>
PROBLEM
I am unable to access my app its showing This application is not accessible. Sorry , you are not allowed to access payroll. Please contact this application's administrator.
Image not appearing in html view to PDF
Hi Support, I have created html page which has image. I can view the image in html view. But when tried to convert to pdf, the image is not available. Kindly help with this issue. Regards, Riswan
Inserting data and lookup fields
First . I import a googlesheet named "Customers" in zoho creator. Second. I try to insert another goolesheet called "Files" in "Files" seett i had a field refers - lookup and fetch the name fo the customer Now i try to import the sheet called "Files" but i dont know how to tell the created form that the values in the field (customer) must be lookup fromthe other form. Is any solution for this???
Update email notification added user
I am the administrator, when a user asks me to update the information in the database that the user entered, how can I send an email notification, that I make the change? I try whit it, but not work (added picture)
API
what is the difference between REST API and XML RPC?
Background images
can i have a background image or change the background color in forms?
Deluge Script: filtering a view based on user input
Hi- Upon login, I want to be able to have a user select from a list of projects and then display a filtered view based on that project selection. I want to be able to do this in a script. Any ideas? Thanks.
Calculating the median by using percentile
Hi, I try to calculate the median with the suggestions made by one of your blogposts. https://help.zoho.com/portal/en/community/topic/how-to-get-median-to-work. I use a pivot chart in which I have the number of patients that had a fall per month listed. I added the formula as suggested by the answer to calculate the median: Percentile("Autoview_1498650252695_Clinical_Quality_indicato Table"."Number of patients that had a fall",50) but that does not work. Can you provide me with some suggestions
my account is inactive
my account hello@sexysexdoll.com is inactive without any pre-reminder. I have tons of customer requests there, now I can't access to my business, it makes me lose a lot of money now! this is ridiculous. Please reactivate my account ASAP.
Computation of Age
How do I automatically show the age of an employee based on his birthday input and today's date? what field would I use - number or formula field to show such automatic computation? Thank you. frsaiop
Populate checkbox based on filtered data from another form
Hi, I have a form with countries, then a form with states linked to a country. I then have a third form that you can select a country from a lookup but what I want to do is make a checkbox field appear containing all of the states associated with that country. Is this possible? Thanks
Is it possible to use the Column sum value in script
Hi, I wonder if it is possible to use the sum value of a view's column to say fire off an email when this value exceeds a certain number. I can't see how this can be done at the moment because the variable doesn't seemed to be defined anywhere. If this is indeed not possible at the moment, is my only option to add a forumla to the form which will calculate the running total of the value of the the formula field in each form? Is this method documented in the Help wiki or the forum - can't find anything!
sendmail via subform event
I have two forms: Projects and Tasks. Tasks is referenced via a subform within the Projects form, so users will only interact with the Projects form, and won't touch the Tasks form directly. I want to send an email when new tasks are added via the Tasks subform in the Projects form. I am using the sendmail function on the Projects > Tasks (subform field) > On Add Row event, without success. I suspect the problem is that OnAddRow executes the script as soon as a new row is created, but for my
Reports missing data
I have created some customer reports and some of them are missing data. I have checked the fields in the main view and they appear identical, to some that are showing in the report, can you help?
How to enter email with '&' symbol
Hi, We have an email contact that have '&' symbol in it (for example Bob&Jane@hotmail.com) and we cannot enter it in the Email Address field. Is there a work around this? Thank you.
I cannot duplicate an application in my workspace
Hai I cannot duplicate an application in my work space . Can anyone clear this problem?
CUSTOMER PORTAL EXAMPLE
Hello, anyone has an example of "Customer Portal" made with creator? I want to try it.
Can't drill down on published pie chart
Hi Everyone, I published a pie chart report and send the url to an email. When the recipient clicks the link the pie chart is displayed but they can't drill down. When you hover the mouse over the pie, the tooltip doesn't say "Click to see the data". I have a basic plan. Is there a restriction on that plan that does not allow drill downs on published reports? I can do it from the creator though. Here's the report: https://creator.zohopublic.com/rleiman/vacation-requests/report-perma/Days_Vacations_were_Taken/x8mBtFXOz4qMXyH4YnX3b5h3nAbg32mBxHE28R3p5DqfYVnCVXfH4UxtzYDVsUYkZQd36yEPM4QqjsVsW5Wuaaj9hsUHRgju9xzV
Work-around for working with Bank Account details
HiI believe Zoho Creator doesn't allow storing of sensitive information like bank account details in its forms. But most of the applications I'm building (e.g. vendor management, payroll) would be incomplete without bank account details. For instance, how can you claim your payroll application is complete if it can't generate a report containing the following basic fields- employee code, employee name, net amount payable and bank account details. These are the minimum information a bank would need
Avery 5160 Mailing Label Support
Hi Everyone, We are evaluating Zoho Creator and want to know if it has support for printing to Avery 5160 mailing labels or exporting to a PDF using the 5160 labels layout and positioning? We plan to print names and addresses to the labels. Thanks in advance. Truly, Emad
Using URL to fetch record and open in a stateless form
Struggling with a stateless form problem. 1. Public - stateless form 2. Form includes a lookup field; that once a lookup item is selected the record is fetched and the fields load with data. r = Vendor_Dispatch [ID == input.Vendor_Dispatch]; input.Description = r.Description; input.Open = r.Open; input.Close = r.Close; input.Start = r.Start; 3. URL to form has the lookup field at the end with the lookup ID https://creator.zohopublic.com/USERNAME/APPNAME/form-perma/Vendor_Invite/ENCRYPTIONKEY?Vendor_Dispatch=3080649000000690931
Custom Action Edit Function - Not Getting Saved
Hi, I have created a leave application app. In the report , I have added a custom action for leave status ( pending , approved) . I need to send mail based on the approval . I try to edit the function page , but it is not saving. I have attached the screen shot of the function Edit option
Fetch Data between different Applications?
Hello, When I fetch data among different forms in the same application, everything is ok. I am using: if(input.Project != null) { dat = Project[ID == input.Project]; ProjectName=dat.NAME_OF_THE_PROJECT; } But when I am trying to fetch the same value in another application, it's not working. I am trying the below code: if(input.Project != null) { dat = Project_Management.Project[ID == input.Project]; ProjectName=dat.NAME_OF_THE_PROJECT; } But it is not working. Can you please help me. Thanks Mustafa
Library Form - Book Issue Return - Synchronisation -Stock upadtion -issue -Return
I have 3 forms for library management - 1) book stock entry 2) Book Issue 3) Book Return book stock has fields like bookId , bookname ,author etc , In bookissue form I am fetching, bookid , memberid as lookup values . when a book is issued to a member the respective book is subtracted from stock and the report shows the details of the member and the books taken by him or her . in book return - when a member returns the books it has to be updated in the stock . (each member is allowed only 3
Next Page