URGENT- Creating multiple records unsolicited
We encounter a major problem on Zoho Creator. Whenever you add a record by mail,data registers 10 or 15 times in the database. That created duplicates and much more.Can you see where is the problem?
Hide form in database homepage
Hello all, New user/developer here. Working with Creator. I created a few lookup tables to populate lookup fields in a main form, but I don't want those lookup forms or table view to show in the 'Home' menu on the left side of the database home page. Is there any way to hide those individually? Thanks!
Creating a database contractors
My question is: I'm creating a database for contractors to advertise to there services on a website. The contractor input there information ( kind of like a small yellow pages) How do I make it so when a contractor enter our website, they click on tab, enter there info, and then it displayed on our website under a selected State or profession. ie. roofer in Florida, painter in Ohio
Can I capture a signature in a form on a mobile device?
Can I capture a signature on a form when using a Creator app on a iPhone? Maybe use a Rich Text Field? Suggestions?
Conditional Formula
Hi, This is a great application. I love it! Is it possible to make Formula values conditional on the value of other fields? eg NewField ( type = formula if ($OldField == "Old") { value = "New" } else { value = "Old" } ) Thanks, Lee.
Send Mail from View
Is it possible to Send Mail automatically when a View is Displayed. Currently it seems that when a Function is defined and called using Custom Actions in View, it is necessary to select action from header of record to send mail Thanks
Parsing JSON export feed from application
Hello, I am trying to parse a JSON feed from my Creator application so that I can use the data to make a JavaScript/HTML widget. It would appear that HTTP GET requests to the feed url return a content type header as "Content-Type: text;charset=UTF-8" and not "Content-Type: application/json;charset=UTF-8", so I am not able to parse it correctly (e.g. my JSON object is null). The feed URL I get from going to the production side of the application, going to the form list view for the data I'd like,
Allow non-developer user to edit records
At the moment we are using the free account but plan to upgrade to a paid account. If the following is available in the paid account than this is irrelevant. Is it possible in Creator to give the user role rights to edit existing data? I have figured out that the developer role can edit existing data. I want to configure a role that can edit existing data from a view but cannot edit the application. Is this possible? If not, is this a feature that is being considered?
Fetch
How can i fetch records from other applications? And what other applications can i fetch from?
Fields Not Showing Up in Edit View
Hi all, After making some tweaks to a form, only the first seven (out of 40 or so) fields are showing up in edit view. This is a problem, because I need to edit other fields! They are still showing up on the form itself. Reloading the page, logging out and logging in, etc. haven't fixed this. Any ideas?
How do I link forms
I am creating an application and cannot figure out how to have it link my forms. I have a main form with 3 checkboxes. If one is chosen I need the form "Tables" to come up. If either of the other two questions are chosen I need the form "other" to come up. How can I do this?
Undefined, Unset, Empty, False, etc...
How do you test if a variable is Undefined, Unset, Empty, False, etc...? Do you compare to null, "", "-Select-", length() == 0? All of the above? (I sure hope not!!!) Which comparison do you use for a string field type of Single Line/Multi Line/Single Select/Multi Select? I gotta say, checking against "-Select-" is the single stupidest implementation in the Deluge scripting language. Worse, it's not always a string. When returning an empty/unselected dropdown value back from a function, you
Link to image in new window
After a user chooses a file to upload on a form and submits the form I wanted to create a url that would open a new window with that image in it. Is this possible to do?
set null variable
how can i set variable to null in a script? for string i use "", but what about float fields? bruha.zoho
PRINT /EXPORT PROBLEM
Print|Export stopped working on 02/16/2011. I can see my view, but when I select More Actions - > Print or Export, I cannot get connected to the server and system hangs...
Problems with user designations and script actions
I'm running into errors where i get proper results while creating and debugging forms with script while logged into my admin account, but testing the same pages with regular users don't work at all. any help would be appreciated, because if i can't count on the forms and script to work properly i will need to seek an alternative solution.
Chrome and Stateless Form Buttons
The submit buttons on stateless forms do not work in Chrome. John M. Whitney
Problem with Usage Limit
Hi, I'm trying to execute a function, but it keeps failing: Execution Failed Error details: Error occured while executing the script. The execution is stopped since the number of deluge statements that can be executed in an action has exceeded the maximum limit. You can view your usage limits here. But when I check the suggested link to see my usage limit, it says I have not exceeded any limits. I have shared my app "GolfHandicapCalculator" with Support. The function I am trying to run is called
Serious problem with Views Criteria
This statemetn, entered via "advanced" criteria of a view, used to be accepted and is indeed used within two of my views (zoho.loginuser == CenterCode.UserName && SendTo == "Participant") Now I get the message Adding Criteria failed. Please try after some time or refresh the page and try again. and thi happens on new views I am defining BUT also on the ones where it used to work if I try to save them again !!! Please help as soon as possible. Thanks.
Import Excel Spreadsheet
How to import an Excel spreadsheet to a form or view, or how best to display it in anapplication? I need something like google docs e What better way to show an excel spreadsheet in Zoho Creator? Thanks
inactivated account
I have asked a few months ago to reactivate my 2nd account : VIF. Can you reactivate it and tell me what was wrong with it (to solve the pb if relevant)
Permissions
Is there a way where i set permissions where my users can only see what they add in but me as a admin can see what they added in?
Field does not update for a certain record
I have a field (Overlapping_Search_Profiles) on a form (frmSearch_Profile) which for one record does not update when I do this: colSP.Overlapping_Search_Profiles = ""; and the record is part of the collection. I already checked if the record actually is included in the collection. Zoho has Edit Access. To reproduce do this: 1. In my app (bmpm) go to the section 'Admin' 2. Open the view 'Export View: Profiles' 3. Search for the records with 'aer' in the 'Player' column 4. Open one of the two records
Formula field, number of digits
I have defined a formula field in a form, calculated from other fields. How can I define the number of digits displayed on a VIEW? Even if the formula field result has 10 digits, can I define the VIEW to display only 2 digits? Thanks a lot.
Saving function without having made a change to it returns error
The following function was previously saved in Creator: string otherrecordmanipulations.CountEntityProfiles(string EName, string PName) { countNumber = count(frmSearch_Profile[((((Player_Entity.contains(input.EName) && Player.contains(input.PName)) && !Player.contains(input.PName + ":")) && Status == "Active") && Player_Status != "Passive")]); if (countNumber == 0) { return "none"; } else { return (countNumber).toString(); } } If I click 'Save Script'
Code comment not saved
In one of my scripts (on edit / on success) of the form frmSearch_Profile. I can not include a comment line ("// bla bla") above the line 'thisapp.TestFunc4(IDStr);'. Zoho Creator deletes it... Zoho has Edit Access. Regards, Filip
Null field to be "zero" for "null" values
I have a formula field which 5 fields. Manipulating the 5 fields to reach a formula field value. If any of the 5 fields is null, then the formula does not give any value.... how to solve this issue. Thanks.
Question about populating fields on a form automatically.
Hello, I have created a form called for employee contact information, that has a user's name as well as the branch that they work at and other info. I have also created another form and I have it set up so that I can select the employee's name from a drop down last as they are created, but I would like to know how to have it populate a field with their branch location when their name is selected. Thanks.
Created new application under my account and gave user developer rights. The they don't have the option to edit application
I created a new application under my account. I added the usersemail to the share under the edit application. I marked them as developer. I assured the username under account settings is developer. However, when the user logs in to the application, they ddon'thave the edit application feature. Please help! Thanks you in advance
Reg availability of logged in user info in public apps
Dear Users, Username and emailid of the logged in user is available as zoho variables in all the applications created using Zoho Creator. The variables zoho.loginuser and zoho.loginuserid can be used in scripting to write logic based on the user viewing your application. For eg: You can have an application in Creator where you have data related to all your customers but you can make sure that each of the customers is able to view only those records that belong to them based on their logged in username
Number Conversion Function
I need to convert a Hex string to decimal. On doing a Google search for "Zoho hex to decimal" I found this function, apparently in Zoho Sheet: DECIMAL Returns a decimal number, given a text representation and its base radix. Syntax DECIMAL(text; radix) Syntax Description text is text representing a number with the base radix radix (an integer between 2 and 36). Any leading spaces and tabs are ignored. Letters, if any, may be upper or lower case. If radix is 16 (hexadecimal system), any leading 0x,
A href link in mail
Hello, I am trying to put the link in mail body of my email in Zoho creator. I need to provide the link to the uploaded document through mail sent. I have the link - "<a href='https://creatorexport.zoho.com/DownloadFile.do?filepath=/" + input.File_Upload + "&sharedBy=" + zoho.adminuser&appLinkName=test&viewLinkName=test_view+ "'>Uploaded File</a>" But it is displaying the entire link instead of the "Uploaded File" caption. The HTML tags are also enabled in Application settings. Please help me to
Marketplace - if you are not logged in you cannot search the marketplace
I happened to be browsing the marketplace today and was not logged in. I could not find a search box! The only option was to browse, which is highly inefficient for hundreds of apps. If you login, you see a search box. Please make this search box available to non-logged in users! Also, when I click the "Post Your Requirement" button, it did not work! In fact nothing happened, I only saw an error in the bottom left hand corner status bar. I was using IE 8. I did go back a second time and this time
Submit form and populate fields in a separate application form.
Please advise if this is possible: On successful submission of a form I want to use the OpenURL in a script to open a form in a different application but populate fields in that form based on the submission from the original form. For example, I have a Findings application with a Priority field and a Tasks application with a Priority field. When a user submits a Result I want the Tasks form to open and populate the Tasks.Priority field with what was submitted from the Findings.Priority field. These
Error in Importing DATA. HELP ASAP!!!
Sir, I've got a problem here. I used "create apps using DS file" and it work. But when I tried to import data into it an error occurred. Picture as stated below. This is the only apps in my acc. Why does it said I've reach record limit even though there is no record is inserted yet. No one reply to my previous topic so i've created new one.HELP ASAP pls...
Feature updates and bug fixes for 08-FEB-2011
Please link to or elaborate on these new additions... User defined & System fields are categorized across Zoho Creator. - View Edit Mode : Column properties, Column width, Group/sort by, Filters & criteria - Form Edit Mode : Lookup field's field selection drop down - View Access Mode : Show/hide columns "All Times are in" will be shown only when at least one date time field is shown in viewThanks, John M. Whitney PS: Please do some maintenance on the forum announcements (posted on the right). Some
Look up part of a field. Does field value contain a string.
I have an accounts form that allows our reps to enter in an account name. However to avoid non exact duplicates (i.e Global Travel and Global Travel LLC) I would like to have a note field that updates with all possible matches of what ever is typed so far. So for example when global is entered the notes field list Global Adventures, Global Assoc Growers, ect. Basically the same functionality as an auto complete based on a database lookup. Is there anyway to do this?
If condition in a view
Hi! I have a field in a view that depends on the values of two other fields and I need to show diferent values. My if condition is: if (input.Preco_jumbo > input.Preco_continente) { Mais_barato = "Continente"; } else { Mais_barato = "Jumbo"; } My question is where should be this statement? In the form field associated to an action like on add/edit or in the view script?
Remove 'All Times are in ' from forms
Very minor request. On the bottom left of all views is the phrase 'All Times are in ' even if there are no time fields on the view. Is there a way to remove this note? Herb Wexler
How do I pass data from one form to another form?
Hello, I'm trying to build a personal financial planning database. I want to pass the "Transaction Amount" from a Transaction Entry form to a similar field in a Transaction Summary form. The link between the two forms is the Transaction ID ("ID" in the Transaction Entry form and "Transaction ID" in the Transaction Summary form). I have been able to create a link between the two forms and pass the ID, but I'm confused about how to pass the Transaction Amount. Thanks so much, Ann
Next Page