How to show records from Zoho Reports in a paging table/grid?
I am trying to use Zoho Creator (ZC) to allow a user to select a range of criteria and return a list of records. These records, however, are not stored in my app but in Zoho Reports (ZR). There could be a million or more rows in the ZR view. I want to show the selected records in a grid so the user can select one of them and show the record in a read-only form. I have already written the read-only form as a Page. I can already read the data using the ZR API but I'm struggling how to show the records
My Account is inactive
Hi Support team, My business account (email phuongnam@vpppn.com) returns "Account is inactive" when I try to log in to Creator. Unfortunately, the locked account also means that I cant access my previous business emails and business CRM data having a major impact on my business. Could someone please activate the account as soon as possible. Thanks a lot for your support, Loi
No Image Field Action? [ Resolved ]
My record has a field to upload an image. I also have a field to display the image. On Load, if there is no image shown in the image field, I hide the field used to display the image. What I want is for the field to appear and be filled when the user selects or changes the image. There is no field action for image fields. Is there some way to do this?
Error importing the app in Zoho Creator
Dear Zoho expert, I meet problem when importing the app into my home, maybe because it has many row. When I import the scrip window appear, and no app was imported after that. I tried to copy this script and paste into new app, but the error is null, and I can't meet my app again in home. Can you help me pls?
Online booking System with Zoho Creator
Hi, I am trying to create Online Booking System with Zoho Creator. Problem i am having is: Staff allocation, E.G We have 5 person and each of them is available 9-5PM. I need 5 Columns in Calendar Day view with Staff Names. If it possible i can achieve this which Zoho Creator ? Image is attached for the reference.
How can I disable a theme?
Hi everyone, I'm developing an app in Zoho Creator and I wanna to use pages ans custom HTML to navigation, but I don't figure a way out to disable or hide the standard themes. Is there a way that I can hide or disable standart themes? Best regards, Eduardo
Can Zoho replace Google Sheets ?
Hi We currently use a stack of Google Sheets to run some of our business functions We use it to manipulate data and create reports. Some of the key things we do are 1 . Import lots of changing data 2. Modify it in some way 3. Export data back to our website Is Zoho a more stable replacement for this? Google sheets has issues with the amount of data and imports we use. Ian
very slow in loading the page
Hi, can you please fix? The loading of pages are very, very slowly and it started yesterday. https://creator.zoho.com/accounts12/abn/#Page:New_Business_name
Multi-valued fields in MS Access
Hello, I have an Access database where the main data table has many multivalued fields. I imported the database into Zoho creator and all the tables were created but the data in the table with the multivalued fields did not import. All other data in tables without multivalued fields were imported correctly. Any ideas?
print html page in small size paper
Hi, Greetings! I have a requirement to print the html page in creator as a gate pass or as a event ticket or as a hotel bill. In these cases, I may use a thermal printer and I need to print it in a small size papers (like hotel bills/ gate pass). Is it possible to change the paper size or print properties from creator? Or else how the above mentioned requirement can be achieved?\ Please help me out it is an emergency. Thanks, ITKES
Zoho Creator iPhone App Geofencing Problem
Hi, I've created a simple form that can only be submitted by a user from a specific geographical location using the geofencing option on the right panel in form builder. I tested it out by trying to submit a form from an iPhone 6 Plus, iOS 10.3.3, location services for the Zoho Creator App are turned on. When I click submit, the Zoho app says it's unable to determine my location and to turn on location services. I'm at a stand still, can anyone provide some insight? Thanks.
Unable to translate captcha content
Hi, My native language is Portugues and I can't translate the captcha! =/ Will have in the future support to do this? Thanks cabello
Where is data stored ?
In Canada we have a data privacy act we must comply with, and there are concers about the Patriot act in the US. Is Zoho data stored in the USA, Canada, or elsewhere ? markv
input.user
hi Zoho Support Would like to check whether will this deluge work? input.users="abcd@zoho.com"; Regards
On Update Form Script Not Working On Multi Select
Hello Zoho Community! I'm having a bit of a problem. I've got a deluge script that runs on update in one of my form fields. At this point I'm just using the following script for testing. info 'Can you see me?!?'; If I edit a single record from a report and edit the appropriate field, I'll get my 'Can you see me?!?' prompt. But, if I select two or more records in my report and update them, I'll see no info box at all. Am I missing something here? I thought the code in the "on update" section
Email Updated record
HI I'm new to Zoho so sorry if this is a basic question, feel free to point me in the right way of some documentation to read. The issue I have is the database (A facilities management database) emails certain people when a record is added. This works well using the email notification setting with the default template. The issue I have is making it recreate the exact email when anything is changed or updated in the record. This might be contractor assigned or notes added. I want it to send all the
calendar report filter
hi, i have a calendar report based on a form "task" in which there is an user textbox and a partner multiselect. we are 4 colleagues, and i'd like to make a filter that shows record in which the user is selected in "user textbox" OR in "partner" multiselect. thanks
How to bring other fields from Zoho CRM when choosing one contact?
Hi, Im not the most experienced in Zoho Creator so any help is well received!! I have been trying and still cant figure it out. When I build my form, I am able to choose a Zoho Crm Contact Button to put in my form. I would like that when I choose my Zoho Contact, some information such as the Mailing Address, City an Email are brought to my zoho creator form automatically. I have read about getmyrecord by id but haven been able. Can anyone explain better than just posting the link about getmyrecord?
Unable to share applications
I have not been able to successfully share any Creator applications with other Creator users. We have all walked through the "Share Application" resource documentation, but have still be unsuccessful in being able to share any of our apps with each other. The message we often see is: You have logged in as --UserName--. You are not allowed to access this application. Please click here to login as a different user. Click here to go to your Home Page. We are currently using the Professional edition
Website designer is unusable.
Most of the uploader pages stay stuck on a continuous loading screen. I left the picture uploader on to see how long it would take - 45 minutes before I gave up. I have Zoho Mail and I love it. I've been wanting to use the website designer for quite some time because of the price and all of the features. This is extremely unfortunate that the website designer is so unresponsive. I checked the status page, everything is running fine on their end, but on mine, terribly.
Date Field
Hi there! How can i make a date field where the user only selects month and year, but no day?? Thanks!!
Text orientation for PDF export
Hi everybody! I´m trying to get a record summary to export some headings written vertically when sent as pdf via email. i introduced the next code to the html editing box for the heading: <h1 style="text-align: center; writing-mode: vertical-lr;"> <font color="#ffffff" size="2">PRECINTO</font> </h1> I have to issues: - When the email is sent it delets the code leaving it like this: <h1 style="text-align: center;"> <font color="#ffffff" size="2">PRECINTO</font> </h1> - I whant
Occasional Invoice Fails to Generate
Hi, We've recently started using a laboratory information management system designed in Zoho Creator, which is connected to Zoho Invoice for billing. I've just noticed two instances of tests ordered in Creator which did not generate an invoice. What's the best way for me to trouble shoot this? Thanks, Chris
Rebranding not working
Two problems (so far) with the rebranding feature. 1. When I try to upload a logo, I can browse my files and select an image, but when I click "Upload" either the three blinking dots blink momentarily or they blink indefinitely without result. 2. When I enter a company name and click "Save", the company name disappears and is not saved. I have an Enterprise license. I have tried this on two browsers, both on Windows 7, Chrome 34.0.1847.131 m and MS-IE 11.0.9.9600.17041.
How can I set a form to automatically fill a time/date field when a decision box is marked?
Hello, I am trying to set up a field that stores the time and date when a decision box was marked positive. I tried a couple ways in workflow but I couldn´t get it to work. Thanks
How do I get my reports to automatically refresh with updated information in forms?
We currently use reports to store and sort recipes... If the cost of goods changes and we change it at the source, I would like for the reports to reflect the most current price. Is there code I can add that tells the report to refresh with updated values when opening?
Sign out from Portal
Is there any command that will sign out a customer portal account? I have a page embedded in my website that requires a Customer Portal sign in. But there is no option to sign-out. Even closing the browser does not sign the person out. This can be a problem on public computers!
stateless form embedded in html page to input a parameter
Hi, I have an html page that has to make same queries/calculation based on a parameter. This parameter has to be defined in a stateless form. Is it possible to embed the stateless form in the html page and use a form's field as parameter for the html page? tks pippo
Hide/Show help
Hi I have the following fields Radio Button 1 (two options yes/no) Radio Button 2 (two options yes/no) Check Box Date Single Line. All fields are hidden on Form load except Radio Button 1. When Yes is selected on Radio Button 1 I want Radio Button 2 to appear **** ALL WORKS FINE UP TO HERE ******* When Yes is selected on Radio Button 2 I want the SINGLE LINE and DATE FIELD to appear and CHECKBOX to hide When No is selected on Radio Button 2 I want the CHECKBOX to appear and SINGLE LINE and DATE FIELD to
Custom actions
Hi My problem is taking place in Report>Custom_Actions. I would like to create a button which update a quantity. The button in the Purchase Report update a quantity in the Stock. My script works on Success on Form Actions but not on Functions. Here is my script fet= STOCK [ID == input.Add_Product.REF1]; fet.Quantity = (fet.Quantity + input.Add_Product.Quantity); Error at line number : 3 Variable Add_Product does not exist in PURCHASE Why something which works on Sucess can not work on Function?
Auto populate data when lookup field is auto-selected
I have an email address lookup field that is auto-selected based on loginuserid: emailToSelect = Employee[Employee_Email = zoho.loginuserid].ID; Employee_Email_Address.select(emailToSelect); Now, when I add a new record and on form load (not 'on success') I want my form to auto-populate additional information related to the employee that is auto-selected via the above code. The following code works, but not on 'On Add' --> "On Load'. if (Employee[ID == input.Employee_Email_Address].count() > 0)
Users do not see my shared app
Hi, i made a basic subscription made an app, then invited a guy, that can use the app then invited two other users, but they do not see my app at all. help
Send a single email with multiple recipients; selected in list view
Hello everyone, Searching the forum and several zoho creator wikis did not enable me to set this up by myself, so I decided to post in here. I think the topic pretty much explains what I am trying to do. I'd like to add a function/custom action which puts the email field content of the selected records into the bcc field of an email. (bcc: email1@qwe.com, email2@qwe.com)
Sharing
I tried my first share with an employee. One report is not showing up in her menu and the Edit pencil icon is not available in the other main report I need her to use. Any ideas what I did wrong on the share?
Issue Passing Search Parameter to HTML Embed Form
I am trying to embed a search box and a report in a custom HTML page and pass search parameter from search to view. I have tried using openURL and am not sure what is the correct way to accomplish this task. Any input will be appreciated. We really want to include a lookup in the search box also to find records in the embedded view if possible. I tried this in the stateless search form On Click event: openUrl("https://creator.zoho.com/..../..../#View:Master_Schedule1?input.Employee_ID_Number=" +
Zoho Creator App Restore from Backup Does NOT Work
Thought I'd get this out to the forum in the hope we can shame the Zoho team into speeding up the resolution:)...and perhaps where others have had the same issue and have discovered a workaround to avoid the manual updates required... When you restore an application from a previous backup, the following elements are NOT restored, which can lead to significant manually updates being required to fully get the app back to the previous state: 1.All Report Restrict Visibility settings are lost - any reports
Zoho Creator + QB integration, halfway done, stuck at retrieving QBid from response
I have a Zoho Creator app (Form) that successfully creates an invoice in QB. Here is the sample response received @ ZC end. I am struck at how to retrieve the QBid from this response. (Attached is the response for a dummy invoice generated in QB via ZC, ID=9) Has anyone here integrated with ZC-QB? how do u handle info-retrieval from the auto-generated response? Pls advice Any help is great help Thank you Deepa Govind -Deepa Govind http://homepreneur-online.com/
Function to reduce code duplication?
Hi, In my calendar view, I have the event title set as the 'Calendar Name' field. I run the following code when a record is added, but also when it is updated. This creates a useful event title for me in the calendar view. brand_lookup = Brands [ID == input.Brand]; type_lookup = Types [ID == input.Type]; if (type_lookup.Type == "Special Event") { input.Calendar_Name = input.Description + " - Special Event"; } else { input.Calendar_Name = brand_lookup.Brand + " - " + type_lookup.Type;
How to Publish a page in zoho creator and access it without login
Hi team How can i publish page in zoho creator? I know how to publish a form in zoho creator. But how can i publish the page without login access in zoho creator?
Sending form field data with mailto:
I have added an "Add Notes" field to a form which will be visible when editing a record. The note contains a link with a mailto and I want to send some of the fields as an e-mail I first tried to access the fields directly, but that didn't work. Example: <a href="mailto:someone@somewhere.com?subject=<%input.Title%>&body=<%input.Content%>">Send this record via e-mail</a> I then tried to generate a populated mailto:-link in the onLoad script. Example: Send_mail_link = "<a href='someone@somewhere.com?subject='
Next Page