How do I create a script based on a selection from a dropdown list?
I want to create a script in a creator form so that when a user selects a city from a dropdown list, another dropdown list appears with all of the neighborhoods in the selected city. At this moment I am stuck trying to create a Actions on User Input script and I can't make an If condition that recognizes the dropdown items as variables. Thanks for any help you can give me.
Not able to untoggle secure access
Hi, In my application "Board Elections 2012" the Ballot form is not loading. I suspect that the issue might be https, but I am not able to untoggle secure access. Clicking the button and saving under settings has no effect. The next time, I open settings, it's back to https. Thoughts? Brian
Rename application does not work
When I try to rename my application from the Application Settings page, my new names always reverts back to the original name after I click "Done". Is there something else I am supposed to do get the new name to save properly?
How to Export App & Database Together and import into another zoho creator account?
I can "Save as Deluge Script" and import the .ds file into the other account, but I can't copy the .ds and database together or import together. I don't want to manually export each view as an .xls and then manually import each view as an .xls for 2 reasons: 1. takes more time than I want. 2. the import feature doesn't work perfectly for certain fields (e.g. date & time) thank you, josh
Add time to date field
I have a date field that I am wanting to take upon user update and add the time to it and put that into a date time field. I keep getting an error when I try this: date = input.runDate + " " + zoho.currenttime.toString(); input.startTime = date.toTime(); input.endTime = input.startTime.addHour(1); It gives me the error unable to convert string to date. What is a better way to accomplish this?
How can I view documents that have been uploaded with the File-upload field?
I've created an Application in Creator, with three "File-upload" fields. Users will be uploading text documents (.doc/.pdf) I'm wondering if there is a way to batch-view the uploaded documents. Is there a tool in the software I can use to batch-download the original documents that were uploaded? Ideally, I'd love to see them as a printable, combined .pdf - is anything like that possible? Thank you, in advance!
Updating records - stateless forms
I have 3 stateless forms based on one large application form Application_Page_1 Application_Page_2 Application_Page_3 When I am at the end of page 1, I create a new record in the application table upon clicking the continue button. What I would like to do for page 2 and page 3 is update the current record that was just created in page 1 instead of saving a new record upon continue. How do I do that? Do I need to create a function that stores the recordID upon saving of the record in page 1 in some
Preview build available - Major change in the internal Framework of Zoho Creator
Hi all, The internal framework of Zoho Creator has undergone a major change. Though there are no major visible changes in the GUI, there are lot of server side changes. Hence we wanted to have a preview release before releasing it in creator.zoho.com . The preview build is now available in http://precreator.zoho.com . You can test your applications from the above link. In a few days, we will release it in creator.zoho.com . Note : Please login before accessing the above link. If you access the above
How do i shared my Creator Apps with one of users as a developer?
How do i shared my Creator Apps with one of users as a developer?
Unable to rename my app.
I try to rename my app via the Settings panel, but after pressing save nothing happens. Free edition.
How do I create a form that populates some of the fields from another table?
I am trying to gather addresses for all people that will be attending an event. What I want to do is be able to send people that are helping me to an online form. The online form will have the names of people populated in the name fields that it picks from another table where they do not as of yet have their addresses filled in. Then, the person helping me, just fills in the address for that person and submits it. Once it is submitted, their name will no longer show up on the online form. How could
Allow inline field placement
Sometimes it would be nice to have a few fields on the same line such as city, state and zip in a form instead of always having only one field on each line. It would save a lot of space and make the form look better.
use Deluge to limit records
I'm creating a view for a team member who only needs to see the most recent jobs we are working on. I'd like to set a criteria that will limit her view to records that have Estimated Start Dates from today to three months from today. I found a similar question at http://help.zoho.com/portal/en/community/topic/zoho-currentdate-in-url? but there the question-asker wants to use this in a URL I know there is a Zoho-wide variable called zoho.currentdate So in psudo code it is: Estimated_Job_Start_Date
How to hide fields while editing a view
I am working on a database -- I'm creating a custom view for Rayma: http://creator.zoho.com/spcorppm/pm1/#View:Rayma Currently I have it displayed as a grid, which is a little clunky. It would be better if she could edit it from the "list" format -- but when you hit "edit" you see all the fields, not just the ones that are included in her view. Is there a way to limit the field that appear when you hit "edit"? -- Kristy
Would be great to be able to rotate view titles
I have a bunch of views that are basically check boxes -- yes it was done, no it wasn't done. I want to work on them in "grid" but since the titles of the fields are long I have to scroll through pages and pages. I've tried adjusting the width of the fields, but then I can't read what it is. It would be great if I could rotate those labels to landscape, still have the field width autosize and see all of my checkboxes at one go. -- Kristy
I can't rename or change settings of any of my apps
Hello I can't rename or change settings of any of my apps Thank you for your help Olivier
Email data submissions still causing multiple records
Hi, email data submissions are still causing multiple records. This topic does exist already, but is labeled as solved for some reason, and its definitely not solved! Please let us know whether you are aware of this problem, and if there is a way to solve it. Many thanks Tom
Deluge Code 'include file' - containing fields that are common to a number of forms
Is there a tip or a trick that would allow me to set up a number of fields that will be same in a number of forms... For example...suppose I wanted each application to have 2 fields called 'Hidden_Passed_In_Unique_Key' and 'Hidden_Follow_On_URL', then is there a way that I could include the following snippet of Deluge Script in each form that needs to use these fields....I'd like something along the lines of '#include <common_deluge_scripts/hidden_fields.ds> Hidden_Passed_In_Unique_Key
PreparedStatement Error when recording data
I get this error on my "Record an Activity" form. 1 . [t_696562000000011896] Exception occured while setting value in PreparedStatement for the Column [Total_Flig_696562000000024109] Check whether the datatype for this column is given as specified in the data-dictionary .[t_696562000000011896] Exception occured while setting value in PreparedStatement for the Column [Total_Flig_696562000000024109] Check whether the datatype for this column is given as specified in the data-dictionary. My application
How to show field value after form submission
I need to show a field's value (a formula field) on a page after the form is submitted. I have added it to the Success message, but that only stays on the screen for 1-2 seconds, and it needs to be viewed longer than that. Ideally, I'd love to pass the value to another page, but I don't need it to do that. I just want either a popup screen to appear or the ability to keep the success message up until a button is hit (like OK) or something like that. The twist is that after the success message,
Restrict Form to One Column
I notice that when there are a lot of fields on a form, the form automatically wraps the form elements to a second column. Is there a way to control this behavior and restrict the form to one column regardless of the number of fields?
Is there a way to get all of the strings in a Checklist/Picklist...not just the selected ones...
Hello, Apologies in advance this is a bit long... If I have a checkbox.. Checkbox_1 ( displayname = "Checkbox 1" type = checkboxes values = {"Option 1", "Option 2", "Option 3"} on user input { alert("In On User Input - input.Checkbox_1 is :" + input.Checkbox_1); } ) and a related Decision box...that gives the user the option to select or deselect all the strings in the checkbox in one step... Decision_box_1
searchRecords() in CRM returns Contact List (which is a List()) - how to check for empty list
Hi, I am having some trouble testing for an empty contact list when I use the CRM searchRecords call in Creator...anyone have a suggestion...the problem is the List that is returned always has 1 item in it...even if that item is 'null'. I guess if no CRM record is found matching the search criteria, I would expect there to be no records in the list...here's some code that may explain it... ContactsList = zoho.crm.searchRecords("Contacts", searchString); testContact = map(); testContact
Read ZOHO Database using PHP (CURL)
Here is the working version of PHP CURL to read data from your ZOHO database. Using the CSV POST method to avoid using GET"s that show your queries in the address bar This is the code for posting the data using PHP CURL <?php // This is the function for posting with PHP using CURL function curl_post($url, array $post = NULL, array $options = array()) { $defaults = array( CURLOPT_POST => TRUE, CURLOPT_HEADER => 0, CURLOPT_URL => $url, CURLOPT_FRESH_CONNECT => 1, CURLOPT_RETURNTRANSFER
Create and use a Relational Database in Zoho Creator
I understood that Zoho Creator support full relational database function by linking forms through look-up field. Is it possible to create in Zoho Creator an application which should obey below relationships diagram? Desired relational database should have these types of relationship: - 1 to 1 relationship - 1 to (0 or 1) relationship - 1 to many relationship - 1 to (0 or many) relationship Should I create a table for each entity (from A to V) ? Because relationship between A and C, D, E is 1 to 1.
Store a list variable in a single record?
I'm looking to store a list variable in a single record. How would I go about doing that? Thanks.
How to display the no. of days
This was made in Function tab int calculations.CalculateDays(date start_date, date end_date) { Days = (((input.end_date - input.start_date) / 86400000)).toLong(); return Days; } Now I want to display the value of "Days" in form i tried input.Days=input.Days; but not working How to do it. Any idea
Help with syntax
I've created a check box field called 'options' that has three values, A,B & C I want to hide field 'date' on the form if the user selects option 'B' What would be the syntax please? Martyn
Deluge/Plain Text/Rich Text Not Functioning
I am working to generate a "sendmail" script, but currently, anytime I create a line break it isn't converting over correctly and is showing a "\n" tag at each break in the rich text. No matter where I create the message (rich text/plain text/deluge), it is sticking the "\n" at each line break. Here is an example: When I enter the following deluge code: "Test <br> Test" I end up with the following text in the Rich Text editor: Test \nTest
Newbie
I have a form called Case Data with a field called "Status" with options of "Open", "Closed" and "Suspended". On another form called Investigation Data I have the same field with the same response. What I need is when I put in a response in the "Status" field of Investigation Data is for it to update on Case Data???? Any help with steps needed would be appreciated...just started with Zoho this week and trying to fumble around with everything. Thanks
how to access "get" values in url from inside form code
I am trying to retrieve "get" values from a url and use them inside a Form's code. For example from the following url: http://creator.zoho.com/<user name>/<app name>/form-perma/<form name>/key=30409000000057085 I need to get the value 30409000000057085 and put it in a drop down list. The documentation on the following page says: "Note: The default field values will be available in the form's on load action." http://help.creator.zoho.com/Functionality-based-URLs.html#To_edit_individual_records_by_passing_record_id_in_the_URL
variables from one form in another form
Hello, I have a problem with connection of two variables in one dropdown menu. In one form I have two fields: "name" and "email" which You input in textboxes, in next form i would like to have a dropdown with values in form like: name(email) and after picking one of values from dropbox i would like to send a message to the chosen mail. Thank You for any help. (Sorry for my english)
Formatting email submission so it appears correctly in Zoho
I've figured out how to submit records to my zoho application using email. These are emails I am forwarding. The problem is now formatting the email so it doesn't show up as garbage in Zoho. I've found that changing the text encoding on the email to Unicode (UTF-8) will eliminate the problems with reading some characters such as apostrophes ('). It appears the submit data by email function reserves the colon (:) for identifying the fields that I'm using in the form. My work around is to replace
Email notification \n inserted in body
When using "email notification", the character \n is being inserted in into each row of text in the body of the email message. This is a new issue. I have been using Creator for over a year and never experienced this problem. PLEASE HELP
Image from Webcam
Quite simple, we already have the ability to upload an image from disk. Currently I take the image using Photobooth, then attach it. This could be streamlined by having a form object that could access the webcam (iSight) and take the picture there and then. Ross
Passing form values to an external URL ?
Hi there, What I am trying to to is design a form, gather the data, and then take some of that data and redirect to an external URL passing some of the data across. Eg: Fill in Name, tel, email on the form click submit - it saves this info to the database, then redirects to eg: http://www.mydomain.com/cgi-bin/myprogram.pl?Name:Tel Is this possible and if so, how do I achieve this ? your help will be most appreciated.
Reports and HTML View
Is it possible to embed reports in a HTML view?
How do you print data from a view?
Hello How do you print data from a view? Necessary to adapt it to a label. Hugs
How to make an accumulated sum?
Hi, can anyone help me on this? I need to make report with a column with a running balance for the data: DATE NAME AMOUNT RUNNING BALANCE (accumulated sum) 01/01/10 alksdjfañlskf $30.00 $30.00 02/01/10 aioijñlkjas $20.00 $50.00 05/02/10 oiqureasd -$5.00 $45.00 Actually I need to know if its possible to be done in the reports area and in the creator area. Thanks.
how to sum the value of all the record in a table?
Dear all, HI! How are you? I would like to know how can I write a script that calculate the sum of a value of all records in a table. An example would be that I have a registration form which allow guest to register # of guest he/she will bring. what I would like to know is how to write a script that calculate the total number of guest of all the registration record Assuming that my table has the following 3 records # Reg 001 guest 0 # Reg 002 guest 5 # Reg 003 guest 2 What I want to do is to calculate
Next Page