Type mismatch seems bogus
Problem: I built a multi-page stateless form, following the excellent example of the Summer Camp Registration. The pages 1 & 2 both store fields in the master form, as expected. When attempting to follow the same process on page 3, I cannot add the code to the form definition, because I keep getting an error modifying the page, as follows: The field rec.TargetRevenue1 is of type BIGINT. But you are trying to update it with data of type DECIMAL However, the fields TargetRevenue1 and the corresponding
Internet Explorer 9 support
ZC Team, Internet Explorer 9 was launched a few months ago and it is already delivered to Windows Vista and Windows 7 users by OS automatic updates. Have you plans to include it soon in the list of supported browsers? Regards, George
HTML view has lost all formatting.
I have created a couple of HTML views, which display as brochures, with the required property information as entered into my database. Everything was working correctly, until an hour ago, and now the CSS formatting which was being applied appears to be ignored, and all elements are simply listed one after the other on the page, in plain text. Here is the link to the view: https://creator.zoho.com/4732209/propertyprosperity/view-perma/Standard_Brochure/PyRNmxShbOzrD941hzp2uYY4YqASNa0Jy6COSTdAVhuQq9OmC3bddFTzAB3176VZSsCRxGzdmOYg3SqhWgSOV8KP5dCvEksDvCUC/?recID=623880000001192015
2 Views - Different User Restrictions - Photo shows for one user but not another
Hello, I have a membership application that contains member information. Since there is no way to control access permissions between various users I have done the suggestion of creating 2 different views All_Members and All_Members_Restricted. I share All_Members to users that I want the Edit and Delete links to appear and for the users I don't want to give edit and delete capabilities to I share the All_Members_Restricted. This works fine except for one major problem. I have a photo upload and a
Can ID be used on multiple forms?
Since ID is unique for each record, I guess I can't set the ID of a record in another form, is that correct? Since I have a record that's starting on one form, and transitioning to a separate form, in order to keep a link to the original record, I assume I must create a third id type field for the two records on the separate forms to share - is this correct thinking? Thanks! Kenny
Can the Add/Edit form for a View be made to contain only the fields in that view?
I had assumed that, when I have a view with a subset of the fields in the main view, the Add/Edit form would only show the fields in that subset. That does not seem to be the case. Is there a way to make this work?
Dynamic Picklist - retaining field values on edit/update
Zoho Support, I am using dynamic picklists in an application and adding records works as advertised. When editing the record, however, I am using an "on load" script to re-populate the picklist values. This re-load of the picklist values is causing the original entry to be removed. Is there a way to keep the original field value intact, while re-loading the picklist with new values?
Send email task with embed HTML view
Hi, I create a html view in Creator. I would like to embed this html view in message field of sendmail task. The embed url is a Functional-based URL. I try to put iFrame code in the message field, and the html can display in the message box, however, after send the email to my mailbox, I can't see it in Gmail or Outlook. How can I embed the html view in sendmail task? The url look like this https://creator.zoho.com/123/salesforce/view-embed/Enhtml/JjZSkMMXHUVmSwWjvHRNf6n6/code=123 Thank you.
Fetch Records Based on Two Conditions
Hi: I am trying to Fetch Records based on two conditions. This is the general idea of what I am trying to do, and I realize the syntax is not correct: statelist = Grove[Field_Name == input.Field] sort by Grove_Name && statelist = Grove[Scout_Check == "Grove Check"] sort by Grove_Name; Does anyone have a suggestion on how to make this work? I am new to Deluge. Thanks!
Create List , List String Syntax Clarification
Hi, Need some clarification on using List String The developer Docs here says https://help.creator.zoho.com/Create-List.html list4 = List:String(input.Country + ", " + input.Name); For me this gives a deluge error "Invalid argument. List expression is expected as argument." Not until i insert another pair of { } of braces can i get it to work list4 = List:String({input.Country + ", " + input.Name}); Either there is a bug in the statement or an error in the docs, Can someone please clarify Regards
can't open any View with type "HTML Page" in my app
I can't open any View with type "HTML Page" in my app in Zoho.Creator. Yesterday everithing was ok. Nothing was changed. But now it's not work.
Calendar view bug - View, Edit, Cancel loop
In a Calendar view, my users get stuck in loop of modal boxes when they: click a record to view details click Edit click Cancel click Close click Cancel click Close repeats...Of course, the trick to closing these modal windows it to click the "Close" button in the top-right corner. Please make the "Cancel" button close the Edit modal window. "Cancel" functions as expected when in a List view.
Can´t save view
Hi Zoho I have a problem with saving a view. I wish to remove "entre" + "billetpris" from: https://creator.zoho.com/runehagel/events-cafezusammen/#Page:Informationer_til_kommunikation I however get the following error when trying: "FAILURE:Error occured while saving the view. Kindly refresh the page and try again later". I have read in other topics on this forum, that this should be a problem on the serverside. Can you please help me ? Regards Rune
Automatically record the site URL which contains my stateless iframe embedded form
Hi not sure if possible but lets see I have 20 Sites each with the same contact form (name, email phone etc ..) I am using a stateless form embedded in an iframe The only difference in the form is that i hard code in a hidden field the url of the website, this is so i can determine which website sent the user submission So at the moment i have 20 forms. Would be nice to cut it down to one form, if only i could write some script that would allow me to determine which site the form is on and have that
Making search results selectable
After creating an html-view for a search form, I want the user to be able to select one of the returned results, which will then be passed as a parameter to the next html-view. But I don't have a clue how to do this. The attached codes is for the currently working html-view. It currently returns an ugly table showing each record matching the search criteria - so user can enter any data he has (phone, zip, name, etc.) and see which records might be the one he's looking for. Now, I need to be able
Unsure How To Structure This Search
I'm trying to make an app that will allow me to input information from a card, then allow me to search the results based on multiple criteria. This is what I have so far: Card_Input Form Name: <value> Type: <value> Cost: <value> Card_Search Form Search By Name: <value> Search By Type: <value> Search By Cost: <value> I've got an HTML view that displays the results. Right now, I have it working for one variable, but I'm unsure how to take it further. I'd like to be able to search for one or all
Need help sorting before output to html view - List()?
I am trying to fetch data from one table based on entries in a second table. The fetched data needs to be sorted after collection and before output to my html view. Here is an example of what I am trying to do: I have a form/table called Enter Genotypes. The table contains 12 fields that each represent a specific gene and each field has a dropdown that displays the genotypes that relate to that gene. The user selects the appropriate genotype from the dropdown. Each gene (field) can have a unique
Update Record error
I have a task form that contains DueDate and also a Priority field. What I'd like to do is to arrange it so that when the DueDate is approaching within X weeks or days, it will automatically update the Priority field to "1-High" Ultimately (which I'm not sure if it can be done) my employer would like the form to auto adjust the priority not only based on the DueDate but also on the EstimatedHours for the project. For example, if it will take an estimated 100 hours to complete a project, the project
Functional URL "OR" constant operator
I'm trying to filter down a view via a url params like so.. #View:<view_name>?location=<Need to pass 2 locations> in PHP, Python, etc. To pass multiple values you go.. #View:<view_name>?location[]=a&location[]=b which get's turned into location = array("a","b"); I REALLY need either an "OR" operator or an "IN" operator. You already have the "BETWEEN" operator that uses the semi-colon. #View:<view_name>?FieldName1=<StartingRangeValue>;<EndingRangeValue>&FieldName1_op=58 Is there an unlisted operator
Tooltips do not display
None of the tooltips in my applications display. I'm using the following browsers: Mozilla/5.0 (Macintosh; U; PPC Mac OS X 10.5; en-US; rv:1.9.2.19) Gecko/20110707 Firefox/3.6.19 and Safari Version 5.0.5 (5533.21.1) Any advice? Thanks,
How can you limit number of registrants to 100 only?
How can you limit number of registrants to 100 only?
User selects 1 record out of search results view...
I painstakingly built a search form with html view as follows: user enters whatever piece of data they have - such as partial phone number, zip code, business name, etc; view then retrieves a few fields from each matching record and displays them in a table (super ugly at the moment, but functional)Now I want user to be able to select which of the matching results is the desired record - select that result - and go to a new html view or form displaying all of the data for that record.
Changing Field Types
There is a restriction on changing a field type if that field is referenced in a script. In most cases this is a very useful restriction. However can the restriction be removed if the script is only Show/Hide or Enable/Disable. Herb Wexler
Cant delete applications....?
I gave shared a zoho applicaiton with another of my creator accounts as a test. Problem is now i cant delete the application from zoho. What happening and why? Well actually i get this long error message. i dont want to go through the application and make all these modifications just to delete the app. What can I do? There are actually 3 apps I want to delete all giving the same type of message. The applications are as follows and they are all installed on this account. Copy of Art Inventory
Login Page
Hi I'm new to Zoho, I need your help to create a Login Page for my website. I've defined a of User names & Passwords in excel. I want the same database to be used for login. Basically a Login page for my website. Kindly advice.
Converting a payroll workbook in Excel to Creator
I have a payroll spreadsheet that we use for our business, as I have been unable to find a software package that does things how we need them. We pay our people "by the piece" doing electrical work, and we use vlookup, drop down boxes, and various equations to calculate payroll. Love to find a way to do this online with Creator and have it export info in a format acceptable to Quickbooks online. Any recommendations? What should I budget for something like this?
iPhone GPS and Zoho Mobile
Hi: We are using Zoho Creator a like it a lot. However, the one thing that we cannot figure out how to do that we need is to get GPS coordinates on iPhone using Zoho Creator Mobile. Does anyone know if there is a way to do this? Thanks!
Function for returning date after adding x number of business days (no sat, sun)
I have a customer that wanted to let a user schedule 4 BUSINESS DAYS out. I couldn't find a saner way to do this so here's my function. date helper.bizDays(int days) { iterator = helper.iterator(); time = zoho.currentdate; for each n in iterator { if (input.days > 0) { time = time.addDay(1); if (time.getDayOfWeek() == 7) { time = time.addDay(2); } else if (time.getDayOfWeek() == 1)
Can I change My zoho id?
Is there a way to change my zoho id? My business name has changed and my current zoho id must change or I need to somehow move all my applications and records into a new account! Any help on how to make this move without too much pain would be great.
Problem during Sign-in
Dear Helpdesk, I am based out of Mumbai and work for Aqua MCG. Have previously used Zoho CRM and was impressed with the features. Been trying to login to Zoho Creator since yesterday and have not been able to do so. After the user name and password is typed in, if there is a wrong password given, it does mention that the user id and password do not match. If the right password is given, it reverts back everytime to the home page. Also why am I being asked for a new user name and password everytime
Relative criteria searching
Is there any way we can do a relative search from within the view of a data base. This is available in the reports - how can we do this from within the views ? For example - I would like to search on things like: all records for THIS week , LAST week, or NEXT week - same for the month time period. I realize there is last 7 days etc. but these are not the same. The relative search query is very powerful as shown in the reporting function. If there is a work around please advise. Thanks
Multiline in a Form or Application
Hi, I would like to know how to add a Multline Entry for Example, Multiple Line Items in a Purchase Order or a Invoice. For Example a user should be able to keep adding multiple lines if required. If this Possible in Zoho Creator. Regards, Rahul
Update Record from Stateless Form
Hello, I have an application (https://creator.zoho.com/jpiajr/compost-tracker) that I woudl like to do the following As it stands now, the first stage of the process is when a user fills out the Phase I form Once that form is submitted it creates a records in the "data_form" (which is the master form that the stateless for feeds feeds into) what i would like to do is have the buttons i created on the "View_Data" view to be able to open the a certain stateless form that is relative to the ID. so that
Email notifications activated...not receiving email notifications
Hi, I created a simple form that I'd like to use to capture data and then email out to a variety of email addresses. I've gone through the instructions and have done the Set Email Notification section. Everything looks fine, but when I go and test the form by submitting some info, I never receive an email. Any thoughts why that is? Thanks
Challenging Task: How to prevent double bookings
Good morning zoho crew! My new task is how to prevent double bookings. Stateless form Guest_Reserve form Test_Reserve holds the table fields date time Zoho date/time start datetime Zoho date/time end number Number_of_Riders number Current_Seats_Available picklist Status (Reserved, Waiting, Available) is there a way for zoho to check for times that are booked ? maybe something like count Zoho date/time start between Zoho date/time end if input.Number_of_Riders is more than Number_of_Riders mark
Using Creator to build quotation database
Hi Has anybody used Creator to build a quotation database? ie tables with products and pricing (potentially by customer) that can be used to generate quotes? If so, do you have any tips on what has worked well? Thanks Isis
changing text to other symbols
Hi. I've read some forums around regarding the lack of support for creating password fields in Zoho Creator. I noticed they were dated back around 2009 or so. I was wondering if there are any improvements about that as of today. In addition, what I really want to know at the moment if there is any way in Zoho Creator to change whatever is on the text field into something else, like how a password is like for example. Well, through coding... Like... my password "12345" will instead show up as "*****"
Suggest add a Function for string loop
Hi Suggest add a Function for string loop, such as spinning off a string one by one， for example "1234567", ripped out the results of cycle "1", "2", "3" ... until the get finished, there is no such function in ZC? Thanks! Stanley Guo
Unable to Rename a Form
Dear All, We regret to say that there occurred an issue from our side in renaming the Form from the application edit mode. We will fix this issue at the earliest. For now, change your form name form the form definition which works fine without any error. Please find the below detailed workaround steps and Screenshots. Go to the edit mode of your application and select your Form from the Forms tab. Click on More Actions -> Form Definition. You will now be in the script tab with the form script definition.
Aggregate Sum function
I am using the aggregate sum function <variable> = <Form_Name>[criteria expression].sum(<Numeric Field Name>); First issue is if there is only one row then I get a null variable. Second issue is when there is more than one row I am getting incorrect results.
Next Page