Create an alert, email, log if CRM to Creator does not import.
I have a custom workflow when a new "lead" is created in CRM it is added to a creator application. Occasionally the process will not work, because of missing data, misaligned dats, etc. What would be the best practice, or if anyone has a suggestion
How to access Zoho Inventory Warehouses in Zoho Creator
It's not listed as one of the modules available in getRecords, how would I best be able to access that information in a Creator app? Looking specifically to create a dropdown on our order form that pulls in all of our Inventory Warehouse locations and
Record Templates
Hi , How can we create Record templates with Form submit Data? Need whenever any client fill the form and submit then the data of that client send through email using record template. And if client update any field later then updated data again send
Allow multiple actions in Web Report Actions
Currently, it is possible to add more then one Action in the "tap of a record" for the Quick View in Mobile and Tablet mode. Combined with adding custom actions based on conditions this allow for complex behavior. Example : On tap of a record, if record
Importing CSV : no update ability available
After seeing the fantastic new options to update via import, I've gone to test it and can't find the option ... When reading the document it said that the option should be under settings, but it's just not there https://www.zoho.com/creator/newhelp/reports/import-data-to-reports.html
Improve Creator Widgets Functionality
Some functions on Creator Widgets are lacking and would be great for expanding the usability and limits of Creator. Here are my suggestions: First of all on public Widgets the retrieval of data could be permited obtaining data from published reports so
Update Record Without Creating a New One
Hello, I'm definitely a newbie so any help would be appreciated. I have a form where we collect documents from new hires. When employees are filling out the form the mandatory fields are the Candidate ID (pulled from Zoho Recruit) and email address. All
On creating new table record, autofill field from URL parameter
Whenever I add a new record to the Intervention table, I would like the lookup field to be autopopulated with the value of the SearchID parameter. How do I do this? I've tried row.examplefield = input.URLparameter but this doesn't seem to work.
API Access to Sandbox
Hi there, is there any chance to access zoho creator sandbox via API? many thanks
function - datetime comparison
For deluge scripting, is there a datetime comparison function to see which one is of the earlier/later time? Is the operator built for datetime comparison or is it only comparing it as number? Also, is it possible to have multiple function within a script or do I have to create multiple script and have one call(not sure if this is even possible) the other?
How do I populate a Subform with data that already exists from a lookup field in the main form
I have searched the help options for information about this, but can find no example that fits what I'm trying to do. I have a main form with several subforms for which I need different reports (already set up). Each of these reports needs to be sorted by the same fields which recur throughout, Client, Course, Provider and Trainee (all have their own forms). How do I avoid having to enter this information separately in each subform? It all appears as lookup fields on the Trainee form where the subforms
Error when deleting autofill fields
Hello, I am a beginner and I did a program to fill in fields automatically, but when deleting a record in the front end marks an error. Does anyone know how to put in programming to avoid this error? Thank you so much. https://www.awesomescreenshot.
How do I see the files(pdf,etc.) in a Zoho Creator Report instead for a file link using File Upload?
The usage of file upload filed in zoho creator forms is to upload a file link but I have a doubt that this field value in report can show the whole file like image field instead of file link (attatchement). Is this possible to do or not? I am new to Zoho
New Import Interface - Paste Data & Run On Add Scripts
Since the new Import interface has been pushed out, the ability to Paste Data directly has been removed. This was something we were using very regularly to quickly and easily import information. As far as I can see there is no way of doing this at the
Redirect on logout
Hi, I am using Zoho Creator forms and views embedded into my own website. I would like to include a logout link on my own website which triggers zoho logout but then redirects back to my homepage, rather than Zoho's homepage. Both the URLs 'http://creator.zoho.com/logoutpage.jsp' and 'https://accounts.zoho.com/logout' leave you on Zoho pages. Can you please tell me the correct URL to use to logout and redirect to my homepage? Thanks, hdptcar
Add rows to subform (Form B) with dynamic data comming from another form (Form A)
Form A is a Requisition form where People select products to get Quotes from suppliers. Subform in Form A looks like below- Form B is a Quotation form where vendor submits quotes for productsAbove data in subform A needs to be displayed in subform B(this
Send email with value of a lookup field
Hi everyone, Is there a way of sending an email with the recipient (the "To: ") taken from the value of a lookup field? i.e. I have a form with a lookup field called "Email" that has a value taken from another form, and I want to send a confirmation email to this recipient... is that possible? Thanks!
Custom form colors, hide header, etc.
It would be wonderful if we can choose a background color of forms and customize the header based on deluge script! I know this is possible if the form is embedded in a page. But doing so makes it very time consuming, and it is not 100% effective because
checkbox
Hi, I m stuck since a couple of hours on deluge How can I code : " If the checkbox return to the state "uncheck" then... The thing i wanna do is 1 if the user check the checkbox : show the field 2 if the user uncheck the checkbox : hide the field (following a previous check) The following code is not working if (checkbox != null) { show field } if (checkbox == null) { hide field } thank you in advance
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?
Next Page