How to restrict file upload types?
Is there a way to restrict or validate the file type in the "file upload" field? I want the users to upload only image file types (jpg, png, bmp or gif), and they shouldn't be allow to upload zip, exe, rar, pdf... files. Thanks
Customizing Report Header Text/Width
I have a report, and I want to customize its header text length because somehow Zoho "miraculously" trim my Report Header text without even bother to provide tooltip or anything like that for my clients to see the full text. So I browse the documentation
How to hide a section using check box
Hi i have a secton which contains around 15 fields. If the checkbox is ticked by the user i want the section to be visible or else the section to be hidden how can a custom code be written for them. Any reference would be appreciatable! Please help me
How to Select a Choice in a dropdown upon Another dropdown input.
Hi i have two dropdown's dropdown1 represents Product and dropdown2 represents Units. If i select choice Description as "Wall Concrete Pouring" then i want Units to be "Cubic meters" . If (input.Description = "Wall Concrete Pouring") { Units = "Cubic
Mobile Quick View Field Labels [Solution]
I've developed two solutions for field labels in Mobile Quick View: 1. [Simplest Method] Create single line fields (or similar-type fields) with default values of what you want the label to be. E.g. Field name = Due Date Label, Field link name = Due_Date_Label,
Check / validate email field in subform against another form
On each row of a subform I want to check whether the customer's email address already exists in our database. FORM = Customers (this contains contact details etc including email) MAIN FORM = Clinics SUBFORM = Sign-up Something like: For each row in
Get ID from Lookup Field
Hi, So I have a form Projects that has a lookup field of "Builders". I want to export my Projects in CSV, but I need Builders field by ID instead of the actual name from the lookup, as the CSV export, exports with the name not the ID. So for this reason,
On edit: hide subform row if it contains data
Hi guys, might be a strange question... But is there a way to do the following: On edit > On load > hide rows in subform if they contain data And then allow users to add new rows with new data. So when form is submitted, data in hidden rows is retained
Relationships when importing data
We have been evaluating Zoho creator and find it has all the features we need. However we have been trying to import our data into Zoho creator from our relational database and do not see how we can recreate the relationships in Zoho with existing data? We have exported all the relevant tables to excel files and have imported them in Zoho creator, but cannot find out how we can recreate the relations between the individual files (example: between customer and addresses, or between customer and bookings).
Basic Loops
I'm using a Count database with several records to trick Creator to make an iteration process that allows me to replicate what a FOR NEXT or REPEAT or WHILE process would allow me to do. Is there any plan to have a LOOP of some sort in future releases. This would be so helpful. Additionally: It would be great to allow the INSERTING or APPENDING of records as this would allow for the creation of a very sophisticated programming environment. Finally: A link in with your other products that would allow
Adding groups to non-stacked charts
I want to show a chart that shows the total amount booked for each publication date in the next week. But I want to show the publications separately. With the stacked charts I can select a stack by, but I can't see how to do that for the bar and line
Zoho.loginuserid is not fetching right Login User Email ID
Namaskaram Zoho Creator Developer Team I am using Default Send Mail functionality in Workflow. I have added "Zoho.loginuserid" for "To" address When the Email is got triggered instead of taking Login user Id it is taking Workspace Owners Email Id and
Tip 30: How to perform Google search from Zoho Creator
Hi everyone, Hope you all had a chance to try out our last tip. This month we have another interesting one for you—how to perform a quick Google search from Zoho Creator. This tip can be useful for redirecting your users to Google to find relevant information
Subform Add Line Automatically
I have disabled the Add Line feature in the SubForm. But I do want to be able to add a blank line with a deluge script. How do I do that?
Adding White Space in Deluge Code.
Hi there, I've been coding in Deluge for around 7 months now. Something I usually do within my code files is adding some white space to section out parts of code. I've noticed in Creator, and other Zoho Apps, that when I save my code in functions, the
List of all Projects to Creator
I'm looking for the simplest way to keep an updated list of Project names and status as records in Creator. I have one portal and am looking just for the following data : Project ID Project Name Project Status I would like to run this from a scheduled
How can I add a page/dashboard defined in creator to the CRM as a tab?
See the title. We want to include our application in the CRM, and I can't work out how to add a page from the app to the CRM tabs.
How to include column total in scheduled report?
I'm sending out a monthly report as a pdf. I have the view set to total a numeric column. When I export it, the total appears at the bottom of the column. But when the scheduled report is sent the total is not shown. How can I add a total to the numeric
How to use getUrl ??
Hello how are you? I would like to know if method getUrl can set a ip public ? For example, 138.121.141.251:8080 Regards
[Community Webinar - VIEW RECORDING] Zoho Creator as a geospatial database | Feb 3, 2021 | #DevInsights
Dear developers, Hope you had a happy new year! I'm happy to announce that we will be continuing our Community Webinar series into 2021 as well. This year we're inviting several of Creator's veteran developers to share their knowledge and experience with
two subforms of the same form - possible?
I have Purchase form which has a Purchase-Item subform. after the purchase Is made, the manufacturing process begins and i subtract from stock the needed items to make the desired purchase item. to keep track of the stock movement, i create on validation a purchase item of the needed component where i record a timestamp and the stock level at that point. this way, the report showing Purchase-Items can show me stock movement of different items over time. i would like to connect the needed component
Xero Integration using Zoho Creator
Hi, We have a basic application in Zoho creator that tracks our clients and workload. We have a form that tracks the work and when the task is set to complete we want to automate the process of the invoice information being sent to our Xero. Any suggestions of the best applications that could link Zoho creator to Xero and perform this function? I have looked at Zapier, if anyone has feedback on that? Thanks
Random Number Generator
I would like to create a "Magic 8 Ball" type script where a person enters a questions and then a script generates a random number then pulls that numbered from a database. i looked through the documentation but it didn't cover anything like this.
Need an sample coding for Custom action buttons for view record-summary view (template)
Pls, add "Custom action buttons" in record-summary View (which are specified for this View)
Bulk uploading URL contents to Creator app
I am creating a Creator app to replace an existing on (built in knack) however I have a lot of documents stored on the old app that I need to move to Creator. The documents are stored as a url and I have exported that as a new field - but I would like
Integration with woocommerce
Hi, I want to know how to integrate woocommerce website data into zoho creator. For ex.,I have an order form in my website,once the order is submitted the data should insert into creator.
Issue when parsing XML that contains special characters more than once
Hello, I have found a bug when parsing XML that contains a URL that has GET parameters. The following example below throws an "invalid XML/JSON" error when executing (note: this is actually a small example from a response being received from an API): data = "<xml_node>https://someurl.com?rating=PG&size=35&default=mm</xml_node>"; xml = data.toXML();
Edit for the perma link in zoho creator
Through the publish function a customer is able to view the form through the perma link provided. Can this link or embedded code be edited in any way ?
Auto submit a form?
We use a form as a GPS "locator", in that we capture the user's coordinates upon submission. At the moment, they have to click the Submit button to accomplish this. Is there any way to auto submit a form when visiting it?
Using creator as a backend for a web application
Hello. I am considering the possibility of using a creator application as the backend for a (fairly) simple NodeJS web application. I've looked at the creator api and this seems like something that could be possible. Is anyone else using creator in this way? Does it work well for this?
How do you add a Contact integration that is linked to the Account
On our booking form in creator we have an Account field where the user selects the account that this booking belongs to. How do I add a contact integration field that only shows contacts associated with that account?
How do you filter a report on zoho account id
I've added zoho CRM integration (Field name = Account) to our form, and it shows the account name on the field, and in the reports quite nicely. However, when I'm trying to make a page for that account I can't filter the reports on the Account field.
Success message after updating record via edit record
I have set up a stateless form so that the user can pick a record from a picklist and then be taken directly to Record Edit mode, using the guidance given (http://www.zoho.com/creator/help/views/editing-records-via-record-id.html) However, when the user clicks on Update at the bottom of this page they are taken to a page with the message 'Data updated successfully' (https://creator.zoho.com/appcreator/jsp/successpage.jsp) which leaves the user stranded, instead of the usual pop up message. Is there
need help with a formula field
Hello, I have the following two formulas in a field I want to run the first one if the field titled Side = Long I want to run the other one if the field titled Side = Short Here are the two formulas, how would i get this formula written correctly? ((input.Closed_Price
calculating days, hours, minutes
i have the following equation worked out, but it is not subtracting the time used in days portion of it and adding that into hours in the hours part of it (((input.Closed_Time - input.Open_Time)) / (1000 * 3600 * 24)).toLong() + " Days " + (((input.Closed_Time
Adding a new field to an existing report - it doesn't appear
There are sometimes when I will develop a form and set up a report, but then need to add a new field. When I attempt to add this new field to the existing report it just isn't there - I am a developer so have full access to all view/edit/delete permissions
Moving Stateless Form Button
Is there anyway to move the buttons on a stateless form ? Rather than be below I'd rather the buttons be on the right ... is this possible
Multiple criteria in URL for filtering report
I'm trying to use a panel in a page to create a click through action to a filtered report. I can get the filter to work as long as it is one critera and it's an equals. This works https://creatorapp.zoho.eu/OWNERID/APPNAME/#Report:documents_report?documents_status=Testing/Quality%20Assurance
Asking user if they want to submit due to duplicate entry
Hey all, In my application, I would like to prompt the user with a question asking whether they would like to submit an entry that has duplicates in certain fields on submit. If they still want to submit it, they can and if they don't, they can cancel
How to format links in reports to be clickable URLs
Prior C5 upgrade when I was using single line field it would display links as a clickable URLs in reports. After upgrade those links are no longer clickable. I am also aware there is Url field type, but I don't want to migrate all my fields to new type,
Next Page