Is there an easier/better way to create a script that repeats n number of times?
nline = List:Int({1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11}); cntLst = List:Int(); num = input.n; for each integ in nline { if (!(num == 0)) { cntLst.add(num); num = (num - 1); } } for each ent in cntLst { some proceedure } Any help would be great!
How to restrict users from exporting
Hello, I need to be able to restring the people who have access to my database from being able to export. Right now when users access my database they are able to export to PDF and CSV as well as other options. Is there any way I can stop this? Thanks.
Application Domain Mapping
Is it still possible to map a domain to an application without using the customer portal feature? Cheers, John Whitney
Expiration policy... specific number of days
I see in the Terms of Service a mention of account expiration due to inactivity, but it doesn't say how many days. Can you tell me how many days of inactivity will trigger account (or application) expiration? http://www.officeswap.com
Trouble with function to update field with current date via custom action
The custom action button in my report runs and displays the success message. However when I check the Quote Sent Date field it is empty. Here is my function code void SentRFQ() { rec = RFQ [ID == ID]; rec.Quote_Sent_Date = zoho.currentdate; } Any ideas
How to determine if the lookup dropdown does not have a selected value
I have a master form: Branch Master - ID - Branch Name Another form - Account Name on Account Branch (Lookup from Account to Branch Master on ID column of Branch Master) On the Account form, when I write this code input.Branch != null to determine that the lookup dropdown has a value, I can't even save the script. How do I determine if a selection has been (or a selection has not been made) made on a lookup dropdown?
Access database from iphone app
Hi, I'm creating an iPhone app and wish to populate my remote database with zoho creator. I wonder if it is possible to access my zoho creator app's database from this iphone app like one can access a random remote mysql database. If so, how ? I didn't find any documentation on zoho's api's... Thanks.
Public Access and Login
Hi, I've built an application that I wish to make public and commercialize. Is it possible to customize the registration for my App that combines with your login registration? ie I want to ask additional questions and log them plus send login confirmation with username and password. Key reason is I use the login variables within creator throughout the App and if I make the app public with login I think I lose this variable use, I'm not sure how to get round this. Also want to change the Home option
Duplicates/launching same application multiple times
I'm creating an application that I would like to launch to all students on campus. I would like to relaunch the SAME application every semester to update the students file on which classes they have taken. How can I do this? Also, how can I make sure that every time they fill out this application, their information will automatically update their previous report and not add a duplicate student with the same name? Thanks!!
Zoho Creator Accessibility
I'm interested in raising the awareness of web accessibility concerns within the Zoho Creator community. Some people cannot use a mouse, including many older users with limited fine motor control and users with impaired vision. According to the World Health Organization 285 million people are estimated to be visually impaired worldwide; 8.3 million in the US alone. All U.S.government and most educational institutions are required to have their IT systems meet minimum accessibility guidelines. Zoho
System Fields Missing from Report GUI
I wanted to create chart displaying a running total of sign-ups but "Added Time" and "Last Modified Time" are missing from the report builder GUI. Where did they go? Cheers, John Whitney
hi with sendmail functionality is below stuff is possible
hi, using send mail is it possible that 1)After successful upload of data it send mails to respected user and manager 2)In case there are errors while importing data ,send respected errors as attachment to Manager and user. 3)Then Manager will check and approve data. hi if above stuff is possible tell me how?
What is the Easiest Way to Exchange Registration Info
I am a newbie and have successfully created a "Student Registration Form" within ZOHO Creator. Since students contact me to register – I would like to just send them a link that goes straight into the registration form – Once they complete the form and submit it – I would like to get the notice (back to my email) their form is complete. I want to be able to insure that a student can only see their form and nobody else’s. Can you please advise the best way to do this or direct me to a on line tutorial
Subform Bidirectional lookup
Hi Zoho Team, I have the following problem: I have 4 forms (Supplier, Product, Quotation, Order) Supplier has a bidirectional link to Product (One Supplier, Many Products) Product has a bidirectional link to Quotation (One Product, Many Quotations) And now I am working on the bidirectional link between Quotations and Orders (One quotation, Many Orders) But I'm stuck, I want a subform in my Order Form because it allows users to create an Order including several Quotations I can create the lookup field
Zoho Creator pages are not accessibble to some users
We have found that some content in Zoho Creator is not accessible to our visually disabled users or users with limited dexterity. For many users the only way to access web content is through a screen reader or other assistive technology. There are a few simple things that can be done to make Zoho Creator accessible to everyone: Images should include alt tags Form labels don't reference the form fields, The Labels the "for" attribute like so: <label for="FirstName">First name:</label> <input
Fetch data from another app
I have two apps, Warehouse Database and Pricelist Master Database. In Warehouse Database I have a form called Orders and in Pricelist Master Database I have a form called ContactForm. I have created a Lookup in Orders called input.Company which fetches the Customer name from ContactForm. What I want to do is then using this link fetch the remaining data such as address / customer no. etc and populate fields in Orders. I know how to do this in the same app between two forms, I use something like:
auto fill field in sub form
Hi I have tried following other posts about auto filling fields but cannot seem to get it working, here's my set-up: Main form: quote_system Sub form: areas Price list form: master_price_list In the sub form, users will fill out rows of data completing a quote, they start by selecting an area (which populates from a lookup field), based on this selection a new lookup field gives them a type from the master_parts_list which in turn gives another dropdown with possible parts (again from the master_parts_list).
Identification of Duplicate Records
What is the most efficient way to identify duplicate records for a large number of records? It does not seem efficient to compare each record to all others because of the maximum number of executable statements per deluge action. Note: I did not enable one record per user due to the type information being gathered. Cheers, John Whitney
Addition of values not working as expected
Hi, I have a form1 with fields say Id,Name and Type and Quantity, Quantity available then form2 with fields say ID,Name,Type,Quantity,Quantity Sold and Quantity in stock. Based on the type given in form quantity available will be listed. What i want to do here is , On success of form 1 i have written a code to fetch the form 2 field with current form1 fields, If their type and name is equal then add Form2.Quantity =Form1.Quantity+form2.Quantity. rec = Form2[Event_ID == input.Event_ID.toString()
Consolidation of stock tables
Hi! I am new to Zoho Creators. I am having 5 different tables for stock count. For example: Table 1: Chennai Stock Table Table 2: Delhi Stock Table Product Model Stock Count Product Model Stock Count A 10 B 20 C 20 C 30 Simillarly, there are 3 more tables for different locations. I want t consolidate all
No duplicate values in two or more forms within the same application
Hi... I need a little help. I have an application with more forms inside. I would like that a field become unique in every form (i don't want that a student duplicate a value). For exanple: A student must book for an activity for the days 6 and 7 May but he can't book himsle for the days 10 and 12 May because he already booked for the days 6 and 7. Ho can i coul do it ? Thank you in advance for every suggestion.
Htlm View showing upload or not links from differents views
Hi, I have a HTML view that summarize datas and uploads from some views as: myAnswer = FormA [ID == input.recId.toLong()]; myAnswer1 = FormB [FieldUnique == myAnswer.FieldUnique.toLong()]; myAnswer2 = FormC [FieldUnique == myAnswer.FieldUnique.toLong()]; So when I want to put a download link in the HTML View I write this code: <td NOWRAP> <a href="https://creatorexport.zoho.com/DownloadFile.do?filepath=/<%=myAnswer.UploadField%>&sharedBy=IM&appLinkName=NAMEAPP&viewLinkName=NAMEVIEWFORMB"><%=tempVariable%></a></td>
multiple many-to-many relationships
Main Problem is I want to ensure the database structure is correct so that I can convert it into Zoho Creator Form Combination (This is one element from a multi-function 50 Form application (Functions range from ordering products from suppliers to maintaining inventory etc...) I can give access if necessary, I have attached a visual of the 'problem' as Design Specs.pdf and A copy of the already implement database in Zoho Creator (which works and I am happy with, I develop the relationships in Access
User Creator to create seo application to track domains and project status/next actions
Is there a way to use Creator to extend ZOHO Crm to track domains per Account and marketing activities. Is this done easily by integrating zoho projects or do we need to build a custom app in Creator? Thank You
Creator App - iPad / iPhone Issues
I have a lookup field (Lookup A) that fetches data and updates other fields in my form. One of the fields updated is a another lookup field (Lookup B). Lookup B then updates other fields. Problem 1 - Using the Zoho Creator app, this works on my iPhone - However - it does not show the data in "Lookup B"...instead it says "1 option selected" - How do I get it to show the value of Lookup B? Problem 2 Creator App on iPad - Lookup B is not updated Problem 3 Using Creator App on IPad - Pictures are
Missing Embedded Code
Dear ZoHo Experts, I have a problem with ZoHo Creator, i have builded an app. It looks good. But now the problem: I cann't find the embedded code for the website. It seems that the embedded code has disappeared from the Publish tab. Can you figure out what is wrong? Is it a bug that you have to solve? Kind Regards, Jan Willem
Possible Bug?
Hi, When I try to execute the "Add Product" action from your Order Management 4.0 sample. (Please refer to attachment Script image) The Error message displayed. (Please refer to attachment Error image)
Why does this request give error 2892? The application name is correct.
https://precreator.zoho.com/api/json/myapp/forms/?authtoken=0e508cec205591dc3f137662b614f2fb&scope=creatorapi I don't know why this gives an error. The authtoken and application name are both correct. Is this a bug? If not, how can this be fixed? Thank you.
Creator Data WIll Not Import Into Zoho Reports
I am no longer able to import Creator data into Zoho Reports. Steps to recreate: Creator - Data Location = web, in the URL box I am inserting the URL from Creator "links" "permalink", "publish URL". It returns a message "unknown host or host not reachable. Please verify the URL provided"
Submit Failure Message when Press enter
I have a form that will get data from zoho crm. My problem is when press enter, it will show the error message, All i need is to disappear that message only, if (input.Email != "") { vSearch = "(Email|=|" + input.Email + ")"; crmRes = zoho.crm.searchRecords("Contacts", vSearch, 1, 1); if (crmRes.size() > 0) { fa = crmRes.get(0); input.FranchiseApplicantsID = fa.get("CONTACTID"); input.First_Name = fa.get("First Name"); input.Last_Name = fa.get("Last
Pricing zoho creator
Hello, I used the free version of Creator Zoho, now I require buy 1 user, when revenue in my account the standard plan is $ US25 for 5 users, but if I enter a new user the standard plan is $ US5 for 1 user, I need only 1 user, I can buy it? Julian Calderón Escobar,
Not All Table Objects Available in Form?
In my Phone_Line form, I am trying to add a reference from another form Line_Account. The following is the code from the field I'm creating in the form Phone_Line. Why does this work: must have Line_Account_BTN ( displayname = "Line Account (BTN)" type = picklist values = Line_Account.ID displayformat = [ Parent_Account_ID + " - " + Phone_Number ] sortorder = ascending searchable = true width = 206px ) But this does
Is there a formal enhancement request system with Creator?
Is there a formal enhancement request system available for Creator? I am hoping that I can log many enhancement requests to make this tool more wonderful. It is a great tool already. But like every piece of system, there are always rooms for improvement. I would appreciate if any of the Zoho Creator team can response to this. Thanks.
Lookup Link Records with Pivot Tables/Charts
We have a table of sales data (A) which link to a table of product data (B) via a Lookup from A accessing a unique product ID in B. How can I access parent fields in B while running reports for A? This help document shows how to do this for List reports under the header "Creating a Link to Parent Records":https://www.zoho.com/creator/help/forms/creating-relationship.html But how do we do this with Pivot Tables & Pivot Charts?
Remove Commas on a Number field
Some of the user put commas, when they put commas, The formula field is when wrong, How can remove commas automatically on input?
Ratings
I am working on an application that I want users to be able to rate records (out of 10) in. I have created the fields for it, however, I am having trouble figuring out a way to display the average ratings. Right now, when a user rates a record, the view just creates a copy of the original, with the new rating. Could someone explain how I can get the average, without creating extra records?
Import Inline Subform Data
Is it possible to import data from Excel to a form that has embedded subforms in it (subforms that are created inside the parent form as opposed to being created on their own and linked)? In excel I have one subform field populated with comma-delimited values. In the import wizard, I map this excel column to the subform field (tried it by selecting and deselecting the import subform data checkbox on the first page of the wizard). The import declares success for both the parent record and the subform
Automated Mail to Specific used
Is it possible to send automated mail to specific users based on user selection? I have 5 spocs whose names are available in the drop down field, Automated mail need to be send to them based on the user selection with some or complete data of the details entered by user. As of now I have used send confirmation mail option which send mails to all users. I need to restrict it to specific users. I don't know scripting nor any have any developer to help me. I understand it is possible with little bit
Alert based on calculated time
Hi, I write to support but have no answer to my problem. I have a script to show an alert based on calculated time (lookup field of meeting) "on input" of field. Now, with Creator update, I try the same script in other form but don't run. Anyone have similar problem with? Thanks in advance. Mike if (input.lookup.toString() != "-Select-") { meetTime = FormMeetingPlace [PlaceMeeting == input.lookup.toString()]; timeDiffinMilliseconds = (meetTime.StartTimePlaceMeeting - zoho.currenttime);
Zoho Creator Form Builder is inaccessible to some users
Form Builder is not accessible through key commands or a screen reader (only through dragging with the mouse). Our users with visual disabilities and limited dexterity are not able to use the service.
Next Page