Is it possible to use an external API in Zoho Creator Cloud Functions?
I would like to use Node.JS cloud functions to use an external API for web scraping. I want to scrape a website and then use that scraped data to create a record in my Zoho Creator database. How would I go about doing this using Cloud Functions in Zoho
Customer Portal : "Unrestrict" Access
Hi, I have a report that I want to set up so that multiple Customers of the same company can see the same records - rather than just the AddedUser. However I can't seem to lift the restriction and when I view this report as a Customer I can still only
Copy the content of a field to another
Hi, I have a text content of a field.How can I copy to another field?
New line in formula field
I have a formula where I'd like to group the information from others fields to display in a view in the following format: Age: 23 Hair: Long Tall: 9 and I put the following string in the formula field: "Age : " + fieldAge + " Hair : " + fieldHair + " Tall : " + fieldTall but ZC is giving a error about "Error at line 1 : Script contains new line character, kindly remove it and try again" How do I do it? Please cah you give an idea... Thank you Rodny :)
Is there a limit to the number of URL parameters I can have?
I am trying to create a flexible search feature for my application in Zoho Creator using a stateless form. The form will run a script that looks like this: urlStr = "https://creatorapp.zoho.com/<my-username>/<application-name>/#Report:All_Products?ID=[";
Is there a way to create a PDF template which renders image tags in rich text fields?
I am attempting to send a record template as an email attachment as part of my application and am finding that rich text in the template doesn't properly render image tags. The images instead render as missing image icons in the PDF field. I have published
On Create - On Success profile: Agent is not valid: Line: (1)
Hello to the forum! :) I've been trying to add permissions to users from my own registration form using a successful form submition. But I've been getting the same error The code line I am using is this: thisapp.permissions.assignUserInProfile(input.Email,"Agent");
Access to records based on domain
Hi, I am looking for some feedback on how I am looking at approaching this application, The application I have in mind deals with equipment that is sold by our distributor partners and that needs to be assigned to the end-user that purchased it. This
way to make header and footer repeat in page or record template
guys, i am trying to build an invoice record template and cant get the header appear in multi page. so i tried to build another page with html, can we code to make the header/footer appear in every page? it looks more tidy if the contents of the invoice are more 1 page. and i dont want the "Grand Total" hanging somewhere middle of the page if there were multipage. thanks in advance, Jeff
Zoho Creator - Memberstack Integration
I'm trying to monetize an app I built on Zoho Creator. While I love the tool, integrating subscription billing into it looks cumbersome to say the least. One tool that looks interesting is Memeberstack. They provide a front end for creating accounts,
current time
zoho.currenttime is returning a time 7 hours earlier than my local time. (I am in South Africa - GMT + 2 hours) This was not the case a few days ago when I got the right time. This is despite me setting my locale to the correct time. You need to fix this please, or provide some stability if you are thinking that this is a useful function! avma
Help with automatic Country-State selection form
I'm trying to create a form where I can select the State based on the Country field. In other words, if the Country field is "United States" I need the State field to show only the States that belong to the United States. If the Country is Canada, it should show only Canadian States and so on. Can anyone help with a Script for such form? Thanks, Ed Silva. edsilva7
Zoho Page - Show Calculated Percentage
On a Zoho Creator Page / Dashboard I'd like to show a Percentage Value. The value needs to be a calculated percentage from two different Tables (Income and Expenses) The basic formula looks like this: (Sum of All Expenses / Sum of All Income) = Expense
Lookup previous records stored in same field
Hello, I want to put a dropdown where user can choose to type new record or choose to select from the previously recorded entries in the same field. When I put a lookup it asks me to choose the form and field to look for but doesn't has any option to
How to create a feedback form linked to a training application form
Hi, I am trying to create forms for training/course application. How can I create a feedback form automatically after someone submit a training request and ties it to the training form number?
DROP DOWN DEPENDENT
Hello, I have days with this problem, could you help me? I want to have a drop down that shows information according to what was selected in a first drop down. Example: Select EU, and in the second drop down that only US cities appear, Select Europe and
Community Learning Webinar: Delve deep into the core concepts of Zoho Creator | 17th June, 2021
Dear developers, Every customer has unique business needs and unique problems to solve. To be able to give solutions to these problems, to get over any stumbling blocks and to be able to build applications expeditiously that tailor to specific needs,
Add more gesture/click behavior
Hi there, I'm just reposting to the forum, for the community to discuss on it, my suggestion to add some more gesture/mouse-click behavior. First of all, thank you SO MUCH for adding the feature to edit the click/tap action of a record! Been able to directly click on a record to edit is really nice! I would like to suggest the additional behavior: - double-click action (to edit record for example if Onclick = view) - over-mouse action (to view record detail for example if Onclick = edit) Please
Possible to translate an HTML page?
Hi guys, the translate feature is cool. Can it be applied to HTML pages as well as forms? -- If you need any help with this or anything else related to Zoho, check out www.nuanced.it or email me at jeremy.nagel@nuanced.it
Pause script while alert box is displayed
It would be great if the scripts would wait for the user to press the "okay" button on an alert box, because if the script takes the user out of the place where the alert box is displayed, the user wont see it. Maybe a pause statement....
Sorting of subform rows
How is this still not a thing? Every platform I have tried before is able to do that. A Company bulletin needs a subform listing it's Employees alphabetically. A Staff form needs a subform listing his/her Tasks by Date_field An Order Form needs a subform listing the Products in alphabetical order Sorting subform records is a matter of visually organizing the data. Displaying data by added_time is seriously pointless and misleading to the eyes in most cases. Has this been added to upcoming developpement?
Update Page iframe based on selection of a report
I'm trying to create a page that holds all relevant information about a site....Documents, Permits, Purchase Orders etc... I have a Site form with all relevant subforms...Documents, Permits, Purchase Orders, etc... On the page, I have an embedded report
Fetch data from SQL Server
Hello, I have a database in SQL Server on my server. Every day I need to import data from a table to Zoho Creator. How can I do? is an example of this procedure? Regards, Maurizio
What's the most efficient solution for this use case ?
Hi, I'm after an opinion or two about the best practice solution for this problem I may have as my company starts to scale in size. I have an app which I built as a Training database tool. It contains a record of all training available and records what
Adding "Bearer" keyword to POST header return "Internal Exception"
Hi, I'm getting a very odd failure: I'm trying to make POST request using invoke url. i created header map and added 2 key-value pairs (Authorization, Content-Type). now, when i'm putting the value for the Authorization key as "Bearer hqYUIGEmoTfdWNp54SFRQ8VGz"
Auto populate selected fields names
Hi Everyone, I want to insert the field name of the selected field which is decision field in subform in CRM from creator. I want to insert the value each value have a separate row in subform I have form in Zoho Creator, and it's have a associated Deal
How to fetch relation between forms and reports using API
Hi, I am trying to create an application where I want the reports and forms relationships using API. Is there a way to get that information? Thanks Anuja
How to set iframe size dynamically?
Hello, I am working on displaying the following ZohoCreator form on http://sharespace.co (please scroll down to the section "Pricing, Quotes and Inquiries" to see the form). What I would like is to have the form's height change dynamically, as the content within the frame's height changes. The form currently works that only 5 questions display, and as you fill out the form, it expands to revel more questions. With the current styling, I can only set the iframe height to a specific value (I've chosen
Importing data to a subform
I have spreadsheets with data for a master form and a subform. Records in both spreadsheets have the ClientID. Is there a way to import the data and specify that the ClientID is the key field? So when I edit the master record it shows only the subform records that share the same ClientID? Herb Wexler
Show / Hide Fields in Subform
How do I Show / Hide Fields in a subform row based upon the selection of another field within that row?
Fetching Data from a Subform that fulfils specific criteria in Zoho Creator
Dear Everyone, I have a subform (Reminder Details) within a form (Reminders) in which I am storing two columns, Serial Numbers and Dates. Now, I want to fetch data from that subform which I will be using in a deluge script. I want the dates to be extracted
Key Value drop down
Would it be possible to add the ability to have key/value pairs in a dropdown so that we can show a user friendly item and a system id from an api lookup.
Auto populate to subform by row
Hi Good day I have a Loan Product form in Zoho Creator And it contains more than 10 decision fields. And it's associated with Deals in CRM. Now I want to get the field names of the selected fields. And populated into the subform of the associated deal
How to duplicate the data of a field?
REGISTRATION FORM 1. The student when registering puts his email FORM 2. I make a record and the date to call the student when his class is due. WORKFLOW in FORM 2: The notification comes only by putting the Email field. Question: How do I make the Email
Changing color of header bar
Is there any way to change the color of the Header bar at the top of a form? mohnkern
Zoho Creator Form
I have created a basic Contact Form in my Zoho Creator. Now I would like to know how to generate the embed code for the same to place in my website http://www.vedicravi.com/ Kindly help...
how to create serial number in subform?
hi.. i need to generate serial number when click a add new row in subform..
Do you use Creator for your professional services portal?
I have a client that does taxes and bookkeeping, and we are thinking about creating a Portal phone app and portal online so the clients can upload documents. Does anyone here use a Creator portal for their professional services business? How does it
Add Record to creator report from JS widget
I have created an HTML page to get the location. I need to get this location and insert it to report name called "Location" in Zoho creator. this is the error that I'm facing, POST https://creatorapp.zoho.com/widgetapi/companyname/developer/form/Locations
Integration zoho creator with python
I’m trying to build a desktop application using python. I had gone through the api and I was able to fetch and post the data from zoho creator. I need to create a function, when a approve button is clicked on zoho creator form, the desktop application
Next Page