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
Sent mail with the content of Lookup field
I have this code to the sendmail the value from the lookup field: TorneosForm = Torneos_Form [ID == input.Torneos_MDE]; ContactosForm = Contactos_Form [ID == input.Nombre_Arbitros2]; sendmail ( To : input.Correo_Electronico From : zoho.loginuserid Subject : "Cambios en la Asignacion" Message : <%=TorneosForm.Torneos_MDE%> ) Receives this error : Error at line number : 6 Improper Statement Error might be due to missing ';' at end of the line or incomplete expression
Pass Custom action Form Object selected records to html view for loop?
I have a custom action that executes for a collection of records. (ie, I select several records in a view and execute the custom action.) This uses a form object with record ID's. My function is as follows and it opens an HTML View: void Shipping.Order_Batch(Purchase_Request_Form ID, int Order_Number) { openUrl("#View:Order_Batch_HTML&ID=" + ID + "&Order_Number=" + input.Order_Number, "popup window"); } I want to pass the list of record ID's into the Html view and use the selected records as
How to import data into a page
I want to use zoho to fill out a contract automatically if we choose a customer (name,e-mail,address.etc.). I made the contract as a page. I've added the contract text with INSERT HTML, but I don't know how to add expressions from a form. (I made a stateless form to choose the client and I've added this to the contract page). Can I get some help,please ? :)
Details on the working ?
Hi, I am very new to the Zoho, so I came across many doubts in the same, 1) Whats an application ? with the forms created in application how can I gather data from my customers ? 2) Can I create a single form with 135 fields ( 25 Dropdowns, 70 text, 20 Checkbox, 20 Date ) in one form ? 3) If not how can I do it with multiple forms ? 4) Ho can i implement the multiple form application to get data, if single form is used we can embed it to some of the web page and get data, in case of multiple form
Upon Duplicate - open the Edit form for the new record
When duplicating a record, the user has a very hard time knowing which one is the new duplicate, making it too easy to continue from there with the *original* record, assuming it is the new duplicate. Also: I'm able to duplicate a record multiple times where there is a name field that is both mandatory and unique. The records sit in the list with a blank name! Yet the UI would never have allowed their posting. To improve this: Upon Duplicate: always open the new record for Edit. Or at least
Add person capable of making changes
I want to add a person who will have the capability of making changes to the database, while keeping the general public only able to view and print. Did it once, but can't find that section of Creator now. I want that person to have same ability to change as I do.
Update records using Function
Hi, I am trying to create a function that will update the respective fields when it meets the respective criteria . see below form screenshot , there you can see the Coverage-01 and Coverage-02 are blank. I want to input "Full" in the coverage fields if respective MVPD fields is not null. like - for station : TV1 , the MVPD-01 is not blank so Coverage-01 field should be updated by "Full" but Coverage-02 should be blank since MVPD-02 is blank. I was trying to use below Script but not working **********************************************
Ingreso de fecha desde zoho creator app iphone, (error en formato)
Desarrolle una forma para ingresar información, en donde el dato de fecha es importante, no permite el registro desde la app de zoho creator en el iphone, inicialmente se capturaba sin problemas, ahora esta generando este error con varios usuarios.
other not working in drop down
Hi, I have added the other option for some of the drop down fields in the form. They all show in the report view except in the case of 'spread sheet view' but while I export the data none of them are shown in the exported data. Am I missing something ?.
'clear' can be used only in on load actions (deluge error message)
But In the following page: https://www.zoho.com/creator/help/fields/add-to-picklist-dynamically.html you say: Example Below is an example code that can be specified in the On User Input action of a subform picklist field. list = Product [Category == row.Category] sort by Product_Code ; clear row.Items; row.Items:UI.append(itemlist.Product_Code.getall())
pdf page 2 print view won't print
In the Zoho creator program we made, we recently added a second page to our print view, but it won't print. Now says loading on page one and will not download page two to print. Zoho support was unable to fix this issue and i am extremely frustrated. Any advice would be greatly appreciated.
Page with embedded form requesting login but shouldn't...any workaround?
Hi All, I have a form embedded in a page using the script builder embed form gizmo: <div style='border:2px solid rgb(125,186,0); margin:4px;' elName='zc-component' formLinkName='DataEntry' params='zc_Header=false&zc_SubmitVal=Next&zc_ResetVal=Reset'>Loading Form...</div> Accessing the page via its permalink, I am asked to log in in order to see the contents of the form. How do I get the form in there without login request? Do I have to scrap the Embed format and insert the public access
Finding out the logged in user's role and/or profile from within Deluge Script
is there any easy way to determine the role and/or profile of a user that is currently logged in, in a similar manner as we can find the zoho.loginuserid - can the role and profile of the user be retrieved in deluge script at all ? thanks in advance, Jennine
Form Actions > Validate > Uploded File Missing
Hello, Since I cannot set hidden filelds as Mandatory, the only option I have is to "Notify on Validation". How can i write this on the Workflow? I need to write that: if field1 is "Yes" then field2 must contain an uploaded file how do i write this? Thanks, Tor Vergata University
Adjust editing in report
Hello, Can I change the order of the edit options in a report: Edit Delete Duplicate Print View record See attachments for a print screen. Greatings, Erwin
Unblock outgoing mail please
Please can you unblock outgoing mail for account questionario@bcc8453.it ?
choose first 4 characters in a string
How do I choose first 4 characters in a string please
Column Menu hide help
Hi On a file view there is a menu that has Sort Group and Hide Column When in the view I hide 3 columns that I don't want to see in the view but want access to when I edit the record. When that page is refreshed the view unhides itself. How can I set it so a column hides perminately. Thanks
ZOHO SMTP Servers
My application's emails are being blocked by our email filtering service. My IT department wants to know what IP address or range to add as a filtering exception to allow email from Zoho's SMTP servers. So far, the only one I can see from email headers is 72.5.230.66 and 72.5.230.67 Are there any others?
addMonth Built-In function in a formula field return an error message in the form
Bonjour and thanks for your reply. I setup a formula field adding a number of month to a date field. The Expression in the formula field ("TermDate") is : Date.addMonth(Periode) Where "Date" is a date field in the form and "Periode" is a numeric field in the form The formula field work great but after a moment, before finishing the input of the record in the form an error message popup tellng : "Invalid value found Field Name : TermDate" Anyone to explain me what I did wrong ?
Help with some coding Please
Hi and I hope you can help OK here is what I want to do... I have 2 fields for this task 1 is Post Code (Simple Field) 1 is Agent (Drop down box) In the Agents section it lists what post codes the agents can cover When I input a post code into the post code field I only want the agents that cover that post code to appear in the drop down field for the agent. Hope this makes sense. Nigel
Next Page