Uploaded File Validation
Is there any way to validate a file-type and size? I'd really like my users to post only PDFs, JPEGs, or Google Docs under a certain size. Cheers, John Whitney
automatic updating of database from external link/spreadsheet
I am new to Zoho, but am very interested in Creator. I have forms being submitted via another service which updates a google spreadsheet in real-time. I believe I saw something mentioned in a forum about the scheduled updating of a database from an external link/spreadsheet. Is this possible, and if so how, because that would be awesome?
5 FORMS INTO 1 REPORT
I have created 5 forms that are all linked together by one common reference number. I need the output results to all populate into one report. I do not want to look at 5 different reports when the forms have been completed. Can someone tell me how to merge 5 reports into one easy to read report?
populate form via email
hi there is form on website which takes from user name phone city email form sends email notification, it is possible to customize notification how can i populate creator's app via email from web-site form?
Field Types
I had an application running on the old Builder Platform. Now when adding items to it, such as a lookup field, when I start to write a script, that field, gets a field type change to an Integer. I wanted it to stay as a string. Can I change it at anytime?
importing data to a subform from the main form
Hi, I saw this forum https://help.zoho.com/portal/en/community/topic/importing-data-to-a-subform#2266000002822095 and I tried using the steps but really it doesnt work for me, I don't know if the title on the spreadsheets are wrong but is it already the same with the link view name. I have allowed edit access on the application named SAMPLE. Please help this is urgent thanks.
Upload file - Creator API
I am trying to send a file to the creator using a java code through the API creator as shown in the link: https://www.zoho.com/creator/help/api/rest-api/rest-api-upload-file.html # http_method But all attempts are returning 500 error. see the parameters sent with POST: Url = https://creator.zoho.com/api/xml/fileupload/ applinkname = XXXXX FromName Requisi_es fieldname = teste_1 recordId = 836809000002270003 " filename = filename.pdf scope = creatorapi and the file ... tried to send with Content-Type
Dropdown dependent on dropdown? How ?
Hi Just make new form. Logic is next: 1 dropdown - choice of city , 2 dropdown - choice of firm in this city. How to make this logic and how upload to creator those dependencies "city-number of this city's firms" I have about 90 cities. In each city form 40 to 2000 firms. Thank you.
Lookup Issue with New Application Builder
By default, the new app builder uses ID numbers for lookup fields. You can select the display name however. I have a lookup filed type using checkboxes, so the values entered are a list. This is how it appears in the Report view: But this is what happens if you email this field: Is there some new deluge aspect to get this to display names rather and ID numbers for sendmail? Very Frustrated with the New App Builder, John Whitney
Dynamic View
Hi I have a number of Stateless forms that hold information for engineering configuration. The Current Config ref is stored in a variable that is global (via a table). One part of the config is a set of Widgets, Each Config can have up 10 Widgets each widget has 5 parameters. I was going to code this as 10 static sets of data in the main table but thought I would be knocking on the limits of Zoho and fields in Tables. So I was looking at a Master-Detail set up just for this part of the config
Another backup error
New app, built from scratch, backup is successful. When restored gives error: "java.sql.SQLException: BLOB/TEXT column 'Descriptio_1388351000001002559' used in key specification without a key length"
In IE, record edit link triggering reload to home page
If one clicks on the gray Edit button, no problem, but should one click on the Edit row of the hover menu, then the link, instead of opening the record for editing, triggers a re-load of the home page. If this in not a common problem, let me know and I will open a support ticket. Thanks,
Newbie design question on code vs description in Dropdown/Lookups
Hi everyone, I am new to Zoho Creator app builder tool and this forum. I weren't sure if my previous post got through. So I am going to try again.... I have a simple question. When you setup the Dropdown/Lookups, can you setup a dynamic lookup list where it can display a description value on the Dropdown, but store a code value into the Form record? For an example, if I have a US State setup Form, the Form will have a CODE field and a DESCRIPTION field. The CODE field may have "AL" and the DESCRIPTION
HTML View, Populating a table with fixed number of columns
I wan to populate a table with fixed number of colunms with records from a form. The idea is to display an iframe (in a zohosite) with products that belong to a selected category in a 4 columns by unlimited rows table. the question is this. I can have the records to display in a collection variable like this: Products_to_display=Prdoucts[Category==input.Category]; now I need to populate the table, one product per cell (say the product name for now), with the condition to have only 4 columns. I
pivot table report window in Chrome not working propperly
Hi have you noticed that when using chrome a pivot table report's window does not allow you to get to the bottom? it keeps returning you to the top? This does not happen in Explorer. Any advice on how to fix this? I'd like to use Chrome. Regards Luis
Encoding a string in a HTTP Post
Hi, I'm trying to use the Google API for adding placemarks on maps. The HTTP body needs to have the following: <atom:entry xmlns='http://www.opengis.net/kml/2.2' xmlns:atom='http://www.w3.org/2005/Atom'> <atom:title type='text'>Faulkner's Birthplace</atom:title> <atom:content type='application/vnd.google-earth.kml+xml'> <Placemark> <name>Faulkner's Birthplace</name> <description/> <Point> <coordinates>-89.520753,34.360902,0.0</coordinates> </Point>
copy formula error?
hi there is working code in creator 1 filed - formula field, calculation works well try make new formula field (new builder) just copy code of old formula in place of code of new formula builder says "Expression not supported in forumla" how copy code of 1 formula to code to 2 formula?
Data format errors: Enter a valid date format
Under Applications Settings, I modified the date to dd-MM-YY format When I load the form, the date fields still show the old format. Also, when I select a date from the date picker, it shows the old format. When I submit my form, I get an error. When I change the date to '07-07-13', then it works. The date format specified in the form and the date picker is not in sync with the application setting.
Newbie design question showing description but storing code value on Dropdown/Lookups to
Hi all, I am new to the Zoho creator app builder tool. I have a simple design question. I came from an Oracle development background. In many Oracle typical screens, there is a List of Value widget like Dropdown that is based on a SQL query or dynamic query. Typically, there is a code and a description value where you want to show the description on the drop down but physically store the code value. How do I set this up in Zoho Lookup or Dropdown form widget to do this? For an example, if I
Updating a field
Hi Could you help please -- I am sure this can be done.. I have a Form = Clients that has a field = HealthPlan - Yes/No When the Client Purchases anything : I have a Form = ClinicalDetail ( like Invoice Detail) - I have a Field = Discount in a subform called Rows ( main Form is the Clinical ( like Invoice) - which holds the Client ID I would like Clients that are on the HealthPlan - to get a 10% discount - so that this applies automatically. So I would apply script to Form = ClinicalDatail
Issue with saving scripts - new creator script entry
Hi all I had an issue when updating the form scripts ("workflow") for an existing customer. Their database had been created using the previous generation of the Creator design platform. I needed to add some script lines to their existing code. I was able to paste them (using the freeform scripting interface) and save it into the On Load script area, and it "stuck" correctly (it was still there and working when I looked later). However, when I also pasted into the Validate area, and did a Save
Posting to Database
Ok, forget about my last post. All I want to know is if it's possible to insert a record into a Zoho form, from an external website, without forcing the page to refresh? I will learn any language I have to, I will do whatever I have to...I just need a way to submit a record into the database, without a page refresh. Currently, the only method you have listed is submitting a form. That refreshes the page. I need my plugin to execute onLoad. So if it automatically posts, then refreshes, the user will
Ajax, Json & adding a record.
I'm currently trying to test to see if I can come up with the code to add a record to the database. This is what I have: $.ajax( { type:"POST", url:"https://creator.zoho.com/api/c.mart6780/json/boxoff-mw/form/Stats/record/add/", data: { authtoken:"<MyAuthCode>",scope:"creatorapi",UserID:"56464",MWName:"Test",Attack:"980" }, contentType:"application/json; charset=utf-8", dataType:"json",
Report based on drivers name
I am trying to create a database to track loads run by my trucking company. I am hung up on generating a report for the driver's payroll. My trucks typically run with team drivers so I have fields for "Driver A" and "Driver B". I also have fields that indicate the number of miles the load is and the rate per mile each driver is to be paid. I need a report that will pull the pay details for each individual driver whether they are listed as "A", "B", or both. (A driver may be listed as both if
Error while duplicating Records
In my app one of my forms gives me this error when trying to duplicate a record: "Error while duplicating records". All of my permissions are correct in the app for allowing duplication and even as the app owner I cannot. As additional information this form has a subform associated with it and does a lookup to my zoho crm onLoad. These are more sophisticated elements and I wonder if they are causing this error. Other forms duplicate records fine. Please advise.
Application for Zoho creator
Hello Friends, I will like to know if there's a mobile app for Zoho Creator or an Andriod Mobile app that will allow me access my developed forms directly. If there's none please when can we get one?. Thanks Presoft
Serious Subform Namespace Error
I found a serious error that caused my application to loose a significant amount of data. Zoho is unintentionally causing a variable that was pointing to a subform to now point to a form instead. Here is how it works: Let's say we create two forms: Books Pages The form Books has a subform that is called Pages. Notice how the subform Pages in Books has the same name as the form Pages. Let's now say that when you delete a book you also want to delete all the pages. One way you may want to do that
new form field doesn't appear as a column in views
I hope someone from support can can help. Using the new builder, I added a new email field to my form. I want this to appear in all my views. It appears in one view but not in any of the others, even though I went through each view to make sure the new field has added (through column properties). Everything checks out fine, even using the old builder. I'm not sure what's going on. I've already provided support access to the application. Thanks very much for your help.
Performance issues possibly related to GApps integration
I am wondering if any users of large applications are seeing performance issues in Creator, possibly related to integration with Google Apps for Business. We have a large application (almost 2.5mb of code), and our sharing is based on groups created in Google Apps. We also import Gmail addresses and usernames into several forms. The application's owner/admin virtually never sees performance issues, and for him the application works quickly and flawlessly. But normal users constantly contend with
Can you move zoho creator to zoho recruit? Would notes still work?
Can you move zoho creator to zoho recruit? Would notes still work? We have a lot of records in creator so not sure if it would be worth the effort.
Is Zoho suitable for a database like this?
I'd like to build a hosted database solution that will be website accessible with users logging in to provide tips and/or comments on previous tips. Users will also be able to vote up or down previously left tips. Online searches will be based on a couple of fields in the tips and will be ranked based on the votes up and down. Not necessary to login to perform the search. I'm sure I'm missing info so don't hesitate to ask if you can help out on the answer. Thanks.
Consuming Rest api - Authorization header for Oauth
Hi I am trying to consume a REST api. The api uses oauth 1.0 authorization header. how can i build the same? the following code gives an error: headerMap.put(Authorization,OAuth realm="https://api.yyyy.com/1.1/search/abcd.json",q="test",oauth_consumer_key="CubXzXXXXX",oauth_token="1605380557-gW4XXXXXXXXXXX",oauth_signature_method="HMAC-SHA1",oauth_timestamp="1374470468",oauth_nonce="wn1Are",oauth_version="1.0",oauth_signature="kdCPHM5XXXXXX"); Please help.
How Do a I Create a New Record Using Deluge Script?
Say I have table Users and table Locations. Now, say I want to automatically create a location for a User when I save them for the first time. How would I do this using deluge? Thanks!
Invoice Payment Subform
Is it possible to use subforms to create a invoice payment form. I am trying to import invoice details to a form with information about the invoice (e.g. invoice #, invoice amount, invoice due date) and then create a form where the user can enter select an account and view the invoices that need to be paid. They would then enter the payment amount and select the invoices to be marked as paid. For example Account: XXXXXXX Date: 07/20/13 Amount: 100.00 Invoice # Invoice Due Date Invoice
How to handle web users in Zoho Creator and their passwords?
Hi, I just read that it's against Zoho policy to store passwords in Creator applications and this violation may result in account deactivation. Please advise how does Zoho propose to handle situation when a public application (embeded in public web) has to handle registered users. I need a web user to be able to come back and update his/her registration that I handle in Zoho. There will be thousands of registrations and thus also thousands of users out of which only fraction will actually come back
Hide input text using html code <input type="password" /> in the "Add notes" field type?
HELP!!! I need a simple, minimally secure username/password function to protect access to one of my view pages. So I am trying to hide the input text for a password in a form so that it looks like this: I cannot do it from within an HTML view because the limit on javascript in ZOHO creator prohibits me from submitting (as far as I can tell at least - please let me know if this is wrong because I'm an html noob). Thus I am trying to do it from within the form field "Add notes" which supports HTML.
How can I assing a default user to Zoho CRM Field user
Hi, When I add a new record in a BBDD, I need in event OnAdd -> OnLoad assign user default that it is adding the new record as a record owner. I created a user field (type Zoho CRM field user) but in my script I don't know how assign it. I try to write: input.user = zoho.loginuser; But how they are different types I can't to asign it. Can anyone help me?
end of week/month
hi guys, i hope you can help me to solve this problem. I have a form called "clients" where i set payment terms of them and apply it on every invoice. If i have scheduled payments with "n" days starting by invoice date, i haven't problem to obtain the "due date". The problem is when i set payments with "n" days starting by the end of the month or the week. Can someone help me? Thanks in advance bye
Comment lines changing location
Hi, It's not a major bug but I have noticed that when I add comments to code, they move around Eg When I try to save the following code if (input.ORDER_TYPE == "CHILD") { show SHOW_MILESTONES; } //Show child form hide SHOW_CHILD_FORM; It get's changed to the following when I refresh if (input.ORDER_TYPE == "CHILD") { show SHOW_MILESTONES; //Show child form } hide SHOW_CHILD_FORM; I'm finding my comments move away from where they should be. Can someone please investigate? Is anyone
Webhook to an existing Creator list
I have a list of customers in creator which was imported from CRM data. A decision has now been made to update our CRM subscription to allow webhooks, while it's straight forward on how to set the functionality up am I going to be left with duplication of customers once the webhook starts exporting i.e. when the data imports to creator will it recognize the existing customer name and update data rather than creating a new record?
Next Page