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"
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 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!
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.
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
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
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",
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
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
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
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
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
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,
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
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
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
I would like to report on emails sent from a schedule
I would like to report on emails sent from a schedule How is it done? DC
How to create a unique revision to a record by linking it back to a record within the same form....
Lets say I am cooking and I have 10 recipes. So, I create a form with each recipe as a record and I give that recipe record a name. ie. Carrot Cake. Now I want to experiment with the ingredients in that recipe, so each new experiment would be a revision of that original Carrot Cake recipe. So I create a field Revision. Can I create a lookup field that would show what revisions had been previously created for the Carrot Cake recipe? So that duplicates are not created? Or can a formula of some kind
Form on site & auto-filling Creator's app
Hi on my site right now i use jotform's form in which users fill name address phone attach files how can i make the next: form on my site that 1) will accept uploading files AND 2) automatically fill new entry in my creator's app with attaching uploaded file as i read before - stateless forms do not accept uploading files
Line spacing in views
I have a simple view with 2 columns of single line fields. The vertical spacing between the lines of text in the view is larger than the actual text. Is there a way to change the spacing?
Form Layout
Hi - do I have to have 1 field per line, or can I have several fields on one line so that my form can be wider and not so long? This would make it easier to fill in data quicker. lenfante ------------------------------------------------------ This is posted using zohocreator feedback form
Number of fields in table
Our table includes "too many text fields". Your support documents state: "Form can have maximum of 80 text fields with max length of 255(SingleLine and Email). This can be increased by reducing the max length value." We reduced 50 fields from 255 characters to 3 characters. We are still UNABLE to add a single new field to the table. What's going on????
Checkbox Variables???
I am trying to do a script based on action on a checkbox. I want to expose more fields to enter if a person checks a check box. When I am doing the script, what is the name of the variable for "checked" ie. if (input.HRA == ???) What goes in the bold ??? to tell it checked? Thanks Q
Infinite parent child relationships
If I have "Comment" and want to have sub-Comments for each "Comment", whats the approach in Zoho Creator in order to do this? Is it possible to do something like under any particular comment entry have "add comment"? I'm okay with any programming required here, I've gone through alot of the documentation but can't find anything related to this.
Relationships (via lookup) in Zoho Creator
Hi, I have a question regarding Zoho Creator lookup. I'm wondering how relationships (lookups) are defined "internally" on Zoho Creator. It seems that lookup fields accept any arbitrary data type and not keys/ID's of the referenced items. If a field I specify as the lookup is "Name", and I point to that field in lookup, "Name" must be unique? How does this compare to standard databases which usually use a unique ID/key to creation relationships? Is this more comparable to say Access database? I'm
How do I make the Sub Form look like the rest of the form?
Hi, I'm working on my first application and I've included a sub form in my main form. The sub form appears to in a table view and scrolls off the screen to the right. This make for a very bad UI. How do i change the the sub form so that it appears as the rest of the main form does? I've read through the manual/quick start guide and the searched the knowledge base and cannot find the answer. Any help is appreciated. thank you, Larry
ZOHO Creator
How does zoho creator work? what if I want to make a computer application or a phone app?
Houston!! I have a problem
Hi guys. I'm new with Zoho and i've made some HUGH errors. I have 2 forms. Form 1 - Portfolio Brand: Dropdown menu Model: Text Field (no duplicated values accepted) Form 2 - Sales Date: Date value field Brand: lookup value from FORM1 Model: lookup value from FORM1 (with a criteria that dependingo on the Brand you will see Model) Now, the problem. I've beenn updating form 1 - Portfolio, and as it was easier, i've deleted all the values and recreated them. The problem is that now, all the registries
HELP!!!!
HI, i want to know if it is there any way to selecta dropdown menu depending on the user that is creating the record. What I want is to add a field where i can see the Complete Name of the user that saved that record. This is because USER names are really strange, so i want to create something like: If username == "jd2012" then Owner = "John Doe" So, i can create a list of the users witrh the correct name, but i want to know if this is possible! thanks in advance Pablo
Newby question :)
First of all, hello to everyone and thank you for reading my post. Here is my problem: I own a martial arts school and I am trying to create a database in which i ll be able to keep track of my enrolled students and their monthly payment status. Up to this point I ve created 3 forms, a registration form, a payment type form (different types of payment, monthly tuition fee, private class, school accessories etc) and a final invoice form which takes the name of the student from a dropdown lookup function
How can I set hierarchy based view?
How can I create some auto views based on user roles in creator? I know we can create a view which can be populated against current user id. But when there is multiple roles (not only admin and user) and different hierarchy, how can I set this type of auto view? Otherwise in case of new employee joining, every time I have to edit/create some criteria in a view to get the hierarchy wise view. Can it be possible using collection? Pls help. Sudhakar Saha Technical Consultant GoldenLion Consulting Services
Changing field type after data import......
I am creating a new form and decided to import the data from an excel spreadsheet since I had over 200 records. During the import the field mapping correctly shows the sheet and the data headers. I can choose the type of field. At first glance it makes sense to choose single line, but the field is for "manufacturer name". When the form is later used to create a new record, I would like the "manufacturer name" field to give the choice of selecting the "manufacturer name" from a list. I have another
Next Page