Application suddenly giving mysterious error message and crashing though none before today
For an unknown reason an important HTML View for my client's organization is now crashing with the error message shown below. I am unable to determine the cause of the crash. The error message is useless. Please investigate the cause of this crash and help me get it operational ASAP. The link is: https://creator.zoho.com/w21admin/w21data/#View:Scheduling_Day_View Thank you. --- Greg aka datazen1 aka w21admin Santa Fe, New Mexico
Can I make the database secure?
creator.zoho.com/findachristianband/findachristianband I am trying to create a data base for bands. Just their contact info. I want it assessable for anyone to view, but I don't want it to allow just anyone to post. I'm afraid of malicious post. Is there a way to make it so I have to approve of a post before it shows up. Or to make it so they email me their info, and only I can post? I was editing the database in Mozilla, then testing it in Chrome. In "set permissions" Set Permissions, I left
Retrieve all the fields from one view
let's say I have a view A with fields 1,2 and 3, and field 3 is a lookup field for a view B with field 4,5,6,7,8 and 9. So, image you are going to add a new record for view A. And in field 3, which is a lookup field, you will select one of the record for view B right? I will show all the field of the select item (from view B), so the user can be sure that he is choosing the correct field. I am getting all the info from the select item and showing it in a note field into the form. But I am showing
Is it possible to re-load form fields within the same form?
Hi I am wondering if a new button could be added next to submit and reset. This button could be label "Add New" which could reload the fields already in the form n number of times by hitting "Add New". See the attached picture, any ideas will be welcome! Thanks Ray
Format phone number fields
How do I format a phone number with parentheses, spaces and dashes in a form and/or view?
Error importing ical feed url into Google Calendar
Hi, I have created an ical feed URL for a view which appears to generate the feed correctly. However, when I attempt to add the URL to Google Calendar the following error is shown: "Settings Error Could not fetch the url because robots.txt prevents us from crawling the url." Can someone please advise where I am going wrong? Thanks, Anton
Can I use javascript in a HTMLView??
Hi, I have a View with HTML, and in the table I put a checkbox column, but now I like when somebody clic the checkbox it execute a function, by example an alert box, is it possible?? using javascript? any suggest? Thanks a lot!! Regards
Time Field
Hi, Could someone help me to find a way to use time format like 10:43:01, wich means 10 hours, 43 minutes and 01 second? I really dont know why there aren´t a Time Field in Zoho Creator. Thanks in advanced,
Filter by Criteria Issues
Thank you in advance to anyone able to help me with this issue. I have a Task Form and in that form is a lookup field "AssignTo" which pulls from the Employees Form to have a dropdown list to pick who to assign it to. Within the Employees Form is a checkbox and the AssignTo has a criteria to filter the dropdown to only show those Employees with the checkbox marked. That way there aren't a hundred names to scroll through but just those that you assign an item to. That works fine for what I need.
Success Message not popping up on IFrame
Hi there, success message not popping up in I frame for firefox or IE, I saw a solution posted while looking for something else, forgot to bookmark it. What is the solution/workaround please?
How can I pass parameters between form and html view?
Hi, I have an HTML View with the CRM Contacts List, but I like filter by example by Last Name, I embed a form with a label text and a button, in the button clic event I execute the list and I like to pass the result to HTML View like a parameter, can I do this? How? Thanks a lot, Regards!!
User Access
How can I have a tab, available for only me to view (administrator) that lists my users and allows them to edit/delete/add info in the view tabs???? I need to allow some people to do this and some to not have that permission
Date and schedule question
Hi, a few pointers needed,,, if I have a date field for example course date, and use add.year(3) to add three years to this date (this would be renewal date) how can I store this date and use it to schedule reminders via email to chase renewal up for renewed business......
Problem: "Duplicate" function in list view does not work
I cannot get the Duplicate function to work in one of my views. I select the record and click Duplicate, and it says "Record Duplicated Successfully" --- but it isn't. No duplicate record is created. This is the link to the view, it is shared w/ support: https://creator.zoho.com/w21admin/w21data/#Page:Events Please help. Thank you. --- Greg aka datazen1 aka w21admin Santa Fe, New Mexico
How To Retrieve Specific XML Data
I want to be able to retrieve specific xml data from a specific website and then update the values of other fields on my form with that data. I have been messing around with the executexpath and get url commands, but I cant seem to grab the data. So basically, I have a form, and when a user types in his ID number, an xml file is called, to retrieve other data. For example: ID: Name: Age: When a user types his ID in, I want to poll a live xml doc on the web, (http://www.domain.com/(ID).xml,
Set last entry date as default date
How do I set the last entry date to be the default value of the date? E.g. If I key in the first entry, the date is 1st May, then for the second entry, I want to default value of the date to be 1st May too.
Sorry, but brain is dead need help with alerts
I hope i placed in the correct sub forum. Its been a little while since i had to update my form and having some issues. I have it set up for a 'coordinates' field, with the format as ###|### (#=number). I have an alert to pop up if they input the coordinates wrong. I am also trying to have an alert pop up if the new coordinates are already entered. I do have it checking for dup's and will give an error like: 'invalid entry for key2' ... What i would like is for it to compare to DB and if already
[t_741848000000027025_PIDX] Exception occured while inserting rows Failed to update data
I have a form with a list view. When the data is entered via the list view edit form, I get the Exception error above whenever the dropdown fields need to be edited. Please help
Why won't this script lookup wildcard matches?
I'm looking up two fields here, Case_Name and Adverse_Party to see if there is any wildcard match in the database. Adverse_Party works fine in this script but Case_Name only shows a match on the current entry and never matches any historic data even though I know there should be matches. What's going wrong? cnt=count(Case_Management_Form[(Case_Name.contains(input.Case_Name) || (Adverse_Party.contains(input.Adverse_Party) && Case_Code != input.Case_Code))]); if((cnt > 0)) { records = Case_Management_Form[Case_Name.contains(input.Case_Name)];
How to allow user to see all records in one table that match criteria in another table?
I have 2 tables: customer and appointment. I can search the customer view to find the customer record I want. I have a Lookup in Appointment to Customer, so that when you create a new appointment, you choose the customer. But, how do I then click on something to see *all* past appointment records for this customer? I can imagine a button in each row of the Customer table where I could click "See Appointments" and it would bring up the Appointments page, but of course, only showing the records
Error defining picklist
Hi, I'm getting an error trying to define a picklist...code is below: must have Office ( type = text width = 200px on user input { if (count(Order_form[Office_Name == input.Office && Received_Impressions && Sent_to_HK == false]) == 0) { clear Order_List; } else { for each y in Order_form [((Office_Name == input.Office && Received_Impressions) && Sent_to_HK ==
Anyone have a step by step with regard to zoho creator and google calander?
A sample app maybe? I cant get it to work?
Lookup field is not populated in "Edit" mode
Hi, I've got an application that was working fine until a couple of weeks ago, but is now not working I'm afraid. I have a form called "Games". The only field in this form is "GameDate". This is a date field. I have another form called "Results". This has a lookup field called "Game", which references the "GameDate" field of the "Games" form. When I look at the view for the "Results" form, I can see that the reference to "GameDate" is working fine. When I *View* one of the records, the "GameDate"
Report PDF Exports do not match User Filter criteria
When I enter criteria in a user filter on a Report, such as a date range, and then go to Export to PDF, the export includes everything from the database and not just the data within the date range I had specified. Please let me know if I am doing anything wrong if there's any way I can help you recreate this issue. Thanks, Jennifer
ZCreator with Google Apps sharing ONLY with Google Apps users
I'm an administrator of a small Google Apps.I've installed ZCreator in my Google Apps, because I want to share ONE of my application with Google Apps users. Other applications I'd like to share with users outside the Google Apps, but now I'm not able to do it. It can't be true, can it? :)
The Alert Box...
How do I do a new line in the alert box? Tried <br> as a guess, but didn't work. Also, how can I do a "for each" in an alert box? I want to list 2 fields from records. Right now, it lists all the info I want, but it does <field1><field1><field2><field2> I'd rather have this: <field1><field2> <field1><field2> Hope I explained that correctly. Thanks in advance!
Nested dropdowns?
I'm trying to create multiple nested dropdowns for use in an attribute agreement analysis, but cannot seem to get this to work beyond the 2nd column. I have a source sheet (Sheet2) that has 5 columns of data - each connected to the next. I need to be able to create 5 dropdowns in Sheet1 that populate left to right based on the prior selection. The idea is that I want people to evaluate the test cases in Sheet1, and get the right options populated in the dropdowns from Sheet2. I imported the workbook
SQL like queries.
Dear All, I have 2 forms with 2 views created on my Zoho creator. I am not using the ids generated by zoho, because the forms will use ID entered by the user (just because this a requirement from the place I work). So, I am trying to write a script that will do the following: while the user is entering data into form B, he will enter the ID from one item from form/view A. After the ID is entered, it will show the information from that item into the form B, and some fields from form B will be automatically
Sharing a linked COPY of an application (without using the Marketplace)
I've developed an application which I'd like to share with another company. Note that I DON'T mean simply inviting other individuals to contribute data to my application -- I mean creating a separate copy of the application's forms, views, scripting, data so that another company can use the app themselves. And if I make a change to the source code, I'd like the change to propagate to the other company. Is this type of arrangement possible? Can I do this using the Marketplace? Can I do it without
Problem with Record(s) that cannot be edited and submitted! Please assist.
I have a record in a particular form that when edited cannot be submitted successfully. Here is an example: The view link is: https://creator.zoho.com/w21admin/w21data/#View:Contacts_All The record ID is: 340313000007715263 When you 'Edit' the record, the form pops up. But whether or not you change any data, when you do a Submit you get the following error: (it is impossible to resubmit this record) Please advise. If you find issues with this record, please scan all records in that form
Lookup field not retaining format
I have a form for products that includes a price field in currency format. I also have a transaction form that includes a lookup field for the product price field. How do I make the lookup field appear in currency format?
PickList
I have a question regarding the picklist, I want to set a value from one particular picklist by url on a form, if I set the picklist from the wizard when I am creating the component, when I pass the parameter by url, the set is made correctly however if I populate that picklist from deluge script and I pass the parameter by url, the set is not done correctly, Why?????
Saving changed records in Grid View is *still* hanging and not saving changed records (intermittent, but frequent)
This problem was reported and acknowledged many months ago and still remains an ongoing problem: When in Grid view, if you change some records and click the "Save" link, the application hangs while displaying "Saving Records". The problem seems intermittent, but FREQUENT. After waiting a long time for the saving to complete and finally refreshing the browser, you see that NO CHANGED RECORDS WERE SAVED during the "saving" process. Could this be looked into please? Months ago you said it would
How do I delimit a lookup multi-select field with line breaks instead of commas?
Hi I understand there is no direct way to make each entry of a multi-select field appear on a new line when viewed, i.e. one two three rather than one, two, three However, there is a workaround using the replaceAll function and the <br> HTML tag, which I don't fully understand. Could someone please explain this option? The multi-select field I have uses a lookup from another form to populate the list. Many thanks Martin
Help with script
Could someone please help me? I try to make a scrip but I dont know how. I tried this: if (input.survey == "Completo") { (input.Percentual_Completo==10) } else if ((input.survey == "Completo") && (input.projeto == "Completo")) { ( input.Percentual_Completo==15) } else if (((input.survey == "Completo") && (input.projeto == "Completo")) && (input.infra == "Completa")) { (input.Percentual_Completo==45) } I did this based in the follow syntax: ( https://help.creator.zoho.com/Control-Statements.html
script editor incorrectly changing parentheses
I have a validation script which is being saved without any syntax error but when the same script is subsequently reopened for editing, not changed, and then saved again, the editor throws an error due to the automatic changing of parentheses. The following line saves correctly: if (count(Client_Contacts[((Client == input.Client) && (Is_Billing == true) && (ID != input.ID))]) = 0) However, the script editor changes it to this: if (count(Client_Contacts[((Client == input.Client && Is_Billing) &&
Question About Linking Forms & Records
As I am trying to learn more about how to use this, I was wondering if people could point me in the right direction for something. Say I have a product that has 1000 units available for sale. Someone orders 5 units, and I now want it to display it as 995 units available. How do I do this? Do I enter it manually, or can it be done automatically? What I do everything manually, and so I enter a record for that customer ordering 5 units. Can it automatically decrease the units available from 1000 to
need help with simple application
is there anyone out there I can hire to get me started with a simple preferred vendor list? I have the info in Excel, but want to add it to our Google Apps
Cannot Duplicate application...
Hello, I cannot duplicate my Art Inventory Management 3.0 When i click duplocate or copy application it just never duplicates. I have Enabled Edit Access to Support. When i save the application and create a new application from it I get the following error: Error at lineNumber:1 Function:thisapp.general.ArtSerial() does not exist The function is there and it does exist. Please help me correct this issue. I need to be able to duplicate this application. Thanks
How find matched record and alert?
I want users to fill out a form but if there is a match between the data they enter and exisitng data in the database I want the user alerted (by email). The email needs to contain the matched data as well as the Case_Code value from the matched database record. How would I do this? I tried my luck at this but it doesn't work, if Case_Management_form(Case_Name == input.Case_Name && input.Case_Name != "") || (Adverse_Party == input.Adverse_Party && input.Adverse_Party != "" email_body = "Possible
Next Page