Read-only privileges
Hi, is there any way to assign read-only privileges to few users without actually canceling editing privileges to other users? If so, what's the procedure? Thanks,
"Click to view data" - not for users?
Hi. If I'm logged in a admin, and I view a bar chart, I can click the bar to view a table of that data. But users don't seem to have this feature. Is there a way for users to have this ability? Or just admins? Thx.
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
Sort dropdown alphabetically - how to sort by Last name and not First?
Is there a way to have a dropdown list sort by a customer's last name and not the first? The order for the dropdown list is: last name, first name, date-of-birth. Keeps sorting by First Name - which works, but doesn't work as well as sorting by last name. Thanks!
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
How can I append item to multi select list with script?
Let`s say I do have a multi select list containing initially "mike", "tom" (from editing field->enter choices). I would like to append "denise" to the same multi select list by using a script. Below code does not append, it erases mike & tom. Any suggestions? Thanks! on add { on load { multi:ui.add("denise"); }
Formula issue
I am attempting to add values out of dropdown boxes and total them up what would be the formula. Right now it just places all the values from dropdown boxes I want them totaled.
Disabled fields overriden in Grid view
I have a field set to be disabled on load (add and edit). Using the 'edit' button the field is disabled. However, if I switch the view to grid view, it shows the field enabled, and I can change the settings. I don't want people to be able to edit that field. Is there a way to make grid view respect the disabled field, or to disable grid view?
New Home Page
We are pleased to announce the new version of our Home Page (Dashboard). All GApps users would have already noticed it. This will be available automatically for all new users who will sign up from today. Existing users can also access it directly - http://creator.zoho.com/home - to test drive it. Within a fortnight, we will enable this home page as the default one for the existing users as well. Apart from the new polished L&F, we have brought all the settings in this page, which the Admins will
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.
Am I able to create a form that will be accessed by clients outside my company?
Would this require a user ID for each client?
Can I filter a view on a 'related field'?
I have included a 'related field' in a view and am using that field in a criteria and I get the 'unable to fetch...' message. So simple, but it doesn't work. See http://help.zoho.com/portal/en/community/?ftid=2266000000144107 Please advise. tt
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?
public
want to acces my database to public
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
How do you have users fill out a survey (form) without having access to the Application itself?
I have a number of consultants who visit a site and need to fill out a site assessment created in Creator. I want them to have unique login and passwords and NOT to have access to anything else but the form they are required to fill out (via permalink?). The main issue is that it seems that access to the form via permalink requires them to sign in using the same login as the administrator which could easily give access to the application, not only the form they are required to fill out. Any suggestions?
How to setup a dinamic view in hmtl?
Hi, Thanks in advanced for all contributions that i may get one this. Well, i read some topics about this issue, but none of them was to clear/self explanatory for me (foreign in English and code prog). So, i have my form INFO to register my paper letters (something like a invoice). My needs: a) That after submit, a html is generated allowing me to print current data that i have submitted . b) That in a view i could have a button or a link on each row that opens a html template with the respective
Being a developer
Hello, i am set as a developer on Zoho Creater and i still cant edit the application any ideas? Nihal
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
I am becoming more and more disappointed with ZOHO
I am currently trying to add new fields to one of the forms in my application. I drag it to the form canvas, type in name and see how it is placed in the form layout. But as soon as I refresh the form design view - the new field is gone! I tried several browsers and they all have this problem. I remember having this same problem half a year ago. I remember reporting this problem (could not find the topic) and I was then told that it is a browser issue. I don't buy it. If that would be a browser issue
Make dropdown field default to most recently added entry
I have a lookup field w/ a dropdown (for Customer) within an invoice-like form. I would like the dropdown to default to the most recent entry so that the user doesn't have to search out the newest customer... I have option enabled to add new entries on the fly (check box for "Allow users to add new entries in XX"), and would like them to populate in the dropdown after being added. Thanks!
Suggestion on Report Builder.
Hi Zoho, The new filter in the report builder is nice! It would be nicer if after using it, filtered results can be printed via pdf as "what you see is what you get". For now printing only follows the original report template and ignore the new filters. Or I missed something? All the best, Edith
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
HTML Views
Hi! I have been using DabbleDB. There you could to make public your custom views. I am testing now HTML Views. I have embedded it in my site. I have made it public. It still requires login access. How can I have the public of a HTML View! Thanks!
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
Problem deleting rows with Rest API
I am posting a request to the REST API to delete a record and I receive a Internal 500 server error as follows: HTTP/1.1 500 Internal Server Error Date: Mon, 02 Jun 2008 18:28:41 GMT Server: Apache Cache-Control: max-age=10 Expires: Mon, 02 Jun 2008 18:28:51 GMT Vary: Accept-Encoding,User-Agent Connection: close Transfer-Encoding: chunked Content-Type: text/html 1f9 <!-- $Id: errorinfo.jsp,v 1.4 2006/11/16 10:49:08 muthumariappan Exp $ --> <html> <head> <style> body { font-size: 14px; font-family:
Ability to hold onto Record Collections across form events. OR ActiveRecord/ORM'ish relationships
Right now each form event (on add, edit, validate, etc), is pretty much it's on sandbox when it comes to variables. I would love the ability to load in a record collection "pointer"/ model that can be accesses across the events. This would cut down a lot on unneeded "state" fields that are pretty much only created to bridge the gap from say an on-add to on-validate. I recommend a "collection" field that works much like formula or just a global name space mixed variable map(). Where you could stick
Limit Autofilter Lookup results
I have a Current_Tasks view which has an Autofilter for the lookup field Customer in the Clients form. The dropdown list for Customer is getting very long, however, because the autofilter lookup returns every single customer we have ever had in Clients. I have tried adding to the criteria for the Current_Tasks view Customer.Inactive ==false, but that does not affect the autofilter. I have added the Inactive == false to the criteria for the Lookup field on the Tasks form, and this does correctly
Tip for quick record lookups.
Here's a little trick I'm using to speed up subsequent look ups of records on a form. 1. Problem.. You've dynamically pulled in a list of records into a radio box selection. You want to use the selected radio button's value to do a lookup on another record (The record you just pulled in). BUT the value in the radio button is something not very unique like a vanity date or a location or something of that nature. This will make getting that record more difficult. 2. Solution.. Embed the records
Filter dropdown based on previous records
I have 2 dropdowns in my form, when the user selects the first dropdown it filters the second one. What i would like to do is autofilter the second list based on previous records, if there is a previous record then the list will not display that option. I have tried many different code snippets from the fourms and the kbase and can not get it to work... Help please!!! Thanks, Damien.
Help with printing from Zoho Creator database
I've developed a catalog of resources using Zoho Creator. It's a merger of a "library catalog" and "resource guide." It includes an item, a description, a URL, contact information, and then a number of columns with specific categories/filters. All of this makes for a very long horizontal screen. My problem: When users search and get a set of results, I need them to be able to print those resources in a format that's helpful. Right now, if you print from the browser window (firefox or IE), and if
Help with combining views
I have managed to automatically assign a unique ID number to related records in different forms (using MaxValHolder). Now I need to combine the related records into one view. In other words, I want to view all records with the same ID number in one view. Is this possible? I currently export into Excel and sort by the ID number to stack related records in sequence. It seems too complicated for a fairly simple database function. Thanks in advance for your help.
Newbie - Sort HTML View Script - Examples?
I am new to Zoho and have just started building an HTML view showing a table of wines listing by rating. Can someone help me learn how to use script builder to sort the table by rating in descending order? I can't do this through the normal table view since I am going to use an HTML view to customize the table's appearance. The code I'm using now (minus the css) is below. It's rendering the table just fine, but it's not sorting, obviously. I have no idea how to add instructions to sort this table
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!!
Next Page