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
Ignoring blank fields in simple formula
Hi All I'm trying to create a formula expression to sum four fields using this expression: "£ " + ((Presentation_Cost + Press_Release_Cost + Other_Costs + Deliveries).round(2)) which works fine, unless one of the four fields are blank and then the result is also blank. What do I need to change it to so that the formula will ignore blank fields? Many thanks Nick
Not Able To Remove Added Filters In The View
Hi, I have a zoho creator view with some filters added for various fields. All the filters are working fine with respect to functionality and also filters can be removed. But the adding and removing of filters is not correctly working for lookup field values. For suppose i have added a filter for a lookup field value.When i click on the remove symbol(Click to remove this filter) i.e., close or cancel (X) in the applied filter of the view as shown in below screen print, a new field for the filter
Initial value in a multiline text
hi, Can somebody tell me the default value for a multiline text? I am trying to check whether multiline field is empty or not by comparing it with 'null' , using if condition but it does not seem to work. Am I doing something wrong? Thanks in advance.
How do I Close a Popped Up Stateless Form via Script ?
Hi: I have a Stateless Form (called Base1) ... the on Click action for one of the buttons is ... thisURL = "#Form:Stateless1?zc_LoadIn=dialog&zc_NextUrl=#Form:Base1"; openUrl(thisURL, "popup window"); ... i.e. another Stateless Form (called Stateless1) is popped up ... this part works. And if the user clicks on the Close link at the top right corner of the popped up form, he/she is returned to Base1. However, when the user makes changes in Stateless1 and clicks on a Custom (or Submit) Button within
Button style for SUBMIT ?
hi just made stateless form for my app and turn it on site how can i make submit buttom in red color? in "customize" i didn't find any tunings for it
Get rows from uploaded excel/csv files upon "Submit"
Hi it's my first day of trying Zohocreator and I have created a simple form with a File Upload field and the usual Submit button. How do I fetch the data (rows & columns) from the excel file? or given that it's a CSV File (Comma Separated Values). Thanks, CJ
Default value for text field (single/multi line)
Hi.. Is there any way we can assign default value for text (single/multi line) filed ? Thanks,
Actions for each new row/record in Subform.
I want to send an email to each new email address added in a subform. Is there a way?
ZC - ZInvoice integration questions, Autoemail for customer && Set default payment gateway
Hi there A couple of questions when zinvoice is generated via zc integration tasks 1. When an invoice is generated via ZC (& status set to open), does that automatically mail the customer with invoice attachment and payment details? 2. my client tends to use STRIPE for payment, Can this be set up as default @ ZInvoice,.. or via ZCIntegration task? -Deepa Govind http://homepreneur-online.com/
How do I delete a tab in Zoho Creator?
When you create a new form, it gives you the option to put that new form in an existing tab or a new tab. I've created some tabs I now want to delete. How is this accomplished? I'd also like to be able to hide some tabs from other viewers. Is this possible? Jonathon
API: Sample Code for base criteria in HTTP GET
Just struggling to get this to work, can anybody elaborate on the following from the knowledge pages: authtoken Required. A valid API authtoken. Referhttps://api.creator.zoho.com/Generate-Auth-Token.htmlfor generating authtoken. scope Required Specify the value as creatorapi <application name> Required. The name of the application that contains the form. <view name> Required The name of the view to show records from. zc_ownername Optional. The owner of the application. Required if the application
Hyperlinks in Embedded Report
I wanted to display a name, and two hyperlinks on a report... embed in a webpage... and have someone be able to see the report, copy and/or click through the hyperlinks. However... embedding a report doesn't do that. If you right click on a displayed hyperlink, you get choices like sort, view underlying data, etc... Not what I wanted at all. I simply want to embed the DATA into a webpage so it appears as a table of links, that behave like any other link on a webpage. Do I need to do this
Only allow user to access records based on specified field value.
Hello, I am using Hariharan's CRM. Each store has a unique Zoho login. In the New User form I have a field named STORE. (There may be 2 or 3 users per store) Also every record in a form called LEADS there is a field called STORE. I need to ensure that when a store logs in. They can only view their own records and not the records from other stores. Can anyone please help?
File upload - box.net?
Hi, The file upload only has the following options Local Computer Google Docs Is there a way to integrate Box.Net files? My client keeps all their files on box.net and wants to select and upload files from the one location.
No RSS option in Export Data
Hello, in my application Cafe Nanny I cannot see an RSS option in 'Export Data.' I have shared the application with support. Thank you
Can we control the way ZC generates ID for data?
Generating ID fields seems completely random, is there any way to control sequencing, particularly on imported data?
Next Page