Multi language support
I am using a trial version and have added data in multiple languages, as well as have fields in multiple languages. Will this feature still be available to me after the trial period is over?
triggering a beep/tone/sound as an event
When filling out a form, I'd like to provide the user an audible confirmation during certain events (for example, On Edit/On Load). The user is entering data away from the monitor and the tone will indicate a new record is loaded and ready for inputs. Is there a method to provide an audible indicator that's triggered in an event?
Zoho creator api authtoken changing on their own.
We seem to experience a very regular problem where the zoho creator authtoken is deleted or removed from our account. When this happens crm stops sending records to creator via webhook and we loose records, sms messages that should go out to clients etc. We need something to let us know when this happens. The authtoken gets deleted and we loose all of our sms messaging systems. It is difficult to know if they are working or not and this is becoming something we need to check weekly in order to
Using Form and Note field to display images but the images will not work in published links
Hello I have a custom action that opens a URL to a Zoho Form that my clients use to edit and approve reports. We use a note field to display images, but it has come to our attention that the images do not display. We have recreated the problem and it seems the pictures only display within Zoho and not in published links.
Lookup Refreshing
I have 3 lookups (for another app) in a form that Fetch Countries. The problem is that if I create in the first lookup a new Country record this will not appear in the second and third lookup selection. So I need to refresh the form. Which is the best way to update the other lookups without refreshing the form and loosing the already filled fields. Thank you,
Customer Portal Allow New Entries
Hello, I setup a customer portal for the app A, I have a form with a lookup that fetch information for the app B also I enable the option to Allow new entries. When I access thru customer portal the Allow new entries option doesn´t appear even though the user have all permissions. Its not possible to create records to another app thru the customer portal? Best Regards,
How to check the value of lookup is selected or not
I have one lookup in which i have names and after selecting names i am displaying the address of the selected name.but if the lookup value is not selected then i want to display the text-boxes to accept data from user.I have "-Select-" field at top if user selects that "-Select-" then i want to display the text-boxes to accept input from user. how can i do that.
Pros and Cons of sometimes using a separate app (vs. adding to existing app)?
Could we use this post to collect wisdom on the behavior / capabilities / strategy of adding more as a separate app vs. adding to the same app? I'll give a start from our limited understanding. I haven't seen this discussed in the Help or on the Forum -but please provide links if it is. (We have a "main" app with a suite of some 30 tables/forms and associated reports, etc. But for 2 others, we've made each separate apps, mostly for their own unique security -Enterprise license- and unique customer
Add records from zoho crm to zoho creator raise permission denied using rest api
Add records from zoho crm to zoho creator raise permission denied using rest api
Search across all fields in a form to return matching results
Hi all, I've got an application that contains a form (A) that has several linked parent forms (i.e. so form (A) has many drop-downs that change dynamically based upon results chosen). I have created a stateless form for a search function. I'm now trying to search each of the fields to see if it contains the value I am searching on. I I have create a HTML view ready to display the results (using field names and op_26 - i.e. Field1=<value1>&Field1_op=26&Field2=<value>&Field2_op=26&etc...). However,
Basic Student/Class Enrollment Example Needed
Hello, new to Creator and just can't figure out what I'm sure is the most basic of requirements: I have two forms: Student Class Student form has a lookup field to Class as multi-select with Bidirectional Relation checked Class form has lookup field to Student as multi-select with Bidirectional Relation checked I can easily enroll a Student in multiple classes the issue comes with reporting I need to run a report that shows the individual students enrolled in a class: Class Name (3) Student 1 Student
Record adding from zoho crm to zoho creator gives permission denied
zoho creator give error permission denied while adding record from zoho crm to zoho creator using creator api
Conditional payment based on user input
Is there a way to make the recurring payment on the form conditional based on a particular input the user gives on the form. Example : if the user says Monthy Payment it is process as a monthly payment . If the user specifies Annual payment it should process the payment as one time. Thanks.
image on user input
There is no 'on user input' for an image field. Is there any way to detect that the user changed the image before they submit the form?
[SOLVED] How to change a value from one form which resides in another & create a function that changes the status.
Hi, This whole "Not having to code a single line" for Zoho is proving itself not quite true... So.. I have two forms. A and B A has B as a subform A has a status dropdown I wish to change this status dropdown on form A FROM form B(From standalone form, not as a subform) . How do I do it the best way? AND Can I change the value of a radio button depending on the value from a textbox? Thanks for all the help! /V
Best way to create a printable Invoice lay-out
Hi, I need to create a couple of lay-out's for quotes, orders and invoices which can be send in PDF by mail to customers or can be printed. What is the best way to do this at the moment? Kind regards, Johan Boerema
Copy filed value to other fields in the same form
Hi, I'm building my first application in Zoho creator. I was wondering what the best method is to copy a filled value to other fields in the same form. I've got a visit address field, which should be copied to post address and delivery address (when they're empty). But the field should stay writable, so the user can enter another address when needed. Kind regards, Johan Boerema
add record does not work in mobilecreator.zoho.com
Dear all, I just became a new user and am testing the functionality of zoho creator. One obvious problem I encountered is the script below not working on mobilecreator, but it can work on creator.zoho.com I create a form and add one single line field and just want to add a new record when click on the submit button. I dragged "add record" in script builder and got code below. insert into test_form [ Added_User = zoho.loginuser test_abc = "1111" ] however, it reports error "Improper Statements/Expressions
Html view minor problem se pictre
I need help badly, please see pic that i want to do. it seems i cant find "annoucement and new hires to edit the text. from this.. to this. this is the code : htmlpage Homepage() <%{%> <style> #mainDiv a:hover{ text-decorationderline; } .announceLine{ border-bottom: 1px solid #F1F1F1; font-size: 13px; line-height: 32px; list-style: none; } .quickLine{ font-size: 13px; line-height: 26px; list-style: none; } .mySub { overflow: hidden;
Pie Charts from data in Zoho Creator
Is it possible to create pie charts in Zoho Creator? If not directly, do you have any suggestions? I have a client that I think Zoho Creator would be perfect for, but they insist on presenting some data in pie chart format to management. Thank you, David
Zoho Creator -> Changing date regarding input
Hello, We are working as a travel agency with rental bikes. When the time of arrival is after 16:00 for example, I would like to book the bikes for the next day. Thus when we fill in time of arrival > 16:00, the startdate of the bikes should be the arrival date + 1 day. Is this possible? Looking forward to your reply. Thank you very much! Kind regards, Luc ten Haaf
Date format
Hi, Is there any function that I can convert the below date format Actual : 2015-08-14 00:00:00 Formatted: Friday ( only extract full day name) I want to convert the actual date to Full Day name only. Thanks Arfater
Pop ups on html pages
I'm told that opening pop-up windows (openUrl) in html pages is not possible. Are there any other workaround to accomplish this? Thanks.
Current Date Recalculated Daily
Dear Zoho, We really need help with a particular formula. We run a debt recovery company. We have an app at https://creator.zoho.com/zoho_zubin/copy-of-collision-accident-recovery-services# BACKGROUND: 1. The app has a form called "New Claim". That's the form we use to create new records. 2. The form produces a report called "All Claims". The purpose of the report is to help us look at records based on the age of a particular record. We want to be able to know how long we've had the record open just
Populating email field based on CRM user
I have created a form in Creator that is being launched from the CRM app. I would like to auto populate the name and email address of the user submitting a request in the form. Is there a way for Creator to retrieve/fetch the username from the CRM? Thanks in advance for any assistance or guidance.
Refer to field in another database
I'm working on script for a basic form. On that form, there is a Lookup Field that connects to a form in another database. I'd like to pull-in information from the form in the other database based on what's entered in the Lookup Field, is that possible? Here's a bit more detail: There is a Task form. It has a multi-select Look-up field: Person(s) Responsible. The dropdown menu for that look-up field (Persons Responsible) is based on a Team Members form in another database. Included on the Team Members
Concatenate text fileds to keep running notes about customer interaction
Dear Zoho, Could you please help wit the following problem; 1. I have a record keeping app called Concatenate App. It's designed to keep notes of conversations or other interactions that we have with customers. Please access it at https://creator.zoho.com/zoho_zubin/concatenate-app/ 2. It has one form called "Concatenate Form". 3. Each one of the records in this form relates to a customer's file. 4. The form has 3 fields: a) All File Notes - this is the field which I would to display the combined/concatenated
fetch value from crm module and fill into creator.
I have a form with a dropdown and a number of single line fields. From crm, I want to get the contact which is related to a account and fill that value in dropdown and on selection of dropdown, its relavent information should be filled on fields. One more thing: I want to get value from crm and on load of a form it should get insert into table first and then from table, it should get populate in th form fields. is it possible in zoho creator? Please tell me how can i do this?
Bug when adding share permissions through API
When adding permissions to a form via the API although the form displays the permissions correctly, unless I also add permissions to the Section container the page loads incorrectly and although the forms are listed when hovering on the section when clicking on one of them nothing loads, just the same broken page as shown below: The only way I've found to fix this is to add permissions manually to the section via the GUI, however this is a pain when i expect to have close to 15k users Once the permissions
How to show contact associated with account.
Hello I need some help. I have created a form in which I have a Zoho CRM field which is bind to account. When I select any account it fetch it information and fill into the fields. A Account can have multiple contacts. I want to show these contact name in a ZOHO CRM Fields. How it is possible in zoho creator? or is their anyway to display contacts associated with account and on select of contact its information should get filled in felds.
Help regarding accessing Parent Account.
Hello I need some help. I want to fetch the parent account from the account module. In Potential module, I have created a custom link which redirect me to zoho creator. In zoho creator, I have created a function in which i had passed potential id from crm and based on it i am fetching account id and account information from this account id. In Account module, I have parent account field which is lookup of account module. A account can belongs to one parent account but a parent account can belongs
what is the difference between zohocreator.exe and zoho-migration.exe?
I would like to upload a csv file to my creator project every night. I'm pretty sure I need zohocreator.exe but I cannot find it. I did download zoho-migrator.exe. Is that a new version or something? Thanks!
creating a formula using the results of another formula
Hi - Newbie here again. This seems very basic: I'm trying to create a series of calculations. Many of them depend on the values returned from other formulas. How do I accomplish this? Those formulas don't appear as options in the Field list when creating my formula. thanks Charles.
Importing Images via data import
Hi Zoho Community I'm hoping this might be a simple answer...and I just haven't found it yet! I have an XL spreadsheet of about 3000 rows identifying indivudla items. Each item has a corresponing item has an image associated with it - stored separately as a file (so yes - 3000 individual image files). Data import is working through the normal method - however I have not had success in importing the images into the form. I would like to avoid to going to each record individually to upload the images
Can I log on as user when I am Admin?
Is there a way for me to log on as a 'User'? I am testing out some of the security and I can't figure out how to log on in 'User' mode. So far I have just used a second email address, but I am migrating to a paid version and I don't want to pay for a user just to test. Thanks.
Restrict days and or holidays
What would be the best way to restrict day(s) or upcoming holidays? Ideally restricting days or holidays from a calendar date field from being selected. Any ideas?
Preventative Maintenance Visit Date Tracking
I have a database of conference room information. Main Form has all the information about the room and then there are two subforms that tie back to the main form. There is a subform for assets that belong in each room and then there is a subform for Preventative Maintenance visits to each room. We would like to track these and be able to make decisions based on certain date intervals. What I would like to have is a calculated field called "Date of last PM Visit" that would show on our Main Form
Change Date format
Hi, I am trying to pass date value to API call but API wouldn't accept the formation that is already set in creator So I need to convert it to respective format. Actual Date format in Creator : 11-August-2015 15:59:30 API call Format : : 2015-08-11 15:59:30 Can anyone please help me how do I convert the creator format to API format Thanks Arfater
zoho.loginuser id in a pusblished page
Hi, I am trying to count every time a user access a zoho page but I am trying to filter out company users with an account in zoho. in other words I want to count only user with zoho.loginuser=Public. My problem is that everybody looks as public when accesing this published link... Is this how it is supposed to work? for instance here a link link at the bottom of tha page I display the zoho.loginuser, allways Public even if I am logged in to Zoho at this point. thanks Luis
Pagination top and bottom
Hi, I wonder if it is possible to have the pagination of a list from zoho view to show on the bottom, not only on the top. The reason is that if the user goes looking at the records from top to bottom, it is logical to have a "next" button right there, at the bottom, rather than having the user go up all the way only to click next. Thanks Luis
Next Page