VLOOKUP
Is there a VLOOKUP option in creator like in ZOHO Sheets?
Grant Admin / Edit access to a registered user
Hi Creator Community, Is it possible in Creator 5 to assign one of the users of an app to be a co-admin so that they can also edit the app? This doesn't seem possible via the users and permissions tables in the app settings nor in the user list on my
Filtering data by an URL
I am using the filtering data by an url facility as you suggested by the example: http://creator.zoho.com/sampleapps/company-details/view/User_View/criteria/Name=James/ In your example there are filtered all the records that have the field �Name� equal with �James�. What I need now is to filter the record where the field �Name� contains �James� . Any suggestion? All the best, Doru
Bugs in "Record Summary Template" feature
Hi there, I just tested the "Record Summary Template" feature for Zoho Creator. First of all: Great idea - this is exactly what we've been waiting for! But there are three essential problems / bugs: 1. If I want to fetch values from a related form/database, the record summary only shows values that were originally added as free text (string / in may case: single line). If I want to include values from the related form that come from e.g. dropdown-menus or radio buttons etc. it just doesn't show up
I love Zoho
It's very useful in my field of work... I would 100% recommend this to my friends. :)
Zoho Books Integration with Creator
Is Creator going to be integrated with Books? Or is it already and it is not in the documentation yet? Bruce Letterle Red Lab Media
Multi language survey
Hello everyone, How can I add a language option in published zoho application? I want to make a survey and the first option will be language and the rest of the questions will change according to the user input. Looking forward to hearing from you. Thank you! Aroub
Is Zoho Creator HIPAA Compliant?
Hello. I am working on several projects that require HIPAA compliance and would like to use Zoho Creator for them. M My main question is Zoho Creator HIPAA compliant? If so, how do I prove to my stakeholders that it is? They just won't take my word for it - I would need written documentation from Zoho to verify this. Are there any links that show this? Does Zoho have other products like CRM, etc. that are also HIPAA compliant? Thanks. Rich
rtl support for Creator
I would like to add my vote for rtl support for Creator, including form labels on the right of the fields and all right aligned.
zip.extract() throws error 'Error at null' for uploaded file.
here is my code - zip = input.image_file; file_collection = zip.extract(); error: Error at null
Multiple Form report
Newbie question: In my monthly budget planning app I have following forms: Expense Category: [Category] Expense Subcategory: Lookup [Category]; [Subcategory] Expenses: Lookup Expense Category: [Category]; Dynamic Lookup [Subcategory], [Amount]; [Date]; [Month(Date)] Budget: Lookup Expense Category: [Category]; Dynamic Lookup [Subcategory], [Amount]; [Month] Now what I would really like to achieve is to build a classic report summarizing expenses by Subcategory + an info from Budget how much was budgeted
Changing the Names and Pictures of users added to the Customer Portal
How do I change the name and pictures of customers added through the customer portal? When I add them; their name is just their becomes their email address with out its domain. Also I dont have an option to update their information or tie their information
Pivot tables not updating
Does anyone else have consistent problems with pivot table data consistently being wrong or out-of-date? We have some simple forms/tables that have pivot table reports, but we constantly have to click Regenerate or Refresh and half the time that doesn't show accurate data. We've chatted with Support multiple times to no avail, so we wanted to get the community's take on this. Thanks!
Creator : Calculate Hours/Minutes between two time fields
I have two time fields and need to know how many hours and minutes there are between them (and convert to decimal if possible). Every thing I've tried is either for datetime data types; won't let me do calculations on time fields or the function timeBetween()
Formula to calculate total number of products selected in a Lookup field
Hello there, I created a form to log all the orders received for certain products and the quantity ordered. Here's below you can see its related report: Now, I am creating another form, where I can select anyone of the items in "My Products" through a
More resolution for maps
I'm creating a simple application for listing properties and have noticed that the map provided for reports or location is from Open Street Maps with low resolution and many streets are not named. Is it possible to get a higher resolution map like the
Exporting report as file to other report
Hello Folks, I have a requirement to download report from Creator using api. But there is no api to download report. Data api have report view functionality but I can not sort data and if some one changes are order in report my functionality will fail.
integration
hello urgently needed Zoho developer application front is built or he can build it from scratch I want to integrate woo-commerce to a Zoho creator application (customers -orders-subscriptions-tickets) get data and add data (two ways) more information
Changing the year start and end dates by app
I have an app that contains a lot of financial information that needs to have a start date that isn't January. When I try and filter any report using the relative ThisYear or NextYear options it defaults to January - how can I change it ?
OCR Field
i can't find ocr field in my zoho creator
Populate a lookup field
I've been searching for an answer to this question. I've been able to auto-populate a field using: input.Notes = "sample text"; without any problems. But when I try and set a field that is a lookup it does nothing. For example, I have a service code field
Form does not load
If I am not logged in, the form is stuck in loading mode. I can see the form title, and a little spinning circle but the form fields do not load. This form is public. Any idea as to why this happens? How do I fix it? http://creator.zoho.com/d2x2/smyths/form/2/
sending email in html + css
Hi, How do I code a custom email with html with css coding? I've using an email template with css. Can I put <head> <!-- If you delete this meta tag, Half Life 3 will never be released. --> <meta name="viewport" content="width=device-width" /> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>ZURBemails</title> <link rel="stylesheet" type="text/css" href="http://zurb.com/playground/projects/responsive-email-templates/stylesheets/email.css" /> </head> Regards Umar
Find/replace in a Zoho Creator report (spreadsheet)
So far I think Zoho Creator can do everything I need without coding to make a product database ... But I need to be able to find/replace across the spreadsheet view (report) of my information. Zoho's email support suggested that I use Deluge script. Can anyone give me a quick description of you to say find all the instances of the word 'axelotl' and replace them all with 'axolotl' across all of my data and all of my fields? When I'm viewing the spreadsheet report of my information (in 'Access this
CREATOR Admin Name issue
Guys, I'm using Creator through Zoho One. In the Zoho One admin panel, I'm listed with my email address as Super Admin for the Creator app. Within Creator, however, I am listed in each app with my email address as admin (good) but with a different name
Can a form in Creator access/alter data from Inventory
I am trying to set up an inventory check-out system for our employees when they pull materials from our internal inventory for their department. I am trying to figure out if there is a way to allow Zoho Creator to access Zoho Inventory and deduct the
Availability on date
I want to buy the dates and time in which I have spaces available for attention, that if there is a date that is not available, it does not allow to schedule that space, is this possible?
Remove country code
Hi there, I am based out of Australia. I have a phone number field that is defaulting to Australian country code +61. Since all the phone numbers in my zoho records are in Australia I would like to remove the country code from the field? Can you please
Field Navigation Order
Field Navigation Question. Is there a way to change to the field navigation order within Creator. I have a two column form and fields seem to tab or flow based on when I created the field instead of the natural flow order of the input fields, can I change this order to make it a more intuitive input flow for the users?
Where do I find the Hex color code for the default chart themes?
Hi As it's not possible to change the colors in the charts, I want to add identical colouring to the numbers (on Panels) below, but I can't find the Hex values anywhere. Can someone point me in the right direction please? Karen
zip.extract() throws error 'Error at null' for uploaded file.
here is my code - zip = input.image_file; file_collection = zip.extract(); error: Error at null
Mail merge template on Quote module
Hi! Is there a chance to Zoho offers mail merge templates for Quotes Module in te near future? There isn't on native product.... only on custom module? Will I have to create a "custom quote module" to acess mail merge template? Tks Paulo
Customer Portal URL
I added the domain in the Customer Portal URL area. But when accessed by the new domain, the application does not appear.
Can you put a Currency field's symbol on the left of the field?
My currency fields show the correct symbol (£) but they put it on the right of the field (see screenshot). That's not how we use the currency symbol in this country. Can you change the currency symbol to appear on the left? Many thanks Steve
Export image fields as public accessible link
Hi there! I have a database with product master data and 3 image fields. I need to export/analyze the database through ZOHO Analytics and retrieve a public accessible URL of the product images. Example: Product name: iPhone 8 Plus 64GB Product image 01: https://www. ..... Product image 02: https://www. ..... Product image 03: https://www. ..... Do you guys have an idea how to achieve this? My workaround is to upload the pictures to ZOHO docs and paste the public to a text field, but that is
Page editor frozen
Hello community, I hope you are very well. I´m having a problem a problem with my apps. I have a form with a few records, and I am trying to make a page with some indicators, so I went to the page editor, i took the "New Employees this month" Panel from
Print calendar?
Is it possible to print the calendar in Creator? It only lets me print a list or summary
Hide or archive records?
I have lots of date-driven records, so I’d like to hide or archive records at the end of each month. How would I do that? I don’t want to delete them.
Fetch Leads from crunchbase.com
Hello! Say for example I would like to integrate third party websites like crunchbase.com with Zoho, is there any way that I can do this, perhaps via API or customising via Deluge Scripting? Cheers Zhili
Zoho Creator Published Form on Wordpress Page
Hello folks, I tried to embedd a published form from Zoho creator over iframe and with the permalink into my wordpress page but the form isn´t displayed. The frame is loading and says: creatorapp.zohopublic.com has refused the connection. Tried also over
Next Page