example of HTML list view showing data from two forms
Hi trying to final a template example HTML view that will list all records from two different forms that are not child forms. records from each form have a 'name', 'points' and 'status that i will to display in a single list.
Latha Please Help! "Servlet Exception Error"
Hi, I am attempting to make changes to a view and receiving this message when I go to edit the view: [ServletException in:/jsp/edit/view/viewedit.jsp] null'
"User Defined Variables" in Script-builder for Scheduler
Normally when we create temporary variables, they show in the User Defined Variables menu when using the script-builder wizard. This is not the case for the wizard in the Scheduler! John M. Whitney
Share by information in a View
I would like to share portions of an application by information in a View. For example an application may have a list of members that are either Active or Inactive. I would like to restrict access to some sections to Active members. In the share section it would nice to select a View and indicate the column which contains email address. When a member changes from Active to Inactive there would be no need to go back to the share section and change the list of email addresses. This feature can evolve
Second Criteria needed on report
Second criteria needed on report. I have one field which is (field_name1 is not null) which will put it on the report but I need a second criteria (field_name2 is null) to have it fall off the report. Hhow do I show both?
Help with Error Null Message
I am trying to edit a view and I keep getting this message: [ServletException in:/jsp/edit/view/viewedit.jsp] null'
Form view criteria help please
Why wont the following form view criteria restricted records work? Date_Collected is formatted to zoho time field. ((Date_Collected < 'zoho.currenttime')) So in my head this should stop all jobs that have been collected from displaying in the jobs view. Thanks Nigel
Commissions Calculation
hello all, In my application, am trying to calculate the commissions to be paid out to sales people. I already have the criteria for the commission, e.g if a clients purchases product A, the sales persons gets "x". am having difficulties in writing this code; it would run like this: if the Product is A, then commission is "x". Any ideas on this? kind regards,
Embeded Verification
Verification code in my app works fine on the Zoho Creator domain, but after embedding it into my website it doesn't work.I tried it several times with no success. I am publicly sharing the application it's named "TOA Rating Application". Can anyone help me with embeding the app? Kind Regards J.Page
Private database, user authentication
I have several private Zoho db's we use for our company and it's brilliant. The only issue I have is the limited number of user accounts and limited authentication. We have around 60 staff who all use the db and they all share one generic login to Zoho for creating content. Obviously this is a fundamental security issue but I couldn't find any other way around this, can anyone give me best practice for creating a database for a team of 60 staff with user authentication? As a side thought, perhaps
How to archive patient data record?
Hello, I have created a medical database that handles patients. Every patient has a ID created like balasankar Unique ID example. I would like to create a button that would close the patient records, removing him from the "Patient View", and archive his data on a "Archive View". But if the patient comes back I would like the ability to reactivate him back to the "Patient View". Thank you.
Ho do I make a database private and use authentication?
I love Zoho Creator, one issue I'm struggling with is how to use it for my business. We've got about 60 odd staff, all the staff need to access the database but it's got sensitive client information so that can't be made public. Currently I've got all staff using one generic account and they all use the same password so they can view the data. This is not very good, when anyone leaves the firm they still have the account details and access to the database. So how do I do this? What's the best practice
Lost all my data and new data can no longer be saved.
I recently found out that I lost all my data saved under "Job Applicant" which I created under Zoho Creator. As I enter new data and submit, data is not being saved anymore.. what is happening?
Add a Record by Email: File Upload
The ability to add html data (rich text) by email is terrific (see https://help.zoho.com/portal/en/community/topic/rich-text-data-by-email) It seems logical to extend this functionality by also accepting an attached file. There are a number of situations where this could be valuable. For example, accepting PDF contracts, job applications as Word documents, and system logs as text files. In email, attached files are MIME blocks that are encoded with Base 64. Listed below are some typical ones A Picture
Warning for Gmail users in emails sent via Zoho Creator
If you use Creator to send email notifications having at "From:" your Gmail address, the recipients with Gmail accounts will see the following warning on the top of the received message: This happens starting with today. It is not a message such as: "Sent via zoho.com" - but the warning above, which can make the recipient suspect that the message is not a legitimate one. I suppose that it is a change in the way Gmail "reads" the information from the email headers, but I hope that there is something
Need help email notification.
hello all, I would like to enable email notification on a stateless form, based on the following criteria: my application is based on managing the sales task force, I use the stateless form to update the status of the clients that the salespersons talked to. In the form, I do not capture the salespersons email id, but I do have their email i.ds. How do i enable, that when each client details is updated, an email is sent to the sales person about the status of the client, including the details? Thank
Frame tageting is broken again.
Hi. Behavior that has been working for 2 years is now not working. The submit success message is breaking the frame targeting. Use Case: 1) Target a frame using the anchor link attribute TARGET. Like this: 2) Open this page and click this link: Matthew Trouts <a class="_Lnk" target="tskCal" href="http://creator.zoho.com/ensobase/david_bartels/Listings/record-edit/All_Listings/243881000033951289/&zc_SuccMsg=Finished" style="font-weight: bold;">Matthew Trouts</a>3) The proper form loads in the Frame.
How to get current table name in the ZC Deluge?
Hi How to get current table or Form name in the ZC Deluge? Thanks Stanley Guo 2012-2-14
Is it possible to reference a form dynamically in Deluge Script?
Hi! Is there any possibility to reference a form dinamycally using string literals? Something like this: Form myForm = zoho.getForm("App", "FormName"); myRecords = myForm["Foo" == "Bar"]; It would be fantastic!
Cannot delete record
I have 2 forms: "EP Configurations" and " EP Core and Menu Default" I added lookup filed "EP" to " EP Core and Menu Default" from "EP Configurations" - > field "ID". Later I decided to get rid of this field. (I deleted it) Now, If I added new record to EP Configuration, and then try to delete it, system hangs forever. The only way I found to delete this record, is to create "EP" lookup field again on the " EP Core and Menu Default" screen I shared the application, you can take a look "EP
Help with Date calculation
Hello all, I would kindly like to request for help in writing a code that does the following: On my form, I have two date fields, 1 with the date, the client makes an order and the other when the client is to make a payment. I would like to do the following: within 14 days, of entering the 1st date, the second date should be updated i.e the client should make the payment, if not then send an email to the client informing him/her of the due payment. If however, within the 14 days, there is a payment,
How can I have Zoho Creator Data automatically entered in a Zoho Docs spreadsheet?
I set up a paypal payment through zoho creator and would like the info (conditional to choice made in a drop down box) and payment amount automatically entered to a zoho docs spreadsheet that is embedded in a private page so customers can see their balance in real time as payments come in. Does anyone know of a quick way of getting this done? Any help would be appreciated.
Newbie Q: linking tables
I really am a newbie with this and I am struggling to follow the way all the parts connect. First of all I wonder how tables are linked or for that matter constructed? I gather that forms are the basis of tables and views are used to display the data. But really I want several forms to send data to one table and I need some data to be created automatically, for example an ID field. Then I need to link tables, for example that ID field. I have a whole lot more questions but to start perhaps this will
Print Button?
I'm wondering if there is anyway to add a "Print" button at the bottom of a created form that will be embedded in a website? I'd like for people to be able to print the form they've filled out before hitting submit or have it automatically print when they hit submit. I'm not good with code or script so if that's what I need to do, help would be appreciated.
Zoho not working
Cant get access to Zoho Creator, are the servers down. Please advise as I cant work.
Printing one record per page
I have a view with a list of customers and products. I have grouped products by customers but now i'd like to print the list in defferent pages for every customer. is this possible?
Fix this please. Form does not show up.
OBR Consumer - Business Management Application shared. Form name: Business Order I can see the back end, not front end. I need this fixed asap please. Thanks
Can't copy or duplicate application
The application won't copy or duplicate, which of course is necessary to test it.https://creator.zoho.com/utl_la_rochelle/adherents-utl/ Can you help? Thanks so much Joël REMAUD Webmaster jremaud@utl-larochelle.org
Recent Improvements
I am sorry to say, but the recent improvements made to ZOHO Creator make it a lot harder for me to keep my data updated. The "locked in place" Add, Search, etc. force me to have all columns showing regardless of how wide the view is and regardless of what columns I am changing. I believe it used to float to whatever size the view was, or at least should. I cannot now find the "global" changes option to selected rows. I no longer see the number of records.
An instance for .contains() fails for .getall()
Re-posting my comment from here as a bug report: https://help.zoho.com/portal/en/community/topic/more-fun-with-lists I was testing the ability to fetch a collection of records as a list using List_B = {"c", "e"}; List_C = (DATABASE[(List_A.contains(List_B .get(0)) && List_A.contains(List_B.get(1)))].ID).getall(); I made a test app for support that uses this exact same functionality: https://creator.zoho.com/niskypto/list-test-2/# Use the "Select" form to enter two elements. You will find the alerted
Start a New Page for Each Record When Printing From Summary View
How can I start a new page when a new record starts if I am printing from summary view?
Problem with hide/disable of subform field
I have the following statements in the on edit on load section of a form hide Order_Actions_subform.Courier_Count; hide Order_Actions_subform.Owner_Count; They work as expected. However when I switch to scriptbuilder mode the statements are converted to hide Order_Actions_subform; hide Order_Actions_subform; Which hides the entire subform! Herb Wexler
How can I pass a value to restrict a picklist from a subform when adding a new record to the lookup form that populates the picklist?
For instance if I had a main form that contained the field "Country" 1. and a subform in which I needed to add a new entry into one of the subform's field's picklists 2. and the lookup form that populated the subforms picklist had both a "Country" and "City" field, 3. how do I filter the lookup's "City" field by the "Country" selected in the main form? Or in other words how do I pass a the "Country" variable value 3 levels deep to the lookup field. I can easily do it if it's a lookup for a field
Multi Filter multiselect
I am currently developing a resource manager for a group of shops and would like suggestions on how I can filter a 'Multiselect' field using a Lookup picklist listing area managers. I have 4 affected zoho creator forms. resource_form Field: available_to (lookup populated from shops_form[shop_name]) shops_form Field: shop_name (simple line text) Field: area_manager (lookup populated from manager_form) manager_form Field: name (simple text line) order_resource_form Field: multiselect (populated with
Zoho Deluge Script documentation--many images are broken!
Hello, I first noticed this last week, and it's gotten worse. The images for many of the deluge script documentation pages are broken. Examples: https://help.creator.zoho.com/Defining-a-Function.html https://help.creator.zoho.com/Invoking-a-Function.html https://help.creator.zoho.com/Delete-Records.html Many of these images are directed to "/attach/1.0/Deluge-Reference/" I've noticed that the -working- images are in "/attach/1.1/", but trying to get broken images by that rename isn't working for
Form list is not in alphabetical order
I have so many forms that I've had to go to a naming convention, however the entries are not in alphabetic order. How do I fix this? App is CIC Reports and it has edit access
restoring yesterday's accidental loss of data
Yesterday I was working on my application containing over 150 records and hit the restore button accidentally. How do I go back to Feb. 6, 2012 records?
ADD / Remove modules
hi..is that possible to rename the main modules like FORM, VIEW, and add extra modules ??
Could allowing email notifications upon form submission make my email address public?
I saw an increase in spam to my email address after allowing email notifications. Could email notifications make my email address public?
Dynamic picklists. Field selected vs field visible in form
Hi, when using Dynamic pick lists, how can I populate the pick list with say, IDs form the applicable records of the target list, and yet see other field in the pick list like name for instance. In other words I wan to emulate what the default picklist field does in a form. you link to a field but can see other field/Fields. I want to link to IDs but wan to see name. thanks for the support, application details below My application: Sistema de Operacion Yaxche Form: Productos Cotizados Dynamic Picklist:
Next Page