Criteria lost after searching embedded view
I imbed most of my list views in html views. This is one example: <div elName='zc-component' viewLinkName='Search_Profiles_Embedded' params='Player=<%=recP.Name%>&Player_op=26&zc_Search=true&zc_AddRec=true&zc_DelRec=true&zc_Header=false&zc_Footer=false&zc_DuplRec=true&zc_EditBulkRec=false&zc_Summary=false'>Loading View...</div> The user can enter 'Search' criteria for the visible columns. This all works fine. But when the user clicks 'Cancel' after he's done searching the view, the parameter limiting
Public Access Pending
Hello, I need public access to my form as soon as possible. It has been a couple days already. Thanks for your help! Marco
Help Please. Need Probation Tracking software.
How would I create a probation tracking system to track probationers,charges,fees,fines,court dates,photo, etc?
Google Calendar & ZOHO iCal Feeds Not Playing Nicely Together
I had to update my ical feed url strings in Creator. I'm now attempting to add them to Google Calendar by the "add by url" control and have encountered many issues. I'll point-out that all these ical urls are shared publicly, and render when pasted into a browser. I understand some of these issues may be on Google, but other's are probably on ZOHO. Issue 1: Often, Google imports the calendar name as an unintelligible string appended by @import.calendar.google.com. The name can be changed in the native
How to create a rich application forms in the visual?
Hello Create an application form in richer visual? For example, I would create a form in a manner that was divided into groups? Like a component group similar to the visual studio. Thanks
Is it possible to create a "other" field for a radio/multiple choice list?
Hi, I want to create a form with a "other" field, that is a text-field where the user can add his own choice if it is not in the original choices. Is this possible? What is the easiest way to do it so that the values of the "other" field also shows up in the report?
Order total
Hello I have looked around and haven't found a solution for my (I think) easy problem. I'm not much of a developper so it explains why I'm stuck I'm creating an easy online order form to well... order a product Price is fixed (1555 €) user has 1 questions (radio buttons) with 3 options Q1 R1= 0 € R2 = 75 € R3 : 25 € I'd like to have an order total showing somewhere in my form that add's up to the 1555 € when respons 1 or 2 is selected Any help is appreciated Thank's
Invoke File Attachment Sendmail Task
How can I use a stateless form to initiate a form schedule to send a one-time email with a file attachment? John M. Whitney
From private to public form
I have a question. How long will it take to change my form from private to public? I've been waiting fo almost a week. Regards, Liliya
Can not delete Form
Hi, We creat an application by Baihui Creator, The form's script maybe incorrect, so that we can not delete this form. Can not export the .ds and can not delete. Can you help me ? Thanks Andy
How to Change Text Field in Checkboxes to Numbers
Hello...I am new to Zoho and I like what I see so far. Unfortunately, I've been struggling with something that should be pretty basic, and searching through the forums and emailing support has only helped me realize that the only way to accomplish my task is to write a formula. Here is what I need to accomplish. I have a registration form with checkboxes for fees: Check which of the following registration fees applies.* Government Planner $100.00 Government Planner Non-Member $125.00 Contract
Problems with editing an item in grid view with embedded frame
So I am not 100% sure what is going on. I have a grid view that is an embedded frame on one of my personal webpages. I can usually add a record without a problem. But many times I have trouble editting a record. When I click the Edit button the edit screen opens up, I change some text, and then when I click the update button, I get the spinning icon with the system saying updating, but the window just hangs. I eventually have to open up a new browser window and I may get lucky and then be
How do I show multiple line items?
I have two forms with a many to many relationship. I want to create a form that will allow me to view the information from Form A and then show line items from Form B that are related to Form A in one view. For example: Form A contains: Student First Name Student Last Name Student ID Form B contains: Class Name Class ID Class Description In a normal relational database I would have a third table that tracked the student's grades, Form C: Form C contains: Student ID Class ID Grade
I need to make my View (HTML) to open a view through the action of a url in html form with a parameter of a text field.
I need to make my View (HTML) to open a view through the action of a url in html formwith a parameter of a text field. The code is below: htmlpage Gerencia_Baixas () displayname = "Manages Low" content <%{%> <span style="FONT-SIZE: medium; "> <strong> Manager Low </ strong> </ span><br /> <br /> <form action="http://creator.zoho.com/bcrosman/gerenciador-de-dados-na-/view-perma/Baixa_de_Estoque_View/Vendedor=FirstName"> <span style="FONT-SIZE: small; "> <strong> Enter the Name of Seller: </ strong></ span>
RSS feed problems
I'm trying to create an RSS feed from a Zoho Creater spreadsheet, but it's not working. According to the W3D Feed Validation Service (http://validator.w3.org/feed/), the feed is invalid. And, the feed won't appear on my desired reader: http://feedostyle.com. The application is public. Here's what Zoho gives me as the feed: https://creatorexport.zoho.com/westdepere.se/data1/rss/data1_View/ Please advise.
Unexpected Behavior with Links to File Attachments
If I have encoded a link to a file attachment using html, the link only works if I also enable the field to be displayed in a view. For example, this works: But this fails: John M. Whitney
Creator "Reports" --- murky, hard to use, missing features... Ughh!
Woof! The so-called Creator "Reports" are the #1 worse designed module of Creator... period. How to use it is vague, confusing and murky at best. The inability to Sum a column at the bottom of a report (i.e. Grand Total) is missing, but there *is* some kind of strange "sum every entry" function that is visually confusing. And the so-called "preview" mode presents a narrow short view window, though the report is likely to contain several columns that need more view width in the preview. Strange
How can I provide alternate language versions of the labels in my public forms?
I want the user to be able to select language from a drop-down, and the form control labels and fixed text immediately change to the language-specific string I've provided. Thanks.
Hide Custom Actions on Permalink
I've noticed that if I provide a permalink that does not require a sign-in, people viewing the permalink can still see the custom action drop-down menu (when custom actions are present) and the custom action button if it is visible in the view. If a non-logged-in user selects a record and uses the custom action drop-down menu it actually carries out the action! I cannot find an option to hide the custom actions. If these cannot be hidden, it seems like a real bug and security issue. Please let me
On Add -> Validate issue!
What I am trying to do is the following: I have a form where people can register whether they are coming to the game or not... They have to fill in there name and they have to enter a date. Now I want to check if a user is already registered before submitting the form. Because duplicates are restricted. I use the following piece of code: if(count(Attendees[name == input.name]) > 0 && input.Date == '26-FEB-2011' || input.Date == '04-MAR-2011') { alert "You are already registered for this date."; }
Zoho Creator getURL hangs and does not return
Hi, I am trying to use getURL to integrate with a bulk SMS provider. The following URL (with actual password etc) works fine from a browser http://bulksms.mysmsmantra.com:8080/WebSMS/SMSAPI.jsp?username=xxx&password=yyy&sendername=Rentoys&mobileno=9199999999&message=Hello+World However when I use it with getUrl, the call hangs and never returns. I have tried passing headers (User-Agent etc) and I have tried simple and detailed response. But none of the options return. Is there any way to debug
IF statements and Email
Hi, im just having a issue with the below bit of code. Recipient=input.Email; Kaituna=false; Rangitaiki=false; Wairoa=false; Tongariro=false; Ohau_Channel=false; Hot_Pools=false; Pickups=false; if(input.Raft_Trips.contains("Kaituna River")) { if(!(input.Pickup.contains(""))) { sendmail [ from:zoho.adminuserid to:Recipient subject:"Booking Confirmation" message:(((((((((((((((("<div style="text-align: left; "> <div style="background-color:
Rearrange the fields in a column chart view
Hi, I'd like to know if is possible to rearrange the fields in the chart view. For example, I have a column chart with 3 columns: Ex, Cx and FO and I'd like to show the columns in these order: Cx, Ex and FO. Is it possible? Thx
Group Lookup Field List records
I am using the lookup field (Student Name) on a form that is based on another form that has multiple records for each student. Thus, I could have five records for the same Jon Smith student. In the lookup field it will list John Smith five times. How do I get the lookup field to group the like records so only one record for each student is displayed in the list?
embeded view open with filter
I am using embedded Creator forms for my site. I know how to add filters for a view and I know how to embed forms. My question is this: is there a way to open an embedded form view which allows you to pre-select a filter, but also allows you to select the other option of the filter while using the view. An example might be better: I have an application that tracks customers and their associated tickets. Tickets are either Active or Closed. From the main form, I would like to add a custom action
RSS feed problems
I'm trying to create an RSS feed from a Zoho Creater spreadsheet, but it's not working. According to the W3D Feed Validation Service (http://validator.w3.org/feed/), the feed is invalid. And, the feed won't appear on my desired reader: http://feedostyle.com. The application is public. Here's what Zoho gives me as the feed: https://creatorexport.zoho.com/westdepere.se/data1/rss/data1_View/ Please advise.
Help writing a deluge script to store variable based on date and frequency conditions?
Hi everyone, I have a form that tracks participants in a treatment program, and depending on what phase they're in would like to filter a view that shows which participants are scheduled to report in for the week. Phase 1 = every Thursday (every week), Phase 2 = Every 2nd and 4th Thursday (every two weeks), Phase III = Every 3rd Thursday (once a month) I was hoping to see if there's a way that I can create a formula to calculate who will be on calendar for the week, something that would result
Dynamically Change Initial Value in Lookup Table
I would like to display the current lookup field selection as the initial value for the next form data entry. As an example this would be useful if entering multiple time entries for an employee (selected from a lookup table of all employees). This initial value would continue to display until a new employee name was selected. Is there a way to do this with Deluge script?
How to send an email when a public user submits a form?
My app allows a public user to create a profile including their email address. How can I get the app to send a welcome email to that user? Sendmail seems to be prevented by the restrictions at https://help.creator.zoho.com/Send-mail.html. Thanks.
Automatically populate a field based on previous field's data?
Hi, I am wondering if it's possible to automatically populate a field based on the previous field's data? We are looking at creating a Library Check-in/out system for the students that come in and out of the library at our school. So for example, we would scan the student's id card and the id numbers would go into the Student ID field. Then we would like the student's name to then appear in the Student's Name field - the name would be based on what the id is. I'm assuming we would have to import
My forms not appearing in mobile.zoho.com
Hi, Not all of my forms are not appearing in mobile.zoho.com. Forms and views from one application appear correctly, but they don't from another. I built the other application yesterday, I built the new one today. Do I have to do something special to make them appear on mobile.zoho.com? Thanks!
Function not saving even though the code was not changed
When i try to save one of my functions ('ViewMatchingAssets') without having touched the code, it throws an error (a variable is supposedly not declared). The apps name is 'BMPM'. I have granted edit access to Zoho. Thanks for your help. Regards, Filip
Criteria Restriction is not working in Views
It appears that the criteria restriction option is not working for views. I have tried this across several applications and all give me the same error message: "Adding criteria failed. Please try after some time or refresh the page and try again." I have refreshed, closed my browser, and even tried using another browser, but nothing is working. Without this, I am unable to add criteria through the script builder or free flow scripting modes.
Can I capture a signature in a form on a mobile device?
Can I capture a signature on a form when using a Creator app on a iPhone? Maybe use a Rich Text Field? Suggestions?
Link to image in new window
After a user chooses a file to upload on a form and submits the form I wanted to create a url that would open a new window with that image in it. Is this possible to do?
Problems with user designations and script actions
I'm running into errors where i get proper results while creating and debugging forms with script while logged into my admin account, but testing the same pages with regular users don't work at all. any help would be appreciated, because if i can't count on the forms and script to work properly i will need to seek an alternative solution.
Serious problem with Views Criteria
This statemetn, entered via "advanced" criteria of a view, used to be accepted and is indeed used within two of my views (zoho.loginuser == CenterCode.UserName && SendTo == "Participant") Now I get the message Adding Criteria failed. Please try after some time or refresh the page and try again. and thi happens on new views I am defining BUT also on the ones where it used to work if I try to save them again !!! Please help as soon as possible. Thanks.
Field does not update for a certain record
I have a field (Overlapping_Search_Profiles) on a form (frmSearch_Profile) which for one record does not update when I do this: colSP.Overlapping_Search_Profiles = ""; and the record is part of the collection. I already checked if the record actually is included in the collection. Zoho has Edit Access. To reproduce do this: 1. In my app (bmpm) go to the section 'Admin' 2. Open the view 'Export View: Profiles' 3. Search for the records with 'aer' in the 'Player' column 4. Open one of the two records
Saving function without having made a change to it returns error
The following function was previously saved in Creator: string otherrecordmanipulations.CountEntityProfiles(string EName, string PName) { countNumber = count(frmSearch_Profile[((((Player_Entity.contains(input.EName) && Player.contains(input.PName)) && !Player.contains(input.PName + ":")) && Status == "Active") && Player_Status != "Passive")]); if (countNumber == 0) { return "none"; } else { return (countNumber).toString(); } } If I click 'Save Script'
Code comment not saved
In one of my scripts (on edit / on success) of the form frmSearch_Profile. I can not include a comment line ("// bla bla") above the line 'thisapp.TestFunc4(IDStr);'. Zoho Creator deletes it... Zoho has Edit Access. Regards, Filip
Next Page