Exporting a view with more than 30 columns
Hello, I know that you cannot view more than 30 columns at a time. I assume that's just a limitation in the web interface, but at the very least, I think I should be able to export more than thirty columns to Excel because Excel doesn't really have a limit on the number of columns it can handle, right? So, do you know if there is a way to export a view with more than 30 columns in a view to Excel?
user shared apps list not updating
I have had a couple of users report to me that their shared apps view does not contain an application that I have shared with them. I have tested this and can confirm that on one test account (where I have 3 shared apps), one of the apps no longer exists but there is still a link and the newly shared app does not appear. I deleted the share on the last viewable shared app and the new app and reinstated them and they both now appear. There is however no apparent way of deleting the shared app view
Are you sure you want to navigate away?
How do I script for forms that users have started to complete/modify that prevents them from navigating away to another page and loosing their progress? Something like... "You are about to leave a page; do you want to save changes?"
Event attendee database - total attendee tally field needed
I am hosting an event - each RSVP form asks how many people will be in their party in a number field. How do I get a total attendee tally? Any help would be appreciated. Thanks, coachbob21 ______________________________________________________________________________ Update - I figured out how to set up a "Total Attendees" report and it works great.
Get me started Please
Hi, Just set-up Zoho CRM and works great. Now trying to use Creator to solve Quoting system and I don't have any coding experience although fairly intuitive. Can somebody help me solve a script to get me started. I have a form called Materials with a field called Product_Description and Product_Std_Cost In my current Form called Modular Component I have one field called Material_1 which is a lookup of Product_Description field in the Material Form. All fine up to here. In my Modular Form
All data is gone
Hi, I changed a field in a form and all data seems to have been deleted from the Creator app. What is the problem and how do I get the data back?
Trying to hide a field
I am trying to hide two checklist fields on Load in a stateless form. The code I'm using is : AvailDate = Availability [((Date_field > zoho.currentdate && Number_Available > 0) && Appt_Date_Scroll != "")] sort by Combined_Date_Time ; appt_test:ui.add(AvailDate.Appt_Date_Scroll.getall()); hide Select_Room_s; hide Select_Product_s; When the appt_test field gets the data from the other form, the two checkbox fields appear. Any Idea's? Thanks!
Create customer in Invoice
Hello: I've read https://www.zoho.com/creator/help/script/create-customer.html but can not get the script to work. I' ve created a script on add-on success in the form. The code is: success message "Datos añadidos correctamente"; cliente = zoho.invoice.createcustomer({ "CustomerName" : input.ApNom, "Email" : "", "BillingAddress" : input.Domicilio, "BillingCity" : input.Poblaci_n, "FirstName" : input.Nombre_del_padre }); openUrl(("https://creator.zoho.com/adminpsicotrade/tea-cloud/#Form:Pacientes_Escolares"),
How to duplicate entries?
Hi guys. I'm new using Creator and this is amazing. Right now I need to duplicate last week entries for each person so they don't need to reenter the same information. Can i do this? Thanks in advance Pablo
Can you update a sub-form without closing main form?
Can you update a sub-form while still in the main form? I what to update a Unique ID number when still in the main form to use in another Sub-form. Mainly just to save time.
Zoho Beginner Exercises and Tutorials?
Are there any exercises for beginners? I am having trouble with the deluge scripting. I have a little programming (Visual Basic 2010) experience, but I am not sure how to use deluge. So I was wondering if there are any exercises for beginners that can get me familiar with Zoho Creator. I already know the basic drags and drops of the tools. Thanks!
Generating a report in ZC
I'm confused as how this works in zoho, is there an example or documentation on how to do something like this? Say I have employees paid by job, where each job is paid by hour. I'm a little lost as to where to create a report like this in Zoho Creator. So I have a form/view like these: Employees --------------- ID Name Hourly Wage Job -------------- Employee (lookup Employee.ID) Time Start Time End Status I need a report like this for each Employee ... where user chooses Month/Year Job TimeStart
Creator stopped sending e-mails?
Hi, I have figured out that creator stopped sending e-mails after the completion of the form that is embedded in my web site? It was running perfectly before 8th Jan. Since 14th it does not work at all. Here is the form https://creator.zoho.com/istanbultangofestival/2013/#Form:Registration_Istanbul_Tango_Festival_2013 Regards... Aydogan
Hide or Show multiple fields
What is the syntax to Hide or Show multiple filed in a form? I would like to hide filed three fields in a form example: hide Service_Type, Street and Notes. Thank you.
300: Stacktrace error
I am looking at a form and I can see the following message "300: Stacktrace:' before the form fields begin and also some more codes at the end of the form "296: 297: 298: 299:". I also can't update the form elements. Can you please resolve?
trying to DeDuplicate using a function
I'm trying to write a function that will help identify duplicate records by using a primary field as a flag. I'm not sure why the following isn't working, any thoughts? void deDupe(date added_time, string city) { pile = List:String(); for each rec in Lead_Master [(City = input.city && (Appointment_Date is not null))] { var = rec.Primary_Phone; if (pile.contains(var)) { for each check in Lead_Master [((Added_Time = input.added_time && City = input.city)
Tab Filtering
Hello, I would like to know if there is any way of filtering on a tab level (rather than view level) I have 23 tabs each for a separate country. Under each tab I have a set of views with data from my forms. There are 10 views in total (eg. General Country Information, Key Economic Information, Key Demographic Information etc.). I might change things on one of the views (to exclude or include certain fields). When I do that I would like this to apply to all my tabs at once - so that I don't have
Tab Filtering
Hello, I would like to know if there is any way of filtering on a tab level (rather than view level) I have 23 tabs each for a separate country. Under each tab I have a set of views with data from my forms. There are 10 views in total (eg. General Country Information, Key Economic Information, Key Demographic Information etc.). I might change things on one of the views (to exclude or include certain fields). When I do that I would like this to apply to all my tabs at once - so that I don't have
Zoho Creator as document assembly app
Hi I want to simplify the creation of contracts for prospective clients. I use Zoho CRM to capture the lead/account/contact etc I use a linked Zoho Creator app to capture the technical specifications of their requirements. Some requirements would be a simple merge field - data captured goes into contract as is. Other fields may be conditional. If one option is selected, then add a block of text to the output (e.g. terms or conditions). Some fields may be dependent (can't choose option 7 if you didn't
Form Duplication on the Fly
Can I duplicate a form using only deluge script or am I forced to manually navigate the creator menus to do so? I want to use a sinlge form as a template and then duplicate it on the fly with code and then populate the fields with data from other records. How is this done? Can it be done?
Question about for each loop
I have a database with following structure: Form1 Name Quantity Flag Name1 30 True Name2 14 False ... The Flag Field will be True if the Quantity is the largest. When I add a new incident the script should check the Quantity if the new one is larger than the previous, then the previous Flag should be False while the new one will be True. In this case a "for loop" with index should be convenient. Please any one give me a hint! Thanks!
Render image in form
Is there any way to render an uploaded image in a form? I'd like for the users of my application to be able to see the photo they have uploaded right in the form, rather than have to submit the record and then go to a view to check if they selected the right photo. One workaround is to use the Rich Text field to show the image, but that looks fairly ugly. Thanks!
Where is the Access Application Button in Creator?
I looked at your guide where you explain to click on that button to start to input data, but neither with Google Chrome nor with Opera I can find that button! The only way I found to access the application to input new data is to refresh the page, return to the dashboard, click on the link to creator and then select the application I want to use. Is there any chance to get that button? Is it caused by an extention? I know it is odd that it happens with both the browsers. Thx.
Create a weekly stock report
I'm using creator to manage the product stock. I would like to make a report that shows how many a certain product are in stock. For example, on week 2 we have purchased 30 hard disk and under week 2 we have sold 5 hard disk and week 3 we have sold 6 and so on, while on week 4 we purchased more hard disks to fill the stock. I recorded the date for each purchase (positive record) and sales (negative record). So in my database it will look like this: Name of product Qt Date Hard disk
Required field only if other field is empty
Hi there, I am trying to add a check on validation of my form. The form enables users to input size and price of products. For the size I have a picklist (dropdown) of available fluid measures (25 ml, 50 ml, 75 ml etc.). This field is called 'Size'. Sometimes, however, the user might not know the actual size of the product in fluid measurements. In that case I would like them to provide a description of the size in a single line field (Operator_Name_for_Size). This is the code that I am using,
Remove shared application which user is closed
Hi, I changed my email and closed my account with the old email. However I have a shared application now it is in my other account. How can I removed this application? Thanks!
What happens when I reach my record count limit in Zoho Creator?
I use the Standard Plan in Zoho Creator. Can you tell me what happens when I reach my record count limit? Will I be unable to create new records? Or will I be charged for records over my limit? I have several people adding records to the database, so I want to know what to expect. Thank you.
Button to cycle trough records in a table
I have uploaded my access application and need to be able to cycle through records in a table using 2 buttons one for next record and one for previous record. Please can someone inform me how this can be accomplished?
Custom search creator database
I am using the it asset manager and I would like to create a custom search on the home landing page. I am able to create a search for a single view but what I really need is to search the enitre database (all views). Is this possible?
Add to existing record based on email unique ID via web form.
Hi All. I'm completely new to Creator and loving it! I'm trying to use Creator to build a very simple CRM and recruitment solution (I've already checked out Recruit). My scenario is as follows 1. User submits registration form on website where their email address should be treated as the unique id (I have step this working no problem) 2. User comes back to website and expresses an interest in a job, Creator should add this expression of interest against the person's record based on identifying them
Special characters
When I do export to pdf file, the data do not write characters č, ć, ž etc.. How can I fix this??
entering data into forms
Hi there- when I upload an access database into Zoho it creates a corresponding form for a corresponding table in access. I only want users to be able to enter into 3 forms and populate 3 tables-how does 1 do this?
Align right only numeric fields
Hello. My default align in my form are left and this is good for string fields. I also have some numeric fields. How can i align only this fields to the right? Regards.
how to assign the value
how to assign the value for the field?
Google Maps
Hi there, I'm a new zoho user and I'm having some problems trying to work out how to get my address from zoho creator into google msps. My addresses are formatted like, field 1: house number; field 2: street; field 3: surburb I have looked through the forums and this looks like the way to do it, but where do I enter this code? do I have to create a new HTML view? if someone could please walk me through how to use the code, that would be much appreicated. ------------ The script uses the
zoho.calendar.createEvent: (a) need API; (b) these events do not appear in Zoho calendar
Hi, I'm a new Zoho Creator user, and am trying to create a Deluge script that will take a date record and a recurrence record, calculate the event repeats from start and end date, then fire off a zoho.calendar.createEvent() for each one. I have two problems: (a) I am unable to find the full API (full set of options) for that createEvent() function; (perhaps the API already supports recurrence, and I could use that). (b) The function runs and completes without error, but no appointment appears in
How to import data from Zoho Reports
I am trying to import data into Zoho Creator from a table within Zoho Reports on a regular basis. Is this possible? Preferably automated, from the onload area of script. Additionally, it would be great if when loading a form, the zoho reports data actually updated a different creator form than the one loaded, but which had information accessed from the form via look-up fields. this thread asks the same question: https://help.zoho.com/portal/en/community/topic/importing-tables-from-zoho-reports-into-zoho-creator
Customized application with locale
Hello. I'm write from Spain. For every form that I make, i must traslate the button (Submit, Reset, Update, Cancel). I's possible to fix this values in spanish so as not to have to change at each. Also, in spanish Monday is the first day of the week. It's possible to fix this value for all the aplications? Regards
Best practices for working with dependent fields
Hello. I need work with 3 dependient lookup fields in a new aplication. Is goog using system field ID to link diferent fields. For example: I'have 3 form Areas, Groups and Subgroups. I have text fields with the names of Area, Group and Subgroup. When i insert a record in group i must select also the Area and when i insert in Subgroup i must select Area and Group. I want have dependient dropdown lookup field so that when i select a Area in Subgroups form, i only can select the group than belong
Import Photos
Hi, Can i import photos (from directory) to zoiho app? thanks in advance
Next Page