Amending export fields on creator
I want to export from Creator - ideally to an RSS feed. I want to remove certain fields so they don't get exported as they are not relevant and make the feed looks messy - ie. ID number, ip addresses etc. I can hide them on the contact view by hiding the column, but on export I cannot find a way of only exporting certain fields. Is this possible? Thanks Alistair
Fetch and update doesn't work
Hi, I have a form (Entering Pricing Information) that is supposed to change the status in another form (Fabric Information Request) to "Quoted" upon succesful submission...similar to your example here http://help.creator.zoho.com/Fetch-and-Update-Records.html However, the status does not change. Thanks for your help
Re do you have any plan for let ZC support Adroid os？
Hi ZC have any plan for let ZC support Adroid os？ Thanks stanley guo
html view that opens records into another html view
Is there a way to create an html view that has a link that will bring up a record into another html view? I want a listing of all my transactions but to have a link that a user can click that will bring up another view that has data displayed into an html table that looks like an invoice. This way i can create invoices right inside of creator. How would i do this? Also i would like to be able to email and print this invoice html view, how would i do this? The print command i think would be easy.
Dynamic Dependant DropDown List
Is it possible to make a Dynamic Dependant DropDown List? Like this First select a country then all stats are dynamicly shown in next dropdown list? If it is possible - please let me see the code ;O)
Cannot save script.
I cannot save my scripts. It takes too long. Please look into this for me. http://creator.zoho.com/ensobase/home/edit/function# tt
Embeding summary views into and HTML view
I want to build an HTML view that would look about like this Summary View 1 Summary View 2 View 3 View 4 I am not familiar with HTML. What is the very basic syntax to get the first two columns? How can I stop Summary view from expanding to take up full width (if Summary View 2 would be absent, for example).?
all data lost in database
I have 10 entries left out of 1200 that are lost in my database. the database is Iao Detention Database my username is iaoadmin I did delete about 80 of the entries but suddenly they all disappeared and left me with 10 entries. I really need those entries back, we are a school and this is a database that keeps track of school rule violations. Please, please help thank you Larry McCarty Iao School username: iaoadmin
Attaching uploaded file to email for download
Hi Guys Me again: I'm trying to allow for a file to be downloaded or sent as an attachment in an email. I would prefer the attachment, but can live with the download link. I found a script that does it here - but when I click on the link in the email it tells me that: You are not authorised to access this file in Zoho Creator. Go to Home Can you guys help with this? Thanks, Jason
Ghost text in free flow scripting in Chrome on a Mac
When editing code on a Mac in Chrome, occassionally there is "ghosting" (please see attached screenshot). This does not occur in Firefox or Safari (which shares the webkit engine with Chrome). The obvious workaround is to either not use the free flow scripting with Chrome or to use Safari instead, but it would be good to get this resolved. Any thoughts?
Settings Page throws error instead of validating the input
I was trying to create a simple form as a support one to an article about cross-site scripting vulnerabilities. When the link name was having a <script> tag it immediately bombed with an error message instead of showing a validation message. See attachment for more details. __________________________________________________ Cadillac shocks and struts Chevrolet shocks and struts Shock absorber
Inconsistent Behaviour Between Browsers
This experience was demonstrated to Ruben yesterday ... and is being posted here so it can be responded directly by the ZOHO Creator Team. In one of my Clients' Application, I have (dynamically composed) links in an HTML View ... something like ... <a href="/hisAccount/hisApp/#Form:someForm?reference=1234">some prompt</a> ... <a href="/hisAccount/hisApp/#Form:someForm?reference=5678">some prompt</a> ... <a href="/hisAccount/hisApp/#Form:someForm?reference=9012">some prompt</a> etc. etc. ... the user
Column data based on start date
I have data that is start date specific for several types of products. For instance, I have a customer that will begin buying chairs in Dec. another buying chairs starting in January but also buying desks starting in November. I want to create columns for the next 3 years, that look at the start date, calculate the revenue from the sales of the item, and add it to that column. Each sales activity is a separate row and I would just like to carry that information out to additional columns in the
Variable in Picklist Criteria
Hello, I need help. I have a form X with fields OPIDX and Name. In another form Y, I want the user to input a value (OPIDY) which will seek to form X in a field / column specific (OPID given by the value provided by the user in the form Y), to then mount a dropdown. Example: Lookup_1 ( displayname = "Lookup 1" type = picklist values = FormX [input.OPIDY].name width = 206px ) where, "OPIDY" would be a variable input by the user. However, it is not accepted.
Cant see all my report
I am just starting to use Zoho creator. I have a small problem which is probably due to my failure to understand how it works. I have a query which returns 22 rows in the report. In the edit screen I can see all 22 rows, printing a PDF produces all 22 rows but the report you only shows 10. There is no scrollbar to enable me to look at the ones lower down (see the screen grab attached) and using the navigation arrows only lets me see one more row. How do I display all 22 of my rows?
Update two records in two differents stateless forms
How can I can Update records in two forms by a stateless form by a stateless form? Those two forms are "Container" and "Sample Tracking". They are linked by a lookup field "Container" in "Sample Tracking". I want to update the lookup field "Container" and also some fields in the form "Container"...By cliking on a button "Attach Container" in the "Samples Received View". I don't figure out how can I can do to update the current record and also do the link to the record in "Container Form". Thank you
Help Desk URL
What URL do I give my customers so they can fill out a help desk ticket?
Embedded form does not load
I have embedded a form in an html view with a <div> tag like this: <div elName='zc-component' formLinkName='myForm' params='zc_Header=false&recID=473791000001064107'>Loading Form...</div>But only the text "Loading Form..." appears. Otherwise nothing happens. The recID was a entered by script before. I hardcoded it to make sure that was not the problem. I tried it with different form. Same there. The html view in which the form is embedded is opened within a Zoho dialog (href with zc_LoadIn=dialog).
ZC Email Format Options?
Greetings, When a form is processed, I need to send an email out based on certain criteria. Is there anyway to have the email formated with any other than basic text? For example, I would like to have boxes, squares logo etc. If I can not originate out of Zoho Creator, can I use a different program in order to prepare and send a more advanced email format? Thanks, Bartley
TextAreaWidth and RichTextWidth
I use the following code to set my TextAreaWidth: zc_TextAreaWidth=100% such as this: http://creator.zoho.com/ensobase/home/#Form:z_Notes?zc_TextAreaWidth=100% Does or when will the RichTextArea support URL param width configuration? such as: http://creator.zoho.com/ensobase/home/#Form:z_Notes?zc_RichTextWidth=100% tt
Using a different email address in To field of scheduler.
Here is the error I get: Error in saving the script: Invalid TO address: In cases where From: address is not a zoho.adminuserid or zoho.loginuserid, the To: address can only be zoho.adminuserid and the sendmail task cannot have any CC: or BCC: address. I do not want to send from my email account i am sending these emails on behalf of another company and therefore need the from address to have a different email address than my admin account. How can I use a different email address in the From field
Delete operation failed Please try after sometime or refresh the page and try again
I want to delete SWIS ID field from Client Data form I am not able to delete it. I get Delete operation failed Please try after sometime or refresh the page and try again
Calculations with data from another form
Say I have a Form-1 with fields: Transaction-Date Product-Number Product-Price Transaction-Currency and Form-2 with field: Date EUR GBP where values in EUR column are x-change rate from EUR to USD. How can I add a formula field to Form-1 where Price-USD = Product-Price x x-change rate for the Transaction-Currency at Transaction-Date? How is this done to get the value in Form-1? How is this done in the HTML view?
Urgent: When I try to make form public, nothing happens
Hi, I had a public form, I changed it to private last night for testing purposes. Now I am not able to make it public anymore. Please help ASAP. Thanks
Send mail
Having problems getting a particular SendMail deluge script to work; if((input.This_is_a_request_for == "Self-conducted Periodical and Forecasts Workshop")) { %> SendMail [ From : zoho.adminuserid To : zoho.adminuserid,"********@******.***"","**************@******.***","********" Cc : "*******@******.***"" Bcc : Reply to: Subject : "New Self-Conducted Forecasts Request" Message : "Here is a new request for a Self-Conducted Periodical and Forecasts Workshop" + input.formdata
Checkbox w/ default value
is there a way to do that with some of these checkboxes? Need to Email Already Emailed Restaurant Wedding Supermarket Bakery Catering BBQ Construction White Black Hispanic Asian Vietnamese Closed
Embedded Website View Will Not Show All Fields Within A Record
We are trying to create a view that shows a select number of fields from a record that we can embed within a web page. We want the viewer to use the search tools to locate a single or specific group of records and when they find one of interest, they would click on the view link and see all of the fields associated with that record. Right now, when we create the View with only a few of fields showing, the view link for a more detailed look only shows the same sort list of fields. Can we create a
Setting an autoindex for new items entered by form
I am very new to zoho and still trying to find my way around, but could anyone shed light on how to have an autoindex entry starting with the year of the date set in the form so that each entry can be indexed using the format: YYYYnnnn where nnnn is a four digit index number. Any help is much appreciated. Loving zoho so far.
Email notifications in help desk.
How do I manipulate email notifications in help desk. If I attempt any changes to forms I get "You are not allowed to view / edit the script."
Problem (Adding Record to my Form)
When I am trying to add a record to the form below: http://creator.zoho.com/demonline/dem-online-koordinasyon-merkezi/#Form:INTERNATIONAL_PROJECTS I am getting this error massage below: 1 . [t_560385000000041436] Exception occured while setting value in PreparedStatement for the Column [N_ULKELER_560385000000053238] Check whether the datatype for this column is given as specified in the data-dictionary .[t_560385000000041436] Exception occured while setting value in PreparedStatement for the Column
Limiting Form Sign-ups
I'm new to Zoho and was wondering if there is a way to limit the number of people who can select an option on a form? I'm used Creator to create a form to allow my students to sign up for various instruction sessions. I used checkboxes as the function type, but want to limit each time slot to 15 students. Is this possible? Thanks!
Link preview in creator
Hi there Is it possible to automatically create a preview image of a website link? Either through the URL-field or through the image field? Thanks Thomas
Form access refused to application user
Hello, In my application, VirtuLIMS, a custom action "Enter Resulton "Under Testing View" lauch the "Sample Tracking" form in edit records mode. The user can not access to this form after have clicked on the "Enter Result" button. Why? And how can I let it accessed by users? Thank you
zoho.currentdate and zoho.currenttime still return the server date and time
I read some posts 2 years ago that zoho.currentdate returns server date and time and that this will be changed. What does it return now? The date and time specified in the aplization timezone or the server time?
Application shared_ The application is not working in the same way for one of the user.
Hello, My application doesn't work properly for an user. My application VirtuLIMS. When he clicks on the Button "Open" in the "Batch View", it redirects him to the "parameter" tab. But it should open the URL for the " Per Batch View", with a criteria. I tried with an other user account and it works properly. Do you have nay idea of what's happening?
Report Format
How can i format the report so that i do not get totals? How can i format the report so that i can adjust column widths?
How to Export only check records from my search results?
How can I export ONLY checked items from my search results? For example, after I filter all records for Phoenix, I want to check a few records and export a viewable list of ONLY those records.
Generate API Ticket
This page has been moved here. http://api.creator.zoho.com/Generate-Ticket.html ????????
Can't delete field
Hi, I can't delete a Formula field on one of my forms. I get the error message.. Data in this form is being processedfor Formula calculation. You cannot add/modify/delete fields in this form till the process is completed. Please wait till it gets over. My application is called Elections and the field is called Hub Contacts Reference on the Hubs tab. Can you have a look at this please? Thanks, Lee
Populate drop down with multiple fields
I've been looking around for an answer to this but I can't find anything to help me. Say a form named 'employees' has a field for First Name and Last Name, and a related form wants to do a lookup for each employee. It would make sense for each entry in the drop down list to contain First Name, and Last Name (and most likely the unique ID). So far I can only see how to add one of these fields to the drop down. This will come up in a lot of the apps I'm likely to develop, particularly if the data
Next Page