URL Sorts by Link Not Name
Hi all, I would like to allow people to sort my lists by the link name and not the URL in views, but there isn't any option for that as Zoho automatically merges them into one record. You can see a live example at tshirtcoupons.com -- try to organize by "Website" and see how what happens. Any recommendations for how to make this work? Thanks!
Need help with Add Record
Greetings, I'm trying to add a record to a form called Walkers whenever there is a new record in a form called Teams. This is exactly like the example you have in your wiki. I have put this in the "On Success" section of the script, but it is not being added to the database. The script used to contain a redirect to another page, and that was working. When I added the Insert, the redirect stopped working too. I have since removed the redirect, and the Insert fails all by itself. Can you tell me
Billing
I just got billed for $5 again. My current plan says: "Free Edition" - please refund asap. Also, this has happened already last month
Unable to Import Creator Form Export- CSV Feed into Zoho DB
Hi, I'm unable to Import Form Data using the guide here: http://blogs.zoho.com/general/zoho-db-reports-integration-with-zoho-creator-step-1 On Import in Zoho DB , the table shows some javascript and html body tag. The DB import form, for 'Web Link' TSV, CSV, has an example link: Sales Details of a Store(fictional) across various regions and product whose URL is http://css.zohostatic.com/db/samples/StoreSales.csv whereas the CSV Feed Export link is in the format: http://creator.zoho.com/appadmin/appname/csv/viewname/
Edit Mode
Hi, I have a widescreen monitor and when I go into edit a record it appears in a box in the middle of the screen. It would be really good for it to just spread out over the full size of the window I have open - this would mean less scrolling to read text in the text fields. Thanks John Vagg
Count all inputs that were made this year
I'm not understanding how to Count all inputs that were made this year. This is what I have: count(ACTION_ITEM_TRACKING[Added_Time.getYear() == zoho.currentdate.getYear()])
The error is: "Error in statement at line number 1 Either the left or the right expression in a boolean expression in the criteria has to be a Form/Table Variable"
Bill Payment tracker in Zoho Creator
To reduce the paper clutter , I have created a Bill Payment tracker in Z Creator - http://smallbizonline360.wiki.zoho.com/Bill-Payment-Tracker.html . I will tie this into Zoho Docs as part of a Document Management system.
stateless and regular form during edit more
Hi..Zoho Experts, I am in such dilemma. I have stateless and regular form. I am passing password field info from stateless from to regular form and store in regular form thru openurl. It all works great for data entry in regular form. But when use wants to read data or edit data then password does not go to regular form from stateless form because am directly pointing to the view link to read/edit data from stateless from thru openurl. so I want to check the same password entered in stateless form
sortation of dynamic picklists
In the help section for "Dynamically adding items to a picklist," it says: "Currently, Zoho Creator does not support sorting of the values in a picklist which are added through script. We will be supporting this feature in our future updates." Just curious if this is still the case - is there any way to sort a scripted picklist yet? Thanks in advance-! By the way, great job on Creator - I'm really loving it and about to change my free account into a paid one.
Suggestion for ZOHO Creator ...
Hi: Recently i developed an Application that required quite a few HTML Views ... working with Free Flow Script ... because Real developers don't use Script Builders ... I found it that the code parser was not very good at identifying where exactly I missed a matching closing "closing wrapper text" (often identified row 1 as the offending line) ... requiring me to develop in tiny steps ... just so I could zoom in on any such errors. While this method of composing the HTML stream ... similar to that
Print Button??
This might seem like a crazy suggestion, but does anyone know how to create a print button for a webform in Zoho Creator. Been trying for 4 hours now. window.print() doesn't work when i try and add it in the script. It seems like a fairly obvious thing to be able to add to a form for me, but I can't find it anywhere.
Mobile Forms don´t support scripts ?
Hi Zoho support : I created a basic form to gather data. In the script on load I´ve hided several questions and wrote a script to make them appear or disappear if a radio button (YES/NO) is selected. The forms works great on-line. However when I try to access the form through my mobile Nokia E71 Broser (Opera Mini, Nokia Browser and Skyfire)It shows me all the questions (It does not hide them on load) and the alerts I´ve programed dont seem to work. Are there any additional limitations in the form
prevent others from using web embed code
using a database to run a website of sorts anyway to prevent others from seeing the embed code or prevent them from using the code elsewhere
Web Embedding
When I embed a view or form on a web page using an iframe, if I have HTML on my web page that links to another form or or view, it always asks for a login for standard users on each page. It does not ask for authentication on every link click if I am logged in, only standard users. Example: I have two html pages created on my web-site that each incudes a zoho creator view. In HTML on the page, there is a link that points to the other page, allowing users to switch back and forth between zoho
removing shared users on forms and views
Hi Support Team, I having issues with my application. I added some users (their gmail id is recognized by zoho and has application in their accounts ) and its been added successfully but when i tried to access the application, then it says 1. no access to this application 2. i tried to remove the user it says a. 12301 unknown object b. 301 object removed and gets back to me the application again. any idea ? Thanks,
View Link
Zohonians, I am trying to figure out how to change the content of the "view" link in the list view. Here is my example: I have the fields Company, Name, Category, Phone #, and Address; I'd only like to have category and company on the main list (to prevent people from simply copying and pasting all the contacts information off the list view), but I would like people to be able to click on the View link and see the company, name, category, phone #, and address. I am by no means proficient with Zoho
Question About ZOHO Creator Data API
Hi: Can I deploy the REST style of ZOHO Creator Data APIs from a program (something.exe) running on my local machine ? I ask this question because the Documentation initially states that ... Zoho Creator provides REST as well RPC style Data APIs that allows external websites to collaborate with Zoho Creator applications, with ease.... but later illustrates a sample method like this ... Sample Form <form method="POST" action="http://creator.zoho.com/api/xml/<application name>/<form name>/add/apikey=[APIKEY]
Summing Data just like in List view
I would like to know how I could sum data like I do in list view IN A COLUMN CHART! I am trying to show "total weekly sales" for each "office". I already have the correct week #'s and I can make this view peferctly in "list" view. However, when I try to make it in a chart each office's daily entry shows up as a separate bar. So for instance "Seattle" would show up three times vs being summed and showed once against all the other offices. Please advise. Thank you!
Creator > RSS Export
I have many reasons to thank you for Zoho Creator, but I would like to emphasize the value, to me, of the RSS export feature. It's marvelously handy to be able to aggregate data from Creator forms in RSS format. For example, I appreciate being able to view collected data in a Grazr widget. djweinstein
report results
Hi, I'm testing the "Client Satisfaction Survey" application I found on Zoho Creator. What would be great if I can link the results database to Zoho Db for 'live' reporting
Question about Custom Actions and Functions ...
Hi: I have 2 questions relating to Custom Actions ... a) When choosing to Show action for each record, is there any way of making the associated Row Button to show in a column that is not at the right end of the List View ? e.g. can a Row Button be positioned in the first (or third) column of the View ? b) In the Function associated with a Custom Action, I would like to have ZOHO Creator navigate to a Stateless Form within the same App ... if I use the openURL command with ... - the permalink value
Hacked
Just released application 4 days age and it has been hacked atready Any Suggestions
Error Importing data
I am having trouble importing data into an existing application in Creator. The data is to be imported into a table but contains only a portion of the total fields - ie 4 out 15. I have tried everything to get it to work - import into view, import into summary form, CSV, Excel, format changes, even reducing the data down to one text field. The massage is always the same - "An error occurred with adding the data". Is anybody else experiencing this or is able to help? Thanks
dynamic formulas in views
I have two forms that are linked by a lookup field. I also have a view based on the first form, the one that contains the lookup field. In the view, I can access the fields from both forms. Is there any way to show in the view the calculated difference between the value of a numeric field in the first form and a numeric field in the second form? (So that if either value is changed, the 'difference' will be reflected in the view)? Also: if the second form is linked to a third form by a lookup, I
Print Problems in IE7
Greetings and as always, thanks for a great app... I have read on the forum that much improved print functions are coming, but I wanted to offer one problem that I am having now in hopes that there is a work around of some type. In IE7, when you use the export to html feature to print, you only get the first page for printing...the output looks correct in the newly launched browser window, but when you go to print preview or send it directly to print, you only get the first page. Since exporting
can't view form
been playing with creator off and on for most of the day - but now however on 2 different machines i get the same display when i goto my app - phone bypass 2 -> forms -> add new the "insert fields" section will load - but not the right hand section which would display the content odd??
ability to add new data in database upon admin approval?
anyway of doing this besides the obvious - email information to admin and then the admin manualy enter the information?
ERROR IN VIEWS: We are unable to fetch this data, sorry. PLEASE HELP
When I’m trying to access most of the views of the App mx-netdev I’m getting this error: We are unable to fetch this data, sorry! Please note that your data is SAFE. Report this problem to support@....... Already report that to support@ but no answer yet. This is happening in most of the views, actually, in all views linked to the form Leads_Form The app is already shared to support. Please, I need this to be fix ASAP since it’s creating me a huge problem during the downtime Thanks
question
how does this work
Complex Filter driven by input form
How would this best be implemented? We have a need for GroupA users to fill out a request form where the check boxes next to various questions that will be used as a complex filter to go and generate a proposal report based on selected target companies. Assume The target companies information has already been entered via various other forms/applications. The challenge is now how to allow Group A users from various Companies to in effect generate a customized proposal based on the choices they make
Using your product
Thank you very much for providing this free service--and if it actually works, we may well subscribe. That said, the interface is a little confusing. It would be nice to have a 'Save" button on the forms during form design, just to confirm that changes are saved before a user leaves the page. It is odd that the tables are called "Views". It took me a while to understand. And so, where are the actual views, that is, views of how the forms look to a user? It would be nice to have a clearer progression
Arabic support in zoho creator
Hello i ve posted a topic related to this issue but i think the moderators didnt allow it so i don't know why??! i'd like to create an arabic form (contact form) so i need it in RTL so could you help me please? sorry for my bad english!
How to access the background color in HTML view ?
Anybody know how to access the background color in HTML view ? I have the following code : htmlpage NEW3() <%{%> <body style="background:#0000FF"> // The blue <table cellspacing="1" cellpadding="1" border="0" width="100%" style="background:#FF8000"> // The orange <tbody> <tr> <td>test</td> <td>test</td> </tr> <tr> <td>test</td> <td>test</td> </tr> </tbody> </table> </body> <%}%> You can view the page
Question regarding summing formulas
Hello, I'm trying to create a column where a formula adds the numbers in several other columns. Example Variable_1 = 2 Variable_2 = 1 In the summed column, I'm selecting "formula" and typing (Variable_1 + Variable_2) Instead of getting "3", however, the field is displaying "21" What am I doing wrong? Thanks in advance!
How do I post to URL
Hi, I have been looking at the Deluge scription reference as well as the tips and tricks and theforums however I am unable to finad a solution to my problem. I have a form for example with 3 field A, B and C. I need to Post this data to an external PHP script to be recieved as a POST, processed and possibly returned to update the form or another form. I would like to know how this may be achieved. From my understanding the postUrl function requests variable from an external applications. I had tried
possible to make fields mandatory, but only when fields are shown?
Hi I have the need to let some of fields that are hidden in the "load", to be mandatory (but only when they are shown via selection in a picking list) Is this possible? Br Skouboe
Another Defect related to handling of URL Encoded Characters ...
Attention ZOHO Creator Support: I have discovered another problem related to ZOHO Creator's handling of the URL Encoded value associated with the single quote ( ' ) character. I have an HTML View that reads a (previously stored URL encoded) value from the logged in User's record in a Table ... and passes it as a parameter to an embedded View ... so the records in the Embedded View ONLY display records where a given field/column matches the passed value. The part of the HTML View script that displays
On Delete Script Action for Forms
Hi Devs, It would really benefit the Creator platform to have On Delete Script, On Validate & On Success actions, for Forms. Relationships across databases then need not be maintained seperately by running random stateless form queries. This would streamline the programming process as well. Instead of us hard-coding work arounds. It would be wonderful to have this feature. Please include this in your roadmap. I invite other developers to give their views, especially if they have come across this
How do I manipulate the html of a view?
I have a view (http://creator.zoho.com/martta.rosa/livros/#View:listas_vender_en) to wich I would like to add a tracking code, from Google Analytics, immediately before the </body> tag. <script type="text/javascript"> ...</script> Where can I find the </body> tag in a view? Thank you,
How can I paste a form on my website/blog ?
How can I paste a HTML form on my website/blog ? How do I come to know if somebody fills up the form?
Next Page