Auto calculate fields when another is selected
Hi, I am trying to see what I want to do is possible using Zoho Creator. In my application I have a field that has a list of names, a field called Placement Price, and another called Commission. When one name is selected, I want the Commission field to auto-calculate this person's commission percentage from the Placement Price. Is this sort of thing possible in Zoho Creator? Thanks, Elizabeth
Need to add rows in an entry form
i want to create a form that askes for previous experience in jobs. I want to capture about 3 column headers and have a row for each one, how can i create "rows" in the form builder. All my questions have to come one after another in a vertical manor any help will be great. i have created a similar form in XLS but want to put it online in a form. any help? Thanks
Can't remove shared app??
One of my shared users wants to remove/delete an old app that someone shared with him over a year ago and he never uses. There is no clear way of how to do this?? How can you delete old shared apps you no longer want? Thank you!
Form Schedule Frequency
I have a form schedule below. My intention is to have it run constantly, identifying records to delete based on the criteria. Since the Modified_Time is only a date record, the frequency = Once. Does this mean the schedule will only one Once and then quit forever? When? Identify_Recs_to_Delete { Execute on 28 days after of REQUEST.Modified_Time } What? rec_ID = (REQUEST[(STATUS == "Complete")].ID).getall(); for each element in rec_ID { delete from REQUEST[ ID == element.toLong() ]; } Cheers,
Grid View
Hello, I would like to use a grid view in order to allow for a various edits for various records while they are displayed on the same page and without going through editing each record. I realized that I am not able to do a grid view because I have deluge scripts (on-edit and on user input) on the form the view is based on. I noticed that you do not currently support it. Are you going to support it in later version, and if so, when? any suggestions for a work around where I can change the values
Adding Criteria failed
try to add search criteria in app's view "Adding Criteria failed. Please try after some time or refresh the page and try again." how to resolve it? app https://creator.zoho.com/vsavonkin/view/40/edit/
Captcha not working?
I have gone through the Captcha help files and successfully added the function to my bespoke web lead form but whilst testing if I enter the wrong code in the Captcha field it still allows me to complete the form request. Can someone help as we are having a large amount of spam currently?
Style based URLs Embedded forms
Hi, parameters looks to be omitted in certain cases of embed forms : for example, in a HTML view, we embed a form with : <div elName='zc-component' formLinkName='FormName' params='zc_Header=false&zc_LblFontSize=18'>Loading...</div> The parameter in bold works correctly, but is omitted when we use the permalink of this HTML view (zc_Header=false is ok but not zc_LblFontSize - not tested with other customization parameters). There's no problem when we use Iframe instead of div. That's minor but good
Maintaining Links when exporting html to pdf
Hi, 1. Is it possible to maintain the <a href="link"> when a html page is exported to a pdf? 2. Does anyone know of a solution using creator/zoho to create a report/document in html and then turn it into a pdf with links. I would like to have thumbnail images that link to larger files if the user wishes. I realise that the application has to be public if I want to be able to export the images. 3. Is it possible to export a html page to pdf and then attach it to an email? Thanks,
Overview of data from different forms (But from same application)
Hi, If i create a single application with several forms, will i then be able to create a view/ report where i can see all data from all forms in just one view? Or can i only see the data form by form? Kind regards, Bo Thygesen
Grabbing the field names for a form
Hi, I want to grab all the field names for a particular form fieldslist = getFieldNames(); // would be from the form itself in the onSuccess action But what if I'm working in a function. Thank you Guy
Help with button
So in my form I have a check box or radio button (doesn't matter which) that when I click if activates the script sendmail [ from:zoho.loginuserid to:input.Agency_Email subject:"Message from Nigel L Cross (Kent)" message:input.Email_Message content type:HTML ] What I want is to have a button within the form that does this instead of using a check box or radio button. Is this possible please Thanks. Nigel
Script Won't Save?
Hi, I came across this issue multiple times, and it is starting to get really frustrating. Basically, my script will not save. No error message shows up, it just keeps saying "Updating Script", but it never actually updates or saves. It happens when I am using a conditional statements where I use "&&" to add another condition. For example, this script will not save. //Alert Box that shows a pop up message if the user tries to select a bike that is already online x = Bike_Listings_Current[Bike_Serial
Refund Requested - No Reply
I've requested that my account be cancelled and a refund issued, but no reply. How do I get someone from Zoho to confirm that my account has been cancelled and a refund issued?
Edit form fails to load if Zoho CRM User look-up field has value
Hi, One of the forms I have been building for a client has a look-up to Zoho CRM's Users module and this Zoho Creator form fails to load in edit mode, when some user record is already selected for this field. When I make this field empty, by using the Bulk Edit option, the edit form opens up without any issue. I have provided below relevant images.. Error scenario : Same form loading with the field is empty : I also have another such Zoho CRM look-up field (referring to Accounts) in another Zoho
build a report based on form and sub from
Hi all, I have built and form and then a sub form with in it so that a person registers their details in form 1 and then in the sub form enters there interests one at a time "submitting" each one as they go. Now that i want to report the details i cant seem to join the two forms to produce one output. Any ideas? Regards Duncan
Running History Information (Change Log)
Hey all So I have a form set which is a project, on the records there are multiple changes happening, for instance costs, allocation of the owner etc. Im trying to find a way to record all the changes; Within the for set I have a Multi line field which ive called history, when the field is first created I would like to enter in the history "project created by " && zoho.loginuser - this returns an error LHS cannot be a constant, not sure exactly what that means but obviously doesn't like having text
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
Next Page