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?
Function fetch all records in a subform
Hello, I have a form with a subform and I want when selecting a client of my form subform records fill one box (with the fetch function). I have managed to do with the first record, but in my subform I register more than 2 records, the fetch only affects the first, I want that all records have filled that box. "R.Ordenes" if (input.Clientes1 != null) { if (input.Correo_Electronico != null) { dat = Clientes1 [ID == input.Clientes1]; R.Ordenes = dat.Correo; } }
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.
How to show information to user after the form submission?
After someone submits the form, I want to give some copy/paste code to the user on the basis of the form's data that has been submitted just now. How can I do that?
Creator N duplicates on workflow
Can I duplicate N records from creator DBF with an instruction on workflow for certain conditions?
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
Do I must need to create relationship using lookup field?
I want to fetch some data from another form using deluge. Do I must create a relationship using lookup field? or I can fetch the data directly via deluge script? Also, if lookup field is a must then what to do with that lookup field when I don't need it at all in my form?
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);
Re-set Auto number ?
I need an auto number value to count sequentially but be re-set to zero at the beginning of every year. Any solution?
Filtering data in iCal feed
I have created a calendar view report in Creator with one criteria. The report works just fine and shows just what it should. But, I have gotten the iCal link for that calendar and added the necessary parameters and I am simply getting an empty feed (no events). As soon as I remove the criteria from the rpoert, the feed works normally. To isolate the problem, I tried changing my criteria to a different field and that produced an empty iCal feed as well. Any ideas on what I'm doing wrong?
Questions
Hi, is possible make this? x=abcd i need put y=dcba Thanks and regards.
add and display running totals on a form
so i have two forms Material In and Material out we get material from different sources so i have on my product in form (table) product 1 qty 10 from PO xxxxx product 1 qty 7 from Job xxxx On my product out form i have a look up field to another form called product type, upon entering the product type i have a field called product on hand and i would like this populated with the total number of products from the product in form. i am using : if (Material_In[ID == input.Material_Type].count()
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?
Updating field in report based on formulas from two forms
The scenario is this: two forms Materiel in & Material out one report Materiel on hand when material comes in it is logged on the "materiel in" form and assigned an Auto_Number when it goes out it is logged on the "materiel out" form using a lookup field back to "Materiel_In" Auto_number is there a way on the "materiel on hand" report that i can set a Materiel_On_Hand field that is something like //Materiel_in.QTY - Materiel_Out.QTY = Materiel_On_Hand IF there is a corosponding record in
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
Latest Creator Update bugs
@Creator Support First let me say that the new compiler is awesome, many thanks :) 1. Double fetch no longer works, eg: //this will not work x = Form_Name1[ID = input.Lookup_Field]; y = Form_Name2[ID = x.Lookup_Field]; input.Field = y.Field; 2. Numbers in drop-downs not saving when using "other" option 3. This no longer works: if(!Field.contains("No")) { alert input.Field; cancel submit; } get this error: Error details: Error in executing On Edit - On Validate script. Function '{0}' specified
exporting data from creator to crm
I would like export the data that I have in Zoho Creator to Zoho CRM under the Vendor section. Can I do this?
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
Customer Portal Profile as System Variable
Hi, is it possible to have as a Deluge System Variable the Profile associated to the login is using Customer Portal? tks, Pippo
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?
Not able to total from subform
I'm trying to total the amount from subform and display in the main form. But it seems the for each loop is not going through all the rows. Here is the script I'm using: ProductTotal = 0.0; for each item in Product_Details { ProductTotal = (ProductTotal + (ifnull(itemTotal,0.0) )); } Product_Total = ProductTotal; What am I doing wrong?
If This then That
I'm having a bit of fun with a service called IFTTT. This offers Creator yet another way to interact with the outside world. Using IFTTT, you compose IF-THEN type recipes using ingredients like email, Facebook, and other Internet services. The roll Creator can play is to send an email and have IFTTT do something with it. For example, I'm using it to update a Facebook page. I have suggested to the IFTTT team that they also enable http post IF's, which is something Creator does well. IFTTT is still
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
Problems with shared application
Hi, since few days many applications that i have created for work and accessible to all the visiotrs on the web ask a Zoho e-mail and password. For me It's a very big problem because many students cannot use my applications. Please help to fix this problem because there's no need of LOGIN. Diego
Umlauts do not work
German Umlauts, e.g. ÄäÜüÖöß do not work in ZoHo Creator. sebastian.schaper
Copy aplication from another environment
Hello, i created a application in a zoho creator instance, but now i want to copy this application to another zoho creator accont. I did and downloaded a backup of my application and tried import the .ds file but the creator returned a lot of errors. Is there another way to copy/import my app?
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
Creating a task to assign leads
Is there a way to have all leads go to one user who can then assign them to different members of staff to follow up on? These leads then need to go back to another one user when the first assigned user is finished with them to be reassigned to another staff member. Is this possible?
Calculation based on options selected
Hi there, I have 3 Option Boxes and based on the options selected it needs to give me an amount Ex OPTION BOX 1 : 1. Mamma 2. Pappa 3. Mamma & Pappa OPTION BOX 2 1. Single 2. Family OPTION BOX 3 1. Monthly 2. Yearly Say I choice 1,2.2 It needs to calculate a formula If Mamma and Family and Yearly then R195.00 Hope this can be done Regards
Device Magic for Front-end Offline
Does anyone out there use Device Magic for an offline form solution using creator as the back-end? I am in desperate need of an offline solution for my field evaluators and have found this possible solution. However, I would like to know if it is working for anyone in the creator community before I make the commitment in development time and money. Also, as a paying customer, I would like to know if Zoho has there own solution in the works. I would hate to spend needless time and money on a third
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
Taxes to be added on the zoho website commerce through PayPal
I am using the zoho commerce on my zoho website. When a customer makes a purchase and the PayPal window opens, no taxes are added. Does anyone know how to do this?
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%>
Dropdowns not listed as User Defined Fields in Lookup
I am a DabbleDB user attempting to rebuild in Zoho. Your Lookup fields are wonderful, and this is a feature that didn't work very well in DabbleDB (which is why I'm rebuilding from scratch rather than importing). But I keep running into the same problem: In Form2, I want to add a Lookup field that refers to a Dropdown field from Form1, but none of the Dropdown fields from Form1 appear in the list of User Defined Fields in the Lookup dialog box. All the other fields from FormA seem to appear just
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
Password
Hi there, I need to hide certain fields until a password is entered Can this be done Regards
Next Page