Mi Zoho Creator is missing !!
I entered in my Zoho Creator page. All gone !!!. My apps are gone. There is nothing on my page. It is completely empty. Please help me. All my information is missing.
Marketplace Client Publishing
In Marketplace, if you Publish an app to a client with data and source code, can they then create a copy that will "live" on independently of the original app. Will the copy have full editing privileges as if it were created by the client? Will the copy lose any functionality if the developer closes their Zoho account? The reason I ask these questions is that I need to move an app from its original account to a second account and the ds file I created from the original account will not import into
How to reference subform data (pre-fill from existing data)
This sounds like it should be fairly straightforward - I have a form that has a subform which is filled out. A second form pre-fills in data from the information submitted. I can't use this older information to fill in the subform in the new form. (other fields work perfectly fine) I've tried: z2=FormName [ID = IDofOld].SubformName; And this returns the IDs of the subform. If I just set the subform in the current form equal to the z2, I get an error when running the application saying: Error Executing
ds file import problem
I can't get a ds file to import. The ds file has many lines...could there be a limit? I get this error: There was a problem importing application null. The ds file was created as a back-up of an application in an account that I own, but that is different from the account I want to import it into. Is it possible for Zoho reps to make this move for me? Would it be worth a try to put the app on marketplace temporarily just to get it moved over to the other account?
Images in HTML page and ZC Form viewable in Google not shown in Yahoo
Hi, Images in HTML page and ZC Form viewed in Google but not shown in Yahoo. Could anybody have idea on how to fix this? Thanks, Lagromac
Why is Zoho making a "secret campaign"?
Why not tell the user that "if you display zoho banner in your website, you will have this incentive", like others did, 30% when there is a sale from a click of the banner. I embedded an HTML page in my website, without my knowledge you put this anywhere, in a image or in a text, https://www.zoho.com/creator/online-form-builder/index.html?utm_source=Zoho_Form_Embed&utm_medium=view_footer&utm_campaign=ZohoAds This result to destroying the layout of images when in live mode or forcing the user to open
How to get singles purchases from a list of tickets.
Hi.......struggling this afternoon. I have a list for 24500 tickets sales. Each sale has a customer number which relates to the customer who bought it. A customer may have bought more than one ticket and there will be a record for each ticket sale. What I need to find out is how to filter or create a new view where I can see the customers who have only purchased once. The best way I have thought of is to find a way to filter the view so that I only see customer numbers that have just one record but
Empty deluge field name (problem with cyrillic)
I'm create field in the form (date type), and fill the name of field using cyrillic character. ZC automatically assign cyrillic name to field deluge name and save changes ... After that I have no access to this field, I can't backup app, I can't download app to my computer. In form definition it looks like empty name: "" ( displayname = "Дата выполнения" type = date width = 130px alloweddays = 0,1,2,3,4,5,6 ) but i can't
More Details button not displaying in the view?
In the help documentation or on these forums, someone showed me how to create a "More Details" button with the class "zc-formbutton" that displays in a view. It allows you to hide columns in a view, but then easily display that data again when clicking on the More Details button and loading a summary view tied to an ID. Anyway, I've used this successfully many times before. However, I just copied my old code, pasted it into a new project, but now it's not working. I'm not sure what's different this
Access to main form fields in subform script
Hello. I have a SubForm called Tasks into my main form. Every time i insert a record in this SubForm, i want to insert one record in another form. The problem is that i need 3 field to do the insert and 2 of these fields are in the main form. How can i access to this fields?
script builder for each on a subform "input." is missing causes save error
Hi maybe me not sure, use "for each" from script builder select a form which has a subform (in case it has to do with the name of the subform mine is called v3_Booking_Form) the dialouge box opens and you see input.v3_Booking_Form then u select it but input. is not present in the written script and it fails to save, you u then go free flow add the word input. and it saves
Create A JSON Request
Hi all! I need to use postUrl function with JSON request parameter like this: { "kind": "fusiontables#styleSetting", "tableId": "TableID", "styleId": 1, "markerOptions": { "iconName": "small_yellow" }, "polylineOptions": { "strokeColor": "#ff0000", "strokeOpacity": 0.5, "strokeWeight": 2 }, "polygonOptions": { "strokeColor": "#666666", "strokeOpacity":
Merge data into Word or PDF
What are the methods available to merge data from one or more tables into a form template that results in a Word or PDF document that can be saved and/or printed? It appears that the only way is to create an HTML template to do this. But how do I get from the resulting view to at least a PDF document?
Form verification code works when accessed on Creator URL but not on Custom App URL
Works here: https://creator.zoho.com/yagain.v/enroll# But not here: http://enroll.360hvpl.com/# Anyone has an idea? -Varun.
subform box dimensions
Hello, I have a problem when I put multiselect boxes in a subform, where I edit the dimensions in form it´s ok and the layout is good, but when I see the fields in the subform the dimensions are wrong. How can I force dimensions settings?
Command to Hide/Show (ALL Fields on Form)
Hi, I've noticed it gets extremely cumbersome to hide or show fields in forms which have 30 fields or more. Could we have 4 commands, Hide(all) Show(all) Enable(all) Disable(all), much like Deselect.all for checkboxes. This makes coding much neater and simpler. Instead of hiding 25 fields, we'd rather hide all then show the 5 we need. Anyone else need this? I hope you can come up with a solution please. Thanks in advance.
Conversion from Personal to Domain Account?
This is probably just a simply oversight on my part but I'll post it anyway. I have a Google Apps integrated Zoho Creator account and I'm trying to convert it from a Personal Account to a Domain Account. I'm using the instructions provided here http://www.zoho.com/creator/help/general/zoho-creator-for-your-domain.html#Account_Types, however when I click on Settings|My Account I don't see the page reflected in the documentation for verifying domain ownership. What am I missing?
reporting on values calculated using formulas
I have a form that includes two user-entered number fields, RSVPs and Attendees. I also have a formula-based field that calculates No Shows as (RSVPs - Attendees). The problem is that I want to create a report that shows, for each site, the total number of RSVPs, Attendees, and No Shows, but Zoho is treating the No Shows field as a text field and thus will not allow me to sum the values. This makes no sense to me, since it's clearly calculated from two numeric fields and can only be a number. Is
Creator AutoNumber Edit
I need my records to be auto numbered sequentially. However, my staff deleted some records so now the ID number reads 117, 119, 123, 125 instead of following continuously. Is there any way that I can edit the auto number to include the number that were deleted. Every time a new number is created it starts from the last generated auto number. Any assistance?
how to get accounts contacts and products details
accountlist = zoho.crm.getRecords(("Accounts"), 1, 200); ac = List(); for each accounts in accountlist { ac.add((accounts).get(("Account Name"))); } we want to get account related products and put those product names in accounts related contacts/lead. so how to get accounts related products and put in accounts related contacts multi select field
How to set criteria to reports in zoho creator
Hi, Is there a way to set criteria to reports throught URL ? I need to dinamically filter data that are shown in the report based on particular field. Regards, Christophe G.
Row Color Formatting in View (Question Re-asked)
I would like to format the color of a row (Red, Yellow, Green Stoplight Report) based on a due date. I saw an old post from 2009 and there wasn't an answer. Just wanted to see if someone had found a solution for this?
Missing field on left toolbar in a pivot table ??
Hi, I added a column in one of my view. Then I created a new report (pivot tbale). But i can't see the new field on my left toobar... Thx for your help ugo
Can not make appliation public
I can not make an application public. No matter what I do it reverts to private. This happens on the application, on forms, and on reports. There just seems to be no way to make these public. It used to work with no problems but since the new editor was added I have had nothing but problems.
Back in progress
Hi, Under the back up in progress screen, I can see an application that failed. Is the back up still running? Otherwise, should it be in previous run screen? My administrator is worried that it may still be running in the background. Can you clarify? Thank you
Where are the list of functions?
https://www.zoho.com/creator/help/script/built-in-functions/built-in-functions.html this link doesn't work anymore. what gives?
Field value in e-mail notification not what is present in Creator/Form View.
I'm creating an e-mail on success of a form and all looks good besides a few fields where I'm having difficulty. I'm sure all the fields im having issues with are all related fix. Example E-Mail Code: <%=input.Contact_Person%>, This e-mail confirms our most recent order. ________________________ The issue is the e-mail sample i'm receiving comes out like this: Example E-Mail Sample 1267173000001045015, This e-mail confirms our most recent order. __________________________ The field reads in ZoHo
Distinct Value
Hi All, I am trying to create dynamic drop down list in my form. Form : A - Location =============== State City Area Zipcode. The nature of the form is, all 4 fields altogether will give you unique value. But for a given column, it will be duplicate value. (ex: one state may have many cities, one city may have many areas etc..) Form B: Blood Bank Register ====================== For this form, I need to create State, City, Area drop down list dynamically. I have created simple drop down fields. State
Lookup
Hi everyone I'm hoping that someone may be able to help us with this question. We currently have a list of customers and a list of service codes. In a form we choose a customer name and then choose a service code for that customer. This may look like: Name: John Smith Service Code: 55P662 We have another form that uses the name, but different pieces of information. We want to be able to select the name of customer (John Smith) then it automatically show the service code entered in the other form.
URL Filtering by lookup field in view
Hi all, I have a simple lookup field in a form. The field name is Entity_ID and the main form it references is called Entity. I need to filter this view by Entity but seem unable to do so. Previous suggestions include something like #View:test_view?Entity.Entity_ID=8888888888888 This has no effect and does not filter the view. I have also tried #View:test_view?Entity=8888888888888 This yields a blank view. Any ideas as to what I am doing wrong? Previous post would seem to indicate this is the
Can't edit after saving a new view??
My shared users can't edit after saving a new view. They can edit fine from one of the views I created with the app. But if they then re-sort, hide-columns etc to customize the view, then save it under a new name, if they then click to edit a record, there is an error message that says "there is no such form in zoho creator" and the app locks up. Please advise? Thank you very much.
Serious issue with old app builder: Freeflow script editor wipes code
Hi, I'm experiencing a curious issue. I'll 'save' a code segment using the freeflow script editor (in the old app builder), Zoho will say 'Saved' but then when I click back on the 'On Input' script, all the code is gone. It seems like the script validator is faulty and does not show errors when I click save. It's very frustrating as the first time I did it, I didn't realise and lost about 50 lines of code. Now I'm aware because there's a telltale sign: the dot next to the input field shows as grey
permalinks for reports
When I generate a permalink for a report, it seems to create a static snapshot -- that is, only the data in Zoho at the time the permalink was generated appears; the report doesn't update as new data is entered. Is this correct/expected?
Formula field with Child dependency
I have two forms, Clients and Attendance. Clients has First_Name and Last_Name fields. Attendance has Client, Date, and Status fields. The Client field is a lookup of Client.First_Name + Client.Last_Name I want to add a formula field to my Attendance form to combine Client.First_Name + " - " + Status If my formula is; Client.First_Name + " - " + input.Status 'Client' is a lookup field and child fields cannot be accessed Clients.First_Name + " - " + input.Status Variable 'Clients' is not defined
Current E-Mail Notification Suggested Best Practice
Currently, we're using the new application builder. The help documents reference going into On Success in the builder to use deluge. But I also see the email notification on the new app builder form settings page. From the way I see it, if we want simple form submission on success, we can use the form builder settings area. But if we need more advanced, we should use deluge. Is this correct?
Inventory Database
I added trucks to my inventory DB. Now I want to be able to subtract the Part used from that truck, and update the total in my inventory. Presently it just subtracts when personal uses a part. I have a script below. I am trying to picture this script, but keep getting confused. Example: If truck 1 uses a part from his truck, how can i subtract it from that truck, and update the balance in my inventory? //Below is the Parts Used validation script input.WO_Date = zoho.currentdate ; Product_Number = Inventory[Product_Number
Zoho Creator Down?
I am experiencing a o connection problem....Java.net.ConnectionException: Connection refused
Auto filled fields - From Data base (Fill as and when type)
Hi All, Is there a possibility to implement auto-populate fields in Zoho creator. We have a form, where we are populating some information. Field1: State Field2: City Field3: Area Field4: Number of boxes To use this form, I have created Drop down menus for State, City and Area. Based on State, City drop down box will get populated. Based on City, Area drop down box will get populated. User is not happy, as one city has approximately more than 1000 diff areas. They have to search it from drop down
Integration with zoho support and projects bug tracker
Hello, Is there any integration with the creator to zoho support or projects and bug tracker? Thanks, Darren
Sorting CRM query results
Is there an easy to sort the results from a CRM query? Thanks David
Next Page