Error in pulling up forms
Hi, Do we have a known issue in not being able to pull up forms? I have been trying to access this link: http://creator.zoho.com/csat_team/april-no-ir-coaching-log-form/form-perma/April/ and it has not been pulling up. Please advise.
How to fetch float, decimal or string records?
Hi i'm new to zoho and started to build my first applikation. Now i need to fetch a record (decimal nr.) from one form to another within the same applikation. This seems not to be possible, because the fetch record function just accept a boolean value e as response. But the recorded input field i have to fetch is a decimal or floating (currency) value!!? I always get this error message: expression type does not match: type required:bool type found:float Can anybody tell me a solution? Greetings from
Same Form in different tab
Hi..Zoho Creator Experts; Is it possible ( I tried but did not figured it out) to use the same form (eg. form1) in different tab in customization. In other words, I have Form1 and Form1 view. I created couple of tabs in customization. example, tab1 and tab2 for data entry. Now I want to use the same form1 in both tab. OR form under tab1 can enter the data and it goes to same database which ever fields apply to it other fields are hidden. form under tab2 can enter the data and it also goes to same
We are unable to fetch this data, sorry! Please note that your data is SAFE.
Hello, I am not able to view my data. when accessing the views i am getting the above. Please help me i need to export the data already in my application. this much data was collected with efforts from so many people and i don't want to lose any of them. Thanks in advance Regards, rejoys
Creating a Form Picklist using criteria based on common ID from different Form records
I am trying to create a Picklist that has a criteria based on a common ID stored in different Form records. Here is the scenario: ACCOUNT Form - creates records for Companies - unique record ID is created (Account.ID) CONTACT Form - creates contacts with reference to Account.ID (Contact.Account_Name) - has field Full_Name for Person's Name (Contact.Full_Name) NOTES Form - has picklist that imports Contact.Full_Name (Notes.Contact) - has the parameter Account.ID fed into it and stored (Notes.Account_ID)
Use of Related fields in Criteria
Can anyone explain why Related fields (from parent form through Lookup) fail to work when used in View Criteria? The script saved correctly, i.e., no error messages, but when you attempt to access the View you get an error: "We are unable to fetch this data, sorry! Please note that your data is SAFE. Report this problem to support@zohocreator.com." This appears to be a bug. Either I am permitted to use the related field because the script saves properly, but doesn't function; OR I am not permitted
Conditionally required field
Here's what I'm trying to do. I have a series of 6 sets of fields with 2 fields in each series (Name & Age). Name is a single line text element and Age is currently a lookup into a table containing valid ages. So in other words I have Name1/Age1, Name2/Age2, Name3/Age3, Name4/Age4, Name5/Age5, Name6/Age6 for a total of 8 fields. I want to do some validation on submit such that name and age values have to be submitted in pairs. Meaning, if a user specifies a value for Name1 they must also specify
Problems exporting to Excel
Hi I tried to export one of my views called "Purchase Report / diff " in which I have a calculating field. This field calculate the difference in time. As soon as I try to export is the the process bar starts, but the below empty screen appears. I use the following Internet Explorer: IE 7.0.5.5730.13 Br Dennis Skouboe
Limit on Size of Message Text for sendmail command ...
Hi: Is there a limit on the maximum number of characters that can be contained within the Message portion of an email sent using the sendmail command ? I have a Project where the requirements is to send a single End Of Day email that summarizes the records added that day ... I need to know whether/when I will have to break it up into a number of such emails. Gaev
Duplicate does not work?
Settings Duplicate Share The button Duplicate when pressed does not create another application. any help how to copy application? i tried More Actions Save as Script but it stopped without any output.
The new features are great
I saw in Creator that it's a new built in variable zoho.ipaddress and the code editor improvement (syntax highlighting and line numbers added). This is great! Congratulations, ZC team!
What is a script?
Can someone help me? Hi, I was going thru some of the help stuff but got a few internal errors. I sure hope you can help me. http://creator.zoho.com/cdevlin/graduation-lunch/#Form:Lunch I am trying to be clever, when a person answers my question, how many are coming, I want them to be prompted to enter name, age, and preferred meal for each respondent.. a student is graduating and bring 3 family members, i want each of there meal choices. I also want to know if any of them are under 12.
Edit link on view record openning up in New Windows??
Is it possible to chose how the "edit" link on a View record opens up the input form for editing? At the moment, the input form opens up inline to the page being viewed, which is fine inside the application, but unfortunately it becomes a problem when the View is being embedded into another website using the <iframe> approach as it creates a very small scrollable region for the input form. The <iframe> height is set to auto as I have more than one View being displayed on the external website page.
speed is a big problem now
Hi, Zoho team, Being a big fan of Zoho Creator, I am now puzzled by how slow the system is in recent days. My users are complaining - it is suddenly beyond their level of tolerance. When they enter a Purchase Order, the system often displays a cycling "updating" sign for a seemingly endless length of time. The user will often be impatient and refresh it. When he/she doesn't see the updated record, he/she enters again. Then the same thing happens. After a couple of trials, all of a sudden, 2-3 records
What is: TypeError: xml is null
Can anyone help with this situation? Please? When I am in Edit mode, Script, on a form and attempt to access a field On Update script, I get a "TypeError: xml is null", and the "loading..." icon freezes. It never loads the script. I must refresh to release. How do I debug this script if it won't load? What does the error message mean? Any assistance will be greatly appreciated. Frank P.
Embedding Deluge Script View not correctly using "no prompt for login"
I have a deluge script view that I have used the "Embed in your Website" without require login feature, however the login prompt still comes up when I view the page with the embedded iframe in it. What is wierd about this situation is that some of the embedded page does work and some does not. The iframe code is very straight forward: <iframe src="https://creator.zoho.com/XXXXX/crm/view-embed/Detailed_Account_View/9sneBBK3zXr9NNOEezxttKGfaO5U0MAVZ6RuD3YQgAR9KNmedYH0TmerJuHWGX7AwnOsrrgVh0K8KGkqJxQjwRQw0FmZSRJ1TQWf/account_idstr=310076000000041991"
View with fixed header?
Is it possible to create a view where the header is fixed and you can scroll through the records? It is most annoying to be deep into a view and not be able to identify what your column headings are without scrolling back to the top. I know this is more of a report feature, but it would sure be helpful. Frank P.
Accessing data in multiselect fields, those involving stringlists
I'm having trouble accessing data from multiselect fields. In the form I am using, I have a field hidden (Graduating Class) when the form loads. If the user chooses "alumnus" from a list of check boxes for affiliation with my school, I'd like to then show the hidden field "Graduating Class". However, when I try to script something like when input.Affiliation == "Alumnus", I get an error message saying the left side contains a stringlist, while the right side contains a string... Any ideas? Thanks!
How to display two linked fields in an imported data fields?
Hello In a dropdown list, I would like to display values from a linked tables (example: project_code), and I would like the dropdown list to display also another linked field (for instance project_description). Is it possible? Thx in advance.
Editing Text Fields
I am unable to either add or edit text fields in my applications. When I type in text and click "done", nothing happens. Only by clicking "cancel" am I able to close the edit window. Can you help me? Thank you.
Advanced CRM
I would be willing to pay someone to develop a Zoho Creator solution to this and it would require some phone time to explain and detail the problem. Problem: I have a dataset (in excel) of about 300 records that needs to be tamed into a workable solution Issue: Two lists - Some overlapping memebers We have a mailing list that includes members that have contact information including addresses and emails. Some members are unique to each list, and others exist within both lists. There are members
deleted records
how may i retrieve records deleted by accident?
string and long... inserting xml data into number fields
I absolutely love your getURL and XPath builder features. I use them frequently in my apps. However, I am running into a large hurdle that is holding me back from finishing a couple projects. I insert my xml data into form fields on validate and a few of the insertion form fields are supposed to be number (LONG) and my xml string is well, string! So even though the my xml path "/result/rows/text()"); is only one node of text and it's always a number, it won't recognize it as one. I have found a small
Error when trying to embed form without login
I am trying to embed a form in another website using the API key but I get a message that displays "Error occured please contact application owner.". I searched for that error and didn't find anything. Any help would be appreciated.
Display a table within a form
Can anyone tell me how to insert a table into a form? Here's what I want to do: I have two tables and two forms. Form B has a lookup pulled from Table A (Field A). I would like Form A to include a lookup of all items in Table B that use the lookup pulled from Form A (Field A). Is there any way to do that in Creator? And once those items are displayed in Form A, can I add more items to Table 2 through Form A? Thank you!
Add rec to Sheet from creator.
I am using a stateless form to generate HTML (view) - report So the data is mostly <tr><td> ... in loop While this html is being generated, i also want to add the rows to my zoho sheet Is this possible ?? Why i want to do this. I use vista & HP all in one F4288 printer . the HTML page is about 2 pages long. I am able to print this using browser's print command ( both IE7 & FF8), But for my friend ( -- win XP, Chrome latest version, printer hp 4plus) , only the first page is getting printed.
View with Image in Formula Field & Row buttons, Breaks Permanently, after Hide/Show Columns + Save
Hi, Here's an annoying, serious bug. I have a view with a formula field with 'img src' to display an uploaded image. It also has custom function row buttons. When I hide/show columns and click save, the view breaks! Only the buttons are shown, None of the columns show! In the Column properties: the hide/show status of columns is reset. And I have not been able to reverse this! This means creating a new view based on the same form and then customizing it all over again. Please look into this. This
Looking for developer help for Invoicing application
I am working on an application for tracking some physical therapy bills. It needs to create an invoice to an insurance company that is broken down by patient and searches across a date range. I am stuck on creating a query that can have 4 parameters, Start Date, End Date, Insurance Company and Patient Name. All of these items must be changable on-the-fly. I built the date range filter but the application needs to be edited in order to adjust the date ranges. Now that I found out from the user I also
Add to picklist "on the fly" with auto refresh of picklist
I have a form with lookup fields. I need a "non javascript" way to add to the lookup choices "on the fly" while entering data in the main form. And also automaticly refresh so the main form will display the newly added choice in that picklist without clearing out everything entered in that form to that point. I've seen it discussed somewhere but can't find where. I can sort of get the picklist form to open in new window but it doesn't refresh that picklist so that my newly added choice is available.
how to create user login and account access
is there a way to create a form that asks for a user name and password, validates that against a pre-defined or user-updatable database, and then gives the person access to their record in the database. so you are john, when you enter your password smith, if it checks out...you are able to see your grades for the semester, but not those of anyone else. thanks
Force Browser to Always Get Fresh Copy of HTML View ...
Hi: With regular HTML pages, you can code the following Meta Tag ... <meta http-equiv="Expires" content="0" />... to make sure that a fresh copy of the page is ALWAYS requested from the website/server by the Browser ... i.e. any older copy in the Browser's History/Cache is ignored. I would like to know how I can force the same fresh copy to requested for HTML Views. a) Does ZOHO Creator automatically include this tag ? b) if not, is there a way for the (script) developer to specify this ? ... as
Form vs. View dropdowns
I have a small app that takes user input via a simple form. When the form loads it sets the values of a dropdown (the Activity) based on the contents of a table (i.e. the Activities table). This allows new values (i.e. new activities) to be added to this dropdown by the user. This all works fine. However in the view these new values do not appear when a record is opened in edit mode. The edit form is the same as the entry form but the new values from the activities table do not appear. Can the
how to sort an imported "list"
I am trying to sort a picklist that is imported from data that is stored in a table automatically created with a different form submit. The code that imports this data is below. I tried having the Pick_Student field be sorted alphabetically, but that didn't work. I don't know how I can change my code to do this. Can anyone help? must have Grade_Level ( displayname = "Grade Level" type = picklist values = {"5", "6", "7", "8"} on user input
Two Views into One
I have the following two views: Student_Status (which shows whether a student has turned in their permission slip) AUP_Status (which shows whether their student account has been activated, I import this in) I want to have one view that shows students that have turned in their permission slip, but have not had their student account activated. Thanks, Justin
i deleted my info by accident
please let me know if i can recover this information.
Apply script on 'child' form field based on 'parent' form field
Hi, Right, I did a bit of cheating and combined fields in one form which should have been in two seperate forms - a contact form and an event form. Seeing the error in my ways, I decided to redesign and split the field up into their respective forms. Here is how they look now. Contacts firstname surname email Marital_Status (Dropdown - Single, Got a partner) partnerfirstname partnersurname Event ContactID (Lookup field importing ID from Contacts) Attending_Event (radio field - Yes, No) Bringing_Partner
Contains Criteria
I am working on an if statement in which it looks for the word "AUP" in a specific field. For example, if (y.AUP_Status == "*AUP*") { show sFiles_Activated; show Password; } Thanks, Justin
Last Modified User issue
I am having some issues with the 'Last Modified User' values. I have code in 'Validate' action script in one form where I update a field in another form/view. But the 'Last Modified User' field of the view updated through the script always shows admin user name instead of the login user who actually updated the record. Any help to resolve this ASAP will be appreciated. Regards, Vasu
Information displayed in calendar view
Hello How can I choose the date I want to display in the calendar view? For instance, I want to display a duration spent on a project but also le name of the project. Thanks in advance.
Can you do this in ZOHO Creator ?
Hi: Is it possible to define the url in a url field to be something like ... mailto:support@zoho.com ... and if so, how would one populate this field's content from the content of an Email field ? ... since the url field is made up of 3 parts, what would the script command have to look like ? I know that there is a SendMail command ... but I have a requirement to save some column space in an otherwise very wide View ... and avoid having the user scroll to the end in order to click on a Row Button
Next Page