Combine data in chart
Hi, I have a table with rows of stores sales each week, example: Week1, Store 1, Sales xxx Week 1, Store 2, Sales xxx Week 1, Store 3, Sales xxx Week 2, Store 1, Sales xxx Week 2, Store 2, Sales xxx Week 2, Store 3, Sales xxx Week 3, Store 1, Sales xxx Week 3, Store 2, Sales xxx Week 3, Store 3, Sales xxx I have a chart showing sales development over time. In this chart i have a user filter to be able to see a single store. Question 1. Can I show the single store develoment in a chart together with
Basic Budget Application
I am trying to create a very simple budget application. When I submit a purchase in my Add_Purchase form, I want to send the Cost of that purchase to a form that tracks the Expense Account. In the Expense Account form I already have the budgeted amount for the year and I have a remaining balance formula field that will take the Budgeted_Amount and subtract the Amount_Spent from it. However, I cannot get the purchases once submitted, to shoot that Cost over to add into the Amount_Spent. Instead,
Site visitor statistics
Can anyone let me know how I can get site visitor statistics out of zoho creator? I have setup a public viewable database and i want to see how many people are viewing it. I use wordpress and they have an awesome site stats report. Thanks
Formula Help
Here is what I have: ((Weight * 0.417 + Weight1 * 0.585 + Weight2 * 0.75 + Weight3 * 0.9 + Weight4 * 0.916 + Weight5 * 0.999) / 20) It works great in calculating the value I am looking for. For fields Weight, Weight1, Weight2, Weight3, Weight4, and Weight5 I am multiplying by a known number. I want to add field Weight6 but the number that it is to be mutiplied in order to give me the value I am looking for changes. I added an additional field Fineness to enter the proper number
too wide page in edit mode
With free flow scripting active in functions section but not only in that place (in scripting part of the forms forms and in html views the same happens ), when I use Chrome whenever I activate Refer Fields section from the left and I change the function (in functions sections) or I save the script, the page becomes very wide and I the horizontal scroll is activated. The following short screencast contains an example http://screencast.com/t/BeZbkfmc Regards, George Baltatescu Zoho Creator Developer
Do Zoho Creator Forms work on a Tablet?
I see some related questions from years ago that went unanswered. I have to evaluate this very quickly for a potential contract. I don't need advanced native abilities on the tablet. But I do need basic forms to run well on a tablet, with some way to enter comments, even if it means I custom build alphabet buttons inside the form. Can these forms run on a tablet? If not all tablets, can they run on a Windows 8 / Surface Pro tablet?
Twitter content
Dears, I'm using "html view" in Zoho Creator in order to show some content on my website. I have 2 questions: 1) How can I show the latest twitts sent to my Twitter account on the "html view"? 2) Can I add the latest twitts to my database as new records? Can you provide some code examples or scripts in order to do these tasks? Thank you very much in advance.
Monthly "snapshot" of data
I've built a PPM (project portfolio management) tool that tracks pending projects, active projects, complete projects, etc. Naturally, I always have a live view of how many total projects are pending, active, when they were last updated or other data. However, I'd also like to take a monthly "snapshot" of some data to show trends over time. Can anyone help me with the best way to approach this? Would I need to create a new form that captures the current state of data using the Scheduler? Is this
Timesheet Total Time Worked Calculations
I have seen the below forum explanation of how to generate a timesheet where the start and end time are submitted in the following format, 08:30, 16:45 etc and a total is calculated for hours worked. I don't understand how to use the script function yet, could someone provide an explanation on how to do this? I would also like to add a field for Lunch Break which could have entries like 00:30 or 01:00 as in half and hour or an hour and for this time to be taken off the total. a) you could use Single-Line
Splitting date and time help
Hi, In my form there are 3 fields I need help with, Field A. date and time field Field B. Date field Field C. Time field What I want is when Field A is filled Field B is filled with the date part of Field A and Field C is filled with the time part of field A. So Field A = 28-Mar-2013 09:00:00 Field B = 28-Mar-2013 Field C = 09:00:00 Can anyone help please Nigel
Dynamically expanding Checkboxes
Hey guys Im not sure if this is even possible but I though Id throw it out there. So I want to have a list of Checkboxes that are based on data from another table/view. this would be say for instance a list of Vendors that a member of staff can belong to, but if another vendor becomes part of the portfolio then the list would be updated and they can be selected, at the moment im doing something similar with a Multi Select field but it just seems messy to me... checkboxes would be sweet! any suggestions
Best way to launch a Stateless Form from a View
I want to display a set of records in a view and have a custom button on each row that will allow the user to choose the record, then open (in the same or new window haven't decided yet) a stateless form for that record. I will have it display the entire record, but also expose about 5 buttons that will do more complex stateless database functions and send emails, etc based on the button push related to that one record in the stateless form. I have not seen any particular info on this in the Deluge
Upgraded security framework
Care to elaborate? Thanks, John
exporting the PDF of an html view
Hi, Is it possible to: 1. Export a pdf of a html view to the system ( rather than downloading it ) and 2. Attach it to an email Thanks, Guy
Image reducing in view list.
I would like to have the images in a list reduced and I found this formula but I couldn't get it to work. There wasn't any descriptions on what to change so I am not sure I making the correct changes in the formula. Is there an easier way to change the image size? Please Help. (((((Image_1).replaceAll("border","height='200px' widht='200px' border")).replaceAll("sharedBy","zohologinuserid")).replaceAll("appLinkName",("image-workaround"))).replaceAll("viewLinkName","image_View")).replaceAll("fieldName","Image_1")
Populating drop down box selections
im creating a surgical case log. I want to create a procedure entry drop down box. I have an excel spreadshett with the 100 or so different operations I do. Is there a more efficient way to get this set up than manual entry as I'm afraid this will not be feasible from a time standpoint. Thanks for any suggestions
Apply filter and view result in a different view
Hi guys, my question is: can I made some search (or apply some filter) in a specific view (A) and view the results in another view (B). For example I have a form with this fields: first_name last_name adress city zipcode sex I need to search my friends for "sex" and I need to have a result view showing only last_name, adress and city. Is it possible ? Many thanks Vittorio
Another minor bug? unable to update script
When saving a Deluge Script that has certain syntactical errors the system says "Updating Script...." and will sit forever in this state. The script will never be updated and no error will ever appear. The only way to resolve the issue is to refresh the screen and enter the script again. Because there is no error reporting you have to find the error on your own. Of course this is less than ideal and could make life difficult for coders new to Deluge syntax. I believe this error is fairly new and
Need basic help with drop down or multi-selection
Let me start by saying I have zero experience here but I am a learning as I go. I have a small issue I am sure one of you can help with. In simple terms I want to ask customers how they prefer to be contacted. The options are Mail, Email, SMS, and Do Not Contact Me. I want to have a box appear for Email if they chose email as a preferred contact method and then also have box appear for Cell phone if they chose SMS as a preferred contact method. The address is required and we collect it earlier on
On edit script issue
Hi there, I'm recently getting an error that has not happened before. When I edit an existing entry and try to add a new Subform row, I get something along the lines of: " Error in executing On Add Row script of XXXX. Error. Error in executing Set Variable task. Unable to update variable XXX. Error evaluating NUMERIC expression: ... " Adding new entries does not produce this error. I suspect this might have to do with a recent update since
Edit Mode changes the view
So using Deluge script I was able to hide parts of a form but when I got to edit mode the entire form shows up is there a way to make the script work even when juist viewing it in edit mode?
Email Log
If you exceed your daily email quota of 500 emails per day the balance of emails are logged. Is it possible to access the log to see the initial 500 emails?
Google Calendar API
I am trying to learn how to use the Google Calendar API to add an event created by Zoho Creator form to a Google Calendar. I have a main calendar set up in Google with subcalendars. I would like to be able to add an event to the specific Google sub-calendar when the form is submitted in Creator. I am currently using the Creator Calendar Feeds which work great, but I am not happy with the lag (calendar is not updated immediately). I have seen this post: https://www.zoho.com/creator/help/script/create-event-in-google-calendar.html
Pagination Code
Hello friends, Today, I am sharing a pagination snippet with you. ( http://www.webnersolutions.com/ ) ============================================================================= Function name : calculateTotalPageNumber ----------------------------------------------------------------------------------------------------------------------------------------------- list calculateTotalPageNumber(int total_record, int display_per_record) { if (input.total_record <= input.display_per_record)
[HELP] Post data with php CURL
Currently I am trying to post data with cURL and PHP to populate my custom built app. However I can't seem to get anything to work. I can easily post data the same way to the CRM but not to the creator. This is my code: public function serializeModelling($object) { // Set the curl address $this->curlAddress = 'https://creator.zoho.com/api/xml/write?'; $this->scope = 'creatorapi'; $this->token = '***'; $this->extraParameters = ''; $xmlData = '<?xml
My Zoho attempt
Hello Zoho community, I'm new to Zoho, but certainly not new programming. Unfortunately, I have a hard time figuring out how Zoho could be used for creating any kind of application given the limitations I have seen so far in the level of flexibility of how views and forms can be mixed and the fact formulas don't update themselves as they should when lookup fields are involved, thus creating a large need for (OnInput) code, which is a far cry from the promise of drag and drop design, and requires
Successfully display 1 to 10 number without using for ,while , do while loop .
Hello frnds , I am a newbie in zoho creator.yesterday was my tough time in office when i saw we cant use for,while,do while looping statement then how to display 1 to 10 or more number in successor. My friend Nitin ,who works in webners ( http://www.webnersolutions.com/ ) help me in this.I am sharing a code of snippet with all of you. Function Name : makePageNumberList ------------------------------------------------------------------------------------------------------------------------------------------------------------------
'Merging' the records of two forms for display
Hi, I wish to combine the selected records of two forms: BalanceSheet, Invoices where they have similar fields: Date, Description, Amount I am then displaying a list of the combined results in a html view called Books. What is the best method to 'merge' and sort these records for display or is this the wrong approach? Thank you, Guy
Minor bug? unable to change certain field types on stateless form
Creator is not allowing a certain field type change on stateless forms. When trying to change a field from a Numeric to Decimal type in a stateless form the system allows the user to select the Numeric field for changes. As in the past, the system then allows the user to open the drop-down associated with the selected field and also allows the user to choose the new field type from the drop-down list. In this case, once the Decimal field type is selected the user can navigate away from the field
Deluge Script - Atomic test & set operation with concurrent users
Hello, I have an application which will be used by several users simultaneously. Each user can edit the same data e.g. same record may be removed, updated, etc. Is there some method to address the problem (i.e. race-condition)? Are there any atomic methods that provide "test&set" funcionality?
Feeding a date to a Custom Action function
From a view I need to modify several records at a time based on a date. I want the user to check the records in the view and then call a custom action that asks for the date and then performs an action on each of the checked records. I am feeding the checked records to the function as a form object. What is the best method of getting the date for the function? Herb Wexler
Access workspace apps via mobile?
Hi, is it possible to access workspace apps via the javascript enabled Mobile site (https://mobile.zoho.com/creator/)? I can only access my personal and shared apps but not workspace apps. I can access them via creator.zoho.com/mobile, but apparently this version is limited. cheers, Jeremy
creating a 'wizard' in Creator
Greetings I would like to create a wizard that allows my users to complete a series of forms to complete one 'profile'. Putting all of the data needed into one form would be clumsy and very large so I would like to give my users a page 1 then page 2 then page 3 etc. environment... something that they can save and finish later. A common profile would be like an application for a university or complete employee application with history of education and jobs or a form to gather up all information connected
Showing subforms using the client API?
Hi, I'm trying to use the Zoho Creator client API to show an internationalised version of my form. It works allright for text inputs, but when I try to add a subform, it doesn't show anything. Here's the code I'm using: <span id="first-name-label"><script type="text/javascript">Zoho.writeLabel("Language_Competency");</script></span> <script type="text/javascript">Zoho.writeInput("Language_Competency");</script> </fieldset> Coming from this form (edit access provided to support). Any tips? cheers,
XLS attachment in Report Schedules
How do I attach .xls attachments of my views in the report schedule? Currently the data is in PDF format, which isn't helpful. Thanks, Sudeepta
Downgraded to Personal Free Edition?
Hi support, Why was account sigroup downgraded to the personal free plan? Thanks, John M. Whitney aka buzzap and sigroup
Zoho Not Being Updated From Paypal
I have an application in which users are registering for events (a bicycle club). Starting March 7th, we have had multiple instances of people successfully paying for their registrations in Paypal, but Zoho never seeing the completion data from Paypal. As a result, we don't have a record that the transaction is paid. It's happened in about 20% of the transactions. There's no pattern that we can see as to the type of registration, the event, or the type of Paypal payment. All transactions run
When a Fields' Choices are Updated - Will the Deluge Change Automatically?
When a Fields' Choices are Updated - Will the Deluge Change Automatically? For example, I have a radio button list of 5 choices: Favorite Fruit: - Apple - Banana - Television - Kiwi - Persimmon Now in my deluge script I have: if (Favorite == "Television") { do something; } My question is, if I update "Television" when editing the field to "Orange", will the deluge script automatically change to: if (Favorite == "Orange") { do something; } Now, my specific situation is a LOT more complex. As I have
Multiple Forms with a single table
I have a single table which contains all my data but I want to use 2 or 3 different Forms to populate it. The trouble is as soon as I set up a new Form it effectively sets up a new Table. I want to be able to enter Fields like Name and Address in all the Forms but then add in specific data in just one of the forms. For example, I would like to enter a customers Name Address and Contact info in all the Forms but some forms may require additional information such as Delivery Info and another form Collection
What are the built in features in Creator to create a Calendar view like this?
Is there a way to create color coded events? Is there a way to append a check box for which events to display?
Next Page