Auto populating the drop down
Hi, In My form four drop down fields are there,in that three have some choices and fourth one doesn't have choices.Based on validations i want to populate the fourth drop down with these three drop down choices is it possible?. Thanks.
URGENT: pusblished content not showing up
Hi, I have an urgent need. some public content is not showing up to the public. If I log in I can see the content but this is for public use. This was no problem two days ago. Please help. say for instance this: https://creator.zohopublic.com/yaxche/catalogo/view-perma/Productos_Page/TRBRXUCHQZCQU1y4dsV66KZa1ZMsDRkpzS6TJZxfKPDwXOX56UdZEuYMF5w3FSH9SZh0xn07BRNhFy1MsTWtBpxDZ53y92GRbtvy/Tecnica=102 data is showing up fine, it is the picture what does not show despite the view it refferes to is in fact
Email Notications - Are they Stored?
Hi, Can emails sent from Creator be stored or attached to the record it went from? We need to see the email after it has gone? Or can they be attached to a contact in ZCRM? Or if thats not possible....is it possible to send an email from ZCRM...or would i just set up a workflow in CRM when a field got updated......? Chris
How to modify default messages?
We set a registration limit on each of our forms. The default message that presents when the max is met is "Maximum entry limit reached for this form" . My question is, how do I go about modifying the message? I would like it to say something different; something meaningful to our users. Thanks in advance for your help!
Zoho Creator select page - form menu bug?
Deal All, I do not know if you face same issues with me but in huge applications with more than 10 pages when I try to select a page then I have the following menu (unsorted pages, some of them are out of the table width, we need to scroll down to choose a form etc). Me and my colleagues have the same problems in ALL the browsers. Is it a creator bug?
Debug
Hi, I am working on a function that has to be called within an html page. The function takes data from different tables and return a float. I am in troubles with this function and would like to know what debug tools may I use. Is there a way to populate a "debug table " with deluge video within the table? Allert or Info work within a function? Can a function return an array and not a single value? Tks Pippo
Why is zoho asking for viewers to sign in to an Zoho account where my contact form should be?
I built my two contact forms in Zoho creator. When I logged onto my webpage, zoho removes my contact form and asks viewers to sign in to zoho as if they have an account with Zoho. How can I fix this? Example is given of what viewers of my website see:
BUG: Mis-aligned fields and values
The first view is normal edit view of a Custom record. Then I created a Profile called Drafter, who uses Field Permissions to make certain fields non-visible. When this Drafter user logins to view an order, then click on the customer name to open up this customer. Things start to go wrong. See 2nd image, how fields mismatch the values.
Internet Explorer does not insert Turkish Characters inside CRM InsertRecords API Calls
Dear All, Anyone have problems in executing Zoho Creator apps inside Internet Explorer? We have a Creator Application that inserts records to Zoho CRM with PostURL XML calls. We have identified the Creator app works fine on Chrome and does not work on Internet Explorer. That means, Creator Application inserts correct records with Turkish characters on Chrome but not Internet Explorer. We presume that Creator codes are executed on the client side and use the client language & international parameters.
how to detect that NUMERIC field is not filled any data?
hi! there is NUMERIC client_mobile2 in form try on "on edit - on validate" make some checks for filling fields task - to find situation where client_mobile2 in not filled any data. how to make this check?
Pubblic page in customer portal
Hi, My application is entirely in Zoho Creator. My Customers use Customer Portal feature, they have to login since the first access. I would like to have a Pubblic page that my prospect customers have to view without login in. Is it possible? Tks Pippo
Incrementing numbers on Add Row, based on value in previous row (in a SubForm)
Hi there, I'm building an inventory/order system (yes, yet another onw :-) and when we receive goods, we add serial numbers to them. I will often get 20-30 new items with running numbers and I'm looking for a way to automatically increase the serial number for each new row I create... so something like if (row[-1].S_N != null) { row.S_N = row.[-1].S_N+1; } Can this be done ? Cheers, David
Customer Portal
Hi, Customer portal is great and we use for our external application. Unfortunately the application is used by users who I require to have different permissions. I know you do not support this currently as you state that all users must have the same permissions. It is limiting. I'd really like to be able to use the share unshare deluge command to control access using the users zoho,loginuserid, primarlily on sections ie I don't want certain sections shown to users and a combination of sections to
import - disable deluge controls
Hi, I have a form with a lot of deluge controls in on load, on validate, etc. Sometime I need to export the Table (using the report-export), elaborate it in Excell and import again. When I try to import the import wizard gives me a lot of errors due to the deluge controls. I have to delete deluge controls in on load, on validate, import the table and load again the deluge controls. Is there a smarter and quick way to do it? tks, Pippo
Transparent forms
I was wondering whether or not you can make the background on a form transprant? I have just made a form and embedded it into my website and the white background clashes with the web page and makes it look very unprofessional. Is there any way you can change this?
how to count how many checkboxes has selected?
hi! need count how many checkboxes has selected in entry it will work at "on edit - on success" how to make it?
how to append entry to multi-line field?
hi need log all operations with entries. and think using multiline field - to append custom entry on every "on edit - on success operation" how can i append entries to multiline field? see example
Provide "Duplicate" function for Stateless Forms
It would save a lot of time if Sateless forms could be duplicated to create varitaions, instead of rebuilding every time from the master.
Updating a time in a timesheet record but not the date
I have been trying to set up a report where, if you update the time for a record it updates the time but not the date associated with it. I am able to get the time to update properly, but I don't see any way to get around the date updating the Actual_Time, Total_Time, and Lunch_Time due to the zoho.currentdate variable. Any help would be greatly appreciated. date timesheet.strToTime(map timeMap) { hrs = (input.timeMap.get("hrs")).toLong(); mins = (input.timeMap.get(("mins"))).toLong(); timeValue
Updating a form on the iphone app for a field with decimals
The iphone app for creator use a , (comma) instead of a . (fullstop) to indicate the decimals. How do i correct this? Dawi
Using Functional URLs with iCal
Note: I had originally posted this as a question, but found the answer and deleted the forum post. I just discovered that one can use a single events-based database to create multiple ical feeds. In the past, I just created multiple new views of the database and then drafted the ical urls. The more elegant way is to use the functionality-based url criteria to filter the view, then draft the ical url. For example, in my event database, I have these fields: EVENT_SUBJECT, EVENT_ORG, EVENT_BODY, EVENT_START,
What video tutorials would you be interested on?
Hello everyone. Just made a video on how to mass update your database in zoho creator. You can review the posting here. http://www.creatorscripts.com/blogs/post/How-to-Mass-Update-your-database-in-Zoho-Creator/ but i am interested in finding out what other needs are out there to plan my next video tutorial. If you can comment on the post or drop me a note would be greatly appreciated. Francisco Riojas Creator Scripts Smart Software For Maverick Entrepreneurs www.creatorscripts.com
Apps missing from Personal Apps list
In the past 5 years or so, my company created a number of Apps. With some technology and staffing changes, our paid account lapsed for a few months. I just reactivated the account with a new credit card and now a number of the Apps are missing. Most importantly, I need the Diagnostic Form app we created. I left a voicemail for support yesterday morning and haven't heard anything back-- very disappointed with customer service.
Using portal URL - Public link
Hi, I've set-up an automated email for portal users to click a link to a form and enter their response, as the form is public this works: <a href='https://creator.zoho.com/" + zoho.appuri + "/form-perma/Form_Name/Record_ID=" + record.ID + "&Email=" + record.Email_Address + "&Event_Details=" + eventDetailsID + "&Availability=Yes'><u>Yes, I’m available</u></a> But I would prefer to use the portal URL without the user having to sign in like: <a href='https://myPortalURL/form-perma/Form_Name/Record_ID="
USERS CANNOT ATTACH FILES
Since this morning my users cannot attach files. We upload it on subforms, the file loads to 100% and the form hangs up "Wating for Zoho" and it does not advance We have a form with subforms, and in these subforms there are file attachments. Users cannot attach files. WHY DO YOU DAMAGE STUFF THAT IS WORKING??????? FOR NO REASON IT STOPPED THIS MORNING - THIS IS GETTING TOO FREQUENT
Creator Workspace renaming/creation
How do I rename a workspace within Creator? Alternatively, how can I make a new workspace and move my application there?
Change value of HTML page variable with function
Essentially I want to declare a variable in an html page then call a function that will change the value of that variable. Is it possible?
Brand new to Zoho Creator! Please Help!
I run a flyer delivery service. I'm trying (unsuccessfully) to create an app in zoho to track the flyers going in and out of the office. It's pretty simple, I need to check them in when they come in, and then check them out when they go out. I built an app that can do that. The problem I am having to getting it to automatically figure out the number left by client. This is an example: Let's say "Client A" bring in 1,000 flyers. I would input that into the app. I got that much. Then "Client B" bring
How to manage the "Approve Lead" list
I have a problem since my Webforms return a new Lead record which quite often is a DUPLICATE. 1. If I go to Lead/Lead Tools/Approve Lead/Duplicate Lead this shows me a list of Duplicates that need approving but at present I have 1500 records and I have no means of SEARCHING or FILTERING this list to see what does it contain. Any ideas how to manage such a list 2. Is there a way of including Unapproved Leads in my general CRM SEARCH? 3. Is there a way of adding fields to be shown on the Duplicates
The "Share Data With Peers" option does not appear to work.
Please refer to this: https://www.zoho.com/creator/help/security/manage-roles.html · “ By default, users of the same role cannot access each others data. For example, the VP Engineering cannot access the VP Marketing data and vice versa though they are of the same hierarchy." This appears not to be the case. In my application, users in the same role can see each other’s data, regardless of who ‘owns’ the record. I have “share data with peers” OFF for the role. I have tried deleting the
Backup Schedule
Hi I'm trying to set backup frequency as weekly in Backup apps section in the setup. When i click "Take a new backup" there is only one field "right away" why is no other fields there ?
Form disappeared
Hello. I was editing another form name and reports name and now the form " Add ICD procedure" has disappeared in view mode, but in edit mode i still see all fields and codes.What's wrong i do ? Please help me. Account name zoho_ill Application : My First Application ill@gmx.com Thanks.
Upload File Hanging on submit
I have created a simple form to allow account managers to upload an excel invoice and complete details which when submitted then generates an email to finance. Finance should in theory then be able to access the report and download the invoices once a month when they do the invoicing. Unfortunately when the account manager uploads a spreadsheet, completes details and hits submit the details of the file disappear from the box and the page just hangs so is never submitted. If no file is uploaded then
Android app crashes when trying to load reports
Hi, I have a problem with the android app on my tablet (Huawei MediaPad 7) running Android 4.3. It loads forms ok, but it won't load reports. It just crashes every time. It tries loading and then says, "Unfortunately, Zoho Creator has stopped." It does this for every report. I have the app installed on my Samsung Galaxy s5 and it works fine. Please help. Ben Taylor
Customer Portal (New User? Sign Up)
The new user sign-up feature does not send an email to the user upon filling out the form and signing up to complete the registration. Why would this be?
Google Chrome Timer plug-in
Hello Zoho / Community, Found this post about a really helpful tool in Invoice and books. Is there any plan to include it in Creator ? Kind regards, Alfredo Hire an Expert Certified Solution Provider Zoho Creator Certified Developer Servicios Comerciales CASE SA / Certified Solution Provider casemx@sccase.com.mx ******************************************************************************** saranya.r.. Ease your time tracking in Zoho Invoice, with the all new Google Chrome extension in Zoho Invoice • Announcements • 2
Simplified input of the DATE -TIME field
I am using the the Date-Time fileld in my application because it facilitate date and time calculation. But on the other hand the users are complaining about the time being not user freindely or entering wrong timing is recurent. How can I simplified the look and feel of the time entry section ? Something like the date in a separated field and the hours in a dropdown field would be workable for me. But always keeping the same single date-time field? Thanks
How to pre-filter dropdown via deluge when is a lookup from a different App?
Please help with why we get errors when querying a form in another app. In "APP2" we have some lookups that are from "APP1" (GREAT that Zoho can do this! :-) In APP2, for the lookup APP1 --> Property, there are a lot of records, and we'd like to pre-filter this lookup, via a "choose_state" dropdown for selecting a single State, and an OnUserInput script that queries the records by that state and sets the UI dropdown. (We've done these before and have no trouble with the details. But never "across
In report criteria and custom filters: Support for <fieldname> on the *right* side of the criteria
Customer Support confirmed today that *only static values* are available on the right side of the criteria - whether via the UI or if edited directly in the report Definition. ie, <fieldname> <comparator> <static value> . So please add support for <fieldname> <comparator> <fieldname> . Examples: Record_Owner != Added_User Project_Manager == Project_Owner 2015_Sales < 2014_Sales We are aware that as a workaround, for each query needed, can have a dedicated field, filled via formula or deluge, that
Error when attaching files
Since this morning, any user that tries to attach a file to my forms is kicked out of the application. Can you pls do something? Amazing your capacity to create problems out of nothing. My Zoho User ID : 26676849 application cjuridico Raul
Next Page