bugs in search and auto-complete feature
I noticed this just got turned back on. Please note the following bugs in lookup fields with this option turned on: When an ID value is passed to a form via a querystring parameter (in order to pre-populate a lookup field on page load) the ID number itself is now shown in the lookup field's search box instead of the fields specified in the "advanced display options". E.g. "6123124...." instead of "Bob Smith" in a "Name" lookup. The search function does not work as expected with advanced display options.
Scoring Application
Hello, I am asking this question to see if what I am looking to do is possible before I waste a lot of time and effort trying to make it work. I would like to create a scoring application to track the results of a competition. There will be multiple athletes competing and there will be multiple events. Each event will be scored and the athletes will be ranked depending on how they perform compared to the other athletes in that same event. I have created a form for athletes and an event. I can enter
IP Address From Windows Matching Different than IP showing in Ipconfig
When I show the added user ip address is starts with 76. Through the dos cmd I show 192. which is the address of the router. Where is Zoho getting the ip address from my windows 7 machine?. The reason why I ask is I want to develop an application based on ip addresses in an office so only the machine's in the office can connect to the app. I basically want to build a list of ip addresses in Zoho and test the incoming ip to ensure it's on the Zoho data base. If you need more information, please let
subforms
when I create a subform for a parent_form, I call it child_form. One record from the parent_form is linked to multiple child_form records. So the linkage between the two forms should be in an "associate form" ,right? Where do I find the information about this associate form? Second, for the child_form, can I create a lookup field called "parent_form_id", and have the field auto-populated, non-changeable, with the parent_form ID field value for the parent_form record being updated? Thanks!!!!
Application backup and recovery of a View
Hi, my Application Backup cannot complete the process. Help. Also I duplicate a view, but when I check for it I realize that this view was cancelled. Probably for slow connection and slow explorer display options. Now, how do I do to have another view for the form Solita_documentos. I cannot generate another view for this form. Isnt a stateless without but have no view! Help. I lost all data? It's possible to recovery it? THanks Mic
Unable to open stateless form in EDIT mode
Dear Sir / madam, I have created a Customer master application, in which i have created 4 stateless form. I want as soon as user enter his firm name on submission the application start loading stateless form in edit mode. I am using below link, but system showing an error. Please check the below link and confirm if there is any gaps in link https://creator.zoho.com/hpclmittal/customer-master/#Form:Bank_Information_Data?recLinkID=1002&viewLinkName=Customer_Detail_View
Using creator in iframe
Hi, I am using a view, to show a creator table, embedded via iframe in a webpage. If I click on 'View' for a particular record, it is displayed in a white box and the iframe is filled with a lightbox effect. Is it possible to disable the lightbox at all? Thanks
Opening an email using deluge script
Hello, I'm trying to set up an app to track on call staff members. One of the functions I would like to have is the ability to have a script open an e-mail addressed to a specific address using my computer's default e-mail client. The reason for this is that the e-mail address I would be sending to is an internal address that can't be directly e-mailed from outside our network. If the script were to open an e-mail using the default client (for all users, this would be Outlook), it would allow them
Hiding some fields of the form in a web page
I made a form in zoho creator and I am going to embed this form in my website, so I can collect data from my customers, but I don't want to show all of the fields of the form in the web page. For example if I have 10 fields in the form, I want to embed just 6 of them in the web page (I want to be able to hide 4 other fields from customer) and I will be updating those 4 fields later by editing the view of the form. how can I hide some fields of the form in a web page?
Predictive text in safari
Hi Everyone, I used to use my Zoho Creator application in Firefox browser. I have one form in particular where I regularly repeat name entries. In firefox I would start to type the name in eg' Rachel Lewis' and all of the Rachels will come up, so I scroll down and select the correct Rachel and ensure correct spelling. I have had ongoing issues with firefox and am now using zoho creator in safari. However, I can't figure out how to get safari to remember names entered onto a form, so every time I
Keep Leading 0
Is there anyway to keep the leading 0 when a number field submits? ex. If I enter "012340" The field returns "12340"
How do I generate %...
How do I create a column that will generate a percentage of another column?
Zoho creator to Zoho reports
I have successfully linked a creator form to a zoho databe but are only aple to pull text fields and not the number or decimal fields. Has anyone had this issue? Pleae help. Regards, Michael
How can I make View show the specified records?
Hi, I've a form(named Form) and its default view(named View). Now I fetched some records of Form in my script. How can I send these records to View so that they are presented? Thanks, Roger
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
Next Page