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
How can I search a field using Boolean operators?
Hi I'm developing a bookmarking application using Zoho and a central piece of functionality is to be able to search the bookmark tags field using boolean operators, e.g. contains TV and RADIO but not PODCASTS. I'm astonished to find that (given Zoho Creator is a database creation application), this doesn't seem possible. It's not possible to execute the search via the GUI (I can only search for one tag as it doesn't accept boolean operators), and I can't execute the search via a stateless form and
How Can Users Enter Data and Choose to Share or Keep Private
Hi: Zoho Creator is great! We are creating an private application which will have about 50 users. We would like to keep the application data private (not viewable by the public), but allow our users to enter data. We would also like our users to choose whether to keep the data that they enter private only to themselves, or to alternatively choose to share their data with the other users of our application. Is this the kind of thing best done through a script? Thanks!
Seeking help to customize inventory app
I am new to Zoho and am not a highly techie person. More of a fairly sophisticated end-user. I have worked with MS Access but now require an application that is available for inventory control over various locations. I downloaded Danholmer Anderson's app and have no idea where to start with making it right for my organization. Any suggestions?
Added_User == zoho.loginuserid in Set Criteria Does Not Work
Hi: I am trying to create a view that shows only the records added by the particular user. I found that you are supposed to use the Set Criteria feature with Added_User == zoho.loginuserid, but when I configure it that way, it returns no records. Does anyone have any suggestion what might be going wrong here? Thanks!
Report to View Personal User Data Only
Hi: In Zoho Creator, is there a way to create a report to view only the current logged in user's data? Thanks!
Need Help: Sorting records by Date is not working -- ?!
I have a simple form that includes a date field. I'm populating a checkbox list with records for the user to choose from. The code below shows that I am fetching the records and sorting them by date: clear Choose; rec = Workshop_Descriptions[ID != 0] sort by Date_of_Workshop; for each r in rec { Choose:ui.add(r.Workshop_Name+": "+r.Day_of_Week+" "+r.Date_of_Workshop+" "+r.Start_Time+"-"+r.End_Time+" [ $"+r.Price_Per_Workshop.round(2)+" ]"); }But, the output is not sorted by date! The output is:
Zoho Creator outage?
I'm trying to add some fields to a form, and when I click on the "Done" button in the dialog box, nothing happens. I've had this happen before, and I think it was server outages on Zoho's end that was causing the problem. Is this the case again? Thanks.
How can I set up nested categories for a bookmarking application?
Hi I'm trying to create a Bookmarking Application where information about each bookmark can be stored, i.e. Title, URL, Favicon, Screenshot, Description, Tags, and Category. And I'm having difficulties with the last of these. I want the user to assign each bookmark to just one category which in turn may have one or more sub-categories, e.g. Computing>Internet>Online Storage On the main bookmark entry form, I only want the top level category field visible, with subsequent sub-category fields only
Inserting New Record from a Stateless Form
I have a stateless form with a button designed to add multiple records to another form based on values populated on the stateless form. When I click the button I receive the Error "Error occurred while executing on click script." The script appears to be correct and I can not determine why I am getting the error. Here is the script: for each steprecords in Steps [Process == "T&D - Backlog"] sort by Step { insert into Processing_Details [ Added_User = zoho.loginuser Authors
Very Slow Again
We are having issue loading Creator forms and view again. This is effecting both niskypto and sigroup accounts. And there's also this: John M. Whitney
form creation help
I'm trying to create a form I want phone_type to be hidden on page load and I want it to show only on user input from phone_number field. I want phone_type to show up when some one enters their phone number, but when I click save script I get an error on part of the form that I didn't even modify (see picture) what am I doing wrong. the code that I used I got from zoho website, http://help.creator.zoho.com/Hide-and-Show.html, number 3 the blue highlighted word, on line 64, in the picture is Webpage
Getting odd <For input string: ""> error trying to compile HTML view -- CANNOT SAVE SCRIPTS
When attempting to Save an HTML View, I have been getting the following error almost immediately: The problem is, this error is appearing with nothing wrong with the script... I just load the script, make a minor legal change and the error pops up. This error and some other odd behaviors of the system tonight make me suspect someone's tinkering with things on the server back-end. I cannot compile my scripts until this is corrected. It's Sunday night here, so I wonder if anyone else is experiencing
Client API does not load
Please, I need some help: I'm trying to integrate a form ZC public into my Webpage using Client API. But it loads only the buttons submit and reset. What am I doing wrong? Note: when generating a permalink, instead of appearing the encryptedLink, theZC adds "ZC_PUBLIC_REQUEST" in the URL. Below is the html code of my web page (public url: eciclo.trendimoveis.com.br): <html> <head> <script src="http://creator.zoho.com/appcreator/js/jsonform.js" type="text/javascript"></script> <script scr="http://creator.zoho.com/eciclo/form/json/11/ZC_PUBLIC_REQUESTED"
Next Page