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.
formatting strings in html reports
I couldn't find any built in function to format stings for currnecy For example a = 2.1; I want to display "$ 2.10" anything built in already for things like this? Has anyone wrong a function to do this already?
One entry per user / Date
Hi All , i have 15 fields , one of the fields has a Name Section and the other date , like the following: Name: Date: .. .. . i want to prevent double entries only when Name and Date are double. e.g. Name Date John 12-05-2013 John 13-05-2013 John 12-05-2013 this should be prevented thank you
I need help on a simple lookup problem
I do not know anything about coding so I am hoping there is an app or simple directions to do what I want to do. I just want to create an appointment process. I would like a form that I can add available appointments and a form that my student would use to select the appointment but once selected it would no longer be available for anyone else to select. Josh
Is this possible?
Hi all Would it be possible to call a creator form in the leads view ? What i would like to achieve is from with in the leads view call and calculate some values and the update the given fields without of having to call the creator form and searching for the lead and then submitting the creator form
SQL Querying between reports/views/tables on Zoho Creator
Hi Zoho! I would like to suggest integrating also the Query Tables from Zoho Reports into the Zoho Creator. I find it hard to produce an output whenever I use the "Lookup" fields in Zoho Creator. It just loads the Row ID without it's equivalent rows like description, etc. Customer Name is automatically loaded upon entering this form, but upon saving, I save the ID as reference. But when I create a report using this table/view, the Customer table is not included in the columns (Pivot table) unlike
Dropdown - filtering values conflicts with preset values
I have a form with a CUSTOMER dropdown lookup field and a SITE dropdown lookup field. The SITE lookup shows the SITE ID, SITE NAME and SITE ADDRESS. The SITE field has criteria CUSTOMER_ID == input.CUSTOMER_ID I have preset the form to the most common customer using the on load script. CUSTOMER_ID.Select("INT"); However,when I load the page, the SITE dropdown is empty even though CUSTOMER "INT" has SITES. If I change the CUSTOMER, then the SITE dropdown gets populated correctly. If I change back
How can I add a next button?
Hello! I want to add a new button which opens a form. How can I do it? Thank you
Script doesn't work in edit mode
Hi, I have an issue with the edit mode of a form. My form is loaded with a lot of scripts, both configured "on add" AND "on edit". It works fine, except in one case. I created a view to allow some people without login to edit some records. It's a search form, that opens a view with selected records through a "non login" link. In this view, users are allowed to edit records. The problem is there: in this specific case, the scripts doesn't work... Has anyone an idea ? Regards.
Zoho Creatot in Spanish, French, Chinese, Russian...
Hi, I need to translate our Zoho application to be used in Spanish, French, Chinese, Russian Languages... Any suggestions? There are actually 2 issues. One is the Zoho creator tools like sort, summary view, print, search, etc that are part of Zoho functionality that need to be translated and then there are the actual form fields and database that needs to be available in different options.
Can the user add additional fields as needed?
Hey all, What I would like to do is allow for multiples of select fields such as email adresses and phone numbers if needed. For example if someone has multiple email addresses you could fill in the first one then add an additional email address. It would be great if they could name the email with a tag of sorts like home, work etc. Is there a way to accomplish this? Thanks
Zoho is automatically guessing my domain name
I own multiple domains because I run a number of websites. One domain is attached to the email I used to sign up with and Zoho Creator seems to think I want to use that domain name for this account. Wrong! I want to use another domain name. I see no place to change the domain that you want to set up with the account. Help! Thank you!
Copy forms into another app
How do you copy a form or a section from one app into another app under the same account? Thanks, Antoine
URL Encoding Error
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
How to make a condition in zoho creator
How to create a condition for example I create a checklist field and then when I select no nothing will happen but when I am going to select the Yes button I want to display below the checklist which is a single line "How many" and in that i can be able to put a number on that. Please help me.. or contact me in skype i need an answer skype: srepoyo
UpperCase all text
My client wants all data in zoho to be stored in upper case. What is the easiest way to do this? There is already data in mixed case and there are over 30 forms.
Edit Subforms: Does not save data properly
I have a CUSTOMER form with a PROJECT subform. When I go to my CUSTOMER View and Edit customer 123, I see 2 project rows. The first row should contain agreement 12 & the second row should contain agreement 22. After I change the agreement value and click update, I go to the view PROJECT rows but it did not save properly. However, the PROJECT agreement for 1 row is blank and the other is correct. Before I submit Update: (Expected) After I click Update: (actual) Why is the data not saving properly?
Next Page