Are unregistered users allowed to enter data?
I created a small membership form/database on Zoho, then I shared it with myself (my work address) so that I might enter my work profile into the database but it expected me to register. Does it not allow my database to be used by other unsubscribed users or did I do something wrong?
Feature request: longer alert time
Hi there, I am building an application that is to be used by not so computer literate people, some of them elderly and hence slow in reading. My customized alert messages (like "You have entered the wrong password. Try again") now appear only very briefly, and many people in my test group don't catch them in time. Even at age 30, I myself don't like the speed it disappears with. Could you set the alert time to something like 5 seconds? Or make it adjustable? Kind regards, Wytze stichtingopc
Clearing / Resetting an iframe
I've created a stateless form with 4-buttons - each button, when clicked, populate an iframe ("form-iframe") with another form. I'd like to tack on a "Reset" or "Clear" button that will refresh the iframe back to it's blank state. I tried blanking out the URL in the iframe parameters, but that didn't do the trick. Any thoughts?
On Update : Lookup error...
Hello ZC Team, I have a problem trying to call a function on a lookup field, I can sucessfully invoke and use on the user Input action but when I try to use same code on the "On Update" action I'm having problems: My code on de User Input is: list = base_de_curriculums.gconsu.gclistaconsultores(input.Skill_Disponible); Nombre_Consultor:ui.add(list); This is working very nice- Now I want same but in on Update, message error say" was expecting append, I change add by append and message say
Check number of entries in the database
Hi, I have a form to input a list of location with date. Now i want to consolidate to see which are the location i frequent the most, therefore I want to design out a form to list down the list of location with the number of time visited beside. How can I do so? Thank you.
update a row in zoho reports from zoho creator
Hi, i succedd add a row in zoho reports from zoho creator but can't update a selecting row. I wrote this deluge code. Where have i made a mistake please ? trans1 = map(); trans1.put("Agence", input.Agence); trans1.put("AFFECTATION ANALYTIQUE", input.AFFECTATION_ANALYTIQUE); trans1.put("LIBELLE", input.LIBELLE); mapResponse = zoho.reports.updatedata("BASE", "Table", trans1, "AFFECTATION ANALYTIQUE="+"'"+input.AFFECTATION_ANALYTIQUE+"'"); TY
Entering new records with same first name
Hi, I am having an issue with adding new records to a table when the first name is the same as a record that already exists. Situation: Table A has firstname = Emily & lastname = Ping Table B has a lookup field to pull in the firstname + lastname (Emily Ping) from Table A I am able to enter new records in Table A that have the same firstname = Emily with a different last name...say lastname = Richardson However, when I try to make a new entry in Table B for 'Emily Richardson' it automatically changes
update data in reports from creator/ criteria
I understand how to update data in a zohoreports table with the deluge tasks zoho.reports.updatedata ( BASE, TABLE, map, Criteria) but i don't success to use a criteria depending of the value of an input field. My example is : trans1 = map(); trans1.put("Agence", input.Agence); trans1.put("AFFECTATION ANALYTIQUE", input.AFFECTATION_ANALYTIQUE); trans1.put("LIBELLE", input.LIBELLE); a = "AFFECTATION ANALYTIQUE='" + input.AFFECTATION_ANALYTIQUE + "'"; mapResponse = zoho.reports.updatedata("BASE",
My Wish for 2012: Concurrent User Subscriptions
This is my wish for ZOHO Creator in 2012: For domain level accounts, offer application-level sharing for a limited number of concurrent users. For example, a 5 concurrent user plan would allow one admin and four active users to simultaneously access applications. If another user attempts to sign-in, he would be denied until one of the other four users signs-out, or until the admin deletes a user from the account-level share, or until another user logs 15 minutes of inactivity (no page refreshes or
3 small issues remaining
Hello, I am very very close to finishing my app! My Director is very impressed with what I have done so far - I just need some help with 3 outstanding issues that I am having. 1. - Filtering Issue numbers. I have 3 forms in question, Drawings, Issue_no, and Work_Order. When the user creates a new Drawing in the Drawings form, they also create a new Issue no in the Issue_no form which is a sub-form within the Drawings form. When the user selects the drawing from the Work_order (via. a look-up field)
Re get data FromSQL 2000 by getUrl tasks
Hi Akash: This is a http link through a query from SQL 2000, and then use the getUrl parse the xml file in the creator, the format is the basic reference creator to help complete the test data seems crawl, but can not display the data and found a different format, as follows 1，the sample from zoho creator 2，the sample from my link Grab the data format is as follows： my function code as follows： string test() { sm = "<table class=table zc-viewtable>" + "<tr class=zc-row-header>" + "<td class=zc-viewrowheader
Add Comment in View Criteria
Is a future update can we have the ability to add comments to the View Criteria?
Stuck on Fetch/Update Records to add a number value to a record (Sports-focused developers, please help - images provided)
Hello, I'm having trouble figuring out how to update a record from a value entered into a subform. I'm going to explain the process in plain English and my problem (I'd rate my skill in deluge as "low intermediate") 1- My "Game Score Entry" form is used to enter and update sports scores using a lookup field that contains entries from a "Team Info Entry" for the team name. 2- To keep in-game stats and attendance for individual players, I have a "Goals/Assists" subform with a lookup field that clears
Funtion for Currency Fields
Hello ZC team; I have this situation, in Application B I have a form with fields like: Name, Contract Number, Customer, Rate,etc. On Application A I have a form with lookup field Name, Contract Number, Customer, and other fields like Price,etc. I need that when I select the field "Customer" in App A a function is called in order to fill Price field from the valued stored in App B (in fact rate field). Both fields are currency type (Price & Rate). The link in both applications is the Customer which
Backups
When I try a simple backup, and select the SPREADSHEET format, I get nothing that I can use. In the past it would ask for location to save the file, but now I am immediately kicked out, and I can see a file that ZOHO prepared, but it only contains 2 lines (appears to be the first and the last). None of the hundreds in the middle. I cannot find that file anywhere on my hard drive. With all the changes being made recently to ZOHO, It makes me nervous that I cannot backup any of my several databases.
Creator Loading Slowly in Google Chrome
All of my forms and views are loading extremely slow in Google Chrome (2-3 minutes per form or view). I have tried closing down Chrome and restarting, but forms are still loading very slowly. When I load these same forms in Firefox, the forms and views are loading quickly.
How to format currency fields in HTML view
I've created an HTML view. Some of the fields I'm showing are currency type, but they display as regular numbers. Example: $42.00 shows up as 42. The tax shows up with all 4 decimal places. Is there any kind of format function that would allow me to show these fields as currency in the HTML? Thanks.
Handling substring error
Hi, I use substring(0, 4) to extract the first 4 charaters in the Last_NAME field But when the person enters a name like John Doe, I get an error telling ( it is supposed to extract 4, but only 3 is available) -- fair enough. Anyway i can bypass this error. Thank you, Regards Deepa
Auto Filters not working
A number of auto filters on my application have suddenly stopped working. I have emailed details to support and need this investigated and resolved as matter of extreme urgency.
Use Same Subform Twice in Main Form
Is it possible to use the same subform twice in a main form? I have already created an application in which this is the case, but the scripts that worked in the on user input of one of the first instance subform fields will no longer work now that I've added the second instance of the subform. Each instance of the subform has a different name. Another peculiar thing is that the subform contains a picklist that I've dynamically added to in the on load section of the main form. That works. However,
Fetching data
Hello, I have Googled and searched your forum for an answer but I can't seem to get the code to work. I am either looking at this wrong or making it difficult for myself. I have 4 forms Drawings; Material; Purchase_order and Work_order The Material form has been put as a sub-form in the Drawings form. There is a field in there called "size" which is a single line text I wish to "fetch". In the Work_order form the users selects a Drawing number from a Look-up field which is linked to the Drawings form.
Convert String to Time still having problems
This is the error message I get with the following script, please help? It worked fine for the first few reservations, this is the application Copy of Reservations form Reservations { field alignment = left column { First_Name ( displayname = "First Name" type = text width = 200px ) Last_Name ( displayname = "Last Name" type = text width = 200px )
Creator Reports hyperlink to Creator View
The Reports capability in Creator is nice to quickly display data, but opening the data in Zoho Sheets does not help the user make changes to the data. Is there a way to specify a View to open with criteria set by the Report data. Example for Pivot Table: Date = x axis Number of Sales = y axis Product = data Clicking on the 'Product' number hyperlink in the pivot table displays the data in Zoho Sheets. Could a pre-selected View open instead with the same criteria, Date, # of Sales and Product.
authorization problem in record-edit
Good morning, I have build a small application with zoho creator, and I have shared some forms with other users. In only one case I open a form in record-edit mode via Editing Records via Record ID using (http://creator.zoho.com/<userName>/<applinkname>/#Form:<formlinkname>?recLinkID=<recordID>&viewLinkName=<viewlinkname>). When I use this function logged with administration grant, it's ok, but when I use this function logged like another user, the system generate this error: You have logged in
Auto populate for dummies
Hi I have a view which contains details of clinical trials. I have created custom function buttons for each record. I would like for the user to click on the custom function "Add Recruitment" and the form "accrual log" opens, so that the user can enter their details. The form "accrual log" does open, and I have managed to put a date stamp on the "on load" script of the form. What the form is not doing is prepopulating the fields in "accrual log" with the information from the Recruitment view. I
Fetch and Update
Greetings All, Can someone point me to a clear explanation of "Fetch and Update"? The link http://help.creator.zoho.com/Fetch-and-Update-Records.html is extremly vague. Senario: I have one form that will be storing data. I will be using a different form to collect data. My work is as follows: 1. Complete "Form A" "Form A" will have several fields that will not be completed initially. 2. "Form B" will be processed multiple times. Each time "Form B" is processed, I will
add "text:" when inserting new line
In reference to document below: http://www.clickatell.com/downloads/smtp/Clickatell_SMTP.pdf I have a multi-line text box. I want to add in "text:" when entering a new line. This can be done at any stage, as long as it is formatted before the email to clickatell is sent. I would also like to add in if easy enough: - character restriction for line length (not essential) - character restriction for text box
Form customisation - field spacing and position
Having searched this topic, I learned that 4 years ago, form customisation was being developed. I have noted the customisation options, and perhaps this was the outcome. However, I'm looking for some control over my fields eg. when 'from' and 'to' dropdown options are used, where clicking from and to displays times eg. from 9.00 to 11.30 Title data field ________________________ data field ________________________ data field ________________________ data field ________________________
multiple lookups - data consolidation
i am trying to organize information about the training sessions of athletes, i have a lookup field connecting a certain days workout to a certain athlete, but sometimes athletes work together - how can i link the days workout to both athletes and still be able to get streamlined search / graph results? i have tried multiple lookup fields (athlete 1 / athlete 2 / athlete 3 ) but sometimes "john" works out alone, or may be logged as athlete 2 or athlete 3 on other days workouts, i would like to be
Shared App Not Displaying Properly
I've created an application with a free account and I'm attempting to share it to another user. Whenever that user loads the app they are seeing a nested view of the page with two navigation bars and none of the content. Any help would be greatly appreciated.
Comparing Strings
Hi How do compare strings such as if string1 begins "s" { string2 == string2 + string1; }
My convert date and time is working intermittently
Hi I am getting error messages from my application that I built to make reservations. It worked perfectly for the first 10 reservations, then it started throwing out error messages and started to work sometimes and not at all for my staff. Maybe the 7:00 am needs 0's? like 07:00am to convert the date time string picklist to a Zoho 24hour time calendar? Currently I turned off all of the scripting using the // marks, but this is what the script with action looks like form Reservations { field
Data from 2 forms displayed in one view or report
Hi, I'm trying to get data from 2 different forms to display either in one view or report. I have one form which has details for properties on the market including the asking price of the property. I have another form which has potential buyers details including the maximum they are willing to spend. What I would like to see is a view or report grouped by properties with a sub-list of potential buyers for the properties based on the amount they are willing to spend being higher than the asking price.
Subform - Invalid Entries Found - Please Correct and Try Again
Dear All, I have added a subform to my main form. Every time I try to submit, I get the following error message "Invalid Entries Found. Please Correct and Try again". I notice that some others have had a similar problem, however I couldn't find a solution posted. For reference, Im using Mac OSX and Safari. Any help would be greatly appreciated? BW, Mike
Recovering Deleted Data
Hi, One of our well-meaning staff members went into our Zoho Creator database and deleted a dozen or so records. This happened about a week and a half ago (November 18 or 19). She thought she could simply add them in again later and all would be fine. Problem is these records were part of a relational database and now the hundreds of links between these records (they are "users" in our system) are gone. Is there any way to recover the data and the relationships that have been lost? Mike McIntee
API Code
Hello, Requested and received my API Key. Wanted to link my MailChimp account with the ZOHO account. It did not work, MailChimp tells me that the API Key is incorrect. Could you please help. Thanks. Regards, Daniel
AddMonth question
What value is AddMonth supposed to return when it overlaps into a month in the next year? For example, I am adding 3 months to a date field and the date is in October. I expected it to return a 1 for January but instead it returned a 3. Can you help me on this?
WEB STUDIO 5 WEB SOFTWARE LINK WITH ZOHO
How do you utilise ZOHO database creator using your website as interlink between your clients and database? Lets say you intend to get 100 000 members of your siciety/clients = 100 000 database lines/records. This database would be updated automaticaly when people fill in FORMS on your WEBSITE, pay bills ($ VAULE database record in this case), and some of database records would be calculated values... So you do want your clients to update your database indirectly via forms entries and see READ
HTML View
Is it possible to put 2 table views side by side in a HTML View
Spaces and capitals
Hi, In my application I want to remove uneccesary spaces on input and also change the case from lower to upper (Capitals) Kind regards Dave
Next Page