problem with subform
Good afternoon. I am trying unsuccessfully to help support you in four days and no response . I'm having the following problem: I created a form and subform it loses the rules made in the original form. Form is : https://creator.zohopublic.com/zoho_bruno123/requisicao/form-perma/Correspondente/D6fpDwguR9WbGNZpv4HaNd2W5kytgBsUtB4TUXQSNCFnM2fOw7YyHuF177meO0h3tUyuFQFkbQNPXbXF9HNpW1qxt7XnHejTMus1.
When I put " city " the county should open only selected and is not opening at all. What can it be?
Formula to Calculate Total of Multiple Rows in Sub-form And Return the Grand Total to The Main Form
Hello there, I am working on a main form, a kind of invoice divided into 2 sub-forms. First sub-form is Customer Info. Second sub-form is Items list. I can calculate something like Quantity*Unit Price in one raw. But I don't know to to run formula for one column (Total Amount). So As you can see, I can work horizontally, but not vertically. This is at least the most problem I have. Hopefully, someone could fix this as I think this would be common but no clear answer I found for. Another thing is
Create a lookup relation
Hi there! I try to create the lookup relation. Unfortunately, only one field for the selected form is shown for selection. The rest is the Added Time, Added User IP Address, ID, Last Modified Time and Modified User IP Address. Please advice me on this matter. Tq!
We are unable to fetch this data, sorry! Please note that your data is SAFE.
I am getting this message on views every once in a while and I can't figure out why it appears or why it goes away. Strangely, I have it right now for one particular user on one particular view and only in Chrome, Safari with the same user and same view loads up just fine. Any suggestions?
How do I automate this process?
I am building an automated form that upon opening does the 1. Goes to the suppliers website, as a sample we pretend it is: https://www.url.url 2. Enters my username in the username field. The XPath for the Username field is as follows (I used a fake url for to protect our supplier, but the XPath is real): https://www.url.url/html/body/center/form/p[1]/text()[1] 3. Enters my password in the Password filed. The XPath for the Password field is as follows: https://www.url.url/html/body/center/form/p[2]/input[1]
Group items in subform
hello, in my form i have a subform with fields Product Code || Description || Quantity. How can i make to group items by Product Code and sum Quantity ? Thanks you
Mobile application database "n00b' needing direction re: app in progress.
Good Afternoon, I am really new to building database's for mobile applications. I am experience in building the front-end app though. I am needing help with putting together a database. I do prefer to do the work myself so I can learn. Okay, the problem; I am building an app in app-press (client's choice) & I have done all the psd/ai files and all the boring hard work to put the app into a functional state, now I need to assemble the database. It's an app for farmers/miners re: tyre psi etc... Screen
Development workflow - is it possible?
I have an application that is currently in production. I need to understand how I can accomplish a development cycle/process for this. There will be changes made to the app regularly (multiple times a month possible). Many of the forms require lookups, etc, so in order to do work on a development copy, I need to have the data as well as the forms. I'm told that the only way to duplicate the application with data is to have Zoho do it for me. I am a paid (Professional subscription) user. So now I
Webform with unique link
Hi, I'm trying to implement a webform for a registration to an event. I have various events in my database and I don't want to let users see all the event and pick the event they want to subscribe, rather I want that through a unique link (or any other way) they go to the registration form of a specific event. I wonder if this is possible in either CRM of Creator as I could not find a way to do it. Has someone else had the same issue? Thanks, Andrea
Subform linked to another form
I am working with a subform that is connected to another form, such that it looks like this in the form builder. Is there any way to hide or disable fields within the subform when it is being displayed in the main form?
Conditional Formatting bug
Hi, Admin Conditional Formatting is not working in my calendar view. but it works well in summary view. I'm so sure, i have done it correctly. https://creator.zoho.com/artametise/database/#View:Calendar Thank you.
Picklist filter doesn't work for field defaulted in On Load
Hi, I have a form called Salary Data which has a field called Financial_Year which I default to the current financial year in the On Load action. I have a field called Industries which is a lookup to the Industries table, which also has a field called Financial_Year. I want to display only those Industries in the picklist that match the current financial year. I understand how dynamic picklists work and my code and my data are both correct. Industry ( type = picklist
Function for REST API to import Data to Zoho Report
I have tried with below Zoho Creator Function which fetch JSON data from external websites in JSON formtat and then import that JSON data to ZOho Report table but it not working .could you please help me how to fix it. Thanks Arfater see below code : void API.ZohoReportAPI(string zip) { url = ("http://api.tvmedia.ca/tv/v4/lineups/browse/US/TX/" + zip +"?api_key=*******&detail=full").toString(); response = getUrl(url); lines = response.toJSONList(); //info lines; myMap = map(); myMap.put("ZOHO_FILE",lines);
integrating a form into a separate website
Can we put a zoho form onto our company website so that when a customer fills in this form on our website, it will appear into the 'enquires' section on our zoho database?
OpenURL and Rich Text fields
Hi, I am trying to populate a rich text field when opening a stateless form(as popup) through openURL statement, but the string gets truncated in the field, even though it is in the actual URL. Using encodeURL for the string makes it not formatted correctly... I also tried to encode the actual URL and got a "Not Found on this server" error. Thanks, Damien Cregan Hire an Expert
Calculations on HMTL View
Is it possible to perform calculations on HTML Pages, e.g. on a HTML view I want to call up the count of certain records, and then perform a calculation based on the records count, is this possible? In my application I have a form Clients and I would like to create a HTML view by which I can see which clients have ordered certain products and the duration when they ordered the products. I need to find out the total worth of the products ordered, by calculating discounts offered, gross price and net
Set Decision box on click button
Is it possible to set a decision box value on click of a stateless form button? I need to set a decision box to false but it does not seem to work. Code im using is: input.Change_Shipping = false; Im thinking that maybe I can't change the value for an on click action? This is a stateless form embeded in a Customer Portal html view. Im using this so clients can change their shipping address. After submit i want the decision box to uncheck causing a bunch of fields to disable again. Maybe this is behaviour
Script in page not saved despite the message "Script saved" at the bottom of the screen
I have recently encountered a situtation where modifications to the page in Zoho Creator are not being saved. The message at the bottom of the screen says "Script saved", but when you re-edit the page, the old code shows up. The issue occurs only when modifying a page. No problem with modifying a form script. Has anyone else experienced this issue? If so, how was it resolved?
Records not really being deleted
I have developed an event reservation form for teachers and staff at my school, to incorporate some location conflict checking. When scheduling an event, the user enters the Start DateTime and End DateTime; at that point, deluge scripting searches the database of events, looks for any overlaps in the times for existing events vs. the requested event, and then updates a dropdown menu of available locations. Thus, if a location is already booked, it is unavailable for future reservations during that
Developer Needed - Real Estate Matching App
Simple app for internal use to match buyer need to property(s). App will be for one user (me) plus assistant to enter data. Specs: a) Need two main forms, one to enter buyer purchase criteria and one to enter property specifics. Property/buyer data will be pretty simple, 10-20 fields each. (i,e, one picture, name, price, property type, location, numerical fields, text fields, pdf upload, etc) Each buyer and each property to have custom expiration date field. b) Then a daily or real-time search that
Error Occured while executing on load script.
Multiple records in my application are experiencing an issue when trying to edit the record. Error Details Error Occured while executing on load script. Some (not all) records give this error when editing a record There are no other issues in the logs and the code works for other records. The only way to stop the error is to completely eliminate all code in the on Edit On Load Script. Obviously i cant do this long term. This problem just started out of no where today. Please help!
New to Creator, noodling a raffle generator
Greetings, all. I'm very new to Creator, and have mainly an old-style procedural coding and Access background, so my questions may be a bit...dated! Anyhow, let's say I have a table with Name, Raffle Item, and Entries (for a number of raffle tickets). My old way of generating "tickets" and pulling a random ticket would be to iterate over the number of entries, adding the Name to a new table for each "ticket" and using the autonumber of the table record as the serial number, or perhaps the record
Web page Refresh Causes Fetch values to Change.
I have recorder a video of my problem below: http://screencast.com/t/hJRUOZicfjt Details 1. This is a customer portal page. 2. It is an html page. 3. Has an embedded form with lookup field 4. A for loop running through a series of records. This is what passes the value to the embedded form lookup field. What is happening is the following: On 4th webpage refresh the value passed to an embedded form in the html view changes. If i refresh the page 4 more times the value goes back to the proper value.
bug when print currency EURO
hello, i my form i have a currency field. In, i write 2.50, ok no problem. But when i print in a record summary i have 2,50.00€. With Euro in France, the comma is used to separate number and decimal, we don't separate hundred. Zoho do you fix quickly this bug ? thanks you
How to put data from multiple form in a single html page
Hi, i need to put in a single html page data from specific field of different form. I'm working on a simple EHR, still now no problem. Now i have to put in a single document some data from different users: the doctor1 in formA set the diagnosys, the doctor2 in formB the rehabilitation target, the psycologist in formC evaluate the mental condition of the patient. In other html page i used this: for each r in formA [patientID=input.user] then near Name and Surname i put the deluge references <%=r.Name_and_Surname%>
Importing error
I am trying to import data from a Google Doc. I have 19 records and only 10 are being imported. On the other 9, Zoho is reporting an error like "Row 2 Col 5 - Value '2/27/1964' is not a supported date format". What i cannot figure out is why these particular records are not being imported. The entire column is formatted identically, and yet some records are accepted by Zoho and others are not. If anyone has a solution or explanation, i would be very grateful as I am not stuck! Thanks! David
Load single record on Zoho Creator Mobile
Hi, Within the Zoho Creator Mobile app, i would like to have a form with a single line field on it, where the user can scan a barcode into this field, and it then loads up the relevant record for view/edit. I suppose i am looking for the equivalent function to "openurl", that will work within the mobile app. openurl("http://creator.zoho.com/" + zoho.adminuser + "/" + zoho.appname + "/Asset/record-edit/Asset_Report/"+rec.ID,"same window"); Thanks Best
Bug with Subform and loading
hello, i have a Form1 with a subform wich is a lookup to Form2. I add many rows in my subform with script deluge, no problem. but i want add a check on the Edit on my Form1. by example i write for each line in subform { alert "in the list"; } even if i have 50 rows in my subform the script don't enter in the for each ? Why ? thanks you
Using information captured on another form for dropdown box
HI there, I have two forms, one with referral data and one with broker data On the referral form I have a dropdown box which need to create a list of brokers which I create through the broker form The referral list includes the following fields Broker: (Dropdown) First Name: (Single) Last Name (Sinlge) The broker list includes the following First Name (Single) Last Name (Single) Thus I need the Broker dropdown in form(Referral) to have List of brokers that was created by through the form(broker)
Zoho Creator backup doesn't backup custom deluge script logic from pages, validations, etc?
I backed up and downloaded my application and looked through the files. It looks like pages and validations, etc (deluge scripts) are not backed up? I am shocked to see this as I invest countless hours into developing these scripts, why are they not backed up as part of the regular backup process? Is there any way to back these up all at once or do I have to manually back up each of these on my own?
how to enable auto complete function in script editor
i found this function in an second account that is in free trial period. but how to enable this in my paid account?
Exclude record from look up if exists in current form
I am having hard time finding anything to do with this topic, so I decided to start one. Here is my criteria Form "construction_budget" has a field that looks up from form "plans" this field is a formula field that concatenates the plans square feet and name. On the construction_budget form, this lookup field is named "plan_name" I need field plan_name to exclude records from this field lookup if that record exists in the current forms records. That way only items that need a construction budget
How to open another form with initial value
Hello I'm making a session application form. We have 2 sessions before we start our service 1. public session (about 10 partipants) 2. private session (1 participants) => start our service After public session, we arrange participants'/our schedule and decide the day of private session. Now I've finished creating public session application form and its report. and I added custom action 'apply for private session' to the report. When I click 'apply private session' button, I want to move to private
Something is wrong with ID's on a Form that I have
Something very weird is going on with Form records that I have. I am seeing bizarre behavior of not finding records when I try a fetch also in my page code. I have two records in the Form and am viewing a report, I have attached a screenshot of the report. It shows both records as having the same ID field. When I click on an ID field and copy it, the value that I paste is: 2940790000000069000 This is different than what shows in the report for this field. This is really pretty crazy and very concerning.
What is the correct way to resell Zoho creator apps?
Hi guys, I am planning to create and deploy an application using Zoho - its not going in to the marketplace but rather is just for a client of mine. I am just wondering what the correct way would be for me to do this - should I create the client their own Zoho creator account or should I create an app in my account and then add their users to my account giving them access only to their app? Thanks in advance Dave
Question about unique workflow/assignment problem
Hello, I would like assistance in trying to figure out how to set up a somewhat unique set of workflows. For example, say I have several accounts, each assigned to the respective Stage 1 account representative. Each account should then be able to be submitted/assigned to the next stage, e.g. Stage 2 account representative, Stage 3 account representative. Each representative should also be able to send the account back down. So, something like this: Jones Account: Stage 1 Jones Account Representative
Fetching records from Zoho CRM through a sub-form
Hi, I have some issue with my app. I added a sub-form “Operation Subform” in the “New Purchase” form. The Operation Subform fetches records from SalesOrders and CustomerModule1 modules of Zoho CRM, based on the lookup field Order Number. When I try to run the subform in the New Purchase form it gives an error (something with the zoho.crm.getRecord). The script is the following: //Auto populate from Zoho CRM. Order_Number_ID = 0; for each operation in Add_Operations { crmOrders = zoho.crm.getRecordById("SalesOrders",
Limiting for loop
Hi, I have below script with JSON functions what I am facing the problem is exceeding maximum number of deluge statements. So to avoid the situation I would like to limit the for loop to a specific number like: range from 1 to 200 etc. But Here How do I do that since it is a JSON list, please help me url = ("http://api.tvmedia.ca/tv/v4/lineups?api_key=123" + input.Zip_Code + "&lineupType=" + input.lineupType + "&detail=full").toString(); response = getUrl(url); lines = response.toJSONList(); for
Fetching records From Zoho CRM
Hi, I try to fetch records from Zoho CRM's two modules to a form in Zoho Creator. The following script is written that is saved and runs without problems: crmOrders = zoho.crm.getRecordById("SalesOrders", input.Order_Number_ID); input.Contact_Name = crmOrders.get("Contact Name"); input.Billing_Country = crmOrders.get("Billing Country"); input.Order_Date = (crmOrders.get("Created Time")).toDate(); operationsList = zoho.crm.getRecords("CustomModule1"); for each operationDet in operationsList { operationNumber
Problems forwarding to aol email addresses
Has anyone else has any issues with forms not sending to aol.com email addresses? I have a series of applications and scripts that forward user submitted data to various email addresses, and recently the aol addresses seemed to have stopped getting their emails. Thanks so much for any help! -Courtney
Next Page