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
Connecting data from one app to another
Hi all, Brief snapshot of what Im trying to do: My application is used as a job application. Candidates submit their info and resume via a form. An email alert is sent to the manager assigned to that location We have 100+ locations, each with different managers, each manager with their own email address. The problem that I encounter is that if a manager leaves the company, or is assigned another group or locations I have to edit my script to make those changes. Obviously this is an easy way to
Complete frustration with Zoho Creator
I posted here last week and suddenly started getting Zoho Creator support. That lasted a few days. Unfortunately, each time I talk to someone new and they all have different ideas. Sometimes it works, sometimes it doesn't. I find it odd that since I have been working with them to TRY to resolve the same issue over and over again they somehow manage to call everyday to ask if we are ready to upgrade to $175/month but they don't call back for days on end to resolve my issues. AGAIN I am having
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
Creator Reports: How can I sort the x-axis by y-axis value?
I made a simple bar chart to show the total annual spending on travel for each employee. The y-axis is the dollar amount, the x-axis is the staff member. My problem is that I can only sort the x-axis alphabetically. Instead, I would like to sort the employees according to their y-axis value - in other words, from the person who has the highest spending on travel to the person who has least. Am I missing the easy way to do this? I only see the button for sorting alphabetically...
Dynamic link to amend record in a linked table
I have a view with a couple of linked tables displaying collection/delivery addresses for jobs. I would like the collection field and delivery field to display its contents as a link that opens a pop up window to edit the linked record, in the same way that the default "edit" button does for each record in the view. I have created a formula field in my Suppliers/Destinations form which contains the following code to duplicate the text in the collection name field and turn it into a link... "<a href="https://creator.zoho.com/<username>/cross-dock/Create_Suppliers_Destinations/record-edit/View_Suppliers_Destinations/"
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).
Display Data as Custom Web Page
I created a small contact database. I need to provide password-protected, read-only access so that visitors can only see one record per page in summary format. Is there a tutorial that will help me with this project?
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?
How do I get the app to my site.
How do I get my app to my site.
Question in table form
Hi, Is there any way to format my questions into a table instead of a long list of repeated questions? For example, instead of Subject A: question 1, question 2, question 3 followed by Subject B: question 1, question 2, question 3...can I make a table with Subjects as the rows and the questions as the columns? Thanks!
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
Next Page