Data validation check
In my creator database, I have two fields, one is today's date and the other is a delivery date. Many times people are entering the wrong date into the delivery date. I need to have some sort of date verification check to make sure at the very least the delivery date is later that today's date. Must be possible but how? Many thanks!
Feature Request: fetch record and select field to display within formula field
Hello, I have a table containing cities, one per line (e.g. 'Chennai'). This table has a column refering the country that the city belongs to (e.g. 'India'). I would like to create a formula field that displays 'Chennai, India', to be used in dropdown list. The reason I want to display the country along the city is because it exists two cities having same name but in different countries. Unfortunately, referring the 'country' column in the formula field will not give 'India' but the ID of 'India'
Embed web form
What are the steps to embed the web form on my website? Thanks
Error message <There is no such form in Zoho Creator>
have embed the form to blog, but it returns with error : <There is no such form in Zoho Creator> webpage (where the form is embed) : vezejubankas.blogspot.com Form's direct link : https://creator.zoho.com/vezejubankas/u-klausa/form-perma/U_klausa/ What I already checked: 1. code is correctly embed 2. direct link works fine Please, any advice? Thank you
Cannot share forms or reports
I am trying to share an application with one other user. I've shared several sections and forms with the user. The user sees the application on the home page, but when clicked on it says the user doesn't have access to the application. Please help, Joe
Left Expression is of type string in lookup
After reading a number of posts, I understand the issue that my lookup is returning an integer and my initial data is a string. I've tried following the advice in the one of the forums and creating a variable to convert my lookup iD to the correct field. But I get an error message now on the variable. If the two elements were strings my code would look like: Email == input.Employee meaning that the field from form Ticket_Entry would perform a look on the field employee in form Employee. Of course
user denied
I just today started my paid service with ZOHO creator, but already had my application and user access set up and working correctly. After my first monthly payment went through my 6 other users were unable to access the application I created. While they are able to log into their created Zoho accounts, they can no longer view the application I have shared with them. They get a access denied screen that asks them to try to log in using another account or go back to their home page. I have tried calling
Using Deluge variables in data stored inside zoho creator forms
Hi I am building an error handling mechanism for an application. i want to store the error codes, error names and error messages in a creator table and send back the data requested according to the error code called for. in some errors, for example when a variable sent has an illegal content - Example: Document type can be: 10,11,12 user sent the value 13 for a Document type. In addition to the hard coded message stored in the table, i want to include some dynamic value, in this case the value the
Image map in form?
Hi - noob here, is it possible to insert a clickable image map in a form?
Creator Background Image
How can i change the background like this?
Ordering Sections in Android App
The Sections (Tabs) are ordered alphabetically in the Android App, while the Sections are ordered as defined in Settings -> Sections. Seems to me the Android App should also order Sections as defined. Can we either change the Android App to respect the defined order or have the option to go either way? Thanks, Joe
change of workspace
Hi, Please can you change my workspace from motorinspections to intelligentautomotive please Also.... I want to put a picture in the notes field when a user accesses my workspace, but can only find the ability for text? Can you please advise asap. Kind regards
Sort rows in a subform with display numbers
Dear All, Lets say that I have a subform with two fields like Description and Display Number. I would like when I click submit to sort the list with the Display numbers which I gave. example The first will be Guide Excursion... The second Bus transfer...Land People The third Bus Transfer...Thessaloniki Each time when I give the display Number then to sort them. How can i do that?
Printing on View Record page not working properly
I have embedded a published report table on my website and created a template for "View Record." On the "View Record" page when I click the print button it redirects me to a zoho login page for my app. This is unacceptable for my workflow. Please let me know if there is something I can do.
UK Data - location of servers and data protection legislation
Hi there. I need to understand where the servers for Zoho Creator are located. I'm in the UK, and would like to use Creator for a series of databases. The UK's data protection legislation puts limits on the 'export' of personal data to countries outside the European Economic Area. If for example data is hosted in the USA, then I need to be able to demonstrate that I have explored the data security and privacy protection protocols that apply, and that they will not contravene the UK's legislation.
Can't delete field
I created two lookup fields (Introducing_Player and Introducing_Scout) in my form 'Search Profile'. Right afterwards I realized that I had done this in the wrong form and wanted to delete them. But the tools will not let me delete them as they are supposedly referred in script, which they are not. You have edit access to my app (I only have one). Regards, Filip
Email Notification Multi-Step
I have a multiple step form, that requires email notifications at different steps in the process. How do I do this? Example: In my Human Resources Time Off Request form, the employee must first fill out a time off request. After the employee completes his section, the form should notify the employee's manager via email (with the record). The manager goes in and approves or rejects the request. The form should then notify the office manager via email (with the record), that a request for time
Can I populate one form with data from the database?
Can I prepopulate one form with data that has been previously entered? I understand the 'lookup' field and to use it to connect one form to another. I'm wondering if I can create a script action that looks up data based on a user-provided selection from 'lookup'? dono2081
Dynamic Picklist
I was wondering what I have to do to my dynamic picklist so that if value "a" is present multiple times for it to only show in the pick list once script: Product = Add_Product [ID != input.ID]sort by product_type; select_product:ui.add(Product.product_type.getall());
adding form data via sms
is it yet possible to add form data via sms?
Value Total taken from SubForms
I have a question about getting a Total Value for the order based on grabbing data from sub Forms. We have a large input file which contains a new Report for each Activity within a Job creating a large disjointed data base. From that large IMPORT file we are then pushing certain information from that Import file into separate more specific forms. I have one form right now that is called Work Order. In Work Order there is the SubForm Jobs. A Work Order can contain 1-infinite amounts of Jobs that
Change current workspace
Hi Can you please change my current workspaces http://creator.zoho.com/workspace/educared.ec to http://creator.zoho.com/workspace/fundaciontelefec Thanks
How to setup multiple options, each with unique cost?
I am looking to create a form where a customer can select one of more options from a list of services. Each time they select the option, I would like the cost of that option to added to the total. Each option has a unique cost. I would like to create an option, give it a name, description and a cost. Is this possible in Zoho Forms? Possible to have someone create a custom form to start with, that we can add to? Thanks in advance for your expertise. I am not a software developer, just a casual forms
View Entire Record
When I choose view record I get just the fields that are in that current report. Is there a way to show all of the fields? Or define which fields to show?
Populate Checklist with fields from different form
Not sure if this or possible but would make life so much easier. Form A has 100 different fields. 1 Field ( lead_type) will be a lookup field to form B Form B has just a few with one of them being a check box listing all the fields from form A. In form B we will check the fields we want to appear for the different lead types ( based upon the look up) Then show or hide them accordingly . Now can i do this as an array of some type or will i have to do code for each leadtype i add I want to be able
Adding fields from two forms to an html page
Hi, I have a very simple html test page that works fine when only calling from one form, but I cannot figure out how to add field values from another related form to this table. Can I just modify the parameter "<%for each rec in testzoho" to include another form called testzoho2?? The page below works for the first two fields that are in my testzoho form, but I am trying to figure out how to add 'newfield1' and 'newfield2' that exist in a form called 'testzoho2' to the table. I know html and
Default image size in Email
I want to send an email with images from a URL box, and I want to define a size, example 141 x 141 What is the code that allows me to have a specific size? I have tried normal html codes but not funcionana or get error: http://mx.tuhistory.com/files/escapebacteria.jpg" width="141" alt="" />
Please Wait problem came back
Previously working code is now hanging with the Please Wait screen that never goes away. I submitted the problem to Support but maybe someone has experienced the same issue. Some words of wisdom would be greatly appreciated. Thanks in advance, Henry
Picking up openurl parameters from the stateless form I have opened
Not sure if I have phrased that correctly so apologies if I have. I have a report for a Call Centre which list outstanding referrals to follow up. The referrals are entered via a comprehensive form previous to the Call Centre seeing them. The Call Centre Report only shows limited details of the referral (due to confidentiality) but they do need to update certain fields in the referral record. So I have create the report for the CC and a custom action which now successfully opens the correct record
Over 200 Fields
Hi and I hope you can help. I have mastered the basics of form building and basic deluge script writing. Actually I am quite pleased with myself for what I have achieved so far so thank you to Zoho for this fantastic bit of kit they have developed. Now this project is blowing my mind. I have a client who wants me to create a database that would be an ongoing development plan. Here is my problem. we need nearly 250 fields to make the project work. Now I know the maximum in 1 project as long as they
Feature Request - enhanced "Role" outline view
Under "Users and Permissoins", in the "Roles" outline, please consider adding under each role, a row for each User and their Profile. With many roles, a complex outline, and many users --this will be a BIG help in understanding the picture. Perhaps make it optional. (Currently we have to click each role to get a page that shows its users.) Thank you! CEO UserName - ProfileName UserName - ProfileName MANAGER
Multiple reports. one big one sending information to smaller ones
When i import an xlsx table it only goes into the table im importing to. what i want to be able to da is import to the main report and from there the information is linked to smaller reports big report contains: Item nr Product Name Active ingredient ATC Code Formulation Strength Type of pack Pack size MA holder License (EMA or National) Country Price (Native currency) Price (Euro) where the smaller ones only contains one of each element for the lookup field option. and maybe the option
Trying to sign up for : Zoho Creator Developer Program
I tried signing up for the Zoho Creator Developer Program. I got an email instantly with a payment link . But the link does not work. Is the program still active?
Lookup value in script
I have a lookup form STATUSES: ID STATUS NOTES NAME 21677000001558756 301 SENT NOTE TO USER; WAITING FOR FEEDBACK TO TAKE NEXT ACTION ITEM. PENDING USER FEEDBACK This form is used as a lookup column in MAIN_FORM1. Whild creating a Deluge script in referring to the STATUSES form, using the STATUS lookup field: for each r in MAIN_FORM1 [STATUS == 301] { r.STATUS = 305; } In this case, shall I use for each r in MAIN_FORM1 [STATUS == 301] or for each r in MAIN_FORM1 [STATUS == 21677000001558756]
Automatically create PDF
Hi, I am trying to automatically generate a PDF of a Custom Record. Ive created a custom record to generate a pseudo Purchase order form. I can download the pdf manually but I am looking for automation in workflow. Basically, one will fill out the requisite form ive created (step 1). Once its filled out, it will automatically send emails to appropriate people to update the approval status. When this approval status is updated to "approved"(Step 2) . I want to automatically create a PDF of the Custom
How to create a Form with a variable number of fields?
I want to create a form where the number of fields can be specified by the user. For example, I want a form to ask how many children I have. After telling the form I have 3 children, the form should present three fields to collect their names. Is this possible?
Changing report window size in a pivot report
When I generate a pivot report in Zoho creator and then click on a value I get a new zoho reports window of a fixed size. Is it possible to make this window larger or smaller? Chris
Dropdown values
Dear Coleagues, I am new user of ZOHO (just started today). May you share ideas how to make such thing. I have 2 forms: Customers and Products. In the third form "Problem report" I need to enter Customer name from Customer form (I used lookup) and Product name (I use dropdown). Product name dropdown list should contain products names which choosed customer has. May you explain how to do that? Thank you! Evaldas
Pivot Table Criteria?
Hello, How can I display a Pivot Table data based on the zoho.loginuserid? I know I can do that applying a criteria in a List report but I don't know how to do it in a pivot Table report. Thanks a lot!
Adding records using REST API gives error
When I make the following request I get error code 2899 response with the xml file. I have shared the application and have obtained a valid api key from the server. Any idea what the problem could be? <?xml version="1.0" encoding="UTF-8"?> <form method="POST" action="https://creator.zoho.com/api/xml/sensor-test/form/temp_and_time/record/add/"> <input type="hidden" name ="apikey" id="apikey" value="MY-API-KEY"> <input type="hidden" name ="scope" id="scope" value="creatorapi"> <input type="text" name="humidity"
Next Page