Zoho Freezing
Hi, Zoho is freezing everytime I try to access the script for Bookings (Raft), and I have to refresh the page to get it going again, cant view script at all. I cant really seem to do much to change it, am I able to provide access so support can take a look? Thanks for any help.
Copying data from one field to another in the same form
Hi: I am a new user to Zoho creator. For the most part "deluge" is very intuitive. However, I am stuck trying to figure this out - I have a multi-line field called "Billing Address" I created a checkbox called "Same As Billing" I also created another multi-line field called " Shipping Address" If the user checks the box "Same As Billing". I want the input from "Billing Address" copied to "Shipping Address". How do I do this? Thanks, Ram.
Google Calendar HTML View - Broken?
For over a year I have had a link to a Google calendar embedded in an HTML view (so that the users can see their Google Calendar within my Zoho Creator App). All of a sudden this appears to be broken. In Firefox this will just not display and in IE8 I am getting the error "this content cannot be displayed in a frame". Is this a Zoho issue or a Google issue? Is there any way to resolve this?
Formula Field Not Saving
I understand that a formula field will not be seen by the form user - only on the view. However, after I successfully create a formula field in the form editor, then leave and return to the edit form page, my formula field does not persist (and subsequently does not render in the view). Any thoughts? I've tried repeated the behavior in Chrome and Firefox.
How do I call a function from an expression with current record as parameter?
So I want to do this in an expression field: thisapp.mynamespace.myfunction(currentrecord) But, alas, how do I pass the current record? Cheers and THANKS for any help! And yes, I know "on update" and it doesn't fit my needs.
File upload feature hangs when used to update record
So, I have a inventory app where I'd like to store pictures and update the pictures when needed. I've created a form and used a formula to display the pics in a view using the following formula: ("<img width='100' src='http://creatorexport.zoho.com/DownloadFile.do?filepath=/" + Image_Upload + "&sharedBy=" + zoho.adminuser) + "'/>" I pulled this from the KB article: "How to render the images uploaded in Zoho Creator." It works when I'm just adding a record and displays in my default view just fine.
Duplicate Entry Restriction on hidden field
Hi, I have a drop down called "Client Type" on my form. One of the values in the "Client Type" drop down is "Realtor - Team" and the other is "Retail". If I select "Realtor - Team", I am showing a field called "Team Name". This field has the "No Duplicate Entries" check box selected. Here is the problem, if I select "Retail", this field is not even shown. However, when I try to submit the form, I am getting "Duplicate Entry For Key 3". This validation should not even be checked for "Retail".
Can I add search to Summary View?
if I can add a Search bar to Summary field this is a home run!
Please List Supported Browser Versions
ZC team, Please give us an update on what browser versions are currently supported. Thank You, John M. Whitney
Creator - External Users
Good Afternoon I've started to look at Creator again after a few years. Is it possible to create an application which can accessed from external user without buying a full licence for so say an ecommerce site. Salesforce / force.com has sites which offer this function. Best Regards Ben
Ambiguous Error Messages: WHEN will dev ever fix error messages?
Please tell me how I'm supposed to troubleshoot this message below that appears when running an application? If the program knows a variable has a problem, it should know which variable it is, and display it's name, the line number the problem occurred on, etc. Oh, line numbers in error messages when compiling a script, don't get me started on that subject. Sometimes I wish the Creator dev team would simply go back to basics and get a few fundamental issues with Creator correct. QUESTION: When will
Radio button break down by categories
I have a question about radio button. For instance, Group A item 1 item 2 item 3 item 4Group B item 5 item 6 item 7 item 8 Is there any way to select ONE answer from either Group A or Group B not both? OR how do we break down radio listing and insert label Group B in the middle? Thank you for your help, woodpecker04
Edit Record via URL is not working
According to the help page at https://help.creator.zoho.com/Editing-Records-via-Record-ID.html the following format allows editing of a record via a URL: http://creator.zoho.com/<userName>/<applinkname>/#Form:<formlinkname>?recLinkID=<recordID>&viewLinkName=<viewlinkname> I've had this function working for months, but it seems now that I'm checking it that some of the records either don't appear fully (i.e. a blank screen) or some do work properly or inconsistently. Here is a URL that should work,
Import data function in Shared views
Hi, Is there a way to let a user use the Import Data in a shared view ? Thanks, Pascal Veilleux
Contact Management with time\date stamp
I created a form to enter customer information. I have two follow up questions based on that. 1.) Our clients call and give us special instructions for future jobs. What I want to do, is to enter notes when a client calls and have that be date/time stamped. A client eventually will have multiple notes with different date/time stamps. 2.) I am also going to create another form called inventory. All our clients can have inventory with us. I want to include a drop down that has all the clients
Bug: "Access this application" tab in script editor not going to correct destination
I've noticed over the last few days that when I click on the "Access this application" tab inside the free-flow scripting view, it no longer launches the module being scripted, but instead launches the general application, which is not how it use to operate and is obviously an error. EXAMPLE: Clicking the green "Access this application" tab above in the script editor now takes me to: https://creator.zoho.com/w21admin/w21data/# (the general application startup view) instead of https://creator.zoho.com/w21admin/w21data/#Form:Add_an_Event
@Ruben: As you seem to be the one who answers questions:
Could you please give me a hint about my question: http://help.zoho.com/portal/en/community/topic/how-do-i-call-a-function-from-an-expression-with-current-record-as-parameter I just became a paying customer now, so please give me a good start, I would appreciate a lot, thanks!
Expression-Fields: How to call a user defined function?
Inside a Expression Field I would like to call a function I defined. Like this: thisapp.mynamespace.myfunction(currentrecord) My function is defined as: string mynamespace.myfunction(MyRecord loc) { // do something } How do I addess the current record? Or can I only adress the fields of the record and not the record itself? Thanks for helpful answers P.S.: Why I this tagged this as "problem" and not as "question"? Because this is not documented anywhere. I considder that a problem.
Can you add barcodes to your records that once scanned will pull corresponding record?
I want to upload a barcode to each record that I entered, that once the barcode is scanned it will pull up the record corresponding to unique barcode number. Also, once the record is pulled up, it will not allow that barcode number to be scanned multiple times.
Print Forms?
I have made up several forms and want a way to both print out and to send as a file to others so they can make suggestions. I have found no way to do so other than loading up on the web site and I don't want to do so now. I tried to highlight and copy / paste into Word but it loses all formatting. Any suggestions? - jb
Notefield problem
HI Support! I have a funny problem. In a stateless form working OK I have changed a note field to a new text version. The Script is saved OK, but the change is not reflected when the application is used! I still get the old text in the form. The statement used are plain3=""; ..................... some deluge code plain3=("<strong><span style='font-size: small;'><span style='font-family: Verdana;'>A mobile number with the same last 5 digits has previously been recorded as the client turned up and
How to check the XML empty value?
Hi, Can anyone teach me how to check the XML result is empty? I have productRec.open = (r.executeXPath("/record/price/text()")).toDecimal()); Normal the xml will show <price>12.01</price> However, when there is no value sometimes, the xml show <price/> I have try priceChk = r.executeXPath("/quote/price/text()"); if ((priceChk ="")||(priceChk.length()=0)||(priceChk=null)) { productRec.open = 0.0; } But still can't solve the
Add and update a column in the Form_View
Hi everyone, I have created a simple form which contains of 3 fields: Single line: Name Dropdown: Goals Dropdown: AssistsWhen a user fills in his name in the 'name field' he has to select how many goals and assist he registered in a ice hockey game. It is obvious that there are multiple games in a season. The situation is it is now: Every time a player fills in the form a new record is added in the database... Situation as it should be: Every time a player fills in the form the 'goals' and 'assists'
Two instances of datepicker in the same web form
Hello, I am new to the Zoho forum. Just downloaded the code and started testing things around. I had an existing PHP form where I select start and end dates. I modified my code to now use the jquery datepicker function. It seems that I can only use one instance of the datepicker in one form. The datepicker pop-up only works for the first date but does not for the second. Is this how it is suppose to work? Can I not have multiple date pickers in one form? I searched the Zoho Forum for similar topics
Form is set to public but customers cannoti view form
I have a reservation form that is set for an iframe on this site r r s a d d l e c l u b . c o m http:// rrs addle club.w ebs.com/ maker eser vat ions.htm it is set to be viewable by public but customers are unable to view it. Trouble shooting please? Great system, and if this bug is worked out we may consider upgrading. thank you
Customers unable to access our form ----Critical Failure---
https://creator.zoho.com/rrsaddleclub/reserveticket/form-perma/Reserve_Ride/7rFOYP0CO9M 3uv3yVTRvD3w56TZHPbeZXKShQhwuRtuBrfD68gsQN6BG9nn3xKaOEZkq9tFGN88PwxOpgQGrg3TsZ0QghbpvvQZ4/ is supposed to be able to be accessed by customers without login they cannot view I frame or are unable to view the form after clicking on a link. please help form installed at http:// rrsaddleclub. webs.com/ make reservations.htm I can view it just fine and so can a few handful of users that have logged into the
How to copy code from one field to another in Creator?
Hi, I have attached code to a field using the very useful drag & drop. I would now like to copy the code to several other fields, rather than having to recreate the code every time by drag & drop. Maybe I'm being rather dense, but I can't see how to do this - can anyone please tell me if there is a way to do this?
Need Tech Support: Unable to clear "No Duplicate Entries" setting
I originally set a field in a form to "No Duplicate Entries", but now I don't want that condition. When I uncheck the "No Duplicate Entries" checkbox and click Done, it does not take effect. Re-opening the dialog shows it still checked. Then, to try it another way, when I go into Script mode and attempt to remove the "Unique" flag from that field's definition, I get this error message when I try to save the modified script: Error modifying the page Columns participating in the Primary Key Definition
Inventory Management template available?
I am trying to set up a fairly basic inventory management system for a small organization in multiple locations. Are there any existing applications or generic templates that I can use as a starting point? If not, I need to understand how to do receiving and shipping functions that automatically update the warehouse levels.
Emailing Data is Nonfunctional
user: niskypto app: email-test share: public and support I was going to test the new Email Alias ID feature mentioned here https://help.zoho.com/portal/en/community/topic/how-may-set-the-form-email-address-for-adding-form-data-by-email ... but found that any emails sent to the form are not appearing in the view. I have removed the alias and tried again, still no emails are arriving. Any ideas? John M. Whitney Recommend
Field selection lost on saving the record
In On Add/On Load I add the option "[none]" to a lookup picklist with the following code: clear Introducing_Player; Introducing_Player:ui.add("[none]"); colIP = frmPlayers_List [(Name != "Dummy" && !Name.contains(":"))] sort by Name ; Introducing_Player:ui.add(colIP.Name.getall()); Introducing_Player.select("[none]"); This works fine. But when I save the record, the field Introducing_Player reverts back to "-Select-". Saving other selections in the same field works. There is no code that could
BUG - Cannot Pass Boolean Parameters Via URL
The ability to pass boolean parameters via the #hash format URL has suddenly stopped working properly E.g. openUrl("#Form:Task_Update?ID=1234&Return=true&ShowDetail=true&Comment=test ..." The ID & Comment pass correctly, BUT the 'Return' boolean parameter either does not work at all, or, if the 'Return' boolean works, the 'ShowDetail' boolean does not! Furthermore, it depends if the URL is being opened in the 'same window' or a 'popup window' as to which boolean variable will pass and which wont!!
How can i create a VIEW according to my Requirement?
hello zoho I am create an application in which i am use some formula fields based on calculation, now i want to that when USER submit data then USER redirect to the View of that form and the form contain only Formula fields, means USER sees only the formula fields not the input that it is filled. and another Requirement is that USERS sees only its own record in the View means it can't see the previous results which is enter by the another USER. And my last requirement is that the View Formula fields
WON'T LET ME CREATE ANY RECORDS - Error "1 . [t_704788000000012742] Exception occured while..."
Hi, I must admit I'm a little frustrated. I just spent two days setting up this database for my company and then I go to add my first legit record and.......FAIL. When I fill everything in and submit, I get: 1 . [t_704788000000012742] Exception occured while setting value in PreparedStatement for the Column [Notes_704788000000021173] Check whether the datatype for this column is given as specified in the data-dictionary .[t_704788000000012742] Exception occured while setting value in PreparedStatement
Error - Exception occured while setting value in PreparedStatement
When submit form "Novo Imóvel" (form Potencial) message occurs: "Invalid entries found. Please correct and submit again." appears at the bottom of the form: 1 . [t_679162000000105097] Exception occured while setting value in PreparedStatement for the Column [Potencial__679162000000604155] Check whether the datatype for this column is given as specified in the data-dictionary .[t_679162000000105097] Exception occured while setting value in PreparedStatement for the Column [Potencial__679162000000604155]
Help with Script
I need help in script. I want a client to be able to select one of these States and be able to complete the form. If they choose any other State, then they get the url stating we are not able to help them. The following script works with one State however, I need to allow the form to be completed if they choose any of the follwoing States AL,FL,GA,IN,LA,MD,NC,OH,OK,PA,SC,TN,TX,VA. Otherwise, they get the URL Any help is appreciated if ( (input.State != "AL") ) { hide State; disable
Library log
I'm attempting to develop a database for a tool library for our little non-profit following the closure of Dabble. I've tried the library manager application but wish for a somewhat different structure. We have a PEOPLE form (borrowers) and a TOOLS form, each of which track vital information. I would like a LIBRARY_LOG form, where each entry is a borrowing event and easy to fill out by our librarians when they are busy. The log should be related to PEOPLE1 by a one-to-one, but to TOOLS by a one-to-many
Issue while Inserting Currency Field
I am trying to insert one currency field in my existing form (Financial Transaction) in Penta CRM 10 Application but it doesn't appear after which I tried to add Number field which successfully added after which I tried to convert it in currency again it disappear from my form. I have already given read write access to the support team. Thanks.
Script Help
I need help in script. I want a client to be able to select one of these States and be able to complete the form. If they choose any other State, then they get the url stating we are not able to help them. The following script works with one State however, I need to allow the form to be completed if they choose any of the follwoing States AL,FL,GA,IN,LA,MD,NC,OH,OK,PA,SC,TN,TX,VA. Otherwise, they get the URL Any help is appreciated if ( (input.State != "AL") ) { hide State; disable
Delete "Date" field
I tried to make a date field automatically put the days date in but it is not working so I want to delete it. When I try to do so, an error message comes up stating that the "field is referred in . . . Schedules." and to remove them. I can find no way to remove from schedules to then be able to remove the present "date" field and start all over. - jb
Next Page