Looking for a CREATOR GURU (Form developer)! Are You available?
Hi, here is the project ...I need your help in order to develop the right Form for my website! As an Advertising Agency (New and Poor! :) )we need to allow our customer to Logging in (So, I think I need a DB in order to store customer info?) and fill out the Online Form (Integrated in our website) and save the order. The Form Order require many fields and may need to be exported as csv. file and organize this file for fast interaction with google or other search engine software to upload the file
Recieve an email if I am nearing my record limit?
The documentation says that "You will receive an email well in advance of nearing the limit." But I don't. Is there a certain setting I need to enable?
dropdown list items contain value and text?
Hi: As you know, dropdown list (for example in VB, MS Access, .Net, and other...) items can hold value and text, "value" usually is a number, and "text" is the text. Is the dropdown list in ZOHO Creator has similar feature? Thanks
"Click Here" link no longer appears when exporting a private embedded views without login
Previously, this was working fine. However, today when I try to export a private view using CSV feed, the link to enable "To access the view without login" is no longer visible. See below. Also, here is the documentation that describes what I am trying to do: http://help.creator.zoho.com/Embed-Form-View-in-Website.html#To_access_private_embedded_views_without_login To access private embedded views without login To access the embedded view without login, select the Click Here option displayed in the
Thanks ZC Dev team. Chaining is finally working great!
Thanks ZC dev team for returning this on your methods! Chaining is working great! I recommend everyone use chaining for more eloquent DS. t = store.get(key).toMap().get("timestamp")
Multiple user logins?
I'm new to this and am confused about setting up users. I have shared our app to two employees internally and one client externally. I had assumed that by adding their email to the users list, the email would be their user name. But no, they all must use the same user name and password to log in. If that's the case, how does Zoho even know they are separate users? If anyone on any computer can log in using the same user name and password, what's the need for sharing the application at all? What am
Unable to update multiselect field
I have a form with a multiselect lookup field "Known_Players" that points to the field "Name" of the same form. When the name of a player is changed I want to update all the Player records in which the name is selected in the Known_Players field. For this I have the following code in the on success / on edit event: for each player in frmPlayer [Known_Players.contains(input.Name_before_edit)] { oldList = player.Known_Players; newList = List:String(); for each item in oldList
"Navigation to webpage cancelled" for reports
Hi, I just created a very simple report however I get this message "Navigation to webpage cancelled" when I want to display the report. I use Vista and I was wondering if it is in the internet settings. Does anyone have a fix for this please Andrew
Multiple Forms To One View
Hi, I've got a Zoho Creator database where I have been inputting data using one form which inserts data onto one view (which is presumably where the data lives? What I am trying to do now is create a new form, which has some fields from the existing view (but not all like the first form). For example, The current staff operated database has three fields - name, address & staff comments. I now want customers to insert their own name & address into the database, but obviously don't want them to be
How can we create reports with Creator?
In creator I able to have view but I would like to create a nice costumized reports. Any suggestions?
Community Bug Tracker App
Charles, what are the plans for the Community Bug Tracker App? Ref: https://help.zoho.com/portal/en/community/topic/home-page-loading-problem Thanks, John M. Whitney
Error
Hello, I've identified one posible bug. It happens whenI am inside a Html view with an Iframe inside,and this Iframe has another html view inside itself, that has one view with a custom function. When I execute this custom function it opens a #view in a pop up window. This pop up view has a custom function too that if I execute it, then it refresh itself but duplicating the pop up. I dont know if I explained myself Sergio Galiano
View 30+ fields error after sort.
I have a view with 40+ fields. That's a lot of fields, I understand. <rant> However the view is very valuable as user us the browser built in search to searh the rendered view affording them quick access to information that would otherwise on the Creator platform be too difficult to find. Ok so that's why there is so many fields. I wouldn't use this approach if Creator allowed related fields in view criteria. I been ranting about this for 2 years (albiet to an empty room). </rant> Now the problem.
Accessing one form/view from another form/view
Is there a way to access the entire record of an included form in a combined view? For example (using the example in the help section), in the Employee view, theres Name and Address columns, as well as a Department column. The Department column only shows the name of the department though - is there a way to click on the department in the List View and have it bring up the entire record for that department? Similar to how the entire Employee record is brought up when you click the "Record Summary"
Automated Multi Select Choices
OK, I have an existing customer contacts database. I now want to log notes from visits to my customers. This will obviously require a new form, however I want to be able to select data the "customer name" field of my customer form in a drop down menu on the new notes form. Is this possible? Thanks
How to implement IF THEN logic in a database?
I have an app idea where I don't want the IF THEN logic coded in the app. I instead was thinking that it would be easier to manage and change if it were in its own database. Think of it like a conditional question and answer flow. The answer to a particular question will lead you to a different question. In the table I was thinking: Question1 IF answer x THEN goto Question2 ELSE goto Question3. Is this possible like this or does it need to be coded in the logic of the form?
Quick tip on using JSON data resources & sharing records between apps.
Howdy, Just thought I would bring this to your attention. If you don't know this already when you make a getURL/postURL request to a JSON resource Zoho allows you to convert that JSON to XML using toXML(). BUT, did you know that you can convert it straight to a map var? This is especially useful when you just want to grab one single JSON record to populate an html page or form. Example : Let's say that you want to grab a SINGLE record out of a separate app in the same account. The traditional
Creator Email and SPF
I'm getting spf softfail for emails from ZOHO Creator. This is not a big issue, but should be addressed as a best practice by the ZC team to insure optimal mail delivery. Documentation is expected for those of use that run our own domains and email. My email account is from Google Apps (customized google mail). Here's an example from the mail header: Authentication-Results: mx.google.com; spf=softfail (google.com: domain of transitioning webmaster@niskypto.org does not designate 72.5.230.66 as permitted
Add iCal by URL to Google Calendar Failing
I'm working on my application and testing out various ical feeds from Creator. Just now, Google is saying it cannot add these by URL, although I have added a few recently. Edit to support given for application "pto" John M. Whitney
My Application form promoting login details
Hello Respected Members I am enabled my public service for embedded form in website without promoting login then in my application there are three forms in my application two forms are work normally then can't promoting login details but one form promoting login details please give me a solution Thanks
New user: First of many questions: Filtering drop down lists
Hi, I know that this question has been answered several times in the forums, and I have tried using the script but I am obviously doing something wrong as it keeps throwing up errors. I must be making mistakes when changing the code to fit my form names and field names. Please assume zero knowledge when replying to this - sorry! I am trying to create drop down lists that filter to 4 or 5 levels. I have a small business that has 2 different divisions: design and printing within these divisions
Efficient Loading of List Boxes ...
Within all the posts in this Topic ... http://help.zoho.com/portal/en/community/?ftid=2266000000515054#2266000000512211 ... this suggestion might be lost on the ZOHO Creator Team ... I think that if ZOHO Creator had a command like ... fieldName:ui.addCollection(collectionName.FieldName) ... you could then do something like ... mySchools= Schools[State_Code == "TX"]; selectSchool:ui.addCollection(mySchools.School_Name); .. and it would be a lot faster. Please consider it ... as it would ... - cause
How do I resolve function signature changes.
Please tell me how to resolve this? The message makes no note of where to fix this inconsistency. How am I suppose to fix this, given the current message? related: http://help.zoho.com/portal/en/community?ftid=2266000000321767 tt
Function removal helpers
Here is the error I'm receiving whilst deleting a function. Function cannot be deleted. This function is referred in the following places. Please remove the reference,then try deleting the function. In action script--> In action script--> In action script--> As you can see the calling functions are not enumerated in the error message. tt
Which is the correct Record Count?
I see different record counts in these locations: 1) Account Settings > Usage Limit > Records Count 2) The Record Count on the View page of my application. I only have one application. The counts differ by around 100. Which is correct? Thank you.
How to display a warning of a possible duplicate entry?
Hi, Creator is looking very good as possible solution for us. I know how to prevent dups, but would like to ask about a different scenario, please. We are using a form to enter requests from individuals. We will only allow one request per individual, but there will be times when two different people might share the same last name. Is there a way to display a notification of a possible duplicate entry? That would allow the data entry person to check for previous requests. If none are found, we would
Creating A New Records Via Scripts
Hey Zoho People, Am trying to create a new record on a different table by picking entries from another table but its only creating one field,and I want it to create many entries on a given criteria,but its only picking the first record with that criteria....Please Help me on how I can populate the table with all the records fitting a certain criteria..Thank You.
Creator App Recommendations Please- can it do this?
I need to create a database Web app to be used both from a PC/Mac, iPhone and Android Phone. It needs to be multiple user. Users will pay a monthly fee to use the app. Users will be able to look at just their data. The app needs to provide a Wizard-like step through of a technical lab process and prompt the users for each step of the workflow for data to continue. The app will ensure compliance with lab safety procedures and needs to be very simple for anyone to use. How can I create this in
How to send form by email based on a field value - please help
Hi I have a really simple form with about 10 fields. I would like to receive an email with data input in the form only when the form is updated and a certain field has been updated to "closed" instead of "open". I have looked in the help section on scripts but cant figure it out. Can you help? If yes, I will email you a direct link to the form plus the login and password for you so you can add the right script in my form. (I will change the password afterwards). I am sure it is a 1 minute job for
Simple Inventory Application
Has anyone shared or developed a simple application to track equipment serial #'s, location, make, model and a field to input any maintenance done on the item. I'd like to be able to generate lists of equipment.
Record Collection Tips
If anyone ever sales they've never written bad code they are either lying or they are God himself. I starting using Zoho in Feb of 09 and like almost everyone that comes to Zoho Creator; I was looking for a way to make my business processes better. This led me to the wonderful world of Deluge Script! I would like to Deluge Script learning curve, well, less curvaceous for many of the new DS'ers out there. One aspect about Deluge Script that I immediately picked up on and enjoyed is how you do looping
Creator: The application copy did not copy the drop down choices
we made a copy of an application. The original app had some drop down boxes and people would select from a list of choices. our copy of the application has lost all of the drop down lists.....nothing appears in the drop down box. can you help?
getFieldValue() in On Success
Excuse me, I follow the below example : Can the SendMail from a form only send data from the decision checkboxes selected by the user? value = formMap.get(key); As result, the value returned "null" in my email. I have tried the same way to return the output on a plaintext field, it succesfully showed the value. Is this any problem on it that I cannot use getFieldValue while On Success ? Best Regard
User Submitted Data
Sorry, I know this question has been asked before but cannot locate an answer to help me. I do not have the "User Submitted Data" checkbox to enable me to attach the information rendered on my form in the e-mail I send to the users. My form is open for support. Please review it and tell me what I need to do. Note: I had it in the very beginning when I was testing the firm, but it is missing now. Thank you, Vanessa
Changes not saved
I'm freaking out. I made a crapload of changes (new fields, tons of new information), and I just went to access my application and THEY ARE ALL GONE. WTF??? How do I get help with this? I need to report to my boss tomorrow and now I don't have half the research I had done. I am beside myself.
How do I . . . Adding fields together (script)
MABAH Profile Information Confirmation for <%=Email_Id%>. input.First_Name input.Last_Name How Do I make type the script that will enable these two fields to list the first and last name (e.g., Vanessa Griffin). Thank you.
How do I pre-fill selected fields?
I need to create a form to allow people to enter data for multiple workshop events. I now have a form which allows a user to select their name, city and state date, time, location from dropdown menus. This works great if someone is entering a single event, but if they need to enter multiple workshops, they have to repeatedly select their name, city and state. Since this information will be the same for each event and since only the time. location and date will differ, how can I have those specific
download a file when you submit a form
I am trying to create a form which will help my customers to download a pdf file when they hit submit button. I validated the form using the get url and when tested the pdf file won't open. could anyone say how to correct this?? Thanks
enhancement request for views
When I add a custom action to a view the button is always on the right side of the columns, at the end of the line. I would like it if I could have the choice to place the button for a custom action on the left at the beginning of the line for each record.
accidentally deleted some active forms. Please help to recover
Hi support team, Please help to recover this folder http://creator.zoho.com/pashanoi/public-events-registration I accidentally deleted some active forms. Please help to recover them. Thanks Tho Le
Next Page