Blank field not shown up
I would ask if you can assist on how to show up records that have blank field if this field is set as criteria.
View Criteria where a field entry is empty/nul
How can I select only entries where a field is not filled in. e.g. how do I select all employees who do not have an entry in a date field called retireddate. Is there some kind of NUL or UNDEFINED constant that I can compare with?
How do I get values from 4 separate queries to show in one table?
My objective is to build a budgeting interface. Where I can add to each budget products. And each product is made of Milestones and Tasks. My question is, how do I get values from 4 separate queries (Proposal; Product; Milestone; Task) to show in one table? Like the above image. Is this possible?
How to add a formula that subtracts date and times
Hello, I am new to app development. I am trying to create my own zoho app that is a call log. I have 2 fields that are date and time, one is start time, one is end time. I want to track how long I am on the phone. Can someone please show me step by step to get my Field, 'Total Time' to show how many minutes and seconds I was on the phone please? Thank you!
Conditional fields?
Can I use Zoho Creator to build a form with conditional fields? That is, a certain answer to one question causes a new field to appear on the form immediately below the first field.
Problems with forms
Hi, I have a problem, I´ve created the form and when I´m editing it i view it, but when I try to access it shows only the title, but not the fields, two questions then: How can I do to see the form? and: How can I know what is the web address?? Thanks a lot :D
Auto generated table ID?
Hi: Have checked online help, seems have different approaches for getting an auto generated table ID. Can you guys let me know: can we create a field which has auto generated number so I can treat that as an unique ID (for example: start from 1000, increment by 1 for each new record, same as MS SQL, or MS Access table). Thanks.
How to calcuate times (min/sec) between 2 date fields
Hello, I have 2 Date-time fields on my call log. How do I, step by step, calculate the time between the two because I want to track how long I was on each call, (including seconds) I also want to be able to see totals per day of number of calls, and time on each call. Will someone help me with that please? Thank you.
Zoho Creator help for a newbie: Form View
Hi all, I'm very new here. I'm attempting to build a database that has some simple category information (location, date, subject) by radio choice in addition to a large rich text block. I'd like to rich text block to be searchable by users. However, the only way I can seem to do this is to have the text appear as a column in the database view, which makes everything quite unusable because the entries are so enormous and the entire text is shown. Is there a way to gag or hide the big text column,
Lookup fields filtering
Hi -- I have a PROJECT form, then a TASK form linked through a lookup field. I need to be able to assign one or more tasks to people records in another form. I thought I'd do with two lookup fields, yet I want to task lookup to be filtered to only display tasks pertaining to the first project lookup field, so only tasks from this project will be displayed in the second lookup, what formula should I use? TIA. — AB
Cannot update my schedules when to do date.
I am unable to make a modification to my schedules. I get the following error when changing the "When to do" (number of days after). "Error Occured. We are sorry for the inconvenience. Please try after some time or refresh the page and try again" Please help, refreshing and signing out of zoho and back in does not help. I have retarted my browser as well. Still no go. Thanks for the help
Visualize database structure (forms ans relationships)
Is there a way to visualize the database structure of an application? I would like to be able to show the forms, their fields and the relationships that exist between the fields.
Bug: Schedules module not behaving correctly or saving edits
The Schedules module is still buggy, driving me to frustration again. I set up a schedule to notify some staff members when a certain item w/ an expiration date (field = End_Publish_Date) is 3 days away. Suddenly this morning (1 day after setting it up) we got dozens of notification emails about expirations on items that aren't even in that form! And, to make matters worse, when I go to edit the schedule and adjust its criteria, I cannot save it! The form is called "Check_It_Out", and the schedule
Delete function no longer working and Java script error on page all of the sudden
I have a function in my commission tracker application that is a delete detail function. It worked for a few months and all of the sudden nothing happens when I push it. I am also noticing all of the sudden that I am getting a java error on page message at the bottom of my IE7 window. Any ideas? We use this app everyday so any help would be appreciated.
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
Next Page