I cant see user permissions in my app
I tried to search in every corner of the CREATOR! In Manage Users for example or in Share settings, this option doesnt appear to me! I remender to see these options in the old creator but now a cant find! I wanna create a user with read only permission! Its simple but i cant find! I use a Personal Free Edition with some adds!
Create a Sales Order in Zoho Books from Zoho Creator
Hi, How do I create a sales order in Zoho Books from Zoho Creator either as an On Add -> On Success action? What script would I use. Thanks in advance, Siya
Auto Filling from the same field.
Hi! I have an application that can be used by both new clients and existing ones. The form has a decision box which when checked distinguishes the user as an already existing client. When this is checked a look up table is shown with all the existing clients, Once a client is selected I want to be able to auto fill his client information, Email, number, etc.. I am unsure how to auto fill this information when the information I need comes from this forms report. Thanks!
TIP: Using Deluge, create URL field with dynamic parameters such as record ID.
Using Deluge, create URL field with dynamic parameters such as record ID. After reading dox and lotsa forum posts, here is what worked for us just now. We're sorta new at this, maybe there are issues, or a better way. Our purpose was, on the convenient "pop-up" page that can display when on a report you click on a linked item's name, to have a linked field at the bottom for "Edit This Record". (A big convenience if you spot a need, you can edit it right away w/o going to a the different report
Data dump
Hello, Does Zoho offers the functionallity to automaticly generate a data dump for example Excel? No export from a report. We can use this data dump for intergration in a financial application we use. Greatings, Erwin Fennema
Alternate View in Report
In a list report I've a "customer" column field which links to the customers form, and when clicked shows the customer view (customer name, email, address, etc.,). How can I change this view to show aggregate data? Id rather see the number of purchases, total purchases, order history, etc.,
Mapping Look up Fields to Zoho Reports...
I tried to map fields from Zoho Creator to Reports.. For most part, it worked with the exception of the Look Up field.. I get a unique number ID for the customer name... ... Any tips on how to take care of this? Thanks
Sub Forms in reports
I am using a Sub form and i am curious what happens to the data when it is entered. I can not see it in the report and all of the data is reduced to some ID number. What happened to my info and how can i find the Sub form in a report. IS it possible to create a link to that sub form that will then open up the data added to the subform?
Multiple if statements in a formula field
I'm trying to figure this out with no success. Can someone chime in on this one? Thank you. FIELDS: QTY_Suspect is a number field Piece_Price is a currency field Suspect_Product_Disposition is a lookup field if (input.Suspect_Product_Disposition == "Sort at customer", Piece_Price * QTY_Suspect, if (input.Suspect_Product_Disposition == "Return to plant", Piece_Price * QTY_Suspect, if (input.Suspect_Product_Disposition == "Scrap at Customer", Piece_Price * QTY_Suspect, if (input.Suspect_Product_Disposition
Would it be possible to enter data into form using HTML Page?
Hi everyone, First of all, sorry for my english. I'm new to Zoho, just building my first application. A little help or guidance would be very much appreciated regarding my biggest problem so far. We are a dental lab and I'm trying to create an application for filling in worksheets. This is a section of our worksheet, the numbers are representing teeth Every square above and below numbers represent a field. Each field can contain 3 different values. (BG, K, T). I would like to create an HTML page,
How do I change columns to Row in a pivot table?
Hi all, Can some one help me in placing column to row I want to shift that to rows. Thanks in advance Venkat
Error with If then statement
I am having a problem with this statement. I am trying to populate the field Fee on my form based on the selection in the field Age_Group. if (input.Age_Group == "70 and Over") {input.Fee = 115}; else if(input.Age_Group == "13 - 69") {input.Fee = 125}; else if(input.Age_group == "5 - 12") {input.Fee = 25}; else {input.Fee = 0}; The error is Error at line number : 1 Number of arguments mismatches I searched the Forum and found a similar issue and put the semi-colons in but I am still getting
Adding current date when choose specific option of Radio button.
I have a form for a Dog day care that i work for. The form has a look up tab for a dogs name and a radio button with two options "Check in" and "check Out". I would like for each time i select "Check in" the current date and time is added to the Date_time field before loading the form and adding it to the report . I have been messing with the script and i cant get it down. I know it is fairly simple but the grammer of the script is not very easy to understand or set-up.
Help with sub form please
Basically I have a field called Documents which has a list of check boxes, when the box is checked it will show a date created field and a upload field. My problem occurs when I create a subform of my Documents form, when I run the application the subform will display all of the fields even though the code is set to hide. How can I make the subform work as intended ? Thanks! :)
Help with my subforms
I currently have a form called Documents in which I have several check boxes, when the boxes are ticked the code will allow for a date and upload field to be shown in the application. I would like to use this as a sub form but when I load the application with the Documents as a sub form it doesn't carry over any of the code. So all of the fields can be seen. It would be a big help if anyone could assist me with this problem. Thanks! :)
Date Field
Hi, I am currently having some trouble with my date field. At the moment I have my date field set to upon the form load it will fill with todays date, however this is all good for making a new user but when I wish to update and existing user it will only display the current date, not the original date when the user first became a new client. Thanks! :)
Sub forms in report
I am using a sub form and i am not sure what happens to the sub form when i view the report. In fact, once i enter the data into the Sub form, this sub form being called, "Vaccination Records", i am not able to access an of the information i have entered. I am glad i am able to add new lines that i have created to the sub form easily but all the data is lost, unless i export the report to excel. How can i get the Sub form to show up on my report, best if it was a link to the Info imported into the
Complex "Duplicate" warnings in Forms
Hi all and thanks for your understanding. i try to setup a Duplicate record warning when user input data in a form. I have three fields : "Item référence" : a no duplicate filed "Start date" : date of use of the item "End date" : date of end of use of the item. If I select for a second record a period inside the period allready selected for the same item, an alert prevent me of saving the record. Exemple : Row 1 Item1 - 01/01/2015 - 31/01/2015 : input accepted Row 2 Item1 - 01/02/2015 - 28/02/2015
LIvedesk pricing with zoho creator
Hi I just take out a business plan and discovers livdesk . I have a doubt about the cost : should register on top of a livedesk plan or business plan creator of enough?
thank you for your answer
Need to create Application "Call to Support".
I am using Zoho Creator for making an application "call to Support" which will create a ticket in Support. When the ticket in Support is closed, its status should be communicated back to Creator. Then, we will work on the same process with CRM. I have created form of Ticket. But I need to add auto reference number for each submitted ticket. How can I add this? After submitting this ticket, I need to show ticket status like open or close. How can I add this option to show ticket status? I need a page,
Can't open page editor (AGAIN!!)
I have an html page, and when I try to open the editor, the page hangs and never loads. The html pages still load, but I can't make changes to them. Anybody have any ideas? I have submitted to support already... Last time this happened, it was because I used "count" as a variable, which is apparently not supported. I got the ever-helpful troubleshooting error of "null". I have not made any changes since last time this happened. See that conversation here: https://help.zoho.com/portal/en/community/topic/can-t-open-page-editor#2266000005930001
Where are my data located?
We are thinking about use of Zoho Creator, but I was unable to explain my coworkers where the data are located. They would be happy if they are accesible and stored at Google not at Zoho somewhere. Could you please explain me how storega of data works? When creating new form, I get option "Data will be stored in Zoho Creator" What does it mean? Thank you for explanation.
Using IP Addresses to Limit Form Access
My organization was concerned that people from outside our area could use our public forms. Here's my solution: MaxMind has a free geo-ip database you can download. I sorted thru this to find and define an IP address range for my city and surrounding areas. To make it simple, I'm just using the first octet (66.167.22.1 is just 66 for my purpose). Using this simple line of code IPN = (zoho.ipaddress.getPrefix(".")).toLong();I can now enforce (via the value of IPN) a reasonable level of geo-based security
IF condition
I am creating a product order form. I have a field with a formula which totals all the quantities, multiplies them by the unit price and gives a total price. I also would like to have a condition that IF the total price is less than a certain amount then a fixed delivery charge will be added automatically. I don't think I can add this condition to the formula in existing 'Total Price' field. So I created another field and attempted various permutations of possible code for the IF condition. But
Page break in Record Summary
Is it possible to have a page break in a record summary. I want to print some of the fields from a record on one page and the rest of the fields on a second page.
Autofill subform
Hello, I have the following issue. Form 1: Field 1: Number Field 2: Subform Form 2: Field 1: Lookup (based on form 1 number) Field 2: Subform Now I want the subform in field 2 filled, with the values of form 1, when selecting the number in field 1. I have made the following script in form 2: x = form_1 [ID == input.field1]; for each row in Subform { row.Description= X.Subform.Description; } The problem is he only fetches and updates the first row. Greatings, Erwin
Mutiple forms one database
Hello, Is it possible to make multiple forms but put all the data in one database? So I have one record with a lot of fields. And I can make different reports based on that database?
SendMail - specify the 'From' name
Hi, a quick question... When using the sendmail function in deluge, is there any way that you can specify the name of the person / company sending the email - as opposed to the email address of the admin person showing. e.g. Currently shows as receiving the email from admin@company.com, want it to show 'Company Name'. Thanks in advance for any help... Paddy
sub-form Creator
Hello, Is it possible to automaticlly fill in a sub-form? For example: Form 1: Generates invoice number and I use a sub-form for different articles, price, quantity, sub-total. Form 2: Looks-up the invoice number and has to automaticly fill in the sub-form. Is this possible? Greatings, Erwin
Support for IE8
My customer portal seems to be broken for users - especially IE8 users. When invited individually ( also not presently working for me) They USED to be able to access the customer portal OK. When invited as part of a list of email addresses - they always had issues - even with Chrome. However - tonight after asking for support on this for the last 2 days - I got this note from a zoho " developer" : "Hello, Greeting from Zoho creator. We are sorry. IE8 is a not a supported browser for customer portal
Make a report more simple
hi all, I have a problem and I got stuck, I want to make a summary report from several different record and print it at the same page (at least). can you help me with that and show me how to do that step by step. I've attached the image of my needs, I hope it can help you to understand it better. Thank you so much.. From this report data become more simple report (as you see, it makes the same Car Number Data as summary) PS: just ignore the Using Date
Lookup field won't display desired fields
I created a lookup field on Form A (Head of Household) pointing to rows on Form B (Apartment). This is a 1-to-1 relationship. The fields which I want to display, Building Number and Unit Number from Form B, won't display in the lookup field on Form A. Only the ID and other system-generated fields will display. What am I doing wrong? Thanks!
Update Form information using a stateless form.
Hi, I have a stateless form that I'm using to enter information into a regular form. Once the information is in the master form, I'm also using a stateless form to show the user only the fields they can change.If the user changes any of the fields: How do I update the information back into the the master form from the stateless form? Thank you in advance, Alan
identify portal user
When a user is logged on and makes a change to a field I want to record that fact. I am using the code... if (input.Live_Status = "Visit Confirmed") { input.Confirmed_By = input.Added_User + " at " + zoho.currenttime; } but it is not returning the portal user it is returning the main account name. What code do I use to identify the portal logged in user. Thanks
look up values from another application
I have a customer list form with account number, customer name, contact name, contact phone, and contact email fields.. I have a form 2 ...with a lookup field for account number...; customer name, contact name ... etc., When I select an account in form 2, I would like to fetch the corresponding values for customer name, contact name etc.. from customer list form.. I tried with the following code... and getting error if (Customer_List.Customer_List[ID == input.Account_number].count() > 0) { x =
Security
Hello, Which measurements does ZoHo takes to protect the databases and the application? Does ZoHo automaticlly makes back-ups? Which measurements does ZoHo takes to secure the databases? Does ZoHo has escrow? Which measurements has Zoho taken to ensure the continuity of the application? Hope to hear from someone soon. Greatings, Erwin Fennema
Get records from a filtered view programmatically
My DB contains a list of 408 000 Persons. The User will filter, as he/she wants, these list of Persons to select the persons who can participate Then I would like that the user could click on a custom action which: - get all the filtered records presented in this view (so the all 119 000 in my screen capture) - do something with, like copying them all in another "form/table" programmatically (not manually) Of course I don't want that the User has to click on each page to select all of them. I am
Trial Period payment form value sent to PayPal
I'm trying to configure a form to submit a payment for a monthly subscription service. The issue is, I need to be able to add a "set up fee" to the initial transaction, followed by monthly payments. The initial fee is equal to the monthly payment plus the set up fee. Paypal has a "Trial Period" for subscription based payments, which can be different values than the set monthly payment. Is there a way to pass a "Trial Period" value to PayPal within the Payment form created in ZC? Thanks, DL
Google Maps
Hello, Is it possible to put a maps from Google Maps in a form/record with a pinpoint in it? Greatings, Erwin Fennema
Fill out Zoho Creator form when Offline
There have been many questions about this over the years, with responses ranging from - no response, to, it's in our roadmap, to, no, it's not in our roadmap. Has there been any movement on this front? HTML5 browsers provide the ability to use a form offline, with data cached, with then the ability to send the data when the device is back Online. If Zoho supported this with Creator forms, the product would be a Leap ahead of the rest, and it would enable all kinds of uses of Creator forms that
Next Page