More ADMIN users
How can I asign ADMIN privileges to more than 1 user in Zoho Creator? Thanks
create a picklist based on criteria, how to setup the formula?
In Form Class, the field linked to For Student is a multiple select lookup In Form Student there are fields First_Name, Last_Name I have another form, called StudentInfo Field: Student (picklist to Form Student) Field: Class (picklist to Form Class) But I only want to load Class that are linked to that particular student chosen. Consider example: Student: Name: Jane Doe Student Name: John Doe Class Class Title: Science Students: Jane Doe, John Doe Class Title: Math Students: John Doe In my Form StudentInfo
"Duplicate Application" function not working for one of my applications
I contacted support, they could replicate the error. But I haven't received any confirmation and don't remember if they gave me any kind of support ticket number or anything of the like. My application is available for support to access. What would be reasons, for application not duplicating?
What is the proper code indentation convention in HTML pages?
I'm finding it confusing to read code with both <% type tags with zoho script code. For instance how would you tag and indent a block of code for each, which fills in cells of a table? What if you have nested loops? <% for each i in IForm { %> <%for each j in JForm { %> <%=j.data %><% }}%>So maybe its not so so confusing with this simple dummy text, but then the editor automatically does some corrections of its own and spaces things like crazy, so what rule is it following?
Criteria Help!
Hi- I am looking to restrict the number of entries in a lookup field in my form and need to specify the deluge criteria. I'm stuck! I currently have two fields I want to restrict with the return of records: "status" field and "discharge_date" field. I want the criteria to return only records that are either "active" status or have a discharge date within seven days of the current date. Can someone help me with the correct criteria to use? Thanks, Troy
Make public to all visitors over the web??
Hello! What pricing tier do I need to enable this radio button?? "Make public to all visitors over the web (Upgrade to use this option) " Is there anyway this can be purchased as an "Add-on"?? Thanks, any advice would be great!
Linking Creator Form to Report
I've found a lot of support for older versions of Creator but haven't found step-by-step instructions for the following using the new application builder: I need to link a Zoho Creator form to an already existing report in Zoho Reports. In addition, how do I deal with a multi-select field from Creator in Reports? Thank you in advance. Adina
Importing incorrectly triggers "length of field" error for related field
Issue: Form has a lookup field to another form When importing, Creator occasionally--and incorrectly--indicates imported value for this field is too long Workaround is to rename value to something very short, import, then change the name back Example: One form called "Restaurant Types" with value "Fast food restaurants" One form called "Restaurants" with fields "Name" and "Restaurant Type," the latter referencing the "Restaurant Types" form CSV import attempted for "Restaurants" with record having
Script for "Today and prior"
If anyone can provide this, I'd appreciate it very much.
Auto add records
Hi I would like to create a new record in a form & then when submitting it automatically create a number of new records in a second form based on a number in the first form. I have a "Print" & then a number of "editions" of that print so that when I add the "Print" details I would like to create an edition record for each number of the "edition". How would I do that ? Thanks Derek
Currency VND
Hi, I used currency VND but your software display it as ZNK??? What is the problem?
Sub-forms and PayPal
Hello! We want to use Creator to capture registrations and bill for that registration(s). I have a primary form where the parent or guardian enters their information AND they are able to submit a donation of any amount if they choose. That Creator passes to PayPal. However on the sub-form where they are then registering their children (at a price of $10 per record/registration) which I have setup as hidden fields (the item, cost, quantity), after hitting Submit it's only passing the donation amount,
Sub-Forms of Sub-Forms?
Hi I've checked all sub-forms but I couldn't find an answer. My form X can draw a "single line" info from Table 1. My form can not draw a "subform" info from Table 1 (or any table). Does that mean that only single lines but NOT sub forms can be accessed via look up? Thanks Ben
How to restrict users to access a record in the table
I am making family/individual management application. I want all users to login to add/edit their family/individual records, but they should not see others' information. Adminstrator group, on the other hand, should have a full access to those people's information. I am new to Zoho creator. Is it technically possible to do with Zoho Creator?
form layout in html view
Is there anyway to drastically change the layout of a form in an HTML view? I'd love to be able to use my own styling and put the fields where i want them to go - I have a rather lengthy list of data, and I would much rather be able to arrange it as I see fit across the page, instead of a long list down the page. Any ideas?
Using our own domain name for our Zoho App
We are using Zoho Creator Professional Plus. Could we use our own domain name instead of the <creator host> (https://creator.zoho.com/) part in the URL, for our Zoho App? i.e.: https://creator.zoho.com/my_username/my_app to https://my_domain.com/my_username/my_app
100K records - what if you want more?
Hello all, very newbie question I am sure. I currently work as a project manager for 2 different companies implementing a 3rd party management suite for finance, supply chain, property management and tenancy. I was looking for an alternative "approach" and being a long time user of zoho in its other flavours, I thought I would see what it could do here. How is a record define? Is it just a row in a table? what if you need more than 100K? can a record be split across multiple tables and count as
Script doesn't update
I am trying to modify a user defined function that I have called udf_ccc.get_ccc. After I make my changes, I get an endless "Updating Script..." message. The function would not update and I would close it after 5-10 minutes. As a test, I added the following code test_variable = 0; The first time I saved the script, I got a "null" message. I'm not sure what it means so I tried saving it again. The second time I saved the script, I get the "Updating Script..." message and it does not finish updating.
custom domain
Team Creator, I continue to be impressed with the quality of Creator and the patient, helpfulness of the support team. But the killer feature I have been waiting for over a year on is still a mystery. Can we please get some kind of concrete update on the future of being able to customize the domain of our apps? Many thanks.
Code for Form Being Ignored - Urgent!
Shared to support Form:Contact_Record Try to edit a record: The type option for student and parent is not working to show/hide field values App: buzzap/edirectory Cheers, John Whitney
Upload proble; Exportto different field names problem
Hi Zoho people In my new event app form some things dont work: ( I used new builder) (generally great by the way!) 1 Sub form > I have "name" field and "instrument" field. This data arrives on export as a long row of digits instead of words e.g. LINE UP : 1112234000000026029, 1112234000000026033 2 Uploads of images, PR docs: not appearing in exported file (images was small < 500k) In the sent email the FIELD NAMES for those do not appear either. 3 A problem using drop down font selection in
Schedule Email reminder for every 3 days based on Status
Hi All, Actually i want to create a schedule which sends reminder for every 3 days till status changes to other value. Please let me know if there is a way to achieve that method. kmkr :)
Setting privileges
I am restricting data access to views by using the filter Added User == zoho.loginuser. This works great to ensure that separate users do not see each other's records, however, I need the Admin to have access to ALL records from ALL users. How can I do this? Thanks.
large database support
Our database of consumer records is now pushing well past the 100,000 limit for Creator and I would expect it will continue to eventually grow into the range of several million. Has anybody worked out integration with SQL type service to manage the larger datasets while still being able to import/export in campaign sized groups of say 25,000 and be able to keep using the applications we've built with Creator? Malcolm.
Change row color in View when field is not null
Hi, I already found a post where it's shown how to color a particular entry. I actually need to change the color of each row in a view, when a particular field of that row is not null. Plz help! Thanks...
Urgently need help for execute event in Sheduler
Hi Akash I try many times for execute event in scheduler,but they all failed and I checked the email address is correct,the screen disply as bellow: Error details:Error in executing 房源状态图示 script(Custom Schedule). Error. Error in executing Send Mail task. InValid email Address Found. Thanks for your help Stanley Guo
Reply to: not functioning properly in new app builder
If I add a reply to: or change and existing one in the new app builder, I get an error when I save: zoho.sendmailtask.rpltonotallowed And a red box around the line. If I switch back to the classic app builder, it saves fine.
Refer Fields box should show the current form
Hey Zoho, it bugs me slightly that the Refer Fields box shows the most 'alphabetically superior' form rather than the current form. Could you change this? (See screenshot below)
Trying to add the resuts of formula fields - Help
I'm trying to make formula field, where I'd like to use variables from another formulas in this form. In result there is warning message, that "variable is not declared". I would like to add the sum of the formula fields to get a total cost. Thanks Ed
Create View showing records for Today and next 7 days
Hi, How would I accomplish creating a view that would display records that occure between Today and the Next 7 Days? This is waht I have, but it's not working. (Start_Date >= zoho.currentdate && (Start_Date >= (zoho.currentdate + '1W:0D:0H:0M:0S') && Start_Date > zoho.currentdate)) thank you.
Problem Restoring backup
While trying to restore a backup (and after changing the name of the application to "AppName backup" on line 6 I get another error about [Sub_View] column 'FORM_ID' cannot be null . No idea where this error occurs in the script or how to find it.
Cannot remove records from linked application
To help simplify the structure of my complicated application, I created a separate External Application to deal with a particular section. In the Main Application I used Sections and Pages that contain the forms of the External Application. They show up nicely, and I can input information. I also constructed a page containing all the views related to the external application to allow users to edit their entries. When I try to delete records from the External Application's database (via the Main
Calculating linked field
My application contains a form that uses linked fields to input information into the database as follows: Field A | --------> If Field A = x then Field B = y | --------> If Field B = y then Field C = z Field C is a percentage field in the original form and when used inputs the correct value in the linked form. So the data is correct. However, when I perform a Deluge calculation with the value using the value from
Remove Null
So I am using html view and I am inserting record variables into the view using the insert expressions tool. The problem I am having is that the drop down menus that have no data/value saved in them are returning "null" instead of just a blank white field. If a field does not have data i simply want it to be blank, not say "null". The worlds null all over my screen looks horrible. Is there a way that the dropdown menus do no return null if there is no data? The text fields seem to be working
Encode URL Question
I am populating a string field on a form via an email with some text from another system. I am then using a URL to open another form and default this data on that form. This works great EXCEPT when there are line feeds or other non-allowed characters in the initial string feed (e.g &). I have tried to use the encodeUrl function, but instead of converting the spaces in the string field to %20 (as I would expect) they are being converted to "+" and passed to the new form this way. Am I doing this
Duplicate Application Error
I am not able to duplicate an application in creator. I press duplicate, and the system says duplicating for a minute or so, but then no duplicate is ever made or displayed in the application list. Please help this is an urgent problem
Moving from easy database from Godaddy to Zoho
Hi there, I have been informed by godaddy that they are ceasing their support of the easy database system which I previously used. They recommended (on their website) that I re-start with Zoho. I am a bit of a novice with online databases but I was able to understand their system once I had a little assistance over the phone. I have looked online quite a lot to get some support on this however it seems that I cannot get through to their call centres which seem to be continually jammed and go to voicemail.
Add Buttons to non stateless form
I am requesting that you allow users to add Buttons on non stateless forms. At the moment it is not consistent because you can add them on stateless forms. I already have forms with complicated logic and I am not converting them to a stateless form. Can you please enable?
Issue with Sub-Form not linking properly
Hi there! I've created two views. Using this form: https://creator.zoho.com/reedmiller17/prisoner-profiles/#Page:Prisoner_Profiles Our volunteers can enter prisoner information, and then at the bottom, write a short letter to the prisoner. I have it set-up like a subform, so my expectation was that the prisoner's ID would show up in the Correspondence view: https://creator.zoho.com/reedmiller17/prisoner-correspondance/#View:Copy_of_Prisoner_Correspondance_View Similarly, under the Prisoner Profile
I need to link two forms together and make relationship!
I am needing to create a relationship between forms that will allow users to submit a form (embedded into website) that will populate data into another or have a view that can access both forms.
Next Page