Auto-populate Sub-form Value
Hie , Have Three Forms A, B, C In Form C have 2 Single Line Fields In Form B have 2 Lookup Fields , a1 and b1(Based On Form C) In Form A have Sub-form (Based on Form B) whenever any customer fills Form A with Sub-form ,when value of a1 entered, automatically b1 value will auto-populate How we can achieve this? Thank you in Advance !!
Subform Lookup Field - no search option on mobile device
We have a Creator form which has a Subform. The Subform has a Lookup field linked to another module. That other module has over 800 records. When selecting the Lookup field value on the Web/Desktop interface, user can start typing text and selections will filter based on contains text. But on Mobile device/Creator App, this is not possible? User must scroll and find only using very big list. Please advise if there exist a workaround.
iPhone app does not work
Hello everybody, I use Zoho Creator (great app) and I wanted to also use it from my iPhone. I installed the last version, logged in and ... nothing. The app seems to reset to the initial state (little button to login at the bottom of the screen). Can you help me out? iPhone 7, iOS 11.3.1, Zoho Creator 5.9.4
Send Confirmation Email from Email Address other than zoho.adminuserid
Can anyone recommend a deluge approach (or 3rd party plugin approach) to allow for sending from any outside email address (smtp, etc...) other than from deluge defaults of zoho.adminuserid and zoho.loginuserid ??? Surely there is a method to call email functionality from outside zoho?
Search interface for dummies?... Please?....
I need a simple search interface to allow users to search one field at a time. I've found the "search function" template, I've created a stateless form, I just can't get it to work. I know the field I want to search. I just want the button click script to return records containing a matching term in the field. Maddeningly simple but I can't navigate the HTML and scripting needed. I know it is possible to use the search function in the list view. It's a lovely function. However I need the simple search
Ask the Experts 2: Live Q&A: Find out all about the new Page Builder in Creator 5.
Hi everyone, As you all know, we recently released the latest version of Zoho Creator 5. The update includes features and enhancements that reduced the complexity involved in app building. One of our favorite enhancements is the new page builder. With the new Page Builder, creating interactive dashboards is extremely easy. It eliminates the need of coding in HTML or CSS — users can just drag and drop the elements they want onto the builder. Also, they can customize them by using a range of pre-built
Report with old record
Hi! I want to build a report that shows only the records that the "Last modified date" is greater than 15 days ago. Is it possible? Thnaks
link to live event?
How do I log in to here this live event?
bigint * bigint gives "mismatch of data type expressions found"
Here is my script - ---------------------------------------------------- lineItemsCostWithTax = 0.0; lineItemsCostWithoutTax = 0.0; lineItemDiscount = 0; discountOnAllLineItems = 0; //Get details of the customer in current order detailsOfCustomerInCurrentOrder = Customers[ID == input.Customer]; selectedProdInOrder = detailsOfCustomerInCurrentOrder.Customer_Discounts.Select_Product.New_Product_Name; discForSelectedProdInOrder = detailsOfCustomerInCurrentOrder.Customer_Discounts.Discount_in_Rs; info
Subform field delimiter in reports
Hello. In the previous version of Creator, when I was designing a report with fields from a subform, I was able to specify a different delimiter for each field (with exception of the first one). Now in C5 I cannot find that functionality (it allows me to specify only one general delimiter, not one for each field). Is there a way to accomplish this in C5? And if the answer is "no", is there a way to go back to the previous Creator version? Thanks in advance.
Zoho Creator -- a product catalogue -- image links from Dropbox broken
I'd really like to use images from Dropbox in my product catalogue on Zoho ... so I only need to have one copy of a file for almost every application I use. I've tried adding ?raw=1 to my links from Dropbox to make the image embeddable, but I get broken image links displayed in my report. Dropbox image links are formulated like this https://www.dropbox.com/s/000000000000/test.jpg?raw=1 Is there a way I might be able to get Zoho Creator to display images from my Dropbox in a report? I could host all
Import old version application to Creator 5
I have a working application in old version. I want to install this application in new Creator 5. Is this possible?
How do you auto fill a lookup field based on input of previous lookup field?
I'm getting the following error when I try to auto-fill a second lookup field based on the information I entered into the first lookup field: Error at line number: 2 In Criteria left expression is of type STRING and right expression is of type BIGINTLIST and the operator == is not valid The data I'm trying to fetch is in the Commodity Codes form. The form I'm trying to input the data into is the Contract Summary form. Commodity Codes (form fields) Commodity_Codes1 (Number) Goods_Services_Category1
Printing Custom Reports - Headers and margins
Hi there, I'm developing an app and have a report with a custom printing template to automate the drawing up of agreements for clients. When I save or print the report, the margins and header are not set for any page apart from page 1. Is there a way to correct this? The idea is to generate a PDF in A4 which covers multiple pages. Any suggestions?
Customer Portal
I have created a customer portal with multiple forms & reports and two html pages - one containing an embedded form & report, and the other an invoice template. I have set all the Module-Level permissions to access for the report. The forms and reports can be accessed fine by the customer portal user, but when the portal user hits the html pages - they are prompted for another log-in? One thing of note - If I am logged in as a zoho user in another browser, they portal users can access the HTML
How can I print report from other forms with together
Dear, How can i print report format from other forms with together. eg. I have Fuel, Maintenance together as one report format in Transition -> all Expense Thanks
Fetching data from lookup field third level
How can i fetch third level field when is using lookup field (bigint) I have only use for String format for that field, not bigint. Field to fetch =========== Transaction -> WO_Customer Name Form ==== Customer - Customer Name Work Order -> WO_Customer Name Transaction
Is there a workaround for the date field language limitation on user level?
Hi, I have a client that uses Creator in Mexico. He has the basic user access and multilanguage option for the date field is not available. He needs to show dates in spanish. Is there a way to work around this limitation using code? Thanks
Military Time to Regular Time
Is there way to change the Time for Date-Time from Military Time to Regular Time?
New creator trying to do formulas and reports.
I'm working on a project for a client that is currently using Excel to generate numbers for charity donations based on a percentage on income linked to each client. I'm not sure where to begin to create a system in Zoho Creator. But here's what I have so far. I have a set of forms like charities, customers, payments, payment reports. When I enter a payment into the payments form, I need to push those numbers into another form, do some math based on linked entries. The end result needs to be a
Maximum number of components allowed
I received this error message. What are the limits? How do I see a list of the published components. I'm sure in this application there are some that do not need to be published. Maximum number of components allowed to publish for your account has been exceeded.
Populate multi select with filtered concatenated values from other form
Is it possible to populate a multi select (list) field with concatenated values retrieved from a 2nd form? Fact pattern: 1. Form A (Master) includes fields for field number, lot, grower, crop (collectively referred to as a Planting). 2. Form B (Timecard) includes fields for field number and a multi select which I would like to populate with Planting. Example: 1. Master includes records as follows: Field Number Lot Grower Crop Ranch A 123 A Taylor Iceberg Ranch A
What, if any, differences/limitations are there in having a lookup between apps as opposed to form to form inside a single app?
Curious what differences there are for some planning we are doing. Thanks, Brady
SMS Integration with 3rd Party SMS Service?
Hi, Please share how to integrate with 3rd party SMS Service (except pre-listed SMS service in zoho creator)? Regards, Easwaran
Zoho Books --> Zoho Creator
Hello, In Zoho Flow I've made a connection between Zoho Books and Zoho Creator where there will be a new record added in Creator after creating a new invoice containing the Invoice ID. In Creator I would like to fetch the invoice information based on the Invoice ID and add a record in a new table in Creator with at least the following information: 1. CRM Account ID; 2. Total excl. VAT; 3. Total VAT; 4. Total incl. VAT; 5. Invoice number; 6. Invoice date; 7. Invoice due date; 8. And when possible
Create a form in oder to let my client update informations on a Potential
I would to let my client fill informations into a Potential entry of CRM. here the flow I would like : 1 - A Lead fill a form on our website. 2 - Convert the Lead to a Potential 3 - Send a email to the Potential explain him we need more details in order to process. We provide a link in order to get form with some Potential infos pre-filled. 4- The Potential fill the form. 5 - Save the data into the Potential. Someone has already do something like this? How I can create a form with some parameters
Drop-down field sorted as text instead of date
Hi Zoho, I have a drop-down field on my form, listing dates. When fetching the data from the form sorted by that field it's sorting it like it's text instead of date. for example: ListMe = (Loan_Valuations[ID != null].Assign_Valuation_to_Date sort by Assign_Valuation_to_Date).getall(); will get me 01-Apr-2017,01-Apr-2017,01-Apr-2017,01-Apr-2017,01-Apr-2017,01-Jan-2017,01-Jan-2017,01-Jan-2018,01-Jan-2018,01-Jul-2017,01-Jul-2017,01-Oct-2017,01-Oct-2017,01-Oct-2017,01-Oct-2017,01-Oct-2017,30-Dec-2017,30-Dec-2017,30-Jun-2017,30-Jun-2017,31-Dec-2017,31-Dec-2017
How to build recurring payment in Check register
I’m building a checkbook register and I’m lost on how to build in recurring payments. Form Add Transaction has the fields required (recurring =yes, Start date, etc). What I thought would work is to use the schedule features add a new record at a scheduled date. That seems straightforward enough, but what I can’t figure out is how to properly identify the records with recurring info, then using that record(s) to create a new record(s) with the recurring data. If anyone has any ideas, I would love
Autofilling fields in subform with multiple rows
Hi, I've made a subform (Next_Steps_subform) and a want the input in one field (Next_steps_responsible) to dictate an autofill in "User". I have created the below code and it works fine on the first row created in the subform, but not in subsequent rows. Image attached to show issue. Any idea why? if(input.Next_Steps_Subform.Next_Steps_Responsible == "Callum Wood") { input.Next_Steps_Subform.User = "alderhey"; } if(input.Next_Steps_Subform.Next_Steps_Responsible == "Jason Taylor") { input.Next_Steps_Subform.User
auto number depending on the last record created
Hi, I want to use the Auto number filed in C5 but the problem is that my number I want to auto create has to have a letter and -. I have a list of project. Each project has a number like P-18-0200. When I create another project, I want the filed "Project number" in my form to be autopopulated with the last project number + 1. Ex: Last project number was P-18-0150, so the next number should be P-18-0151. How can I do that? Thnak guys!
"Map" function in Zoho creator / Zoho Workbook help
Hello, I'm new to Zoho creator and I'm just going through the workbook. I'm currently in the "Add Business Logic" section of the workbook and trying out "Change delivery option based on number of products selected". It does not seem to recognise the ".size()" function and returns it as an invalid syntax. My understanding that is the "size()" is a built in map function. I need to check Product.size() where "Product" is a lookup field, but it doesn't seem to recognise it. Did I miss something? Can
Creator API - Getting Subform field values.
Is there a method to get subform field values using the Creator API?
Private Multiline Textbox
Hi, I searched pretty extensively on the forums but couldn't find any clues to solve my problem. We are building an asset management system for our construction company. The intent is to inventory prospect applicants and track current employee availability/earmark them for subsequent projects. I would like to add a multiline text box on the employee information page which our supervisors can populate with their own private notes about an employee when they work with them. I would like to make it
Zoho Creator 5 = Bugs, bugs & bugs?
Hey everyone, we are a heavy user of Zoho products at my company, espacially the Zoho Creator is used a lot. It really is a really, really great product, as it allows business guys like me to build apps without a lot of coding knowledge. But since the update to Zoho 5, the creator is not really usable in a professional environment. I try to expand our core creator app by some features, and since the update to Zoho Creator 5 I have bugs in pretty much every second step I try to do: - Backups does
Populate Subform with already existing Items
I added a subform to a form and I want to populate them with items already inserted from another form. Can I insert into a subform an already existing item using its unique ID?
Bootstrap CSS affecting embedded report on a HTML page
I am trying to style a custom page in creator with an embedded report. When I embed the report with no style then the report comes in as expected. However when I add the bootstrap 4 CSS file in the overall report area remains as expected but the content is compressed against the left hand side. I dont see any parameters within the zc-component that allow for sizing of the report area so wondering how the CSS is impacting this? I have attached two screenshots - one with the bootstrap.css applied and
How can I go back to the last version until the bugs are worked out?
How can I go back to the last version until the bugs are worked out?
Attach file to Desk Ticket from Creator App
Is there a way to pass a form that is uploaded from a Creator form into the Desk app? I am able to pass all the other fields with no problem, and I found that you can do this with the CRM app using the following syntax: <CRM Response> = zoho.crm.attachFile(<Module Name>,<RecordID>,<file upload field>); Is there any way to do this with the Desk App instead? There is no documentation of this that I could find.
Auto-populating field data once a option is made
Hi, How would I auto-populate fields in a form that relate to a different form? For example, I have a form in which I want to choose a specific category, and the price to auto-populate (note that "category name" field relates to a different field. Within the related field, I would have the category name and price. Essentially, I want the main form to fetch data from a related field within a different form. Note the category name is a lookup field. I'd like to do the same for Employee Name and employee
Showing subform fields in Report Summary
I have a form that uses a Subform defined as a separate Form. The subform-form also has a list subform within it. In my Report Summary, I want to display not just the list of items in the subform (which it does) but also the subform-subform. Parent form -> sub-form -> sub-form items Is this possible?
Next Page