Zoho Creator - Inventory Form - Paypal
Hello, I have used the Zoho Form for inventory. Form Entry: First question, is there a field of formula to generate a unique field number for each person who fills out the form? Also, I want people to enter a certain text field, but I do not want this field to be displayed when the DB is searched. Form Search: Quick back story, I am creating a form where people will "enter themselves" on the web (register) as "people/inventory". Later I want my website's visitors to be able to search the "people/inventory"
Hyperlinks - browser compatibility
I have a dashboard with hyperlinks. The hyperlinks work as expected in the Google Chrome Version 25.0.1364.99. However, The links do not work in Internet Explorer 9.0/12 or Safari Version 6.0.2. I am using the code below <%Urlstart = ((("http://creator.zoho.com/" + zoho.adminuser) + "/") + zoho.appname) + "/";%> <a href=<%=Urlstart%>#View:SITES_View target="_top">ALL SITES</a> Why do the links work in Chrome but not IE or Safari? How can I fix the links? Some users only use IE so I need it to work
Display a form from another form?
Greetings, I'm looking for a way to have a button, link or checkbox on my contact form that says "Log Notes". When I click that, I would like a new form to pop up prompting me for the notes. Can this be done? Thanks, Jeff
View Attachments Online
How to view attachments online instead of downloading it? Can this be done somehow integrating Zoho Docs with Creator?
Automatic selection in multiselect picklist
I have a Region Form which contains a multi-select picklist of Territories.. I have an another user master where there is two multi-select picklists: "Region Name" and "Territory Name". Now, while I'm selecting some regions in the user list, the territories under that region should automatically get selected, i.e; in the user form territory should be selected automatically while I'm selecting the region. How can I do this? It would be very helpful if anyone put some deluge scripts/sample application
Zoho Creator Integration with Sql Server Application
Hello, We have an application that consolidates a lot of different pieces of data into a large report, but the data comes from many different sources. Zoho Creator is the perfect tool to collect the data from hundreds of different users, but we still need our appliation to "display" all of that data. My question: Is it possible to use Zoho Creator as the front end and have the data either persisted into a SQL server upon add or exported to SQL upon command or at some regular interval? Our application
Zoho CRM field does not submit through email
I use a Zoho CRM "account name" field in my app. When I add a record through the app it works fine (through a "lookup" window). But it doesn't come through when I submit a record through email. The other fields in the email are single line. They come trough and I don't receive an error message. I haven't been able to find a solution in the forums. Thanks!
Mobile Sign-in frame clipped
Some mobile browsers (Dolphin is my favorite) give a very good approximation of the desktop experience with Zoho Creator (if they are set to Desktop mode). I have noticed, though, that the Sign In frame is usually clipped (see picture below). The Sign In still works, but one has to know that it is the submit button, AND one's finger has to be nimble in order to "click" the little bit of submit button showing. Might this be something that Zoho could fix by moving the check boxes to the left and putting
Import XLS form load - incorrect tab
I have found a bug with Zoho Creator When I go to "New Form" and Select Form Type "Import XLS" I then select a Tab from the Place this Form under dropdown I then paste in my data and click Done The form and data gets created fine but the Form and View get created under a New Tab. It's not a major problem but the new form and view should exist under the tab I select. It is a hassle moving the form and view and deleting the link. Can you please fix this issue?
A form to add products with multiple variations - and manage the sales & inventory
Hi, I am trying to create a form that will allow me add products that has multiple colors for each of them. Example: Product with code number '405' has 10 colors. Color number 1,2,3,4,5,6,7,8,9 and 10. And I have around 100 products, each one has 10-20 colors. When I sell these products I usually sell a couple of them with multiple colors for each. The color listings for each product are not always the same (not always no.1-20, but usually it is) I want to be able to select a product number in the
How to hide Form Link
I need to hide the form link. Is this possible? I don't want this form exposed I'm simply storing data there.
custom HTML Views
Hi, I've asked this question, but seems I can simplify more to get an answer (that I really need here). When I create a Form for "Tests" with a lookup field: Label Name: Project Import Date from: Project -> ID Display type: Dropdown Advanced Display: displayed as "Name" property for example. Then I want to process a custom HTML view for "Tests". with params: params='zc_Header=false&zc_Summary=false&zc_EditRec=false&zc_SecHeader=false&zc_RecSelect=false&zc_Footer=false&zc_ColMenu=false&Project=<%=Project_ID%>'
pagination in custom HTML view
Hi, Is it possible to add pagination into custom views? Thanks for any response
Send details to my hotmail calender
Hi, If I create a form and within that form id a date and time field for an appointment, is it possible to send that date and time along with the clients name to my hotmail calender. Thanks
Prevent form from displaying?
Does anyone know if it's possible to prevent a form from displaying based on a condition like whether or not the user is the administrator? For example, I have this deluge script working (somewhat): on Edit > on Load: user = Users [User_ID == zoho.loginuserid]; if (user.Role != "Administrator") { alert("Sorry, you don't have permissions to use this feature."); }It displays the alert box as expected. What I need is a way to just show the alert box, then when user clicks OK, the form would
Reset forms & passing parameters
Background: I have an order form that capture ORDER_ID, ORDER_TYPE, PARENT_ORDER_ID and other details. The ORDER_TYPE can be of type child or parent. When a user submits a parent order, they child form is loaded afterwards. It will pre-populate the form to be of type child and save the previous form order id as the child's parent id. This part works fine. Implementation: I have added deluge script via the On Add Submit so that the parameters are passed via the URL next_url = "https://creator.zoho.com/<<application
Login Restrict Records Global
Is there a way to build a stateless form and use that form to create a global variable or session in which i can restrict records. I need a way for people to use this login form to view records but also restrict records I don't want them to see. The standard User functionality only stores two variables (added_user & modified_user) . Well i am the only one adding and modifying records so these filter don't do any good when you want to restrict records from people who did not create or modify them.
Linked Form Update, When update is clicked I just get a message and no redirect.
Hi Guys I have a HTML view that does a for each and the for each creates a hyperlink to the FORM with the ID number, this all works great, but however if i decide to change anything on that record and click Update I get a blank white screen with big bold DATA UPDATED SUCCESSFULLY!! Java Message and then it stays there... how can i ensure that i get the usual Zoho box in the middle of the screen then a redirection say to my main page or even the same page but reloaded... Thanks
maximum number of characters for multi-line fields
We are setting up a database with several multi-line fields. When we import the data the text is invariably truncated. The documentation mentions a 64Kb limit for fields, but what does this translate to in terms of characters/words per field? Is there any way of increasing the character limit for a field?
Linking fields from two different Zoho Creator databases
I have two separate databases in Zoho Creator, and would like to be able to link some fields from each together (so I don't have to make the same changes twice). Is that possible and, if so, how? Heidi
Zoho Invoice CreateInvoice Function from Creator
Hi Guys I am unable to set PayPal, Standard up as an Online Payment Option using the CreateInvoice Function from within Creator. The help file says that "PayPal" is a Key Name that I should be able to select and set in the mapping variables, and if I assign it a value of 1 it should set the online payment option to PayPal, Standard. However, PayPal is not listed in the available Mapping Variables Key dropdown list. Simply typing it in does not appear to work - here is my script. respVar = zoho.invoice.createinvoice({
Is Zoho Creator the best option for my project?
I don't know if I am doing this right but I have been studying zoho for more than 2 days, I don't need a form in my project. Is this project possible by using only Zoho Creator? My project flow is: 1. Upload CSV file containing the data > Time Of Call, Project, Disposition, Call Duration, Zip Code, State 2. Generate a report that will find the Best Time to Call (means that I have to find the data where call disposition = successful call) and the Best Day to call Example: ViewCalls Time Project Disposition
Can't duplicate my app nor upload .ds file
I'm trying to duplicate my "Christmas for Kids" application. I tried saving the script for the app, made the changes, but now I can't find a way to upload it. I have shared the application for support. Please advise. Rick
Print HTML View
Dear all, I have a HTML view. This view is linked with multiple forms by their unique ID. Now, I have to print this HTML view. How can I do that? Pls help. Thanks in advance, Sudhakar Saha
How do I compare dates (earlier, later, difference in days)?
Hi, I have a form in which I have the users enter two date fields (via the little calendar icon). I want to compare these two dates and if one is earlier than another, send an email A, otherwise send email B. The thing is, when I do...: if (input.date1 < input.date2) { sendemail(); } ...it doesn't quite work in all cases. For example, if date2 is 12/21/2012 and date1 is 1/10/2013, it'll say that date1 < date2, when actually date2 is earlier than date1. How do I compare dates and find their relationship
Add entry in Products section in Accounts module via Zoho Creator deluge script
Hi, As above and tried below scripts but I could not get the Products section work. Creating Notes is perfectly fine.... mp1 = { "entityId" : crmAccountAdd.get("Id"), "Note Title" : "Product Code", "Note Content" : input.Product_Code }; resp = zoho.crm.create("Notes", mp1); But creating Products didn't. It only creates new product in Products module... mp2 = { "entityId" : crmAccountAdd.get("Id"), "Product Name" : "13/1300 Number", "Product Code" : input.Product_Code }; resp = zoho.crm.create("Products",
[ServletException in:/jsp/edit/view/viewedit.jsp] null'
hi there when I go to editing my View, there is a masage: [ServletException in:/jsp/edit/view/viewedit.jsp] null' and I can't delete a View can you help me? thank you
How i can to put a link html <a>?
Hi, My name is Juan Manuel and i'm new un Zoho creator. I need a link with tags html, i want pass over by link and show new options or topics or show a new form. i know to made with css or javascript in normal code but i test javascript in zoho and dont work, how can i make this with zoho? Thanks for your prompt response. Juan Manuel
PDF export right margin wrong when fields are hidden
If you unselect a column in a view with "More Actions,Column Display/Rearrange", the PDF export still sets the right margin and column spacing as if the unselected column was included. This means that there can be a lot of wasted horizontal space in the PDF output. Example: create a view that includes 5 columns. Do a PDF export of this view for reference. Then in "More Actions,Column Display/Rearrange" uncheck 3 of the columns. Do another PDF export. The right margin of the view and the auto-spacing
change plan to another account
For Zoho Creator I have an account but want to change to a different Zoho Account. I want to make the different account the owner of the application, including the billing. Andrew
Image width
Hi Zoho, I have added an image field in one of my forms. In the options for the field, I have set the width to 70 px I have a list view for this form and in that list I have set the column width to 70 px. I have also tried setting it to 10 % No matter what I do, the list view displays the full size image. Why does it ignore my width settings? thanks, Anne
Pass parameters through Add New
I like the "Show a link to add new entries" option that you can enable in Forms on lookup fields. However, I want the option to pass values from the current form to the "Add new entry form" You can already pass values through the URL but when using Add New, you cannot pass any parameters. I have a CUSTOMER form with a CONTACT lookup. The CONTACT form has a CUSTOMER_ID field. If the contact does not exist, then the user can click on Add New CONTACT. It would be nice to pass the CUSTOMER_ID from the
Can Zoho run reports like this?
I'm curious if Zoho could do the following things. 1. If we had data set up in Zoho docs, could a custom function pull that data out of a certain set of cells and populate an invoicing app? This would help keep from re-entering $$ amounts each month when we do invoicing. 2. Could a custom function pull data out of a certain set of cells and show up on a graph/bar graph over a range in time? 3. We have contracts that we keep track of and it's important to know the expiration dates. Could a custom
API Calls on a Combined View
Hello Zoho Guru's, I have a Zoho "Combined View" where I have a couple of related fields showing. The view works great! Problem: Here is the problem, when I call that view via the API, those "Related Fields" do not show up. - Is this a bug? - Can it be fixed? - Is there a hack? Thanks!
Form results on websites
I have form results displayed on two separate website. There is a major difference in what is displayed on the two sites. First website: http://jaxareagolfassn.com/MtgNoticeMinutes/ReservationTable.htm Second website: http://www.jaxareagolf.org/index.php/meeting-notice/meeting-registration/ On the first website, there is a gear icon at the top right of the results. The gear may be used to export the results. On the second website, the gear icon does not appear. My users need that icon. Is there
Location of custom filter as a view header drop down?
My custom filter is appearing outside of the normal filter drop down. Instead, it is turning my view header into a drop down and displaying it there. Is this correct? If so, is there any way to move it to the filters drop down? Thanks!
Filtering in lookup field from string to stringlist
Hi there, I have a form called Operators and a form called Suppliers and a form called Countries. Countries contains a list of all countries in the world An operator will only have one country (Operators.Country) A supplier will have one or more countries (Suppliers.Operates_in_Countries) In the supplier form I have a lookup field with a multi checkbox list. In the supplier form I will link all the operators that each supplier is associated with. I would like to filter this multi checkbox so that
Formula to assign value to form entry
I have a form to enter information about client contracts into Zoho Creator. I'm trying to create an a formula to automatically assign a number value to to each selectable line in a dropdown. The field name is input.rating and the following lines are selectable: A1 A2 A3 A4 A5 B1 B2 B3 I want the formula to assign the values in the second column below when a line selection is made and display it on the form or view. A1 10 A2 8 A3 6 A4 4 A5 2 B1 4 B2
Is There A Way To Do Data Unions In A View
I have a main form of members (member_info). Some members have family memberships and the data for the other individuals is in a separate form called (household_members). household_members is linked to member_info via the record ID of member_info. The person in the member_info form is the "primary" member and the household members are "additional members". There are times that I want to produce a report of all members (the "primary" member in the member_info form plus the "additional members"
Eliminating elements from a pick list based on elements in another pick list
I have 2 pick lists: picklist 1 and picklist 2. Each pick list is populated by elements based on a separate search criteria on 2 different views. picklist 1 is typically a subset of picklist2. I would like picklist 2 to persist as a pick list populated with only those elements that are contained in both picklist 1 and picklist 2. Can this be done? Robin
Next Page