Can't openURL in a popup window from a published form
I have several published forms (no login required) that I'm accessing via their permalink url's. A user-action in Form 1 calls openURL and sends parameters to Form 2 in order to pre-populate some fields. After closing Form 2, I then need to return to Form 1 to continue. (I'm doing this since ZOHO can't send field values via "add new"for a look-up field !!!) If I am logged in: Using openURL(form2sPermalink, "popup window", <dimensions>) works, although I have to manually close the popup window.
How to import Excel data in a blank subform?
I have a form which only has a blank subform (with 3 fields). Is there any way to import data from an Excel (with 3 columns) in this blank subform?
Fetch Records + Update
HI All, I'm trying to fetch records from "Inkoop" to "Verkoop" , but it doesn't work. Can someon help me please. Note: I want to fetch the records into a subform "Brillen_Toevoegen" + Can i update the "x.Aantal field" with input.aantal? 1+1 for example. if(Inkoop_link[ID == input.Brillen_Toevoegen.Model].count() > 0) { x = Inkoop_link[ID == input.Brillen_Toevoegen.Model]; input.Brillen_Toevoegen.Merk_inkoop = x.Merk_inkoop; input.Brillen_Toevoegen.Kleur = x.Kleur; input.Brillen_Toevoegen.Aantal =
Problem in Send Mail Task
Hello, When we Add Form Data in Send Mail Tast, there is issue in displaying data of lookup fields. they show ID instead of Data. For example, if I include <%=input.product_name%> in Send mail task (Product name Field is Lookup) In Triggered Mail it shows 3222601000000033005 instead of Hydrazin (Product Name). Please help
Difference between Publish and Embed?
Hi, We've created an app for internal use by our company employees. Because it is sensitive customer information, we do not want to publish any URLs because we do not want everyone in the world to see this information. However, we want to embed forms and reports into our website, for employees to use there. Would we embed the forms and reports? Please clarify the difference between publishing and embedding. And can we embed all forms and reports? In other words, what's the proper mechanism
evaluations or reviews
Newbee here trying to make an app for the local library system. Is there any advice on how to allow users to do reviews of products that other users can see. Like in Amazon you can see how many stars other users gave a product and their reviews. (In our case it will be librarians reviewing if a book worked well when they read it during a story time, but same idea.) Thanks Josh
How to make a list report that displays similar fields belonging to records from unrelated forms?
I'm new to Creator and just beginning to get my mind around it. I know its possible to combine records from different forms into a single list report so long as the records are linked such as a Department Form and Employee form. However, what I need to do is combine records from different unlinked forms into a single list report (or page) such that each row represents the record from a different form. Is this possible? To be specific, I keep inventories of different types of media that fall into
Displaying parent form fields in sub-form report
Hi, EXAMPLE I have a parent form call 'Sites'. I have a sub-form called 'Equipment'. The equipment form is a sub-form of the sites form. Each site can have multiple equipment. 1. Is it possible to display parent form fields in a sub-form report. Without having a lookup field to the parent form. I'd like to see what equipment belongs to what site in the equipment report. If that can't happen 2. I'd like to automatically set the 'Site name' for the subform as the parent form site name. Is this possible.
URL for record summary as PDF on zohocreator.eu
@Support, When trying to use the url described here https://www.zoho.com/creator/help/views/record-summary.html#url to create a link for a record summary PDF it does not work on the eu app. I have tried replacing the ".com" with ".eu" but this does not work. Can you please provide the correct url to produce a PDF on the eu app. Thanks, Damien Cregan Hire an Expert
Pages: How to set report parameter for a decision box?
I am setting up a page what is showing a report. To filter elements by default there is the option to set parameters like: params='Name=John&&Doe'This will show all lines, where the field "Name" contains "John Doe". But how to search for the value of a decision box? I have tried: params='Booked=Yes' and params='Booked=true' but this doesn't have any effect. I receive always all available lines. Any idea? Thanks for helping.
ENABLING FIELDS
WOULD ANYONE HAPPEN TO HAVE AN ANSWER FOR THE FOLLOWING: WHENEVER I DUPLICATE THE TEMPLATE THE FIELDS THAT HAVE AN OPTION FOR THE CAMERA ARE ALWAYS CHECKED OFF. MIND YOU ON THE TEMPLATE ALL FIELDS THAT HAVE THE OPTION FOR THE CAMERA ARE ENABLED. I AM ABLE TO MANUALLY ENABLE THE CAMERA FOR THE FIELDS NECESSARY BUT IT'D BE NICE IF WHEN DUPLICATED ALL FIELDS REMAIN THE SAME.
Automated field values
Hello, I've been doing some searching, and there are probably some answers to this from people with more Zoho knowledge than me. However, I am new to Zoho so please assume zero knowledge - and my terminology may not be quite right. My main problem is not knowing exactly what to search for to find relevant answers! I am creating a new module, entries will have 2 checkboxes and a text field (simplified to describe functionality). I would like the text field default to "None" then if one checkbox is
Custom Order ID
Hi All, Can i have my own costum order ID? Example: ABC12345 and when i add 2 new records , it will update ABC1236 and ABC1237
filter a lookup field by distinct values in a field
I used the code below to filter a lookup field: Lotvalue = Bulk_Inventory[Lot_Bulk = row.Lot_Ripper_Method_Data] sort by Added_Time desc; row.Barrel_Reference_Ripper_Method_Data:ui.add(Lotvalue.ID.getall()); This code successfully filters my lookup field by all Barrel Reference transactions specific to the Lotvalue referenced above. In order to make the dynamic picklist easier to use. I would like to filter the lookup field by the most recent unique Barrel Reference. For example, instead of getting
popup
I created a function to open a popup but I did not just popup a new page? void AjouterRelance(string MailClient, string Nom, string Pr_nom) { openUrl("#Form:Relances?MailClient=" + input.MailClient + "&Nom=" + input.Nom + "&Pr_nom=" + input.Pr_nom, "popup window", "height=100,width=100"); }
Syntax for IF
Hi What is the syntax for an IF on two dropdown boxes? Want to say IF Dropdown box 1 is "x" AND Dropdown box 2 is "y" then show field 1 hide field 2 but IF Dropdown box 1 is "a" AND Dropdown box 2 is "b" then show field 2 hide field 1
Average data on subform based on date on main form
Hi I would like to take an average of a subform for certain months. The dates are located on the main form. I tried using a code that returns an "error at null" currentmonth = Delivery_Date.getMonth(); history = Purchase_Order_Items[Product_ZID = item.ID && Purchase_ZID.Delivery_Date.getMonth() == currentmonth]; averageprice = history.avg(Price_Unit_Inventory); Thanks
Upload file to external storage
Hello all, I have one question to you. Is there any way to upload file to external api? I would like to do this on success event in my form. Thanks in advance! Cheers, HK
Show subform on Form completion, and pass variable?
Hi - we'd like to have a Parent/Child subform scenario. When the Form initially loads, we'd like to hide the subforms (we know how to do this). The parent will be related to various subforms/tables. Our example is this: We have a products table (the parent). In that products table, we'll have -Product Type (Drive, Server, Laptop, etc drop down) -Manufacturer (Intel, Dell, Asus, etc drop down) -Model Number (single line text) We then would have several ProductDetails children tables, each with their
thisapp is Being Converted to App's Literal Name by Script Builder Breaking Function Calls in Custom Schedule Scripts
Hi, I am trying to call a function by using the regular "thisapp.namespace.function..." code. This works everywhere except in Custom Schedule deluge scripts. The problem in the Custom Schedule scripts is that the Script Builder is converting "thisapp" to the literal name of the app and it breaks the Function call. @Zoho Support: Please take a look at this and fix it so I can proceed on my maintenance script, thank you! Check out my Android apps, they're free - http://goo.gl/ludism
Can Not Import Data to a Form with Script in On Add > Validate Form Action
Hi, I tried for an hour this morning to import data into a Form. Nothing worked, I kept getting errors with no error messages. I finally decided to remove all deluge script from the Form's Action: Validate and the next import I did worked as expected! This confuses me, does this mean the Form's Actions are run when importing data? Or is this a bug? To summarize: How can I import data to a Form that has a Validate Form Action in place? Thank you! Check out my Android apps, they're free - http://goo.gl/ludism
Auto Fill Field in Subform from Field in Main Form
Hello, I have been researching this topic thoroughly throughout your site, but I still cannot find a way to write a script in which a field in my sub form can be auto filled by entering it in a similar field in the main form. If it's not possible for it to be auto filled while filling out the original field, then say the original field in the main form was already entered by the admin before the user enters in the other data. What is the script that is needed? Mohammed Alhaj
How do I show the Submit button using Conditional logic?
I would like to only show the Submit button based on a choice from a radio field. If a user selects one of the options, using conditional logic they are shown a message field, which is what I want, but rather than the form allowing them to click Submit, I need the form to not go any further, deterring them from continuing on. Currently, they can click Submit regardless, which causes our organization to receive many invalid form submissions. The Submit button needs to show only on the 1 option we
How to paste google ad code
How to paste google ad code on my website . Do i need to add any tags or anything like that
How Add Dynamic Images in Email Template
we are creating custom App in Zoho Creator for Car Classified. we need vehicle details with images as PDF attachment (using email template) to customer.My question do the vehicle images need to exist in zoho or it will Generate PDF with images as attachment from external images(URL) as well.
Refer Fields Function Back
Last week I was able to use Refer Fields function to update some Apps, this week just gone? Anyone know how to get this button back? We got lots of forms and fields link together. Thanks
No longer able to modify Field Deluge Name of a Note
Did anyone else observe that recently changes to notes Field Deluge Name do not work? When you create a Note, it is created with Field Deluge Name of "note". If you change the Field Deluge Name from "note" to anything else, for example "My Favored Note", the system appears to be saving your change, but when you click elsewhere and then return to the note, it shows again "note". Your change was not saved. If you ran into this issue and were able to come up with a workaround, I would appreciate your
Passing a default parameter to a view and carry throughout the "Add a Record" function of that view
I am using a calendar view and was successfully able to add criteria to filter the view by passing a parameter through the URL. When I use "add" to add a record to the view the form pop opens and the lookup dropdown is not pre-populated with the value that i passed/filtered on. It seems it does not get passed from the view to the popup form. Is there a way to ensure this parameter gets passed to the "Add" functionality?
Dropdown showing 'Choice 1 Choice 2 Choice 3' instead of my custom labels
Is this a known bug, or is there some reason why my custom labels are not showing, and instead my application is showing users 'Choice 1, Choice 2, Choice 3'?
Why can't I update 'Add notes' Field Deluge name
Every time I try to update the field deluge name for an 'Add Notes' field... it does not save and reverts back to the default name (e.g. plain, plain1, etc) Is this a known issue? or is something else wrong? (I'm beginning to question if Zoho Creator app is production ready since things like this shouldn't be happening (and within my first 30 mins using the tool)) #gettingworried
Publishing guidance
During a evaluation, I am unable to play around with the publishing feature. I have a number of questions as to what can/can't be done. I expect to be creating a directory of family members (large family reunion) and the report needs to be embedded into the family web site. I saw that it would be available to google crawler and others, which may or may not be a problem. But I will have a subscription for about 4 or 5 users, but the report potentially will be accessed by hundreds of people. How
How would I get my data to update
I need to get the records in my crm to update.
Populating Products in CRM through Creator
Hi, I desperately need some help with the following: I need to populate (from Creator) the Product fields inside the Quotes CRM module. I have written the following code to send the information to the CRM: ListaProductos = List:Map(); for each xProducto in Productos { LineaDeProducto = Map(); LineaDeProducto.put("Product_Id",xProducto.ID); LineaDeProducto.put("Quantity",xProducto.Cantidad); ListaProductos.add(LineaDeProducto); } CotizacionCRM.put("Product_Details",ListaProductos); Respuesta = zoho.crm.create("Quotes",CotizacionCRM);
single and 2 column layout
I want to combine layouts. fields in the main form in two columns and the subforms in one (so that I can see all the fields). Can it be done? If so, how.
Remove item from picklist in subform
Hi Zoho, I have a subform with an Item field(dropdown). I would like to remove an item from this dropdown if it was selected in a previous row in the subform. how can I achieve this? any help will be appreciated
How to Make Custom Functions without Getting Errors for Trying to Show/Alert Elements?
Hi, I love using custom functions to prevent code repetition, in most cases it works great, however, in cases where I need to do things like Show or Alert I get errors like "'show' can be used only in on load actions". This necessitates that I have to copy and paste my code over and over as I can not use "show" in the Functions interface (as the compiler does not know where the function will be utilized). Is there anyway to make custom functions that use methods like show and alert? Or is there some
Cannot add/save page
Hi, I'm currently testing/learning Zoho Creator for a potential integration app. I've defined several custom functions and I am trying to call one of them from a Page, like below (using the Script builder feature) <% someVar = thisapp.geopal.returnSomething(); %> ... but when saving, I constantly get the "Error at null" error message. The custom function is simply string geopal.returnSomething() { return "sss"; } What happens in here?
Validate Parent Form Input Before SubForm Row is Added?
Hi, I have inputs in the Parent form which are required to be completed before a SubForm row is added, and the Child record detail is completed. While it's quite trivial to check if the Parent form's input fields are complete or not, I am not certain where to put the script to prevent the SubForm row from being added if the Parent's fields are not complete. The most logical place to me is in the SubForm > On Add Row action, however, I don't know how to stop the row from being added. Is there a method
Lookup field not pulling lookup field of secondary form
I am creating a lookup field in a form. The lookup goes to the second form to find values; for display purposes, the lookup field on the main form won't display the lookup fields of the second form. Is there a way to overcome this? Thanks.
Auto delete records based on amount of records and age
Hi there, in our Creator dashboard we have hundreds of apps, each app has a form and a report. Most reports now have several hundred records each - managing and clearing these out when we start to run out of space is becoming a monstrous job therefore I'm looking to create a couple of clever little delete functions to help me out. For a bit of background, we use creator in order to take and send messages to clients, the form uses a sendmail function to email the client, the report is used as a history
Next Page