Why Import Data link is hide to shared users?
I would like to give permission to shared user to import data into one specific view. What I have done are: 1. In share Tab, the specific view (and form) are shared to one user. 2. In the view configuration, the permission to the specific view has been set to "create,edit,delete allowed". But still the user could not see the "import data" link under his "more actions". Is this functionality supported? If yes, how to set the permission properly. Thanks, Gino
Attachment not sent with Schedule for email
I have "email attachment" enabled in a schedule... but the attachment files are not sent. I have opened access to Support for this form: https://creator.zoho.com/lifengwu/moviesvillecom/#View:documents_View
reporting limitation with multi select lookups
Hello Is there a way that someone has sensibly worked around the above limitation an can offer some advice. I can't see I can avoid the lookup requirement and so that really needs to stay. At the moment I'm exporting out to excel but I'd rather just keep it in the app. Cheers Simon
Registration mass send email to members
Hi I just startet using creator. I have created a table with all our members name and email addresses. Are there any smart way via creator that I can send a mail to these members?
Sub forms
Hi can you help. I currently have to click add on the sub form and add the details manually. I already know when I want the sub form entry to be based on other criteria. Say I have 2 fields in the sub form. What script can I use on a field action in my main form to automatically click the "Add" on the sub form then fill in the 2 fields for me. Thanks Nigel
calculate age based on two date
Hi, I have 2 entry Entry A = Date Entry B = Date How can I calculate age from these two entries (Age = Entry B - Entry A) Thanks
Creator is Faster with Chrome latest versus FF latest
Just me or does anyone else notice this Chrome latest edit, views, all seem to noticeably faster than FF latest
Headers and Footers in HTML
Hello everyone, Just wanted to share something I have found, using the following link / code: http://www.w3schools.com/html/html_layout.asp I was able to create headers and footers which you can use to make professional PDF files for customers, etc. A few people (myself included) have been asking how to do this, and the above link is the code that you can use to do it :) Feel free to ask any questions if you need some help Many thanks Ben
Criteria matched value to show up in drop down automatically
Hi guys, Kindly help me for following things.. 1) When I use lookup filed, the value that matched with criteria (only one value) cannot show up in drop down automatically and I need to choose again for this value. How can I overcome this ???? Please refer me for sample script. 2) And can I pass parent form's field input value (From Look Up field drop down) into sub form and also vice visa. ??? BR, zzw
counting months in irregular fiscal year
If anyone out there knows of an elegant way to count the number of months since the beginning of an irregular fiscal year I would really appreciate send that gem my way. I had an app all ready to go for a client that assumed a regular year of Jan1--Dec31 and used the basic .getMonth( ) date function to generate a number count since the beginning of the year for a given date. Then, the client informs me that oops...their fiscal year is May1-Apr31. Now my app formulas must be changed to reflect this
Refresh a Show and Hide expression
Hello, I have the following script: if((input.Order_Type == "Diet")) { show Choose_Diet; show Diet_Description; } else if((input.Order_Type == "Medical Equipment")) { show Medical_Equipment_Type; } else if((input.Order_Type == "Medication")) { show Medication; show Dose; show Frequency; } else { hide Choose_Diet; hide Medical_Equipment_Type; hide Diet_Description; } This seems to work, but when I am in the form it only works one time. I think
need help changing URL on created application...
company change name and old URL has old name...can it be changed?
Creation date
I want to add a column to my ZOHO Creator databases that will automatically enter the date a record was added or modified. Only need date, not time.
Two Forms Using Common Database
Is there a way to set-up two forms that use a common database? Example: Form 1: Application for Employment Form 2: Employee Database I would like to have both forms populate a common database. Thank you in advance for your time and assistance.
2 forms (light and big) for one entry in creator. how?
Hi! i just make one big form (20 fields) for working by manager with clients data (clients orders) in creator. how can i make a lighter form (5 fields) which client can populate for data via web-site. this populated on web-site data my manager will be manipulate via big form. so, light form - for web-site, for clients data at first, big form - for manager, for working and adding more data after processing client's requests. how can i do this? thank you
Jquery datatable not saving state first time round
Hi there, Has anybody experienced an issue with Jquery datatables whereby the state of the table is only saved on the second attempt. For example, I press a button on the page which takes me to another page. When I go back to the page with the table, the state of the table should be the same as when I left it. The problem is, it only saves the state on navigating away from the page for a second time. Here is the code for my table: $(document).ready(function() { $('#data').dataTable({
"More actions" in embedded page
Hello everybody, I need to create a customized web & DB for a client and this obliges me to use the embed function, as my client needs a personalised URL, a header with his logo, contact info, etc. on top of the DB Everything seems perfect, but now I found out that the "More actions" menu is not option in Permalink/Embedded and I really need it so my client can export his DB, print it, etc. How can I sort this out?. Best regards and congrats for offering such an excellent product.
Lookup Criteria
On a form I have a lookup to another table. I want to omit records where a string field is longer than 5 characters. When I add this code to the criteria section of the lookup field Str_Field.length() > 5 I get this error Either the left or the right expression in a boolean expression in the criteria has to be a Form/Table Variable What steps do I need to omit these records? Herb Wexler
New User instruction
I am a new user, are there any instructional videos taking you through the basics, I will predominently be using the SFA features and so am interested in creating call backs, reminders and possible mass emails
Hide / show fields with conditions
Hello; I want to hide some fields with conditions, for example, if the user choose ' No answer', some fields don't appear, I feel very lost in functions, since I'm a novice. Another thing, if the user types '2 'in the field ' number of children ', two fields will appear for each child's name and date of birth, how can I handle this action. I'll be very grateful. Thank you very much.
Sendmail to picklist
Hi, I'm unable to find an help in this forum and in sampleapps. I have formB with list of employee and formA with subform for uploaded document and a picklist lookup field with email of employee showed as name of employee. I need to do the simply action to send in attachment (as link) the uploaded doc to the employee selected in the picklist. I look for it in the iterate https://help.creator.zoho.com/Iterate-Records-in-a-Form.html and https://help.creator.zoho.com/Iterate-Data-in-Radio-buttons-and-Checkboxes.html and
criteria for View Add button.
I'm using an openurl command with criteria to open a view so a users only sees records that are relevant to them. Is it possible to feed the same criteria to the Add button? In other words when they click on the Add the form is prefilled with the same criteria used for the view.
View with Time Criteria from 18:00 to 6:00
I am using this Criteria to View Records created TODAY (Added_Time > zoho.currentdate && Added_Time < (zoho.currentdate + '0W:1D:0H:0M:0S')) I need to create a view for Records created from 18:00 to 6:00 of next day - but is not working .... This is my sentence .... could you please correct it (Added_Time > zoho.currentdate && Added_Time < (zoho.currentdate + '0W:1D:0H:0M:0S') && ( Added_Time.getHour() > '18' || Added_Time.getHour() < '6' ))
Auto Filter Limits
Is there a limit to the number of items that will appear in an auto filter drop down box. I have an auto filter set up on one of my views but it is missing the most recent items that I would expect to see at the bottom of the list. If there is a limit to the number of items that will appear, and if so how to I restrict the list to show say the most recent x number of items. Thanks.
quotation using zoho creator
Hi.. currently i'm using Zoho Creator to create quotation.. i'm using Subform to add few of my products to one quotation as below.. After generating HTML & PDF, instead of showing all products, it only show my last product as image below.. any ideas to solve this problem? thanks..
why cant i get my numeric fields to line up under my column headings?
please help!
For in deluge
Hi, anyone how traduce FOR java condition in deluge script? Thanks Mic digitos_iguais = 1; if (C_digo_Fisca_CPF.length < 11) { return false; FOR (i = 0; i < C_digo_Fisca_CPF.length - 1; i++) } if (C_digo_Fisca_CPF.charAt(i) != C_digo_Fisca_CPF.charAt(i + 1)) { digitos_iguais = 0; break; } if (!digitos_iguais) { numeros = C_digo_Fisca_CPF.substring(0,9); digitos = C_digo_Fisca_CPF.substring(9); soma = 0; FOR (i = 10;
create list of form names
Is it possible to generate a list of the names of the forms and views in an application? What I want to do is create a software request form for an application with about 50 forms and views. When the user wants a change to the software they go to the form and specify if the change is to a form or a view. Depending on the response they are then presented with a list of the Forms or Views in the application. I can manually create the list but it would be nicer if there was a way to do this in a script.
Best way to Control (delay) selected Scripts On Load
UPDATE: I had posted the topic below the stars earlier and now found a better solution. It was simple, really: For the key fields that need to load "first", create a "partner" field that is filled upon load with the same value as the key fields. Then use key field On Update script conditional on key=partner to trigger the filling of the other lesser fields that needed to be filled "later" . Then add partner="" to the On Update scripts for the lesser fields. ********************************************************************
Can't ex[prt all data
I cannot EXPORT data from a database that has in excess of 30,000 records, yet I can in one that only has a few hundred. If there is a size limitation, how do I break apart the large database ? Is this the problem ? I have tried using both Firefox and IE 9, and get the same results each time, only the column headings and one record will be in the XLS backup.
Synchronize Zoho Creator and Zoho CRM data
What is the best way to synchronize data between Creator and CRM ? Here's my plan, but I'm open to something better. Export data from CRM and import in Creator Add a script in Creator (on add/on edit) to update data in CRM Run a daily schedule in Creator to bring back updated data from CRM in Creator Thanks for your input Pascal Veilleux
Passing an html parameter to an embedded form
I have an embedded form to which I want to pass a html parameter. A page "test.html" includes <iframe height='500px' width='100%' name='zoho-Student_Web' frameborder='0' allowTransparency='true' scrolling='auto' src='https://creator.zoho.com/<user>/<app>/form-embed/Student_Web/Arg1=xxx'</iframe> I would like to call test.html&Arg=<string> and pass the value of Arg to the embedded form. In other words substituting xxx with the dynamic value passed to the html page. I've tried all sorts of options
Style the form field label and Passing data between forms
Display name or form field label Can I apply a style on the form label programmatically? Passing data between forms Normally values can be passed through URLs, is there a way to pass it by POST to another form?
Email new and modified records to user
Trying to set up a custom task environment. Would like Creator to send an email to my employee whenever a record with their user id is created or modified. The employee id would be a look up on a user file which stores their email addresses. Help on this is appreciated! Thanks Peter Forman
Set View Width
Is it possible to set the pixel width of a view without embedding it within a table in an HTML view?
Exclude items from picklist
Using the help center I was able to create a dynamic picklist that I am very happy with (and proud of )./ Well, now I want to take it a step further. As it stands the dynamic picklist will display cities based on the selected state. I want to be able to exclude certain cities. This is used to manage our company locations. I created a drop-down field named "Active?" with the choices "Yes" and "No". I want any record marked "No" to be excluded from the list. How can I do that?
Single Record
Is it possible to email or print a single record in a summary view?
File management
I developed a form which purely manages files only. I use this form as a subform for variour other forms, so a master record in an "inventory" table is related to say, 5 image files...... The problem is, the file loads to the Zoho servers are not always successful!!!!! and it's slow some times. And it's expensive to store files on Zoho servers. .... where I can care less if it's a good solution.
Work Hours in a Month
Just sharing a function I made to calculate the number of work hours in a month. It takes the input of a MONTH string (1 to 12) and does the rest based on the current year. MONTHS={"Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"}; this_MONTH=MONTHS.get((input.MONTH.toLong() - 1)); DATE_STRING="01-" + this_MONTH + "-" + (zoho.currentdate.getYear()); DATE1=DATE_STRING.toDate(); DATE2=DATE1.addMonth(1); DAYS=((DATE2 - DATE1) / 86400000); HOURS_LIST={1, 2, 3,
View Recorded Data in Form Layout
Is "form view" an option?? I don't seem to be able to find a way to view just one record in the form view. It would be nice if I could see the entire record on one scree/view and then hit a button that said next to view the next record. I would also like to be able to edit the record in this view. Surely there's a simple way to do this that I'm overlooking??
Next Page