How can I sum the field of all the entries of one form?
How can I sum the field of all the entries of one form and show it in a field of another form like a "formula field" for example. I have two forms, one with people and another one with bills. The bills form have also one field with the price of the bil, and another field with the name of the person ( of the person form). I wanna do a form that shows me the sum of all the prices of the bills that have one person, for example. is the solution a formula like "count"?? Which formula? Who it works? Thanks
Need link to "View" page to show field not on View rows?!
I have a NOTES field that I do not want displayed on the View because too much text but would like to have the NOTES field displayed when I click on the record VIEW link. I know that when I click on EDIT link ALL the fields show but that is too many. I would like to be able to select which additional fields show on the "View" page. Can the View link page be customized? Also, a Multi-Line field can have unlimited characters but the default size of the field is too small. I would like to customize
Problem with PDF generated from Summary View
Hi: I discovered a problem when deploying this form of the url ... http://creator.zoho.com/scriptedlogic/myApp/pdf/myView_View ... even though myView View is defined as of Display Type of Summary ... the PDF file generated by ZOHO Creator renders the content as if the Display Type was List Is this a defect ... or does ZOHO creator only support PDF rendering of List Views ? Gaev
Opening pop-up views with multiple criteria
I have created a relatively easy function to open up a pop-up view: openUrl("#View:vwLangAvail?cboLanguage=" + input.Language + "", "popup window", "height=100,width=100"); Is there an easy way to have the view open with multiple languages selected? Thanks, Leo
Multi Select Box
When a specific item is selected From the Multi Select Box, I would like that to "Show" a specific box. Normally I would go to "On User Input" use the "Show" function and input the field that I would like shown. However, I do not want it activated simply on input... I would like specific fields to be shown for each list item. Does this make sense... I am sure it has been covered, and I am sorry... I am just not sure where to look. Thank You.
Form Missing
I built a form application, began collecting data, now my form has disappeared. I still have the data but no way for additional people to add to it. After having about half my team complete the forms, I'm now stuck with starting over. This doesn't seem very reliable. tim
Poor Handling of Linked Views After Sign-in
I have a system that sends an email to a user with a link to a specific record by ID#. If that user is not signed-in to a zoho account, when he clicks the link, the sign-in box appears. After signing-in, the link to the specific view is not served, but rather all records in the view. If the user is signed-in, then clicking that link in the email presents the specific record view. What I's like to see is the sign-in process to "preserve" the original url, so that when the user completes a sign-in,
Where is Email Scheduler
What Happened, last we heard it was SOON, but that was over a month ago. Please update us, this is an important feature that i am sure many people are awaiting, thanks BG
Web Conference for Zoho Creator
Hello. I'm thinking of organizing a Zoho User web conference. I would like to have some initial feedback from the community on these questions: 1. Would you attend? 2. If so, what topics would you like to have covered? 3. Would you also want break-out sessions on various Zoho Creator topics, tips, and techniques? 4. Which Zoho Developers would you like to invite to present or teach courses? 5. Which time of year would it be best? Summer, Fall, or Winter? 6. If you are a Zoho Creator staff / employee
Zoho Sign-in Box
Is there some way to have a Zoho sign-in authentication box in my form, or as a pop-up, or DHTML type floating object?
Can I allow editing of only last form submission in a view?
I'm having my employees submit their timesheets via Zoho Creator, and I was looking for a way to only let them edit the most recent one, or any submitted in the last 2 weeks. Is this possible?
Feature updates and bug fixes
Greetings to Zoho Creator Users. We are pleased to announce the latest set of feature updates and bug fixes. We now have the complete support for Firefox 3.5. The latest update includes one of the important requirements to import data from a file. The users hereafter need not copy and paste the data into the text area that is provided, but specify the file containing the data instead. The specified feature supports the .csv, .xls and .tsv formats. While this is an enhancement, the feature to copy-and-paste
I would like to create a consultant book system
Looking for a template to modify for the following application I would like a user to check a calendar for a particular geographical location to see whether a consultant is available for that town at a particular time and date for one of 4 training courses. The consultant must be able to modify an online calendar to say whether they are available or not and which courses they are qualified to deliver etc. Once the user tries to select a date and time it should be reserved and the consultant will
Need help with login question
Hi friends, I need help with a workaround. My users are not on Zoho, so I have a simple login form to determine if they are registered to use our appointment system. they enter a login (their email) and password in a stateless form . If that email is in our database with the correct password, the login form sends them to a url with a second form to schedule an appointment. I needed a way to save the logged in "state" of the user so that when they get to the second form, I know who they are and
Turning a string into date/time and back
Thanks to Gaev and Zoho developer friends for helping with my scheduling app. Here is a function for anyone who is trying to do something similar--it takes times formatted as strings (such as 10:00 AM), and convert to date/time for calculation, such as adding 2 hours. Convert string to date/time: date TextTimetoRealTime(string texttime, date newdate) { //This function takes a time string formatted with AM/PM (ex 2:30 PM) and converts it to a real time/date. Arguments are the source of the time
ical feed - Calendar Name problem
Hi there, I'm having a problem with subscribing (in Google Calendar) to my Zoho ical feed. Google Calendar does not seem to be recognising the calendar name, and seems to be giving it a randomly generated name of numbers and letters. Here is the URL for my Zoho ical feed: https://creatorexport.zoho.com/katieboyle598/test/ical/Calendar1/DTSTART=Start&DTEND=End&SUMMARY=SessionType&DESCRIPTION=Attendees&STATUS=Status&LOCATION=Location&ORGANIZER=EventOrganiser When I check this in the browser, I can
How do I calculate the age of a person at a later date?
I want to calculate the age of a person in May 22 of 2010. How do I go about doing that without having two visible date fields. I looked at http://help.creator.zoho.com/Date-Calculations-and-Formula.html#3._How_can_I_calculate_the_age_of_a_person_from_a_given_Date_of_Birth? and other questions on that page and was unable to arrive at a solution.
An action on the "Submit" button
Hi all, I have created a form with some initial questions. I have created another form with a different category of questions. Is this possible: On form 1, on "submit" button, go to form 2 Thanks for your help
Unable to Edit items
I have setup about 7 different Views in my application. When accessing my application, 4 of them (all under the same Section) will not let me edit record data. I can click on the Edit button next to a record, and a new window pops up, but there is not data in it to edit. The Views in the other sections work as expected. Any idea what is causing this issue? Thanks
Unable to Edit a record while in View mode
When accessing my application and going to certain Views, I tried to edit some records, but the popup screen is just dark and blank. Other Views seems to work just fine. Please advise. Thanks
Is there any way to add image from api???
Im working on an creator.zoho application almost done.. all is perfect except images cannot be added using api.. just wondering is there any way to do this.. any help would be appreciated. thx!
Bulk Edit & Password
I have embedded a view into a website with prompt for password. Even though Bulk Edit is not checked in the set permissions section it still shows in the view. Is there a way to remove the Bulk Edit option? Herb Wexler www.PreventingMediocrity.com
Not duplicating app
Hello, I'm trying to make a copy of an app that i created, but it's not working, so I tried to save as script and load it, but this did not work either, then in my Home sectons I clicked the button Duplicate but also didn't work. So I tried to import from a MS Acces database using your migrations software but again, it did not work... Is it a temporary bug or am i doing something in the worng way? Thanks Rodny :(
Unable to import data into my application in a paid account
I have also e-mailed support. This is really a problem because this database is to accompany some stories, and it needs to be updated by tomorrow. Whether I cut & paste the data in or try to upload the file, nothing happens either in Firefox or Safari. I don't really feel like re-typing in 100 entries manually. Don't know if this is a problem just with our app or if others are having the same issue. Hope someone at Zoho can look at this promptly. Thank you.
New Zoho Creator version?
Zoho Creator team, I saw that Zoho launched another product (Zoho Recruit) which has a part "Powered by Zoho Creator" ) as it is written here , a form which can be customized using a Creator-like drag and drop interface. The interesting part is that I noticed some aspects which still do not exist in the actual ZC platform: Auto-increment field Sections in the form (which can be re-ordered using drag and drop) A link under the picklist field to add new available selection options A link under the
Google Dumps Gears for HTML5
http://www.readwriteweb.com/archives/google_dumps_gears_for_html5.php Written by Jolie O'Dell / November 30, 2009 so what's up at Zoho ?
Zoho database and Visual Basic
Dear all, I'm a new user and I need to know if is possible the connection on my DB (created using zoho creator) whit Visual Basic because I need to run an applicaton (made whit VB) to update this database Does a connection string exist? Best Regards
Configuring Date field
I have a date field in one of my registration forms. However, the current format is "dd.MM.yy" and I would like to change this to "dd/mmm/yy" like it is in one of my other forms. I looked to http://help.creator.zoho.com/Configuring-a-date-field.html for help, but the date format option is not available in my application settings for some reason... What else can I do?
Another Field dropped from the Application Settings Form
ZOHO Creator Support: In addition to the missing Date Configuration field on the Application Settings Form ... documented here ... http://help.zoho.com/portal/en/community/?ftid=2266000000681910 ... I believe the field related to the assignment of a Developer (i.e. Provide edit permission to:) is also missing from this form. Please investigate and advise ... I can not assist a client until this is fixed. Gaev
How to create a relation 1-200+?
Hi I have one form where I can enter stakeholders. For each stakeholder, I would like to select his requirements. Around 20 requirements per stakeholder. These requirements are stored in a table, about 200-300 requirements. How can I create a from where I can "add" requirements in a nice way? If I do it like here http://zohocreator.wiki.zoho.com/Creating-relationship.html I have either 20 very long dropdowns or 200-300 checkboxes. Both not very userfriendly. I would prefere something like a dropdown
Hiding a field when embedding a Form in a webpage
Hi - I have a form that includes 4 fields. I only want 3 of these fields to appear when I embed the Form in a website for customers to input the initial data. Is there a way to hide these fields when embedding them in a webpage? I would still want the ability to add data to these fields when I access the application myself later. For example, my Form includes Name, Address, Phone, and Category. Name, Address and Phone would be embedded in a webpage for customers to input. However, I do not
Interfacing ZC with outside server
Not sure if this is for the API forum or Creator so I'll start here :) Would love advice on how to take my application to the "next level". Currently we are using ZC to manage our video assets that are living on an outside server (Ubuntu server). We have certain meta information including title, fileName , and other info on our ZC app. The ZC interface is very slick and we love the potential and now would like to do more. On the outside server we are doing two primary tasks: encoding and ftp transfer
Do Zoho creator free version has export to CSV
Do Zoho creator free version has export to CSV facility ? If it has , how do i do that ?
CREATION A DROPDOWN LIST LINKED
I WOULD LIKE TO CREATE 3 DROP DOWN LISTS LINKED CLICKING ON THE FIRST DROPDOWN LIST WILL DETERMINE REACTIONS OF THE 2 OTHERS
How do I use a Variables to Call a Function?
Hello. I'm working on a Zoho App where I will be using many functions for determine eligibility for client membership and each function's name will be assigned to a specific Criteria form. The Criteria form will have a String or Text field named "Function Name". I'm hoping to call the function name on a separate Form named "Screening" where if the Criteria Type is equal to "Function" and the "Function Name" is present, it will use that particular function assigned variable to call the specific function
Issue with EDIT record
In my apps, only the admin can edit a record with that kind of link : https://creator.zoho.com/<adminuser>/<appname>/<formname>/record-edit/<viewname>/290930000006308125 The view and form are shared with users. Any tips ? Thanks, Pascal
Stateless Forms
There three distinct types of buttons: Submit, Reset and Custom buttons in Stateless forms. So Could you tell me what is different about the 'Submit' and 'Custom buttons'?
Limiting the Amount of Text Displayed in a List View
Hi. I have a table displayed in a list view which has a couple of multiline fields. Because these can be up to 65k characters, they can grow quite large and make a compact display impossible: Is there any way, for display purposes only, that I can limit the amount of text, while not disrupting the actual underlying data? Thanks very much! matt
Passing key fields to other forms as a global variable
I just started with Zoho Creater this morning - it seems like fantastic scalable application !!. !I am having problems with creating a common key field called DEAL_ID and using this to pass to other Forms as the key field. I have tried various ways such as using a script on the form called New_Deal DEAL_ID4 = input.ID + "_" + input.Deal_Name; share form("application", DEAL_ID4); But this does not seem to pass the DEAL_ID4 variable to any other Forms in my application ? Would appreciate any answers
Powered by ZOHO Logo
Today, I now have the 10 user plan, but all my embedded forms still have the "powered by" logo. I read a few other posts here about this issue and tried to clear the browser cache, rename labels, rename forms, etc..but the logo is still there. It's not a big issue since I enjoy helping spread ZOHO awareness, but I'm curious just the same.
Next Page