User registration
I am a newbie and have the following question. How do I setup the application such that the user can register themselves via a form without the admin manually adding them? I'll also need to have it automatically generate the key and ticket for API because I am planning to have an iphone interface to the database via the API.
Decision Box
Hey Guys, i'm undergoing a university project and have encountered a problem creating my application. Basically i have to keep a log of tasks completed by a student for a certain event and if a task has not been completed by a certain date they will be withdrawn from the event However it is ultimately at the discretion of the event organisor so i also need an override function. I was thinking about using a checklist features to log the tasks and a decision box to perform the withdrawel function but
How to make a calendar view out of multiple fields
So I have a form with jobs that have recurring dates that are based on there frequency. My form has a next date, second next date, third next date, ect field. I want to have a calendar view that shows all of the future dates but calendar view can only be based on one fields. Any ideas?
Auto Generate Email
Hi I am a very new user having been forced to transfer from Dabble. We have an instruction booking system for appointments which are completed online. once we receive them we validate then confirm appointment time. To explain fields that appear on the web form are something like this Instruction Date (Auto completed at time of input) Client Name (Input by Client) Detail (input by client) Appointment (Completed by us on validation) Within the form we have additional fields that we comlete
Column widths suddenly way too wide
Suddenly most of my views are super wide as the columns to not display correctly. One view now streches over 3 screens on my notebook. I've checked Firefox and Chrome... same problem. Zoho has edit access to my app (bmpm). Please advise. Regards, Filip
Print & PDF of ZC Views do not wrap text in fields
While preparing for a meeting and needing to print out a ZC view, I discovered that both the Print and PDF functions do not wrap text in the fields, resulting in extremely wide documents -- i.e. the field stretches to fit one line of all the text put into the field. See below. I should note that the offending field is a "rich text" field, and that the text in it has no line breaks. Still, it should wrap. Could this oversight be corrected, please. Printouts and PDFs are essential when sharing
Compare Drop List Item to Supplier Checkbox List
Hi, I am using a Dropdown Field to capture the Country of a Customer registering. Is there a way to compare this value to a Supplier Checkbox List where the Checkbox List of the Supplier may have several Countries Selected EG USA = Country of Customer Registering USA UK China = Countries in the Suppliers Checkbox List Many Thanks
problem adding records to 2 related forms via 1 stateless form
I submitted this to support yesterday but have not heard back yet so thought I would give it a try here. I have a "Contacts" form and a "Clients" form. The Clients form has a "Billing Contact" lookup field which references the "ID" field of the Contacts form. I am trying to use the OnClick event of a single stateless form to firstly add a Contact record and then add a related Client record using the ID returned by the first insert statement, but I am getting an error. When I click on the "View Error
Unknown table or alias 't_612827000000016301' used in select query.
I have been alerted when accessing report page: Unknown table or alias 't_612827000000016301' used in select query. What's that meant?
Is there a user guide for the inventory app I downloaded?
I recently installed the Multi-Location Inventory app to my account and it looks promising for my organization, but will need to be customized. However, before I can take shot at this myself, I really need to understand the guts of this application, which is tough to do just by inference. I am not a developer, more of a fairly knowledgeable end user of similar software (like MS Access).
form problem
Hi, I'm currently working on a University project and I'm having a problem with my form. I would be grateful if any one could help with my problem below. when the data is submitted, I want it to check to see if the date it was submitted is past the date I have specified. and if it is I want it sent to another view. I'm not sure how to do this. any help would be appreciated.
Generate Reports
I would like to generate a report based on check boxes, can this be done if so how?
If scripts to copy within one Application
Hi, I use Creator to list customers and clients. I am not familiar with Deluge and have been trying to write a script to use a "yes/no" radio button field to copy address components. I particularly need help with the Spielman Case Database form. In this one, there is a series of fields for address and an updated address (new address) for each record. Some do not have an updated address in which case I click "no" on the "Address_Change" radio button. I would like it to be so that if Address_Change
Insert multiple rows with creator...
Hi, the below code inserts only 1 row from the fetched data. Can anyone help with code to make sure it inserts all records fetched? Thanks for the help... Pdtxpagar = Alumnas1[Status_Alumnas_os == "Alumna(o)"] sort by Fecha_de_Inscripcion desc; Pdtxpagar2 = Academia[Servicio == "Mensualidad" && Status_Pago == "Pendiente x pagar"]; insert into Academia [ Added_User = zoho.loginuser Alumna = Pdtxpagar.Nombre_Alumna Fecha = zoho.currentdate Forma_de_Pago = Pdtxpagar2.Forma_de_Pago Mes_a_cubrir
Speed of update record?
I have a system that generates work order numbers. There is a form with a single record that contains the next work order number. When a new work order form is opened the following code is in the on load section. //Get the work order number record Next_WO_Num_Record = Next_WO_Number[Record_Name == "ABC"]; WO_Number=Next_WO_Num_Record.Next_WO_Number.toString(); //Update the work order number record Next_WO_Num_Record.Next_WO_Number=(Next_WO_Num_Record.Next_WO_Number + 1); If two people open a work
Related fields into a URL view
Hello, I need help urgently, Related fields in my URL Views have been working for a long time. Today stopped, without any logic reason. The edit support is enable. Look to this URL to understand my problem please: http://creator.zoho.com/sergio.galiano/erp/view-perma/Dedicacciones1/criteria/Contacto.Entidad=BARBERAN Note that the criteria: Contacto.Entidad doesn't work. I have also 3 or 4 more URL that doesn't work with the same problem. Please anyone can help me? It's very important for us.
How to search for conflicts on submit
I'm very new and still learning the basics of Creator so please go easy. I have a form that users fill out which includes the fileds Client_Name, Adverse_Clients and Case_Status. On submit of the form I want these three fields checked against the database, any matches I want to include in an email. Can anyone help?
Google Apps Integration with Zoho Creator: Old Application on Zoho Creator is no longer Visible
Hi Zoho Team, There has been a major emergency. I am unable to see the application "Lead Tracker" that I had developed and shared to other users. It looks like it has been completely washed out. I have so much business critical data that I cannot afford to lose it. Following is what I have done: a. When Zoho Creator was not installed as part of Google Apps the id sagarg@black-and-white.in had the admin role of the application "Lead Tracker" and admin@black-and-white.in was a regular "user" b. Then
Update Script
I need help with the update script. The sample in the help section is not clear to me at all. I am using one form that populates in part with data from another form. That script I FINALLY figured out. But I also want any changes made to the data in the second form to update any changes made to the data that was pulled from the first. Below is the fetch script. What do I need to do to make this update function happen? temp = Membership_Data[MembershipID == input.DMembershipID]; DOrganization=temp.Organization;
Converting List String to just a String or another option to give criteria for a view
Dear ZOHO and Creator developers, I'm having a really hard time to convert a set of elements in a list string to just a string. I need this so I can search in that string. The situation is that I want to develop criteria for a view in which the users sees the records that he himself has created, as well as the records that another user has created. They both (or more of them) have in common that they share the same Group (in the group defenition, their respecitve zoho.userid's are stored. Please
Updating field data between forms...
I have two different forms for membership data. The 1st form contains all membership contact information. The second form records their annual dues payments. I have much of their contact data fetched to the second form so I can see if any contact data needs to be updated when their renewal comes in. The problem is I cannot figure out the right code to make the any updates be reflected in the first form (or table). Here is the code I am using to pull the data. What code do I need for updating
Permalink list views don't honor specified column widths
I have a list view who's permalink to it does not honor the column widths I've specified.... thus, the view runs off far to the right side out of the window (that's bad). The form link name is: Summer_Program_2011_Descriptions_ByName It's shared. I have other list views based on the same form that also behave badly when viewed from its permalink. --- Greg aka datazen1 aka w21admin Santa Fe, New Mexico
Duplicate entry ... for key 2 error
I spent two or three hours wrestling with a form that would generate a "Duplicate entry ... key 2" error (reported many times in this forum) often when submitted. I had no fields marked as "No duplicate entries", so naturally I've learned to figure that ZC is messed up somehow and throwing the error for some bizarre or illogical reason. So after many experiments, I finally discovered that the error message was being thrown because the last character of the strings in a checkbox list ended in a
Duplicate form
I did a search and found the following on how to duplicate a form - Right now it is not possible to duplicate a form directly. However, it is possible to do so via script. Click on "Edit this Application" and navigate to the particular form. From the top strip displaying the Form name, mouse over on "More Actions" and click "Form Definition". You will be redirected to the Script tab displaying the form's configuration in Deluge Script. From the left pane, from under "Form Definition", click on "With
Radio field
How does one design a form with a radio button field of 3 selections - 1, 2 and 3 - and then have each selection take you to another form - form 1, 2 or 3? I don't seem to find a "go to" another form selection. - jb
User deleting calendar entry based on UID
We are using ZOHO Creator to book a location using a form in calendar view. The system sends an mail with a recite to the non registered user. Can we send a link to the user, so the user can delete the record if they want to cancel the booking?
Customized Estimate app similar to Zoho Invoice
I have an existing Zoho app to track clients and tasks that I would like to add an estimate module to. I like much of the functionality in Zoho Invoice, but I would want to tweak it, so just linking the two is not the answer. Also, once we have Estimate working, would want to add Purchase Order, which would be very similar. I would like to hear from developers who would be able to do this for me. Thanks!!
Contact us form
When someone fills in a contact form I have, where does the info they have input go - into Zoho's database? Do I have to go into the database to pick up the info? Can I have it emailed to my email account? Tks - jb
Logging into two Zoho accounts
As I will be working with two different companies with Zoho forms, I have opened a Creator account for each company. Since many of the issues I have will be with both sets of forms, I tried to log into both accounts but it appears that Zoho will not let me do so. Is this correct - one can not be logged into two different accounts at the same time? Is so, why? - jb
Tooltip & dropdowns
When will tool tips be available for Select Items? When will tool tips be available for disabled input text? Most users want to know why it is disabled. Can you not put the tool tip text on the title attribute of the associated label? I modified select Item list and they do not show up in application.
lookup field is randomly working and not working
rec = Ride_Matrix1 [Lookup_2 == input.How_long_do_you_plan_to_spend_on_chores]; input.Time_in_Minute = rec.Time_in_Minute; I have this code, it works fine if I delete it, then resave it on input of my script, but if I try to use it again without resetting the script I get an error message time in minute is null. it is not null since it just worked fine the first time, edit access should be turned on please help trying to lookup the amount of minutes to add to a date time start where input at
Contact form
I used the template for a contact form and made the changes I wanted to same. When someone uses this form, the info input into the fields is sent to the database. Is it also sent to an email address of my choosing? Should I have a form with radio buttons for Sales, Admin, etc., and then taken to the correct Contact form? If I have one contact form for Sales, one for Admin, etc., how do I get the emails sent to the correct email address? Tks - jb
There is not such View in Zoho Creator
I have an application with several forms & views, today I create another view , everything looks fine , I order the columns, I put some sorting columns on the view, etc.etc, then when I try to access the application I receive the message "There is no Such View in Zoho Creator", and of course the previus view defined was not there. I try these creating a New View and also using the Duplicate View function, in both cases the message is the same, is any limitation with the quantity of views?. Regards.
if scripts to fill a form field
Hi, I use Creator to list customers and clients. I am not familiar with Deluge and have been trying to write a script to use a "yes/no" radio button field to copy address components. So far i've gotten the following script to successfully save but not to work in the form. if (input.Address_Change = "no") { New_Address = Address; New_Apt = Apt; New_City = City; New_State = State; } Please help me! Thanks you
Please ask dev to ALPHABETIZE all drop down picklists for forms
In a couple places dev made the effort to alphabetize the list of forms that are needed in various places inside of Zoho Creator, but not all places. Why? It is extremely annoying to try to hunt for a form in a long list of forms, and they are not alphabetized. I know this has been mentioned in older threads, but I feel it must be brought up again. It's a simple SORT function. Please ask dev to complete the task they started and make all drop downs that list form names ALPHABETIC. Thank you.
urgent! Solution Needed for highschool project (easy)
For high school i've been asked to create a database using zoho, part of it involves normalising the information below. to get extra credit we've been told software requirements could be a repeating group, if an exhibitor needs to use more than 1 piece of software. I really suck and normalising and am struggling to come up with the right data tables so that i can start using zoho! If anyone would like to give it a go and along the way please explain how you did it, here is the information which
create a document with zoho
Hi, I have create a database with zoho. Now I have to create a document with some field connected to my database so they can be filled automatically. Someone has the solution? Thanks
Error when trying to Add Technician: "Invalid entries found. Please correct and submit again."
I have been able to successfully add 2 technicians. However, I now get the error below when trying to add an additional one. "Invalid entries found. Please correct and submit again."
Mobile view of data - more than 5 records per page!
I have a Client Directory View in my application https://creator.zoho.com/egutshall/task-manager/#View:Client_Directory I would like my users to access this directory from their mobile phones. When they do, it only displays 5 records at a time, which makes it pretty useless (imagine trying to get to a client #102 on the list!) I embedded this view on my own website. However, if I embed the iframe snippet that requires login access, it is the same 5 records per page limitation. If I embed the
Validation
Hello, I have a function in my application that checks inputted dates against deadlines and if the date is passed a deadline, the system withdraws the student. I need to add in a function that allows the user to override this function so that they can allow a student to participate even if they have passed a deadline, but when I try the script I have written, it still withdraws the student as they are passed the deadline. Is there a way around this? Kimberley
Next Page