Single Lookup Field with Multiple Forms Relation
Hello, I am trying to create a new proposals tracking & sales incentives calculation application for my small-insurance business where sales persons sell different types of products (Life Insurance, Health Insurance, Motor Insurance etc.) and earn incentives
How can I fill in an address field with a lookup field's address field in Deluge?
I am trying to allow my user to create a job and select a customer from a lookup field. When the user selects the customer, they have the option to select a decision box "Job Address Same as Customer Address." If this value is true, the customer's address,
Any update on the V2 Bulk APIs?
I have a use case where I need to regularly request all records from a given form, where the number of records is in the tens of thousands. The V1 API allowed me to request and receive all of these records in one pull. The V2 API is restricted to 200
Zoho Creator app without a Form
Is it possible to create a Zoho Creator app without a Form? I'm looking to create a Zoho Creator app that will pull in info from Zoho Books, do some calculations on some of the bills and then create a Journal entry back in Books. The Zoho Creator app
Pre-fill field on the "New Value" popup form
I have a form which has a "Course Category" Lookup Dropdown and a "Course Title" Lookup Dropdown. They are "cascading" meaning that the "Course Title" list will be filtered based on the selected "Course Category". The "Course Title" dropdown also has a "Add New Value" option selected so that I can add a new Course if I want to but when I click that link it opens the "Add New Course" popup but without the "Course Category" selected. Since the user already has selected a "Course Category" in the initial
Embedded report not loading when using HTML/CSS in a page with a toggle switch to view 2 reports in a page based on toggle right or toggle left
I have a requirement to load 2 reports using a toggle button created using Html and css in the page section . I embedded the report like <div elName='zc-component' viewLinkName='All_Orders' params='zc_Header=true'>2 Loading View...</div> .I using this
Automatic Fill Using 2 or 3 Forms !
Hello, does anyone know how I can do an automatic field filling using two or more forms, as a source of information? I have this code, and it works perfectly for a single form search (In my example: Student1) but I want 2 or 3 more forms. I hope someone
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
Next Page