Upload File to GoogleDocs via Zoho Creator
Hi Is it possible for an uploaded file from a Zoho Creator Form using the upload field to be uploaded into a GoogleDocs Account instead of Zoho for storage? Thanks Gene
Zoho Creator Page Load Speed
I have noticed that at about 12:30 PM (EST) to about 3:30 PM (EST) that the page download / upload speed has been drastically reduced. I am wondering if this is when you are doing your updates which would be 10:00 PM (IST) to 1:00 AM (IST). I performed a speed test for my browser and the results are: Ping : 15 ms Download: 23.45 Mbps Upload: 23.77 Mbps From the results stated above you can conclude that it is not my browser and in fact it is Zoho Creator that is having the issue. My company cannot
Hide / show fields with conditions
Hello; I want to hide some fields with conditions, for example, if the user choose ' No answer', some fields don't appear, I feel very lost in functions, since I'm a novice. Another thing, if the user types '2 'in the field ' number of children ', two fields will appear for each child's name and date of birth, how can I handle this action. I'll be very grateful. Thank you very much.
many mails in input.Mail
Hi, i made a variable Mail, can i put more than one mail in input.Mail? if so, what is the separation, ";" or "," or any aother?thanks
Sendmail to picklist
Hi, I'm unable to find an help in this forum and in sampleapps. I have formB with list of employee and formA with subform for uploaded document and a picklist lookup field with email of employee showed as name of employee. I need to do the simply action to send in attachment (as link) the uploaded doc to the employee selected in the picklist. I look for it in the iterate https://help.creator.zoho.com/Iterate-Records-in-a-Form.html and https://help.creator.zoho.com/Iterate-Data-in-Radio-buttons-and-Checkboxes.html and
Email notification to multiple picklist contacts...
I have a "To Do" form + view which allows you to select a member of staff from a picklist linked to an accompanying "Contacts" form, and assign them to the task being created. When the form is submitted, an email notification is sent to the member of staff concerned. All this works as it should. What I would like to be able to do is to make the picklist allow multiple selections, and send an email notification of the new task to every selected contact's email address on submission of the form. Can
Multi select causes an e-mail to be sent to staff on submit?
I have created a task management application with a form that tracks tasks and a form that contains staff names and e-mail addresses. The action form contains a Multiselect that allows someone to choose who is responsible for the task. This field is populated by a lookup from the staff field. I want an e-mail sent to each staff member set as reponsible upon submission. Can someone help? I am new to deluge and really struggling with this. http://creator.zoho.com/basketballscotland/action-manager/
Create a search function that will pull existing records
Situation: I am allowing users to enter membership data. But, if a membership record already exists, I would like for them to search for it and then be redirected to an 'edit' page where they can edit that existing record. I'm not sure how to do this. What I tried: I made a 'search' box where 'on user input' it searches for any record with the information entered and populates the form with the record information. BUT it will save a duplicate copy if you submit it...that's my dilemma. Any help
Hide / show fields using conditions
Hello; I want to hide some fields with conditions, for example, if the user choose ' No answer', some fields don't appear, I feel very lost in functions, since I'm a novice. Another thing, if the user types '2 'in the field ' number of children ', two fields will appear for each child's name and date of birth, how can I handle this action. I'll be very grateful. Thank you very much.
Does delete or backspacing a Date field to blank create the null value?
The on Input script below is designed to set the penalty field value to 30 if the day of the month is after the 15th, and to 0 if the date is not after the 15th OR if the date is blank (I'm assuming a blank date is null). The problem I am having is that when I delete or highlight and backspace the date to a blank (and then click outside the field to trigger the script) the penalty field is not reverting to 0. Can anyone hazard a guess as to what is wrong with my script? Thanks to Gaev for sending
Simple 'many to many' search example
Hi, I am trying to find a simple example of a many to may searchable database built with creator. For my needs, there are a number of 'instructors'. The only details I need are the full name and the postcodes they serve. Each instructor teaches in a number of 'postcodes'. Each postcode can be served by a number of instructors. The list of current instructors is a lookup from another form so as to always be current. In the end all I want the user to see is a search box. They would input the postcode
View to show latest record for each group of data
Hi, New to creator and just starting on my 1st project. Have some self taught experience of access and SQL but this is a long time ago. Am working on an asset tracker for use by us as an OEM and our customer as they use and distribute our machines. Mostly I need to track current location and current condition. I have a base form for my machine data such as serial number and then some other forms for input of location change and condition change. As the machines are used they will move around to lots
HTML view print problem
Hi, I have a html record view which get parameters from a form, when i wan to print the html record view, i get the following error Not Found The requested URL /bilgain/hr/print/Payslip/&Name=test&Date_field=01/12/11 was not found on this server. this is the print link https://creatorexport.zoho.com/bilgain/hr/print/Payslip/&Name%3Dtest&Date_field%3D01%2F12%2F11
Audit or History of Changes
Is this correct? 1. If I use a combination of getfieldname and getfieldvalues: a. Used in the ON LOAD or VALIDATE - it is null b. Used in the ON SUCCESS - it returns the new value 2. The old. property only works in the VALIDATE Is there any way to marry these two, so I can build a routine that will store the original value of any field that is changed?
Copying text from 1 sub-form to another
Hello, Is it possible to copy text from 1 sub-form to another. For example: I have a 4 forms In the Drawings form I have a sub-form called Materials and the user adds as many material sizes as need. Then in another form called Works_order the user selects the drawing number via a look-up linked to the Drawings form - then from that, can Zoho find all the materials in the Materials form and add them to another sub-form in the Works_order form? I'm basically asking how to come all the "rows" from one
Registering new user
I have registered users before, but today an error says 'email is already registered'. Is the system hiccuping?
ZC Disastrous Platform Changes are Killing My Business
I have been with ZC for around 3 years now. When you invest so much time and money into a particular platform (about $ 30,000.00 USD worth) then it is nearly impossible to simply change platforms and start again. Maybe ZC knows this, which is why they continually introduce unannounced changes that break links and stop businesses in their tracks. For years now I have suffered greatly from these background surprise attacks. An every time it occurs 2 things happen (1) My ability to take orders (bookings)
string manipulation
not to as to much...if you only had the ability to read through a string e.g. string[x] then all other functions can be created from this primitive. Is there a secret way to parse a string? richardson.christopher
I am really Very Disappointed
I am very disappointed Zoho restricted some feature using Zoho Creator form... now FREE on your website is just misleading to public to join and at the end be disappointed that their form can't be access publicly.. The whole purpose of form to get web visitors on the web to shoot their information quick and hassle free .. but now visitors have to sign up or use their own FB Yahoo account which many don't like to share... There is NO POINT to use Zoho Creator anymore ...therefore please stop such
Not sure why this code fails validation.
Background: I wanted to have Zoho assign custom IDs for certain forms so I followed the advice online and created a counter system wherein an Auto_Number form keeps track of the highest IDs and simply adds one to the appropriate counter when a new record is created. I would like to have the ID reset based on the year so that the last ID in 2012 might be 20125689 and on Jan 1 2013 it would automatically become 20130000. I'm trying to achieve this via the scheduler which I have never used before.
criteria for View Add button.
I'm using an openurl command with criteria to open a view so a users only sees records that are relevant to them. Is it possible to feed the same criteria to the Add button? In other words when they click on the Add the form is prefilled with the same criteria used for the view.
How To Verify Email For a Zoho Form?
I have a Zoho form on my website which allows people to complete the form to register for an upcoming event. They complete the fields and then submit it. I receive an Email with all the fields completed. Recently, I had a person submit a FAKE registration form. How can I verify the identity of the person who submitted the FAKE registration form sent through Zoho?
How do I delete unwanted column formula?
I have created some unwanted /incorrect column formulas which seem to attach themselves to all Reports associated with the same view. I really don't want them listed but am unable to see how I can delete them, otherwise it looks like they will stay defined forever! Chris
This Cannot be Good
Cheers, John Whitney
Importing Date from Excel
I created an application on Zoho Creator and initially uploaded data from an Excel spreadsheet. I continually update my original Excel spreadsheet as this is my master database. Is there way to import only certain data (rows) from the Excel spreadsheet into my application?
HTML Views Not Showing on iPhone
We created a Creator app with an HTML view. However, the HTML is not appearing on the iPhone or Form/View list even though it shows up on the Desktop computer. Can you tell us how to fix this? Thanks!
how do i make additional fields appear based on a users previos input in a checkbox
I have a checkbox field with various diagnosis. The can check more than one. What I want to do: If the user checks the NPH diagnosis checkbox, then a whole new set of fields should appear for him to fill out. If he doesn´t check that particular checkbox then the additional field wont appear.
Form skip through- conditional
I may have the subject description slight wrong... ? If I have a form that asks certain questions and based on the answer to one of those questions eg a dropdown field where it provides two options- truck or ship, then pending on the response the user is faced with certain additional questions through another form, which otherwise would not have been seen or been required to complete. Can this be done? If so is this tied in with the subform capability? Is there an example somewhere of this working
Calendar View using HTML link value as "Display Field" has stopped working
The latest upgrade has taken away the facility of using a formula field, which generates a HTML link code with background-color and link to HTML view, as the Display Field. This calendar view which was working well and was used extensively by my client, now looks like shown in below.. While the same formula-field renders fine in list view.. Kindly fix the rendering issue in calendar views.
Print Single Record
I have read that you have a 'print single record' function in beta which you can add on request. Please could you add to my Train2Drive application (edit access is open....somewhat hopefully!). Thank you
Web page hanging on user Zoho log-in
On a page on my web site I have six embedded reports. When a user comes to the page and logs in, they are presented with a 'Loading... Please Wait' message in each iframe. The page then hangs. Refreshing the page using F5 immediately brings up the content. This feels like a bug? Chris
Another ZOHO Creator platform change ... catastrophic to a second client !!!
I have now been told by a second client that the ZOHO Creator platform change has resulted in him not being able to conduct any business ... his application has numerous forms with dynamically populated Radio Button fields ... none of them respond to user selections !!! This is in addition to the first client ... whose customers were being (incorrectly) told that there was no inventory for them to rent (his equipment) ... had to make an emergency change to force feed a "inventory available" response
create a Function Specify Arguments group object drop down list is one selection off !!
Weird issue, maybe me, am using FF latest Create a function Use builder give it a name Specify Arguments: (put something in) In my case i am selecting a group object What ever form i select in the drop down the next one on the list is the one which is written to the function. Its like the drop down is One Value off Thoughts ?
Integrate Zoho Creator with Zoho Calendar?
Zoho Calendar currently has nice functionality that does not seem to be available within Zoho Creator yet. I'm specifically interested in the ability to display multiple calendars as different colors on a single calendar view. Also the ability to easily toggle which calendars are displayed. Is the multiple color coded calendar capability going to be added to Zoho Creator? How can I integrate the two apps so records created and maintained within a Zoho Creator app can automatically be displayed
View with Time Criteria from 18:00 to 6:00
I am using this Criteria to View Records created TODAY (Added_Time > zoho.currentdate && Added_Time < (zoho.currentdate + '0W:1D:0H:0M:0S')) I need to create a view for Records created from 18:00 to 6:00 of next day - but is not working .... This is my sentence .... could you please correct it (Added_Time > zoho.currentdate && Added_Time < (zoho.currentdate + '0W:1D:0H:0M:0S') && ( Added_Time.getHour() > '18' || Added_Time.getHour() < '6' ))
Also have something to tell zoho CEO:
Gaev use to zoho encounter also says understanding, hope can see resolved as soon as possible. As we all know what the system is not absolute safety accidentally, hard to avoid can meet some headache problem, of course, also believe that zoho can help you solve the problem. I also have something to tell zoho CEO: 1, I have used ZC 4 years, and it has always been my business good helper, I can't imagine if not it my business will be difficult to management, so my business and I user can't without
Add Event to ZOHO Calendar
I tested the zoho.calendar.createEvent task (ref) and have some observations and questions. Documentation: Instruct users to create a calendar name in Z Cal or use an existing one. Also, it would be helpful to provide examples of converting Z Creator date-time into Z Cal accepted format. There should be a way to pull a list of calendar names to populate a drop-down field. Rich-text in descriptions not working: I assume there will also be ways to edit or delete events? Cheers, John Whitney
openurl with reports and passing criteria.
Is is possible to use the openurl to pass a parameter to a report. For example I want a user to see a report that only contains records entered with the same userid. This is easy to do with views but does it work with report-perma? Herb Wexler
Suggestions for can be generated viiew by Deluge
Re Suggestions for generate viiew by Deluge 1, the view through the deluge to define which fields to show or hide; 2, if the define the view of read, write, edit, delete, etc. the better; 3, in deluge through the calculation to generate a new calculated field; Through the deluge to generate viiew can be saved to create many different types ofview, just do an all field of view and then hide it, based on all fields of view can begenerated through the deluge to the various types of view, so that very flexible
How to create fields to enter weekly sold unit for an item
Hi, Our company has about 50 Sku, and we want to keep track of the unit sold for each sku on weekly basis. I want to create an area where it has number fields for me to enter weekly units sold each year, what is the best way to do this? I want to be able to use those information to also create reports comparing the same week from past years.
Next Page