HTML view: Error when use Rich text mode
Hi, If I try to make ANY changes using the rich text mode in my HTML view it gives me the following error: Lexical error at line 1, column 12. Encountered: "\\" (92), after : "" It doesnt even let me shift to plain text mode after this. All I can do is press cancel - but then my changes are lost. Please help ASAP Thanks
View for a specified range of date
Can I display the record with a specified range of date as input value, for eg: I want to display all records between the Startdate and Enddate: please help me Thanks
I love zoho
I recently signed up for your services and have spent the last 2 solid weeks building my somewhat complicated database. I love how you can customize everything. Being able to put my own code in has been hugely advantageous and has made it so nobody can possibly screw up an entry. I guess all that programming I learnt at university that I thought I'd never use is finally paying off. Im sure I'll be using your services for many years to come. Great job!
Begginer looking for manual.
I am a developer with over 20 years experience. Am new to Zoho Creator and I am looking for a manual for beginners. Thanks to all
Birthday Emails
Hi All, im using the Schedules section to create a script that will automatically email clients on their birthdays with a short message. ive set it up as per the instructions in the help section but it isnt working. heres what my script looks like: When to do: Birthday Notification { Execute on Contact.Birthday at 18:30:00 yearly } What to do: sendmail ( To : input.Email_Id From : zoho.adminuserid Subject : "Happy Birthday" Message : "Dear " + input.First_Name
getUrl function doesn't work
Since 2 hours ago, the getUrl function fails and no web-data is fetched into a variable. I suppose it is a temporary problem of Zoho api... Has anyone checked it? Thank you.
Count the Number of Member expire in these month
Hi Team I have table of members which contains the Member Expiry date. Can you please help me how can find the number of member expire in these month. Thanks
Delete multiple records
Hello all, Please be patient with me as my experience with databases is very limited,and I am hoping there is a simple solution. In my application I have a form named "Controllers" in this form there are three fields "Serial Number", "Max Temp", and "Hours" I am trying to create a lookup function for the form named "Controllers" I want the function to lookup the "Serial Numbers" of all of the "Controllers" in the form and display them as selectable check boxes. (This Part I know how to do) I then
Fetch specific characters in a data string
Is there a way to fetch a specific character in a data from a form field? This is my situation: I have created a database of car plate numbers (i.e. ABC123, ARX899, etc) which we are managing. Now I wish to be able to fetch the last digit of the plate number and create an automatic email notification based on the last digit of the plate number: If the ending plate number is "1", then we shall receive an email on January 1 to alert that the car needs to be registered on January. If the ending plate
is zoho appropriate for my application?
Members of my org need to view one table of contact data on the web. No adding, deleting, editing, just viewing. I would refresh the data weekly. they will select records based on values they enter for any of 5 fields. once the recordset is retrieved, they need to view it on a nicely formatted form that they can move through easily to see one record after another. They would not be happy with a gridlike view analogous to a datasheet view in Access. Is Zoho appropriate for this application?
Set the criteria on the current month
Hi Team Can you please help me how I can show the members whose Membership is expire on this month. I have the field for Expiry Date. Thanks
Emails not sent
Suddenly Emails not being sent from production application
database in creator
ive just tried for the first time the DB and everything was fine until i decide to add a multi-choice to contry and county, but even i select, the creator add all fields less this ones. also, is there a open source DB with UK all conties? thanks, Carla,
OpenURL - filter by date
I have a form called 'expenses' with two date fields - startdate & enddate. I want to open the view 'expense_list' but restrict transactions between the startdate & enddate. Can you help with the syntax for this requirement? Thanks, Martyn
Sorting values in a lookup field
I've created a job db which uses job numbers. I have a number of forms that link to the job using the job number. I have set the look-up to sort, but in some forms it's not sorting as would expect - see example below: Job Numbers: J016 J007 J026 J019 J030 J998 J999 J040 and so on... Some forms do sort the job numbers correctly - any ideas? Martyn
error while duplicating application or importing application from a script
Hi, I was trying to make a copy of my application. It says "duplicating...please wait" and then nothing happens. So I tried to export the application as a script and then importing it again via create a new application. Initially it gave me the following errors: 1. If I had anything in quotes in the Notes field of the forms. Eg. Please type your name in "CAPS" It gave me an error on the quotes -- " So I removed the quotes from the Notes field 2. In one of the views I have added a sendmail function
If statement
I need to write the following: If(25 =>24,25-24) I will be creating many if statements and want to use the "easiest" script. Suggestions?
Increase the number of records
Number of records for free user should be increased to 1500 or 2000.
Edit Multiple Records
Well the support team at ZOHO answered my last question quickly, and in a way I could understand so here is a thank you before we get started. I have an application named PRT Collar Tracking, in this application I have a single form also named PRT Collar Tracking. In the form I have several fields for user input. The fields I am concerned with are Collar_Serial_Number, Trip_Hours, Circulating_off_Bottom_Hours, Sliding_Hours, Rotating_Hours, and Total_Hours. I need to be able to edit all of the [Trip_Hours,
Views not working properly in iPad
I am using mobile.zoho.com to access my app, and it works for the most part, except the Views are always showing as Summary no matter how they are configured. I need to view as a List or Grid so that I can use the search functionality to search for records. If you select More Actions > View As > List or Grid, the app just does nothing and remains in summary view. I tested in iPhone and it works as it should. I can see List or Grid. only the iPad does not work. I also tested using Opera mini and
Duplicate entry
I'm a newbie of zoho. I don't know how to delete duplicate in my entry in my look up field. Here is the sample: wood wood apple apple apple My look up field is connected to the my table "Products Sold". What I want is to delete the duplicate in my look up field. Another is in the view of my multi-select look up field. In the table connected to multi-select look-up field here is the sample: Nelson --- barangay A barangay B barangay C The above sample is correct
Add Record via REST API
I'm trying to add a new record to a form via the REST API. I am posting this: <input type="text" name="Title" value="test"> <input type="text" name="Aspect_Ratio" value="99"> to: http://creator.zoho.com/api/xml/copy-of-encode-details/Encode_2_Form/add/apikey=*****&ticket=**** I *'ed out the apikey and the ticket for obvious reasons. The only thing I ever get back is: An error has occured. It has been reported to Zoho Creator support. We will look into this issue . Sorry for the inconvenience caused.
get current url as an initial value?
Hi! I have used countless hour on one simple problem: Is it possible to get the current url as an initial value in a field of the form? I was hoping to have a costumized link on several pages with this format "example.com/zoho-form.html?page=last-page.html" to the form-page, and then have the form automatically detect from which page the request came from. My hope is that if you click on the link from "article-1.html", you'd get this in one of the fields in the form: "example.com/zoho-form.html?page=article-1.html"
Data relation of Lookup field broken
I have a Lookup field ('Import Data') called 'Player_Entity' (on form A), for which I limit the choices available in the 'On Load' event with the following code: //Limiting Entity field choices to player tempValue = input.Player_Entity; clear Player_Entity; Player_Entity:ui.add("Himself"); for each recPE in frmPlayer_Entity [Player_Name == input.Player] { Player_Entity:ui.add(recPE.Name); } Player_Entity.select(tempValue);As you can see in the code, there is a field called 'Player_Name' on the
Access for new update
The next update, which is scheduled for tomorrow, is available in http://precreator.zoho.com . You can test drive your applications and in case of any issues, please feel free to post them here. Change Log : 1. Look and Feel changes in Script tab 2. Edit mode menu items increased to 20 per column and 4 columns will be shown at a time. Regards, Charles
Zoho Creator Pricing - Adding Records
Is it possible to add records to a plan? Each plan has limited record limits. I wanted to know if it is possible to increase records without necessarily upgrading plans? Thank-you.
The code looks correct...
Can anyone tell me why this code isn't working as expected? //1. User Clicks Log Button. //2. Does ID Exist in Log? if (count(tblEventLog[intEventID == input.intEventID]) > 0) { /*2 - Yes 3. Open Log View.*/ openUrl("#View:vwEventLog?intEventID =" + input.intEventID + "", "popup window", "height=100,width=100"); } else { /*2 - No 4. Add Initial Record.*/ insert into tblEventLog [ Added_User = zoho.loginuser intEventID = input.intEventID strEventStatus
Can't find "On Success" FORM ACTIONS help________________________
I created a stateless form and want to "SendEmail" on success but I am not able to include "On Success" action on the right side of the Script Builder screen. I only see "On Load" "Add_this" and "On Click". How are "Form Actions" like On Success added so that I can then "SendEmail" "On Success"? Also, the form that created the table has at the bottom "on Add" and "on Edit". My stateless form doesn't have that. George www.yourbizzwizz.com
simple dialogs to an alert? like [OK] [Cancel] to continue with the script or abort it.
What about adding simple dialogs to an alert? like [OK] [Cancel] to continue with the script or abort it.
forms - if selected, show these and make required
hi, does anyone know if it is possible to create the following functionality in creator forms? - if this value is selected, show these hidden fields and make them required, otherwise hide these fields and make them NOT required - if this is selected, make the next 6 fields NOT required, otherwise, make the next 6 fields required i am considering purchasing if this type of validation is possible. thanks!
edit issue with users
I have added multiple users on my data base. My problem is that the way I set it up requires that my users are allowed to go back into each record and record information. This is considered editing in this app and only I am allowed to do this. How can I allow them to "edit" records? This is for a probation company and we see clients every month. We need to document each and every time that we speak to our clients. I do not want to be the only one that can do the data entry. The only solution that
Close an embedded form.
I am embedding a form in my website. When an employee is done enter data into the form, I need them to close it. Do you have a script for closing the dialogue window? Would I use a button to close the form?
String Function
Can I split a string using , seperator. For eg: str={133,233, 333} Can I spilit it like 133 233 333 as Split() function in PHP
User accounts require registration with zoho??? Why???
When I try to send an invite for a user to access my application it seems to require them to create a zoho account. If so why? I dont want them to have anything to do with zoho. They are my users and I dont want them to have to register with zoho. How can I get around this? this is a deal killer for me if I cant get this to work. I would gladly upgrade my account IF I can get features like this allowed.
change column format view in View mode
How I can change column format view in View mode? For example, I have column (formula calculating) in view mode and it looks like 100324.1234124 and other fields like currency looks like 12000,00 I wondering why there different separator? comma and dot? And how I can change calculating field view format like 100324.1234124 => 100 324,12
unable to see scripts
i cannot see my scripts this is what it shows [ServletException in:/jsp/edit/script/sbuilderedit.jsp] null'
Update record from Checkbox
I have written some script that dynamically populates a checkbox with records from another form (this works OK). The user then selects the checkbox options of their choice and the following "on user update" script updates the corresponding records back in the other form. This code also works OK but only if the user only selects 1 checkbox option. If 2 or more options are selected then I get the error message "Unable to update data on the form variable". I should add that the checkbox is dynamically
How to format a view or report on a per question basis
Right now the person I am working with wants to see this: Question 1: Campus 1: Answer Campus 2: Answer Campus 3: Answer Question 2: Campus 1: Answer Campus 2: Answer Campus 3: Answer Is there any simple way to do this? Thank you!
DabbleDB closing
Yesterday, the companies involved announced that Twitter has acquired DabbleDB. Customers will get 60 days notice if Twitter decides to shut DabbleDB down, but the early indications are that Twitter doesn't want to be in the database business. They bought the company to get its brainpower, not its technology. I LOVE DabbleDB. My company originally tested it versus Zoho Creator, and picked DabbleDB because it had all the functionality we needed, with better pricing, and an easier user interface. This
Lookup Field and Set Criteria optioin
Hello, I have just started using Zoho creator and it looks like a great tool. Unfortunately, due to mu inexperience with such tools I am already having a problem as follows... I have created 2 forms (Classes and NewCharacter). On the NewCharacter form there are several fields, one of which is Constitution. On the Classes form there are several fields, one of which ConMinReq. I am trying to add a lookup field (called Class) to my NewCharacter form. When I add the field I want to use the 'Set Criteria'
Next Page