disable lookup field with "Show a link to add new entries"
I've a lookup field with the option "show a link to add new entries". I disabled this field on edit on load. The lookup field itself is disabled, but the link to add a new entries is still enabled. In my opinion this doesn't make sense, specially becouse the user can get confused.
Fantastic!!
I just creating a trouble ticket app in 30 minutes! The last time I created one in PHP with a mysql database - it took me 2 weeks! Thank you so much for this. How much space for data comes with this service? shoffman
how to use 'NULL' in a schedule
i would like to be able to email attachments that are included on a record when its updated. the schedule i have setup works fine and emails the attachments. but i want NO email to be sent if no attachment exists in the 'IP_File_Upload' field. currently i have if(input.IP_File_Upload != NULL) { if((input.Currently_With == input.IP_Approver)) { if((input.IP_Status != "IP Approved")) { if((input.IP_Status != "IP Topic and IP File Fully Approved"))
Please need help
I Have a problem with my attachment, when i edit my record on ipad. When i click the edit in my apps view, the attachment didn't show up. and when i update the record, the attachment get deleted. How can i solve this out ??
Pass data from parent form to subform
Hi, I would like to build a control report using the pareant form for general data, like customer, item, etc. and the childform for the control values. The childform is subform to the parent form. For later statistics I would like to pass the ID of the parent form to each childform record that I enter. Could you help?
HTML View > Insert Html not working properly
Dears, on Chrome it is not possible to insert HTML in HTML View now.(Only problem in Script Builder Mode.) It was previously worked but now after opening insert html page and klicking done button nothing happening. Also in opened insert Html page it is not possible to switch between Rich Text mode and Plain Text Mode. Windows7/64 bit I tried ie,mozzilla and chrome. SI I already tried to re-install java. SI I already tried with another computer Any solution offers ?
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.
"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
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'
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?
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
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.
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
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?
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?
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?
Multi Line --> List
Hi, How can I convert data from Multi Line field into a string list (each line in multi line field to one list item)? Thanks for help, Leszek
Dynamically Updating Subform Links
Hi there, I'm having trouble updating systematically updating parent form links according to new subform information. I have a parent form, FORM A, which has the main information about an organization, address, phone number, etc. On FORM A, I have a subform, FORM B, which would contain transaction information. Each transaction contains a ton of information so I want to be able to add transaction information individually without having to go through FORM A each time. Because FORM B is also a form
Image Field
I am creating a database for resources at my school, and am going to enter details such as name, location, etc. I want to enter a small image of each resource, so included an "Image Field", but can not seem to get an image to load. What am I doing wrong? Am I missing something obvious? Any help would be greatly appreciated. Thanks.
Searching creator app via mobile
I developed a creator app with multiples views that have the search function available. When I access the same creator app via my mobile phone, I cannot do a search in the same views. I don't see the search function anywhere. Can you please advise as to what to do since I need to be able to search for records via my phone. thanks, Ray
Search button on the views is not working.
This morning the search button was working fine, then stopped working. I've been trying the search button several times during the day and is not responding.
De- Dups, DeDuplicating, Removing Duplicates, Eliminating Redundancy
Stamp out and obliterate redundancy! I use Z Creator to keep a large database of addresses for a free snail-mail newsletter I use in my marketing. I am always trying to add names of new prospects, delete defunct prospects, and, in general, keep the list clean. I currently de-dup by dumping the list into a spreadsheet, sorting the various columns and using a simple formula to check for possible duplicates (If A2=A1 Print "Duplicate"). I then scan each possible Duplicate and decide to drop or keep
zoho creator
hello I need to know how I can display "product name" when I select their "product code" in a formalaire know that I exrtaire code "Zoho CRM" to "zoho creator"
number format
Is it possible to change the numer format I am inputing times of min.sec.decimal such as 1.01.34 is this possible and how do I acheive it thanks Andrew
Drop downs autofill on subforms question
I have a script on a form called billing form that autofills information from a Form called Add Kids Form and Add Parents Form I understand this does not work on subforms because of some issues and I've read up on it, but I still don't understand how to implement it on a subform. Can you please help me rewrite the code below so it would work on a subform? And please tell me where to place the code. Thank you. the script is: if((input.Select_Child != null)) { rec = Add_Kids_Form[ID == input.Select_Child];
How to parse json string in Creator application?
In many case, zoho.crm functions just return json string, such as: 1, zoho.crm.searchRecordsByPDC 2, saleItems in following code, saleOrders = zoho.crm.getRecords("SalesOrders"); for each saleOrder in saleOrders { saleItems = saleOrder.get("product"); } How to parse json string in Creator?
zoho.crm.getRecords("SalesOrders") bug?？
There are TWO sales orders in my crm, one has TRHREE items in product details and another has just ONE item in product details. I've following code : salesOrders = zoho.crm.getRecords("SalesOrders") ; for each salesOrder in salesOrders { info salesOrder; } I'm confused that why there are 3 records in salesOrders? It seems that there're 2 records for the sales order which only contains one item in product details: one is for the sales order itself, another is for product item in the sales order.
Deletion of Fields
Hi, seems that the deletion of singel records does not work for me as well, as for some other users before me. I check the records, click delete and the loading logo spins forever. any hint? thanks, stefan
Creator: Tables in forms
similar to https://help.zoho.com/portal/en/community/topic/question-in-table-form I want to be able to add values into a table for various categories over a period of time so we have something like this: 2008 2009 2010 2011 cat a <field> <field><field><field> cat b <field> <field><field><field> cat c <field> <field><field><field> Is this still not possible at all ? or can I have something like cat a 2008 <field> 2009 <field> 2010 <field> 2011<field>
html edit & record delete error
Dear team, 1>Free Flow script can not show now. Before it can show. 2>Script Builder for html dashboard can not show with IE/Mozilla/Firefox. 3>can not delete record.
Next Page