Using my own domain to display pages
Can some please direct me to information or explain if there is a way to display a "HTML Page" under mydomain.com/ Thanks
Need help for stateless form
I am currently want to learn how stateless form work. I look at the instruction zoho provide but I don't understand and could not make it work. I am new to Zoho and programming. could any one help me make it work please? Currently there is no error but when I pick the list, the name field is not pulling the name in to the field box I am welcome any example that could help my understanding such as example application or explanation of the code. Thank you
Login System with Master Admin, admin and users
My question is quite general and i would like your suggestions. It is not about technical problems etc. Well, as we know, customer portal has limitations (unfortunately, we can have the same permissions to all the users) my question is as below: Is there any way to create manual a login system with Master Admin, Admin and users? Let's say an example. We have 3 hotels (A, B, C) which are parts of a main hotel (D). We would like each hotel (A, B, C) to have separate users (login for each user). Each
Open URL function and invoking "on user input"
I have a view with buttons next to each record. When you press the button, a form opens up and a couple lookup fields are populated. Then the "on user input" action are invoked and additional fields are populated. I made one change...instead of open "popup" now I open in "same window" and the "on user input actions are no longer invoked. It appears that opening a "popup" and pre-populating fields will invoke "on user input" actions for those fields that are populated, however, when opening in
Customer Portal
I'm evaluating whether Zoho Creator is the right tool to implement an application that I need. The application is a booking/payment system for a mobile car wash company. There are many vans, going around to many buildings and washing residents' cars on-demand. Here are some of the requirements: 1) database storing all buildings, customers and all their respective cars 2) schedule of which vans are going to which building and when 3) secure login system for customers to register, store/edit all their
Issue in assigning the value to a field on User Input
I try to create the Sales Order form in creator. I've created two forms named "Order Form" & "Order Line Item". "Order Form" has the sub form "Order Line Item". In "Order Line Item" form, I've two fields named "Products" & "Unit Price". "Products" is zoho CRM field for Products module & "Unit Price" is float type. I tried to assign the "Unit Price" while selecting "Products". I wrote the following script on Field Actions --> Products --> On User Input Script: row.Unit_Price = 10000.0; When I running
CSV Imports & Relations
We need to import data stored in CSV into Zoho Creator, and have built into Zoho Creator multi-form relationships. How do we get that to work? For example, we have a form for adding Employees, and a form for adding Companies. The Employee form has you select a Company from a drop down that links to Companies. Then, we have a CSV file of Employees, with a "Company" column that lists the company as a string. How do we import that CSV file into the Employees database in Zoho Creator to where it will
Changing Import Data field from type Radio Buttons to Drop Down list
Dear ZOHO, I have an Import Data field in my form and it is displayed as a Radion Button control. However, I want to change it to a Drop Down list display. In the editor, I does not seem to be possible to change the diplay type. Do I really have to define this field all over again? This would be very cumbersome and difficult. Is there a way to change this more easily? Thanks in advance. Silvester
Include Parent Table Fields in DropDown Form
I know there must be an easy answer to this: I have 3 tables with the following fields: Customers - Fields(First_Name, Last_Name, Phone) Jobs - Fields(CustomerID, Job Name) Billings - Fields(JobID, BillingAmount) The relationships are one customer to many jobs and one job to many billings. When I enter a billing entry, there is a dropdown for Jobs to select the JobID and the values that can be shown are limited to the fields in the Jobs table. Is there a way to include fields from
Make hidden fields "required"
Hi I would like to make a hidden field "required", but only when it is visible (the field is visible when a specific value is selected in adropdown. Can this be done? BR Skouboe
Convert decimal to big int in .addDay() function
I am trying to use the .addDay() function but the number of days will be determined by a calculation using several date fields. I'm getting the following error and don't know how to avoid it. Mismatch data type for function addDay at argument index 1 expected data type BIGINT found dataType DECIMAL The code I'm using is as follows: request.Date = request.Date.addDay(((request.End_Date - request.Start_Date) / (1000 * 60 * 60 * 24))); I know there is a function to change a big to decimal but
How to get GetURL variable and pass it to another form?
I have a form that is filtered using a url variable. Example: ..//#Form:Income?invoice=123 When I click the "make payment" button from mu invoice page. The user will be redirected to another payment page and the payment page will inherit the selected invoice ID (in this case is 123). How should I code this in my "make payment" page?
Creator reports restrict access by user ids
Here is what Im trying to do. I want to show records of my report only to selected users, in my case I have many Hotels and I want users to see records only for their own Hotel. Here is how Im doing this: Im creating certain groups of users by creating a form User_IDs which holds "hotel_id" and an Email (which is zoho.loginuserid) , so each logged in user belongs to a "hotel_id". In my Hotel_Details form I have a lookup field hotel_id, so I want to show records only if zoho.loginuserid in form User_IDs
Email notification
Hi I have an online form which, when submitted, sends an email notification to specified people when certain fields are populated. When those fields are not populated, it still enters the details on the calendar view, which is fine, that's how I want it to be. However, now, all of a sudden, ALL submitted forms are being emailed, regardless of whether or not those fields are populated. I have changed nothing in the settings so why is this suddenly happening? It's so annoying when you change things
Easy way to remove Microsoft Word formatting from rich text fields?
When I export my data from Creator into Excel, I notice that the rich text form fields contain a lot of unnecessary Microsoft Word formatting code embedded - such as... <!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility>
Creator removing final zero in decimal field displayed on a page.
Im having a display issue when I am showing decimal fields from a form on a page. Creator is removing the last 0 in the number. The problem is that my decimal fields are set to 2 decimal points but they display with the wrong number of decimal points. I want the number to display as follows: 45.00 or 45.50 or 45.20 Trouble is they display as follows instead: : 45.0 or 45.5 or 45.2 Creator is cutting off the last 0. I want this zero to display. How can i get the zero to show? My page uses the following
printing help please
Ok Hi, I have the following conditions PDF file on external site that I want to print Page view for staff Name Tel No File to print (which is the pdf file) I use a script to populate the "file to print" field Looks like this https://drive.google.com/a/signedfast.co.uk/#folders/0B8WoWXP12Cw0TTR3ZHUyejZQcmM/" + input.Job_Code + ".pdf" When the page is viewed the link is underlined and clickable but is does not print the PDF file. What am I missing please. Thanks NIgel
Linking ZOHO Creator to ZOHO Reports -can we link Creator to ZOHO Reports?
We have been using ZOHO Reports extensively for the past two years. We are thinking about using ZOHO Creator to create forms so employees can update the data in ZOHO Reports directly from Creator forms. Is this possible? I am seeing that we can import CSV/XLS and Access data but I have not found anywhere that states we can link a new Creator form to an existing ZOHO Reports databases. Is it possible? Also using Creator forms can we add, edit, and delete data from ZOHO Reports? Michael Kokernak
Customer Portal
My agency has multiple applications that team members need to access. How do they get access to all six at the same time as opposed to having to enter multiple portals separately? We have granted them permission to use all applications and sent out email invites. Now each of them has several usernames and have been required to set passwords for each portal. Most of them don't work and now everyone's confused yet few people have access. How best to proceed with this? Also, we have deleted some applications
URL field help
Why does this script not populate a URL field please Thanks input.Print_File = "https://drive.google.com/a/signedfast.co.uk/#folders/0B8WoWXP12Cw0TTR3ZHUyejZQcmM/" + input.Scan_Code; Print_File being the URL field
Restore Data
Hi Zoho team, Can someone please assist to restore the deleted records? I accidentally deleted records which have "Date Filed" for April. Appreciate if someone can help immediately please. Regards, Maricar
Zoho creator on mobile site
Hi. Can anyone tell me why the mobile version of the form loads with the drop down lookup fields like this and if there is a fix for this?
Close a form on submit
Is there are way to close a form on submit? What code do I need to put on "On-Success"?
how to use aggregate functions in a subform context
I would like to use the "sum" function in a subform script as follows: On User Input (for a subform field): input.Total = rows.sum(Item_Amount); This doesn't work at present. Any suggestions? Will this be implemented in future? Anton
Importing Data from Google Spreadsheet Using Deluge Script
Good day to you, I would like to be able to import data from Google Spreadsheet using Deluge script. Is this possible? I'm able to publish a spreadsheet to the web and is gives me a url like the following: "https://docs.google.com/a/mydomain.com/spreadsheet/pub?key=0.............&output=html" Any help would be appreciated.
Fetch data from another app and use in a formula
Hi, I have a app named "skills". I also have a app named "age". At least I have a app named "pointer". In pointer I made two lookups.One from app Skills and another from app Age. What I need is make a formula who combine the field value "specialist" in Skills, the field value "age" and combine in a formula in pointer - input.profile = input.skills + "" + "\" + " " + input.age. The input.skills are from app skills. The other is from another app. I can't use the default value for the fields (the
How to use Map() and postURL()
I have read the ZOHO Creator help guide and attempted to make a form post to an external application and failed miserably. I think it's me not being calibrated on how all the parts fit together. For the reference, the api is from SmarterMail . I'm just going to be lazy and post the form info below and hope someone with a better brain can help The form target to post to is http://xxxxxxxxxx.org/Services/svcMailListAdmin.asmx/AddSubscriber The form fields are all text: AuthUserName AuthPassword DomainName
autofill a field, based on a lookup drop-down list
active form is <test> in <test> there is a lookup field <Item_Num> which is a dropdown lookup field to autopopulate in <test> is called <Item Description> which is just defined as a text field lookup form is <Item_Master> this form has field <Item> that is used to link the two forms meaning <Item_Master.Item> is linked to <Test.ItemNum> In <test> in the field <ItemNum> under the "On User Input" section I have the following script: [note that I am new to script so am I missing headers, "{" or other
Cancel Submit on a Stateless Form
I know the cancel submit function is only valid on a non-stateless form to be added during the validation action, but what i'm looking for is exactly the same function on the stateless form, does anyone know if there's another function out there that can accomplish the same?
Auto Fill selections from list
I have two forms, one for Product information and one for Supplier information. The Product information for has a supplier list linked to the supplier information form, and the Supplier information form has a products list linked to the Product Information Form. Is there any way to have the list auto-select/fill the products name from the Product Information form when I select the corresponding Supplier Name in the list from the Product Information form?
TFA - Deactivate for my users
Since you launched this TFA, my users are unable to create and activate their accounts AND use my application. Why did you do this for all users? You are risking my business which depends on user acceptance. AND you didnt do the TFA in Portuguese!! That s beyond belief. How can you expect people to sign up if they dont understand English? Do you think everyone speaks English in the planet? I can help you doing the TFA translation to Portuguese - but please give me the option to deactivate it for
Usage Limits report is badly broken.
Usage limits as seen from at: https://creator.zoho.com/dashboard#usagelimit is badly broken. The used and remaining measures have apparently swapped. What's worse is that cleaning up data is actually decrementing this 'new' used count. Please take a look at this urgently! -Varun.
Usernames and Emails
Zoho has been busy lately changing some of the authentication processes. The sign-in form in Creator now requests the user's email, although the username also works. I'm happy with this because in the past people forgot their usernames and complained. Since we are moving away from usernames*, it seems confusing that after sign-in the application shows the username and not the email. My suggestions is simple: show the sign-out with the email. *Usernames are now autogenerated by Zoho Accounts and are
Multicheck boxes and subform
Hi, I create a POS for Pizza and i have the follow problem to fix: I create a form that include a subform to choose the product and a second subform with multiply checkboxes that you can choose the extras. For example you can choose: PIZZA MARGARITA and in Extras you can choose EXTRA HAM +0,20$, EXTRA CHEESE +0,40$ etc.... All records works well but my problem is how i can fetch the prices for calculate the total. Right now i try to fetch by: row.TIMH_EXTRA_SUB = EXTRAS[ID == row.EXTRAS].MASTER_TIMH_EXTRA.toDecimal();
Second set of Leads
How can I set up leads for future use by creating a separate category of leads?
How to add to a date but not add time?
I have a field called Checkout_date that has a date without showing a time (i.e. 1-01-2011) I have a Due_Date field that has the following formula Checkout_date.addMonth(4) The result that gives me is 5-01-2011 02:00:00 How can I make it so it doesn't show or doesn't ever include the time, only the date?
Option to have user "add" another group of fields?
I am wondering if there is a way to have the user be able to click to "add" another group of fields. Example: A group of 3 fields for them to fill out: Traveler Name Transportation Notes Then, the user could click "add" and the same three fields would show up again. So they could add (in theory) an unlimited amount of travelers in their group, but each would be individually entered. Does that make sense? Thanks for any help!
Combine Pivot tables to form a single report
Hi, I have the need to combine two pivot tables in Zoho Creator. The pivot table report s are generated from the same Zoho table(Assignments). Pivot Table 1 is a summery of all tasks and income generated in a month. Pivot Table 2 shows the same data presented in more detailed way. Pivot Table two show a weekly breakdown of task and total income generated from those tasks. I would like to combine those two pvot tables to form a single report with the summery report at the top and the more detailed
Multiple records update with zoho api
i have a requirement of updating my zoho records from my website through api. is there a way to update the zoho form records throgh an api of my web app.
Inventory Form Question
I've made an inventory form to receive inventory items and set up initial item quantities. i.e. starting inventory = 1,000 widgets. But I need help creating a new form to enter daily sales and have those sales reduce inventory quantities. i.e. today's sales are 100 so the new total quantity needs to be changed to 900.
Next Page